/*------------------------------------------------------------
-- 請求内訳スキーマのアンロード
------------------------------------------------------------*/
SELECT
   '5' AS DATA_SBT
  ,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
  ,CH0391.PRC_KMK_NM
  ,CH0101.GSAN_SEIKY_YM
  ,CH0101.USE_STAYMD
  ,CH0101.USE_ENDYMD
  ,TO_CHAR(CH0101.AMNT)
  ,CH0101.PRC_TEISE_ADD_FLG
  ,CH0101.ADD_DTM
  ,CH0101.ADD_OPEACNT
  ,CH0101.UPD_DTM
  ,CH0101.UPD_OPEACNT
  ,CH0101.ADD_UNYO_YMD
  ,CH0101.ADD_TRN_ID
  ,CH0101.UPD_UNYO_YMD
  ,CH0101.UPD_TRN_ID
FROM
  CH_T_SEIKY_UCWK CH0101
LEFT OUTER JOIN
  CH_M_PRC_KMK_OPUT_NM CH0391
ON
      CH0391.PRC_KMK_NM_SBT_CD = '3'
  AND CH0391.PRC_GRP_CD = CH0101.PRC_GRP_CD
  AND CH0391.PCRS_CD = CH0101.PCRS_CD
  AND CH0391.PRC_SVC_CD = CH0101.PRC_SVC_CD
  AND CH0391.PRC_KMK_CD = CH0101.PRC_KMK_CD
  AND :PRC_KMK_OPUT_NM_TYMD BETWEEN CH0391.PRC_KMK_OPUT_NM_TSTAYMD AND CH0391.PRC_KMK_OPUT_NM_TENDYMD
  AND CH0391.MK_FLG = '0'
WHERE
    CH0101.SEIKY_YM = :SEIKY_YM
AND CH0101.UPD_UNYO_YMD BETWEEN :UPD_UNYO_YMD_FROM AND :UPD_UNYO_YMD_TO
AND CH0101.MK_FLG = '0'
ORDER BY
 CH0101.SEIKY_KEI_NO
,CH0101.SVC_KEI_NO
,CH0101.PRC_GRP_CD
,CH0101.PCRS_CD
,CH0101.PRC_SVC_CD
,CH0101.PRC_KMK_CD
,CH0101.PRC_TEISE_ADD_FLG