126: FROM xla_events_gt ctlgd,
127: fa_deprn_periods dp,
128: fa_book_controls bc ,
129: fa_mc_book_controls mcbc ,
130: gl_ledgers le
131: WHERE ctlgd.entity_code = 'DEPRECIATION'
132: AND ctlgd.event_type_code = 'DEPRECIATION'
133: AND dp.book_type_code = ctlgd.source_id_char_1
134: AND dp.period_counter = ctlgd.source_id_int_2
375: fa_additions_b ad,
376: fa_asset_history ah,
377: fa_category_books cb,
378: fa_book_controls bc,
379: gl_ledgers le,
380: fa_deprn_periods dp
381: where ctlgd.entity_code = 'DEPRECIATION'
382: AND ctlgd.event_type_code = 'DEPRECIATION'
383: AND dd.asset_id = ctlgd.source_id_int_1
495: fa_additions_b ad,
496: fa_asset_history ah,
497: fa_category_books cb,
498: fa_mc_book_controls bc,
499: gl_ledgers le,
500: fa_deprn_periods dp
501: where ctlgd.entity_code = 'DEPRECIATION'
502: AND ctlgd.event_type_code = 'DEPRECIATION'
503: AND dd.asset_id = ctlgd.source_id_int_1