[Home] [Help]
512: gl_sets_of_books glsob,
513: fa_mc_book_controls bc,
514: fa_lookups_tl lk,
515: gl_je_headers gljh,
516: fa_mc_deprn_detail dd,
517: gl_je_lines gljl,
518: fa_distribution_accounts da,
519: fa_asset_history ah,
520: fa_category_books cb
591: gl_sets_of_books glsob,
592: fa_mc_book_controls bc,
593: fa_lookups_tl lk,
594: gl_je_headers gljh,
595: fa_mc_deprn_detail dd,
596: gl_je_lines gljl,
597: fa_distribution_accounts da,
598: fa_asset_history ah,
599: fa_category_books cb
2974: gl_sets_of_books glsob,
2975: fa_mc_book_controls bc,
2976: fa_lookups_tl lk,
2977: gl_je_headers gljh,
2978: fa_mc_deprn_detail dd,
2979: gl_je_lines gljl,
2980: fa_distribution_accounts da,
2981: fa_asset_history ah,
2982: fa_category_books cb
3053: gl_sets_of_books glsob,
3054: fa_mc_book_controls bc,
3055: fa_lookups_tl lk,
3056: gl_je_headers gljh,
3057: fa_mc_deprn_detail dd,
3058: gl_je_lines gljl,
3059: fa_distribution_accounts da,
3060: fa_asset_history ah,
3061: fa_category_books cb
6297: fa_mc_adjustments adj,
6298: fa_lookups_tl lk,
6299: fa_lookups_tl lk2,
6300: gl_je_headers gljh,
6301: fa_mc_deprn_detail dd,
6302: gl_je_headers gljh2,
6303: gl_je_lines gljl2,
6304: gl_je_lines gljl3,
6305: fa_mc_book_controls bc,
8003: null, -- subledger_doc_seq_value
8004: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
8005: 'XLAJEL' -- gl_sl_link_table
8006: )
8007: select /*+ leading(ev) index(dd, FA_MC_DEPRN_DETAIL_N1) */
8008: ev.event_id event_id,
8009: he.ae_header_id ae_header_id,
8010: ev.calendar_period_close_date cal_period_close_date,
8011: ev.event_type_code event_type_code,
8062: ae_line_num,
8063: mult.multiplier multiplier
8064: from fa_xla_upg_events_gt ev,
8065: fa_xla_upg_headers_gt he,
8066: fa_mc_deprn_detail dd,
8067: fa_distribution_history dh,
8068: fa_distribution_accounts da,
8069: gl_je_lines jl_de,
8070: gl_je_lines jl_dr,