SELECT
    AC0371.SEIKY_KEI_NO
  , AC0371.SEIKY_YM
  , AC0551.SEIRI_NO
  , AC0551.WRIB_SVC_KEI_NO
  , ''                                AS WRISVC_TRGT_KEI_NO
  , AC0371.SVC_KEI_NO
  , AC0551.OP_SVC_KEI_NO
  , AC0551.PRC_SVC_SKBT_CD
  , AC0551.PRC_GRP_CD
  , AC0371.PCRS_CD
  , AC0551.PRC_SVC_CD
  , AC0371.PRC_KMK_CD
  , AC0541.COLLECT_PATTERN_CD
  , TO_CHAR(AC0371.USE_PCT_CNT_GOKEI) AS PRC
  , AC0551.USE_STAYMD
  , AC0551.USE_ENDYMD
  , AC0551.SVC_STAYMD
  , AC0551.FIRST_CHRG_STAYMD
  , AC0551.SVC_DSL_YMD
  , AC0551.SVC_DSL_RSN_SKBT_CD
  , AC0551.KAIHK_YMD
  , TO_CHAR(AC0551.USE_DAY_CNT)       AS USE_DAY_CNT
  , TO_CHAR(AC0551.USE_FAIL_DAY_CNT)  AS USE_FAIL_DAY_CNT
  , AC0551.AITAI_CD
  , AC0551.SIME_DAY
  , AC0541.USE_FAIL_APLY_WAY_CD
  , '0'                               AS MAE_YUSEN_JUN
  , '0'                               AS WRIB_YUSEN_JUN
  , ''                                AS MAE_YUSEN_JUN
  , '0'                               AS WRIB_KKSHI_KH
FROM
    AC_T_EOMOBA_GOKEI AC0371
    INNER JOIN
        AC_T_CHRG_JSVKEI_CKS AC0551
        ON  AC0371.JIGYOSHA_KEI_ID = AC0551.JIGYOSHA_KEI_ID
        AND AC0371.SEIKY_KEI_NO    = AC0551.SEIKY_KEI_NO
        AND AC0371.SEIKY_YM        = AC0551.SEIKY_YM
    INNER JOIN
        AC_M_JURYOPRC AC0541
        ON  AC0551.PCRS_CD         = AC0541.PCRS_CD
        AND AC0551.PRC_SVC_CD      = AC0541.PRC_SVC_CD
WHERE
    AC0541.SYS_CD             = 'AC'
AND AC0541.JURYO_PRC_TSTAYMD <= :OPE_DATE
AND AC0541.JURYO_PRC_TENDYMD >= :OPE_DATE
AND AC0371.MK_FLG             = '0'
AND AC0551.MK_FLG             = '0'
AND AC0541.MK_FLG             = '0'
AND AC0371.SEIKY_YM           = :SEIKY_YM