APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_MC_ADJUSTMENTS

Line 476: from fa_mc_adjustments adj,

472: gljh.je_batch_id,
473: adj.je_header_id,
474: nvl(adj.je_line_num, 0),
475: adj.distribution_id
476: from fa_mc_adjustments adj,
477: gl_sets_of_books glsob,
478: fa_mc_book_controls bc,
479: fa_book_controls bcp,
480: fa_lookups_tl lk,

Line 543: from fa_mc_adjustments adj,

539: gljh.je_batch_id,
540: dd.je_header_id,
541: nvl(dd.deprn_reserve_je_line_num, 0),
542: adj.distribution_id
543: from fa_mc_adjustments adj,
544: gl_sets_of_books glsob,
545: fa_mc_book_controls bc,
546: fa_book_controls bcp,
547: fa_lookups_tl lk,

Line 628: from fa_mc_adjustments adj,

624: gljh.je_batch_id,
625: dd.je_header_id,
626: nvl(dd.deprn_reserve_je_line_num, 0),
627: adj.distribution_id
628: from fa_mc_adjustments adj,
629: gl_sets_of_books glsob,
630: fa_mc_book_controls bc,
631: fa_book_controls bcp,
632: fa_lookups_tl lk,

Line 2994: from fa_mc_adjustments adj,

2990: gljh.je_batch_id,
2991: adj.je_header_id,
2992: nvl(adj.je_line_num, 0),
2993: adj.distribution_id
2994: from fa_mc_adjustments adj,
2995: fa_lookups_tl lk,
2996: gl_je_headers gljh,
2997: fa_mc_book_controls bc,
2998: fa_book_controls bcp,

Line 3060: from fa_mc_adjustments adj,

3056: gljh.je_batch_id,
3057: dd.je_header_id,
3058: nvl(dd.deprn_reserve_je_line_num, 0),
3059: adj.distribution_id
3060: from fa_mc_adjustments adj,
3061: gl_sets_of_books glsob,
3062: fa_mc_book_controls bc,
3063: fa_book_controls bcp,
3064: fa_lookups_tl lk,

Line 3144: from fa_mc_adjustments adj,

3140: gljh.je_batch_id,
3141: dd.je_header_id,
3142: nvl(dd.deprn_reserve_je_line_num, 0),
3143: adj.distribution_id
3144: from fa_mc_adjustments adj,
3145: gl_sets_of_books glsob,
3146: fa_mc_book_controls bc,
3147: fa_book_controls bcp,
3148: fa_lookups_tl lk,

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

6360: null, -- subledger_doc_seq_value
6361: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
6362: 'XLAJEL' -- gl_sl_link_table
6363: )
6364: select /*+ ordered index(adj, FA_MC_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) */
6365: adj.adjustment_line_id adj_line_id,
6366: decode(adj.debit_credit_flag,
6367: 'DR', adj.adjustment_amount, null) debit_amount,
6368: decode(adj.debit_credit_flag,

Line 6436: fa_mc_adjustments adj,

6432: mult.adj_row adj_row
6433: from
6434: fa_xla_upg_events_gt ev,
6435: fa_xla_upg_headers_gt he,
6436: fa_mc_adjustments adj,
6437: fa_lookups_tl lk,
6438: fa_lookups_tl lk2,
6439: gl_je_headers gljh,
6440: fa_mc_deprn_detail dd,