APPS.PA_XLA_UPGRADE dependencies on PA_MC_COST_DIST_LINES_ALL

Line 1034: INDEX( mc, PA_MC_COST_DIST_LINES_ALL_U1) INDEX(ei, PA_EXPENDITURE_ITEMS_PK) */

1030: CR_REFERENCE_2,
1031: CR_REFERENCE_3
1032: )
1033: SELECT /*+ USE_NL (cdl mc ei) INDEX(cdl, PA_COST_DISTRIBUTION_LINES_U1)
1034: INDEX( mc, PA_MC_COST_DIST_LINES_ALL_U1) INDEX(ei, PA_EXPENDITURE_ITEMS_PK) */
1035: to_number(hoi.org_information2) legal_entity_id,
1036: mc.set_of_books_id ledger_id,
1037: imp.org_id,
1038: mc.expenditure_item_id,

Line 1098: from PA_MC_COST_DIST_LINES_ALL mc,

1094: 'Cost' DR_REFERENCE_3,
1095: 'Liability' CR_REFERENCE_3,
1096: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
1097: to_char('-99') CR_REFERENCE_2
1098: from PA_MC_COST_DIST_LINES_ALL mc,
1099: PA_COST_DISTRIBUTION_LINES_ALL cdl,
1100: PA_EXPENDITURE_ITEMS_ALL ei,
1101: PA_IMPLEMENTATIONS_ALL imp,
1102: XLA_EVENTS evt,

Line 1453: UPDATE /*+ INDEX( mc, PA_MC_COST_DIST_LINES_ALL_U1) */

1449: and event_gt.grouped_line_type = lines_gt.grouped_line_type
1450: );
1451:
1452:
1453: UPDATE /*+ INDEX( mc, PA_MC_COST_DIST_LINES_ALL_U1) */
1454: pa_mc_cost_dist_lines_all mc
1455: SET mc.xla_migrated_flag = 'Y'
1456: WHERE mc.expenditure_item_id between l_start_eiid and l_end_eiid
1457: and mc.line_type in ('R','C','D')

Line 1454: pa_mc_cost_dist_lines_all mc

1450: );
1451:
1452:
1453: UPDATE /*+ INDEX( mc, PA_MC_COST_DIST_LINES_ALL_U1) */
1454: pa_mc_cost_dist_lines_all mc
1455: SET mc.xla_migrated_flag = 'Y'
1456: WHERE mc.expenditure_item_id between l_start_eiid and l_end_eiid
1457: and mc.line_type in ('R','C','D')
1458: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */