SELECT
    CH0051.SEIKY_NO
    ,CH0051.SEIKY_KEI_NO
    ,CH0051.SKHK_SVKEI_STAT_CD
    ,CH0051.SEIKY_WAY_CD
    ,CH0051.NEXT_SEIKY_WAY_DIV
    ,CH0051.SKHK_SVKEI_DLRE_SKBT_CD
    ,CH0051.SEIKYUS_HAKKO_YH
    ,CH0051.SHS_HOJIN_SBT_CD
    ,CH0051.SHS_HOJIN_ZENGO_SHITEI_CD
    ,CH0051.SHS_KANA
    ,CH0051.SOHUS_AD_CD
    ,CH0051.SOHUS_PCD
    ,CH0051.SOHUS_STATE_NM
    ,CH0051.SOHUS_CITY_NM
    ,CH0051.SOHUS_OAZTSU_NM
    ,CH0051.SOHUS_AZCHO_NM
    ,CH0051.SOHUS_AD_BNCHIGO
    ,CH0051.SOHUS_ADRTTM
    ,CH0051.SOHUS_ADRRM
    ,CH0051.SOHUS_TELNO
    ,CH0051.SOHUS_NM
    ,CH0051.SOHUS_BKM
    ,CH0051.SOHUS_TNTSHA_NM
    ,CH0051.SOHUS_MLAD
    ,CH0051.KYOSEI_MADOGUCHI_FLG
    ,CH0051.BANK_CD
    ,CH0051.BANK_SHITEN_CD
    ,CH0051.YOKIN_SHUMOKU_CD
    ,CH0051.KOZA_NO
    ,CH0051.NEW_CD
    ,CH0051.KOZA_MEIGIN_KANA
    ,CH0051.TSUCHO_NO
    ,CH0051.FLRLMT_CHOK_FLG
    ,CH0051.CRECARD_NO
    ,CH0051.CRECARD_YK_KIGEN
    ,CH0051.CREDIT_KOKAN_CD
    ,CH0051.CRECARD_NM_KANA
    ,'' AS CRECARD_NM_ROMAJI
    ,CH0051.SHANAIUSE_SKBT_FLG
    ,CH0051.CRECARD_NO_AZKRI_ID
    ,CH0051.SHIKOSAKI_COMP_CD
    ,CH0051.TSUCHO_SYMBOL
    ,CH0051.CRECARD_COMP_CD
    ,CH0051.ORSJGS_CD
FROM
    CH_T_SEIKY CH0051
WHERE
    CH0051.SEIKY_YM = :SEIKY_YM
    AND CH0051.SEIKY_SBT_CD = :SEIKY_SBT_CD
    AND CH0051.MK_FLG = '0'