[Home] [Help]
80: dp.PERIOD_COUNTER ,
81: ctlgd.event_date ,
82: decode(bc.GL_POSTING_ALLOWED_FLAG ,
83: 'YES', 'Y','N')
84: FROM xla_events_gt ctlgd,
85: fa_deprn_periods dp,
86: fa_book_controls bc
87: WHERE ctlgd.entity_code = 'DEPRECIATION'
88: AND ctlgd.event_type_code = 'DEPRECIATION'
122: dp.PERIOD_COUNTER ,
123: ctlgd.event_date ,
124: decode(mcbc.GL_POSTING_ALLOWED_FLAG ,
125: 'YES', 'Y','N')
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
193: decode(bc.GL_POSTING_ALLOWED_FLAG ,
194: 'YES', 'Y',
195: 'N'),
196: ctlgd.event_date
197: FROM xla_events_gt ctlgd,
198: fa_book_controls bc,
199: fa_deprn_periods dp,
200: fa_deprn_events ds
201: WHERE ctlgd.entity_code = 'DEPRECIATION'
226: decode(bc.GL_POSTING_ALLOWED_FLAG ,
227: 'YES', 'Y',
228: 'N'),
229: ctlgd.event_date
230: FROM xla_events_gt ctlgd,
231: fa_mc_book_controls bc,
232: fa_deprn_periods dp,
233: fa_mc_deprn_Summary_h ds
234: WHERE ctlgd.entity_code = 'DEPRECIATION'
368: cb.REVAL_AMORTIZATION_ACCT,
369: cb.REVAL_RESERVE_ACCT,
370: dd.DEPRN_RUN_ID,
371: dh.CODE_COMBINATION_ID
372: from xla_events_gt ctlgd,
373: fa_deprn_detail dd,
374: fa_distribution_history dh,
375: fa_additions_b ad,
376: fa_asset_history ah,
488: cb.REVAL_AMORTIZATION_ACCT,
489: cb.REVAL_RESERVE_ACCT,
490: dd.DEPRN_RUN_ID,
491: dh.CODE_COMBINATION_ID
492: from xla_events_gt ctlgd,
493: fa_mc_deprn_detail dd,
494: fa_distribution_history dh,
495: fa_additions_b ad,
496: fa_asset_history ah,
710: xl.REVAL_AMORT_ACCT,
711: xl.REVAL_RESERVE_ACCT,
712: xl.CAPITAL_ADJ_ACCT,
713: xl.GENERAL_FUND_ACCT
714: from xla_events_gt xg,
715: fa_xla_ext_headers_b_gt xb,
716: fa_xla_ext_lines_b_gt xl,
717: fa_distribution_accounts da
718: where xg.event_class_code = 'DEPRECIATION'