275: fa_deprn_periods dp ,
276: fa_transaction_headers th ,
277: fa_asset_history ah ,
278: fa_additions ad ,
279: fa_book_controls bc
280: WHERE ah.asset_id = ad.asset_id
281: AND fb.book_type_code = bc.book_type_code
282: AND fb.asset_id = ad.asset_id
283: AND fb.transaction_header_id_in = th.transaction_header_id
303: fa_deprn_periods_mrc_v dp ,
304: fa_transaction_headers th ,
305: fa_asset_history ah ,
306: fa_additions ad ,
307: fa_book_controls_mrc_v bc
308: WHERE ah.asset_id = ad.asset_id
309: AND fb.book_type_code = bc.book_type_code
310: AND fb.asset_id = ad.asset_id
311: AND fb.transaction_header_id_in = th.transaction_header_id
331: fa_deprn_periods dp ,
332: fa_transaction_headers th ,
333: fa_asset_history ah ,
334: fa_additions ad ,
335: fa_book_controls bc
336: WHERE ah.asset_id = ad.asset_id
337: AND fb.book_type_code = bc.book_type_code
338: AND fb.asset_id = ad.asset_id
339: AND fb.transaction_header_id_in = th.transaction_header_id