/*------------------------------------------------------------
-- 料金検証-検証用サービス契約抽出
-- サービス契約スキーマのアンロード
------------------------------------------------------------*/
SELECT
    KK0081.PRC_GRP_CD
   ,KK0081.PCRS_CD
   ,RPAD(nvl(KK0081.PPLAN_CD,' '),12)
   ,KK0081.SYSID
   ,nvl(KK0081.SEIRI_NO,'              ')
   ,KK0081.SVC_KEI_NO
   ,KK0081.GENE_ADD_DTM
   ,KK0081.SVC_KEI_STAT
   ,KK0081.RSV_APLY_YMD
   ,KK0081.PLAN_STAYMD
   ,KK0081.PLAN_ENDYMD
   ,KK0081.PLAN_CHRG_STAYMD
   ,KK0081.PLAN_CHRG_ENDYMD
   ,KK0081.PLAN_END_SBT_CD
   ,KK0081.SVC_CANCEL_YMD
   ,nvl(KK0081.KEIZK_SVC_STAYMD,KK0081.SVC_STA_YMD)
   ,nvl(KK0081.KEIZK_SVC_CHRG_STAYMD,KK0081.SVC_CHRG_STAYMD)
   ,KK0081.PAUSE_STP_CD
   ,KK0081.SVC_PAUSE_CHRG_STA_YMD
   ,KK0081.SVC_PAUSE_RLS_YMD
   ,KK0081.SVC_ENDYMD
   ,KK0081.SVC_CHRG_ENDYMD
   ,KK0081.SVC_DSL_YMD
   ,KK0081.SVC_DLRE_CD
   ,KK0081.KAIHK_YMD
   ,KK0081.PNLTY_HASSEI_CD
   ,KK0081.IDO_DIV
   ,KK0081.TK_HOSHIKI_KEI_NO
FROM
   KK_T_SVC_KEI KK0081
WHERE
       KK0081.RSV_APLY_YMD <= ':PRC_CALC_YMD'
   AND KK0081.RSV_APLY_YMD >= ':SEIKY_YM_STADAY'
   AND KK0081.RSV_APLY_CD   = '2'
   AND KK0081.MK_FLG        = '0'