/*------------------------------------------------------------
-- 請求スキーマのアンロード
------------------------------------------------------------*/
SELECT
    CH0051.SEIKY_NO
   ,CH0051.SEIKY_KEI_NO
   ,CH0051.SEIKY_YM
   ,CH0051.SEIKY_STAT
   ,CH0051.SEIKY_WAY_CD
   ,CH0051.BANK_CD
   ,CH0051.BANK_SHITEN_CD
   ,CH0051.KOZA_NO
   ,CH0051.TSUCHO_SYMBOL
   ,CH0051.TSUCHO_NO
   ,CH0051.SEIKY_SBT_CD
FROM
    CH_T_SEIKY CH0051
WHERE
    CH0051.SEIKY_YM      = '${SEIKY_YM}'
AND CH0051.SEIKY_STAT    = '${SEIKY_STAT}'
AND CH0051.SEIKY_WAY_CD IN ('${SEIKY_WAY_CD1}','${SEIKY_WAY_CD2}')
AND CH0051.SEIKY_SBT_CD IN ('${SEIKY_SBT_CD1}','${SEIKY_SBT_CD2}')
AND NVL(CH0051.KAKGT_SEIKY_SKIP_FLG, '0') <> '${KAKGT_SEIKY_SKIP_FLG}'
AND CH0051.MK_FLG        = '0'