/*------------------------------------------------------------
-- 請求スキーマ,請求内訳スキーマ,料金項目抽出変換スキーマのアンロード
------------------------------------------------------------*/
SELECT
    CH0051.SEIKY_KEI_NO,
    CH0051.SEIKY_NO,
    CH0051.SEIKY_YM,
    CH0051.SEIKY_STAT,
    CH0051.SEIKY_WAY_CD,
    CH0101.PRC_GRP_CD,
    CH0101.PCRS_CD,
    CH0101.PRC_SVC_CD,
    CH0101.PRC_KMK_CD,
    TO_CHAR(CH0101.AMNT),
    CH0051.ORSJGS_CD
FROM
    CH_T_SEIKY CH0051
INNER JOIN
    CH_T_SEIKY_UCWK CH0101
ON
    CH0101.SEIKY_NO     = CH0051.SEIKY_NO
AND CH0101.SEIKY_KEI_NO = CH0051.SEIKY_KEI_NO
AND CH0101.SEIKY_YM     = CH0051.SEIKY_YM
INNER JOIN
    CH_M_PRC_KMK_CS_CHGE CH0401
ON
    CH0401.PRC_GRP_CD = CH0101.PRC_GRP_CD
AND CH0401.PCRS_CD = CH0101.PCRS_CD
AND CH0401.PRC_SVC_CD = CH0101.PRC_SVC_CD
AND CH0401.PRC_KMK_CD = CH0101.PRC_KMK_CD
WHERE
    CH0051.SEIKY_STAT               =  :SEIKY_STAT
AND CH0051.SEIKY_YM                 =  :SEIKY_YM
AND CH0051.ORSJGS_CD                IS NOT NULL
AND CH0401.SYS_CD                   =  :SYS_CD
AND CH0401.WORK_KINO_SKBT_CD        =  :WORK_KINO_SKBT_CD
AND CH0401.CHSHT_CHG_CD             =  :CHSHT_CHG_CD
AND CH0401.PRC_KMK_CS_CHGE_TSTAYMD  <= :OPE_NDATE
AND CH0401.PRC_KMK_CS_CHGE_TENDYMD  >= :OPE_NDATE