132: FROM xla_events_gt ctlgd,
133: fa_deprn_periods dp,
134: fa_book_controls bc ,
135: fa_mc_book_controls mcbc ,
136: gl_ledgers le
137: WHERE ctlgd.entity_code = 'DEFERRED_DEPRECIATION'
138: AND ctlgd.event_type_code = 'DEFERRED_DEPRECIATION'
139: AND bc.book_type_code = ctlgd.source_id_char_1
140: AND dp.book_type_code = ctlgd.source_id_char_1
236: fa_book_controls bc,
237: fa_category_books cb,
238: fa_distribution_history dh,
239: fa_deferred_deprn df,
240: gl_ledgers le,
241: xla_events_gt ctlgd
242: where ctlgd.entity_code = 'DEFERRED_DEPRECIATION'
243: AND ctlgd.event_type_code = 'DEFERRED_DEPRECIATION'
244: AND df.asset_id = ctlgd.source_id_int_1
308: fa_mc_book_controls bc,
309: fa_category_books cb,
310: fa_distribution_history dh,
311: fa_mc_deferred_deprn df,
312: gl_ledgers le,
313: xla_events_gt ctlgd
314: where ctlgd.entity_code = 'DEFERRED_DEPRECIATION'
315: AND ctlgd.event_type_code = 'DEFERRED_DEPRECIATION'
316: AND df.asset_id = ctlgd.source_id_int_1