[Home] [Help]
308: gl_sets_of_books glsob,
309: fa_book_controls bc,
310: fa_lookups_tl lk,
311: gl_je_headers gljh,
312: fa_deprn_detail dd,
313: gl_je_lines gljl,
314: fa_distribution_accounts da,
315: fa_asset_history ah,
316: fa_category_books cb
387: gl_sets_of_books glsob,
388: fa_book_controls bc,
389: fa_lookups_tl lk,
390: gl_je_headers gljh,
391: fa_deprn_detail dd,
392: gl_je_lines gljl,
393: fa_distribution_accounts da,
394: fa_asset_history ah,
395: fa_category_books cb
2828: gl_sets_of_books glsob,
2829: fa_book_controls bc,
2830: fa_lookups_tl lk,
2831: gl_je_headers gljh,
2832: fa_deprn_detail dd,
2833: gl_je_lines gljl,
2834: fa_distribution_accounts da,
2835: fa_asset_history ah,
2836: fa_category_books cb
2906: gl_sets_of_books glsob,
2907: fa_book_controls bc,
2908: fa_lookups_tl lk,
2909: gl_je_headers gljh,
2910: fa_deprn_detail dd,
2911: gl_je_lines gljl,
2912: fa_distribution_accounts da,
2913: fa_asset_history ah,
2914: fa_category_books cb
5517: fa_adjustments adj,
5518: fa_lookups_tl lk,
5519: fa_lookups_tl lk2,
5520: gl_je_headers gljh,
5521: fa_deprn_detail dd,
5522: gl_je_headers gljh2,
5523: gl_je_lines gljl2,
5524: gl_je_lines gljl3,
5525: fa_book_controls bc,
7172: default_reval_rsv_ccid,
7173: nvl(bc.je_depreciation_category, 'OTHER')
7174: je_category_name,
7175: (select min(je_header_id)
7176: from fa_deprn_detail dd
7177: where dd.book_type_code = ds.book_type_code
7178: and dd.asset_id = ds.asset_id
7179: and dd.period_counter = ds.period_counter
7180: and nvl(dd.je_header_id,-1) > 0) je_hdr_id, -- Bug 6811554
7243: -- Bug 14007714 : Reinstated fix done in bug 6811544 only for uptime upgrade
7244: -- Downtime upgrade case will be handled in faevddpupg.sql
7245: if (p_mode <> 'downtime') then
7246: FORALL l_count IN 1..l_event_id_tbl.count
7247: update fa_deprn_detail
7248: set event_id = l_event_id_tbl(l_count),
7249: deprn_run_id = nvl(deprn_run_id, 1)
7250: where asset_id = l_asset_id_tbl(l_count)
7251: and book_type_code = l_book_type_code_tbl(l_count)
7561: null, -- subledger_doc_seq_value
7562: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id : Bug 6811548
7563: 'XLAJEL' -- gl_sl_link_table
7564: )
7565: select /*+ leading(ev) index(dd, FA_DEPRN_DETAIL_N1) */
7566: ev.event_id event_id,
7567: he.ae_header_id ae_header_id,
7568: ev.calendar_period_close_date cal_period_close_date,
7569: ev.event_type_code event_type_code,
7620: ae_line_num,
7621: mult.multiplier multiplier
7622: from fa_xla_upg_events_gt ev,
7623: fa_xla_upg_headers_gt he,
7624: fa_deprn_detail dd,
7625: fa_distribution_history dh,
7626: fa_distribution_accounts da,
7627: gl_je_lines jl_de,
7628: gl_je_lines jl_dr,