/*------------------------------------------------------------
-- 請求内訳スキーマのアンロード
------------------------------------------------------------*/
SELECT
    CH0101.SEIKY_NO
   ,CH0101.SEIKY_KEI_NO
   ,CH0101.SEIKY_YM
   ,CH0101.SEIRI_NO
   ,CH0101.SVC_KEI_NO
   ,CH0101.PRC_GRP_CD
   ,CH0101.PCRS_CD
   ,CH0101.PRC_SVC_CD
   ,CH0101.PRC_KMK_CD
   ,CH0101.GSAN_SEIKY_YM
   ,CH0101.USE_STAYMD
   ,CH0101.USE_ENDYMD
   ,to_char(CH0101.AMNT)
   ,CH0101.PRC_TEISE_ADD_FLG
   ,CH0101.ADD_DTM
   ,nvl(CH0101.ADD_OPEACNT,' ')
   ,CH0101.UPD_DTM
   ,nvl(CH0101.UPD_OPEACNT,' ')
   ,CH0101.DEL_DTM
   ,nvl(CH0101.DEL_OPEACNT,' ')
   ,CH0101.MK_FLG
   ,CH0101.ADD_UNYO_YMD
   ,nvl(CH0101.ADD_TRN_ID,' ')
   ,CH0101.UPD_UNYO_YMD
   ,nvl(CH0101.UPD_TRN_ID,' ')
   ,CH0101.DEL_UNYO_YMD
   ,nvl(CH0101.DEL_TRN_ID,' ')
   ,'' AS DMY
FROM
    CH_T_SEIKY_UCWK CH0101
WHERE
        CH0101.SEIKY_YM = '${SEIKY_YM}'
    AND CH0101.AMNT <> 0