SELECT
    KK0451.WRIB_SVC_KEI_NO
    ,KK0451.SYSID
    ,KK0481.SVC_KEI_NO
    ,KK0451.GENE_ADD_DTM
FROM 
    KK_T_WRIB_SVC_KEI KK0451
    INNER JOIN KK_T_WRISVC_TG_KEI KK0481
        ON KK0451.WRIB_SVC_KEI_NO = KK0481.WRIB_SVC_KEI_NO
WHERE
    KK0451.RSV_APLY_YMD || KK0451.GENE_ADD_DTM =
        (SELECT
             MAX(KK0451_GENE.RSV_APLY_YMD || KK0451_GENE.GENE_ADD_DTM) AS KK0451_MAX
         FROM
             KK_T_WRIB_SVC_KEI KK0451_GENE
         WHERE
             KK0451_GENE.WRIB_SVC_KEI_NO = KK0451.WRIB_SVC_KEI_NO
         AND KK0451_GENE.RSV_APLY_YMD <= 'ZZZZZ'
         AND KK0451_GENE.RSV_APLY_CD = '2'
         AND KK0451_GENE.MK_FLG = '0'
        )
    AND KK0451.WRIB_SVC_CD = 'W00000009'
    AND KK0451.PCRS_CD = 'F05'
    AND KK0451.PPLAN_CD = 'PF0501'
    AND KK0451.WRIB_SVC_KEI_STAT = '100'
    AND TO_CHAR(ADD_MONTHS(TO_DATE(KK0451.SVC_CHRG_STAYMD, 'YYYYMMDD'), 11), 'YYYYMMDD') <= 'ZZZZZ'
    AND KK0481.GENE_ADD_DTM = (SELECT
                                   MAX(KK0481_GENE.GENE_ADD_DTM) AS KK0481_MAX
                               FROM
                                   KK_T_WRISVC_TG_KEI KK0481_GENE
                               WHERE
                                   KK0481_GENE.WRIB_SVC_KEI_NO = KK0481.WRIB_SVC_KEI_NO
                               AND KK0481_GENE.WRIB_SVC_TRGT_KEI_NO = KK0481.WRIB_SVC_TRGT_KEI_NO
                               AND KK0481_GENE.MK_FLG = '0')