SELECT *
          , FN_SY_CLASS_R01(type_cd,'CLASS_NM') type_cd_nm
FROM BD_BBS_CUSTOMER
WHERE bd_bbs_customer_seq = :bd_bbs_customer_seq