/*------------------------------------------------------------
-- 請求契約配下契約状態判定
-- サービス契約スキーマのアンロード
------------------------------------------------------------*/
SELECT
     KK0081.SVC_KEI_STAT
    ,KK0081.SVC_DLRE_CD
    ,nvl(KK0081.SVC_DSL_KISAN_YMD,'99999999')
    ,nvl(KK0081.SVC_ENDYMD,'99999999')
    ,KK0081.GENE_ADD_DTM
    ,'10' AS YOUSEN_JUN
    ,KK0081.SVC_KEI_NO
FROM
    KK_T_SVC_KEI KK0081
WHERE
        KK0081.RSV_APLY_CD = '2'
    AND KK0081.RSV_APLY_YMD <= ':SHORI_YMD'
    AND KK0081.MK_FLG = '0'
ORDER BY
     KK0081.SVC_KEI_NO
    ,KK0081.RSV_APLY_YMD
    ,KK0081.GENE_ADD_DTM