42: ird.status,
43: ad.asset_number
44: from ia_request_headers irh,
45: ia_request_details ird,
46: fa_book_controls bc,
47: fa_additions ad,
48: fa_deprn_periods dp
49: where irh.request_id = ird.request_id
50: and irh.book_type_code = p_book_type_code