/*------------------------------------------------------------
-- 請求内訳スキーマのアンロード
------------------------------------------------------------*/
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
FROM
    CH_T_SEIKY_UCWK CH0101
WHERE
          CH0101.SEIKY_YM = :SEIKY_YM
     AND CH0101.MK_FLG = '0'