SELECT
    CH0051.SEIKY_NO
    ,CH0051.SEIKY_KEI_NO 
    ,CH0051.SEIKY_YM
    ,''
    ,CH0051.KHRI_RSLT_CD
    ,CH0051.SEIKY_WAY_CD
    ,''
FROM
    CH_T_SEIKY CH0051
WHERE
    CH0051.SEIKY_YM = (
                            SELECT
                                TO_CHAR(ADD_MONTHS(TO_DATE(MAX(CH0501.SEIKY_YM), 'YYYYMM'), -1), 'YYYYMM') AS SEIKY_YM
                            FROM
                                 CH_M_PRC_SCHDL_TEIGI CH0501
                            WHERE
                                     CH0501.EVENT_CD IN (:EVENT_CD_01, :EVENT_CD_02, :EVENT_CD_03, :EVENT_CD_04, :EVENT_CD_05, :EVENT_CD_06, :EVENT_CD_07, :EVENT_CD_08, :EVENT_CD_09, :EVENT_CD_10, :EVENT_CD_11, :EVENT_CD_12, :EVENT_CD_13, :EVENT_CD_14)
                                 AND CH0501.EVENT_YMD = :OPEDATE
                                 AND CH0501.MK_FLG = '0'
                        )
    AND CH0051.SEIKY_SBT_CD = :SEIKY_SBT_CD
    AND CH0051.SEIKY_WAY_CD IN (:SEIKY_WAY_CD_01 , :SEIKY_WAY_CD_02)
    AND CH0051.MK_FLG = '0'
ORDER BY CH0051.SEIKY_KEI_NO