/*------------------------------------------------------------
-- 料金検証-検証用サービス契約内訳抽出
-- サービス契約内訳スキーマのアンロード
------------------------------------------------------------*/
SELECT
    KK0161.SVC_KEI_UCWK_NO
   ,KK0161.GENE_ADD_DTM
   ,KK0161.SVC_KEI_UCWK_STAT
   ,RPAD(nvl(KK0161.PPLAN_CD,' '),12)
   ,KK0161.SVC_KEI_NO
   ,KK0161.RSV_APLY_YMD
   ,KK0161.PLAN_STAYMD
   ,KK0161.PLAN_ENDYMD
   ,KK0161.PLAN_CHRG_STAYMD
   ,KK0161.PLAN_CHRG_ENDYMD
   ,KK0161.PLAN_END_SBT_CD
   ,KK0161.SVC_CANCEL_YMD
   ,KK0161.SVC_STA_YMD
   ,KK0161.SVC_CHRG_STAYMD
   ,KK0161.PAUSE_STP_CD
   ,KK0161.SVC_PAUSE_CHRG_STA_YMD
   ,KK0161.SVC_PAUSE_RLS_YMD
   ,KK0161.SVC_ENDYMD
   ,KK0161.SVC_CHRG_ENDYMD
   ,KK0161.SVC_DSL_YMD
   ,KK0161.SVC_DLRE_CD
   ,KK0161.KAIHK_YMD
   ,KK0161.PNLTY_HASSEI_CD
   ,KK0161.IDO_DIV
   ,KK0161.TK_HOSHIKI_KEI_NO
FROM
    KK_T_SVC_KEI_UCWK KK0161
WHERE
        KK0161.RSV_APLY_YMD      < ':SEIKY_YM_STADAY'
    AND KK0161.RSV_APLY_CD       = '2'
    AND KK0161.MK_FLG            = '0'