249: to_number(to_char(ret.date_retired,'YYYY')),
250: th.transaction_type_code
251: FROM fa_ceiling_types ceilt,
252: fa_methods mt,
253: fa_category_books cb,
254: fa_books bk,
255: fa_transaction_headers th,
256: fa_retirements ret,
257: fa_additions ad
736: to_number(to_char(ret.date_retired,'YYYY')),
737: th.transaction_type_code
738: FROM fa_ceiling_types ceilt,
739: fa_methods mt,
740: fa_category_books cb,
741: fa_books bk,
742: fa_transaction_headers th,
743: fa_retirements ret,
744: fa_additions ad