SELECT
    KK0081.SVC_KEI_NO,
    '',
    NVL(DECODE(KK0081.SVC_STA_YMD, '20991231', '99999999', KK0081.SVC_STA_YMD), '99999999'),
    NVL(DECODE(KK0081.SVC_ENDYMD, '20991231', '99999999' ,KK0081.SVC_ENDYMD), '99999999'),
    KK0081.MK_FLG,
    CASE WHEN KK2141.OLD_ICS_KEI_STAT_CD = '91' THEN
        CASE WHEN KK0081.SVC_DLRE_CD = '02' THEN '92' ELSE KK2141.OLD_ICS_KEI_STAT_CD
        END
    ELSE KK2141.OLD_ICS_KEI_STAT_CD
    END,
    NVL(DECODE(KK0081.SVC_CHRG_STAYMD, '20991231', '99999999', KK0081.SVC_CHRG_STAYMD), '99999999'),
    NVL(DECODE(KK0081.SVC_CANCEL_YMD, '20991231', '99999999', KK0081.SVC_CANCEL_YMD), '99999999'),
    NVL(DECODE(KK0081.SVC_DSL_YMD, '20991231', '99999999', KK0081.SVC_DSL_YMD), '99999999'),
    NVL(DECODE(KK0081.SVC_CHRG_ENDYMD, '20991231', '99999999', KK0081.SVC_CHRG_ENDYMD), '99999999'),
    NVL(DECODE(KK0081.KAIHK_YMD, '20991231', '99999999', KK0081.KAIHK_YMD), '99999999'),
    CASE WHEN KK0081.SVC_STP_YMD <= ? THEN
        CASE WHEN KK0081.SVC_STP_RLS_YMD IS NULL THEN '1' ELSE
           CASE WHEN KK0081.SVC_STP_RLS_YMD >= ? THEN '1' ELSE '0'
           END
        END
        ELSE '0'
    END,
    KK2141.RNK_SAKI_SYS_SKBT_CD,
    KK2141.OLD_ICS_CD_CHG_SBT_CD,
    KK2141.MK_FLG,
    KK2141.OLD_ICS_CD_CHG_TSTAYMD,
    KK2141.OLD_ICS_CD_CHG_TENDYMD,
    KK0081.SVC_CD,
    KK0081.PRC_GRP_CD,
    KK0081.GENE_ADD_DTM,
    KK0081.RSV_APLY_YMD,
    KK0081.RSV_APLY_CD
FROM
    KK_T_SVC_KEI KK0081
    INNER JOIN KK_M_OLD_ICS_CD_CHG KK2141
    ON KK0081.SVC_KEI_STAT = KK2141.SVC_KEI_STAT
WHERE KK2141.RNK_SAKI_SYS_SKBT_CD = '02'
AND   KK2141.OLD_ICS_CD_CHG_SBT_CD = '01'
AND   KK2141.MK_FLG = '0'
AND  ? BETWEEN KK2141.OLD_ICS_CD_CHG_TSTAYMD
AND   KK2141.OLD_ICS_CD_CHG_TENDYMD