DBA Data[Home] [Help]

APPS.PA_XLA_UPGRADE dependencies on PA_MC_CC_DIST_LINES_ALL

Line 1149: from PA_MC_CC_DIST_LINES_ALL mc,

1145: 'Cross Charge Debit' DR_REFERENCE_3,
1146: 'Cross Charge Credit' CR_REFERENCE_3,
1147: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
1148: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
1149: from PA_MC_CC_DIST_LINES_ALL mc,
1150: PA_CC_DIST_LINES_ALL cdl,
1151: PA_EXPENDITURE_ITEMS_ALL ei,
1152: PA_IMPLEMENTATIONS_ALL imp,
1153: XLA_EVENTS evt,

Line 1466: pa_mc_cc_dist_lines_all mc

1462: and lines_gt.cdl_line_num = mc.line_num);
1463:
1464:
1465: UPDATE /*+ INDEX( mc, PA_MC_CC_DIST_LINES_U2) */
1466: pa_mc_cc_dist_lines_all mc
1467: SET mc.xla_migrated_flag = 'Y'
1468: WHERE mc.expenditure_item_id between l_start_eiid and l_end_eiid
1469: and mc.line_type in ('BL','PC')
1470: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */