SELECT
    CH0051.SEIKY_YM
   ,CH0051.SEIKY_KEI_NO
   ,CH0051.SEIKY_NO
   ,CH0051.SHS_KANA
   ,CH0051.BANK_CD
   ,CH0051.BANK_SHITEN_CD
FROM
    CH_T_SEIKY CH0051
WHERE
    CH0051.SEIKY_YM     = '${SEIKY_YM}'
AND
    CH0051.SEIKY_SBT_CD = '0'
AND
    CH0051.SEIKY_WAY_CD IN ( '2' , '3' )
AND
    CH0051.MK_FLG       = '0'