#-----------------------------------------------------------
#--ＵＱ取込(AC_T_UQ_TRKM-AC_SELECT_001)
#--【内容】
#--請求契約番号、請求年月を元にUQ取込を検索する
#--【条件】
#--請求契約番号
#--請求年月
#--【抽出対象】
#--複数
#-----------------------------------------------------------

--KEY:AC_SELECT_001

SELECT
    AC0351.SVC_KEI_NO,
    AC0351.SVC_KEI_UCWK_NO,
    AC0351.PCRS_CD,
    AC0351.SEIKY_KEI_NO,
    AC0351.SEIKY_YM,
    AC0351.UQ_CUST_CD,
    AC0351.CHRG_STAYMD,
    AC0351.CHRG_STA_HMS,
    AC0351.CHRG_ENDYMD,
    AC0351.CHRG_END_HMS,
    AC0351.USE_BYTE_CNT,
    AC0351.USE_PCT_CNT,
    AC0351.PRC_KMK_CD
FROM
    AC_T_UQ_TRKM AC0351 INNER JOIN AC_T_TRGT_KEY_WK AC0561
    ON AC0351.SEIKY_KEI_NO = TRIM(AC0561.TRGT_KEY_2)
    AND AC0351.SEIKY_YM = TRIM(AC0561.TRGT_KEY_1)
WHERE
    AC0351.SEIKY_YM = ?
    AND AC0561.TRGT_KEY_WK_USE_KINO_CD = ?
    AND AC0351.MK_FLG = '0'
    AND AC0561.MK_FLG = '0'

#-

#-----------------------------------------------------------
#--ＵＱ取込(AC_T_UQ_TRKM-AC_SELECT_002)
#--サービス契約番号・サービス契約内訳番号より、UQ取込のレコード存在チェック
#-----------------------------------------------------------

--KEY:AC_SELECT_002

SELECT
  AC0351.UQ_CUST_CD
FROM
  AC_T_UQ_TRKM AC0351
WHERE
  AC0351.SVC_KEI_NO = ?
  AND ((? > AC0351.CHRG_STAYMD || AC0351.CHRG_STA_HMS 
       AND ? < AC0351.CHRG_ENDYMD || AC0351.CHRG_END_HMS)
  OR (? > AC0351.CHRG_STAYMD || AC0351.CHRG_STA_HMS 
       AND ? < AC0351.CHRG_ENDYMD || AC0351.CHRG_END_HMS)
  OR (? < AC0351.CHRG_STAYMD || AC0351.CHRG_STA_HMS
       AND ? > AC0351.CHRG_ENDYMD || AC0351.CHRG_END_HMS ))

#-

#-----------------------------------------------------------
#--ＵＱ取込(AC_T_UQ_TRKM-AC_SELECT_003)
#--ＵＱ取込のデータ存在チェック
#-----------------------------------------------------------

--KEY:AC_SELECT_003

SELECT
  AC0351.UQ_CUST_CD
FROM
  AC_T_UQ_TRKM AC0351
WHERE
  AC0351.CHRG_STAYMD = ?
  AND AC0351.CHRG_STA_HMS = ?
  AND AC0351.UQ_CUST_CD = ?
  AND AC0351.MK_FLG = '0'

#-

#-----------------------------------------------------------
#--ＵＱ取込(AC_T_UQ_TRKM-AC_DELETE_001)
#--ＵＱ取込の過去分削除用
#-----------------------------------------------------------

--KEY:AC_DELETE_001

DELETE
FROM
  AC_T_UQ_TRKM AC0351
WHERE
  AC0351.SEIKY_YM < ?

#-