SELECT
    AC0591.SVC_KEI_NO
  , AC0591.PCRS_CD
  , AC0591.PRC_SVC_CD
  , AC0591.SEIKY_KEI_NO
  , AC0591.SEIKY_YM
  , AC0591.NINSHO_ID
  , AC0591.USE_YM
  , AC0591.DATA_STKU_YMD
  , TO_CHAR(AC0591.USE_TSRYO)
  , TO_CHAR(AC0591.HOSEI_TSRYO)
  , AC0591.CHRG_KH
FROM
    AC_T_FTTH_TUSHIN_DTL AC0591
    INNER JOIN
        (SELECT
            AC0561.TRGT_KEY_2
          , AC0561.TRGT_KEY_1
          , AC0561.TRGT_KEY_WK_USE_KINO_CD
        FROM
            AC_T_TRGT_KEY_WK AC0561
        WHERE 
            AC0561.TRGT_KEY_WK_USE_KINO_CD IN(:KINO_CD1, :KINO_CD2)
        AND AC0561.MK_FLG = '0'
        ) AC0561
        ON  AC0591.SEIKY_KEI_NO    = AC0561.TRGT_KEY_2
        AND AC0591.SEIKY_YM        = AC0561.TRGT_KEY_1
        AND AC0591.MK_FLG          = '0'
WHERE
    AC0591.SEIKY_YM IN(:TOGETSU, :ZENGETSU)
AND AC0591.MK_FLG = '0'