APPS.PA_XLA_UPGRADE dependencies on PA_MC_COST_DIST_LINES_ALL

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

1041: CR_REFERENCE_2,
1042: CR_REFERENCE_3
1043: )
1044: SELECT /*+ USE_NL (cdl mc ei) INDEX(cdl, PA_COST_DISTRIBUTION_LINES_U1)
1045: INDEX( mc, PA_MC_COST_DIST_LINES_ALL_U1) INDEX(ei, PA_EXPENDITURE_ITEMS_PK) */
1046: to_number(hoi.org_information2) legal_entity_id,
1047: mc.set_of_books_id ledger_id,
1048: imp.org_id,
1049: mc.expenditure_item_id,

Line 1109: from PA_MC_COST_DIST_LINES_ALL mc,

1105: 'Cost' DR_REFERENCE_3,
1106: 'Liability' CR_REFERENCE_3,
1107: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
1108: to_char('-99') CR_REFERENCE_2
1109: from PA_MC_COST_DIST_LINES_ALL mc,
1110: PA_COST_DISTRIBUTION_LINES_ALL cdl,
1111: PA_EXPENDITURE_ITEMS_ALL ei,
1112: PA_IMPLEMENTATIONS_ALL imp,
1113: XLA_EVENTS evt,

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

1460: and event_gt.grouped_line_type = lines_gt.grouped_line_type
1461: );
1462:
1463:
1464: UPDATE /*+ INDEX( mc, PA_MC_COST_DIST_LINES_ALL_U1) */
1465: pa_mc_cost_dist_lines_all mc
1466: SET mc.xla_migrated_flag = 'Y'
1467: WHERE mc.expenditure_item_id between l_start_eiid and l_end_eiid
1468: and mc.line_type in ('R','C','D')

Line 1465: pa_mc_cost_dist_lines_all mc

1461: );
1462:
1463:
1464: UPDATE /*+ INDEX( mc, PA_MC_COST_DIST_LINES_ALL_U1) */
1465: pa_mc_cost_dist_lines_all mc
1466: SET mc.xla_migrated_flag = 'Y'
1467: WHERE mc.expenditure_item_id between l_start_eiid and l_end_eiid
1468: and mc.line_type in ('R','C','D')
1469: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */