/*------------------------------------------------------------
-- 請求債権関連スキーマのアンロード
------------------------------------------------------------*/
SELECT
    CH0041.SEIKY_NO
   ,CH0041.SAIKEN_NO
FROM
    CH_T_SEIKY CH0051
    INNER JOIN
        CH_T_SEIKY_SKN_KNRN CH0041
        ON  CH0041.SEIKY_NO = CH0051.SEIKY_NO
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 CH0051.MK_FLG        = '0'
AND CH0041.MK_FLG        = '0'