select a.*,b.descr from CI_CHTY_FATY a, ci_char_type_l b where a.fa_type_cd='INSERT FA TYPE CODE' and a.char_type_cd=b.char_type_cd