SELECT *
          , FN_SY_CLASS_R01(type_cd,'CLASS_NM') type_cd_nm
          , FN_SY_CLASS_R01(type_cd2,'CLASS_NM') type_cd2_nm
          , FN_SY_CLASS_R01(type_cd3,'CLASS_NM') type_cd3_nm
          , FN_SY_CLASS_R01(status_cd,'CLASS_NM') status_cd_nm
          , FN_SY_CLASS_R01(room_type,'CLASS_NM') room_type_nm
FROM BD_BBS_ESTIMATE
WHERE 1 = 1
AND bd_bbs_estimate_seq = :bd_bbs_estimate_seq