DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_MC_DEPRN_DETAIL

Line 549: fa_mc_deprn_detail dd,

545: fa_mc_book_controls bc,
546: fa_book_controls bcp,
547: fa_lookups_tl lk,
548: gl_je_headers gljh,
549: fa_mc_deprn_detail dd,
550: gl_je_lines gljl,
551: fa_distribution_accounts da,
552: fa_asset_history ah,
553: fa_category_books cb

Line 634: fa_mc_deprn_detail dd,

630: fa_mc_book_controls bc,
631: fa_book_controls bcp,
632: fa_lookups_tl lk,
633: gl_je_headers gljh,
634: fa_mc_deprn_detail dd,
635: gl_je_lines gljl,
636: fa_distribution_accounts da,
637: fa_asset_history ah,
638: fa_category_books cb

Line 3066: fa_mc_deprn_detail dd,

3062: fa_mc_book_controls bc,
3063: fa_book_controls bcp,
3064: fa_lookups_tl lk,
3065: gl_je_headers gljh,
3066: fa_mc_deprn_detail dd,
3067: gl_je_lines gljl,
3068: fa_distribution_accounts da,
3069: fa_asset_history ah,
3070: fa_category_books cb

Line 3150: fa_mc_deprn_detail dd,

3146: fa_mc_book_controls bc,
3147: fa_book_controls bcp,
3148: fa_lookups_tl lk,
3149: gl_je_headers gljh,
3150: fa_mc_deprn_detail dd,
3151: gl_je_lines gljl,
3152: fa_distribution_accounts da,
3153: fa_asset_history ah,
3154: fa_category_books cb

Line 6440: fa_mc_deprn_detail dd,

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,
6441: gl_je_headers gljh2,
6442: gl_je_lines gljl2,
6443: gl_je_lines gljl3,
6444: fa_mc_book_controls bc,

Line 7270: update fa_mc_deprn_detail

7266: -- Bug 14007714 : Reinstated fix done in bug 6811544 only for uptime upgrade
7267: -- Downtime upgrade case will be handled in faevddpupg.sql
7268: if (p_mode <> 'downtime') then
7269: FORALL l_count IN 1..l_event_id_tbl.count
7270: update fa_mc_deprn_detail
7271: set event_id = l_event_id_tbl(l_count),
7272: deprn_run_id = nvl(deprn_run_id, 1)
7273: where asset_id = l_asset_id_tbl(l_count)
7274: and book_type_code = l_book_type_code_tbl(l_count)

Line 8087: select /*+ leading(ev) index(dd, FA_MC_DEPRN_DETAIL_N1) */

8083: null, -- subledger_doc_seq_value
8084: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id : Bug 6811548
8085: 'XLAJEL' -- gl_sl_link_table
8086: )
8087: select /*+ leading(ev) index(dd, FA_MC_DEPRN_DETAIL_N1) */
8088: ev.event_id event_id,
8089: he.ae_header_id ae_header_id,
8090: ev.calendar_period_close_date cal_period_close_date,
8091: ev.event_type_code event_type_code,

Line 8146: fa_mc_deprn_detail dd,

8142: ae_line_num,
8143: mult.multiplier multiplier
8144: from fa_xla_upg_events_gt ev,
8145: fa_xla_upg_headers_gt he,
8146: fa_mc_deprn_detail dd,
8147: fa_distribution_history dh,
8148: fa_distribution_accounts da,
8149: gl_je_lines jl_de,
8150: gl_je_lines jl_dr,