SELECT
    CH0401.WORK_KINO_SKBT_CD
  , CH0401.PRC_GRP_CD
  , CH0401.PCRS_CD
  , CH0401.PRC_SVC_CD
  , ''
  , CH0401.PRC_KMK_CD
FROM
    CH_M_PRC_KMK_CS_CHGE CH0401
    INNER JOIN
        (SELECT
            CH0401_GENE.SYS_CD
          , CH0401_GENE.WORK_KINO_SKBT_CD
          , CH0401_GENE.CHSHT_CHG_CD
          , CH0401_GENE.PRC_GRP_CD
          , CH0401_GENE.PCRS_CD
          , CH0401_GENE.PRC_SVC_CD
          , CH0401_GENE.PRC_KMK_CD
          , MAX(CH0401_GENE.GENE_ADD_DTM) AS MAX_GENE_DTM
        FROM
            CH_M_PRC_KMK_CS_CHGE CH0401_GENE
        WHERE
            CH0401_GENE.WORK_KINO_SKBT_CD = (
                SELECT 
                     ZM0321.WORK_PARAM_SETTE_VALUE
                FROM
                     ZM_M_WORK_PARAM_KNRI ZM0321
                WHERE
                     ZM0321.WORK_PARAM_ID = ':WORK_PARAM'
                AND ':OPEDATE' BETWEEN ZM0321.WORK_PARAM_TSTAYMD AND ZM0321.WORK_PARAM_TENDYMD
                AND ZM0321.MK_FLG = '0'
            )
        AND CH0401_GENE.PRC_KMK_CS_CHGE_TSTAYMD <=   ':USE_END_YMD'
        AND CH0401_GENE.PRC_KMK_CS_CHGE_TENDYMD >=   ':USE_END_YMD'
        AND CH0401_GENE.RSV_APLY_YMD            <=   ':USE_END_YMD'
        AND CH0401_GENE.MK_FLG                  =  '0'
        GROUP BY
            CH0401_GENE.SYS_CD
          , CH0401_GENE.WORK_KINO_SKBT_CD
          , CH0401_GENE.CHSHT_CHG_CD
          , CH0401_GENE.PRC_GRP_CD
          , CH0401_GENE.PCRS_CD
          , CH0401_GENE.PRC_SVC_CD
          , CH0401_GENE.PRC_KMK_CD
        ) CH0401_GENE
    ON  CH0401.SYS_CD            = CH0401_GENE.SYS_CD
    AND CH0401.WORK_KINO_SKBT_CD = CH0401_GENE.WORK_KINO_SKBT_CD
    AND CH0401.CHSHT_CHG_CD      = CH0401_GENE.CHSHT_CHG_CD
    AND CH0401.PRC_GRP_CD        = CH0401_GENE.PRC_GRP_CD
    AND CH0401.PCRS_CD           = CH0401_GENE.PCRS_CD
    AND CH0401.PRC_SVC_CD        = CH0401_GENE.PRC_SVC_CD
    AND CH0401.PRC_KMK_CD        = CH0401_GENE.PRC_KMK_CD
    AND CH0401.GENE_ADD_DTM      = CH0401_GENE.MAX_GENE_DTM