[Home] [Help]
292: gl_sets_of_books glsob,
293: fa_book_controls bc,
294: fa_lookups_tl lk,
295: gl_je_headers gljh,
296: fa_deprn_detail dd,
297: gl_je_lines gljl,
298: fa_distribution_accounts da,
299: fa_asset_history ah,
300: fa_category_books cb
367: gl_sets_of_books glsob,
368: fa_book_controls bc,
369: fa_lookups_tl lk,
370: gl_je_headers gljh,
371: fa_deprn_detail dd,
372: gl_je_lines gljl,
373: fa_distribution_accounts da,
374: fa_asset_history ah,
375: fa_category_books cb
2754: gl_sets_of_books glsob,
2755: fa_book_controls bc,
2756: fa_lookups_tl lk,
2757: gl_je_headers gljh,
2758: fa_deprn_detail dd,
2759: gl_je_lines gljl,
2760: fa_distribution_accounts da,
2761: fa_asset_history ah,
2762: fa_category_books cb
2829: gl_sets_of_books glsob,
2830: fa_book_controls bc,
2831: fa_lookups_tl lk,
2832: gl_je_headers gljh,
2833: fa_deprn_detail dd,
2834: gl_je_lines gljl,
2835: fa_distribution_accounts da,
2836: fa_asset_history ah,
2837: fa_category_books cb
5378: fa_adjustments adj,
5379: fa_lookups_tl lk,
5380: fa_lookups_tl lk2,
5381: gl_je_headers gljh,
5382: fa_deprn_detail dd,
5383: gl_je_headers gljh2,
5384: gl_je_lines gljl2,
5385: gl_je_lines gljl3,
5386: fa_book_controls bc,
7487: null, -- subledger_doc_seq_value
7488: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
7489: 'XLAJEL' -- gl_sl_link_table
7490: )
7491: select /*+ leading(ev) index(dd, FA_DEPRN_DETAIL_N1) */
7492: ev.event_id event_id,
7493: he.ae_header_id ae_header_id,
7494: ev.calendar_period_close_date cal_period_close_date,
7495: ev.event_type_code event_type_code,
7546: ae_line_num,
7547: mult.multiplier multiplier
7548: from fa_xla_upg_events_gt ev,
7549: fa_xla_upg_headers_gt he,
7550: fa_deprn_detail dd,
7551: fa_distribution_history dh,
7552: fa_distribution_accounts da,
7553: gl_je_lines jl_de,
7554: gl_je_lines jl_dr,