APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_MC_ADJUSTMENTS

Line 450: from fa_mc_adjustments adj,

446: gljh.je_batch_id,
447: adj.je_header_id,
448: nvl(adj.je_line_num, 0),
449: adj.distribution_id
450: from fa_mc_adjustments adj,
451: gl_sets_of_books glsob,
452: fa_mc_book_controls bc,
453: fa_lookups_tl lk,
454: gl_je_headers gljh

Line 511: from fa_mc_adjustments adj,

507: gljh.je_batch_id,
508: dd.je_header_id,
509: nvl(dd.deprn_reserve_je_line_num, 0),
510: adj.distribution_id
511: from fa_mc_adjustments adj,
512: gl_sets_of_books glsob,
513: fa_mc_book_controls bc,
514: fa_lookups_tl lk,
515: gl_je_headers gljh,

Line 590: from fa_mc_adjustments adj,

586: gljh.je_batch_id,
587: dd.je_header_id,
588: nvl(dd.deprn_reserve_je_line_num, 0),
589: adj.distribution_id
590: from fa_mc_adjustments adj,
591: gl_sets_of_books glsob,
592: fa_mc_book_controls bc,
593: fa_lookups_tl lk,
594: gl_je_headers gljh,

Line 2912: from fa_mc_adjustments adj,

2908: gljh.je_batch_id,
2909: adj.je_header_id,
2910: nvl(adj.je_line_num, 0),
2911: adj.distribution_id
2912: from fa_mc_adjustments adj,
2913: fa_lookups_tl lk,
2914: gl_je_headers gljh,
2915: fa_mc_book_controls bc,
2916: gl_sets_of_books glsob

Line 2973: from fa_mc_adjustments adj,

2969: gljh.je_batch_id,
2970: dd.je_header_id,
2971: nvl(dd.deprn_reserve_je_line_num, 0),
2972: adj.distribution_id
2973: from fa_mc_adjustments adj,
2974: gl_sets_of_books glsob,
2975: fa_mc_book_controls bc,
2976: fa_lookups_tl lk,
2977: gl_je_headers gljh,

Line 3052: from fa_mc_adjustments adj,

3048: gljh.je_batch_id,
3049: dd.je_header_id,
3050: nvl(dd.deprn_reserve_je_line_num, 0),
3051: adj.distribution_id
3052: from fa_mc_adjustments adj,
3053: gl_sets_of_books glsob,
3054: fa_mc_book_controls bc,
3055: fa_lookups_tl lk,
3056: gl_je_headers gljh,

Line 6225: select /*+ ordered index(adj, FA_MC_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) */

6221: null, -- subledger_doc_seq_value
6222: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
6223: 'XLAJEL' -- gl_sl_link_table
6224: )
6225: select /*+ ordered index(adj, FA_MC_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) */
6226: adj.adjustment_line_id adj_line_id,
6227: decode(adj.debit_credit_flag,
6228: 'DR', adj.adjustment_amount, null) debit_amount,
6229: decode(adj.debit_credit_flag,

Line 6297: fa_mc_adjustments adj,

6293: mult.adj_row adj_row
6294: from
6295: fa_xla_upg_events_gt ev,
6296: fa_xla_upg_headers_gt he,
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,