APPS.PO_ASL_UPGRADE_SV dependencies on MRP_SR_ASSIGNMENTS

Line 93: SELECT MRP_SR_ASSIGNMENTS_S.NEXTVAL

89: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL
90: FROM SYS.DUAL;
91:
92: CURSOR I3 is
93: SELECT MRP_SR_ASSIGNMENTS_S.NEXTVAL
94: FROM SYS.DUAL;
95:
96: BEGIN
97:

Line 138: To increase the perfomance, used the hint mrp_sr_assignments_n3

134:
135: x_progress := '060';
136:
137: /* Bug 1261392
138: To increase the perfomance, used the hint mrp_sr_assignments_n3
139: */
140:
141: SELECT /*+ INDEX(MRP_SR_ASSIGNMENTS MRP_SR_ASSIGNMENTS_N3)*/
142: count(*)

Line 141: SELECT /*+ INDEX(MRP_SR_ASSIGNMENTS MRP_SR_ASSIGNMENTS_N3)*/

137: /* Bug 1261392
138: To increase the perfomance, used the hint mrp_sr_assignments_n3
139: */
140:
141: SELECT /*+ INDEX(MRP_SR_ASSIGNMENTS MRP_SR_ASSIGNMENTS_N3)*/
142: count(*)
143: INTO x_dummy_count
144: FROM mrp_sr_assignments
145: WHERE inventory_item_id = x_item_id

Line 144: FROM mrp_sr_assignments

140:
141: SELECT /*+ INDEX(MRP_SR_ASSIGNMENTS MRP_SR_ASSIGNMENTS_N3)*/
142: count(*)
143: INTO x_dummy_count
144: FROM mrp_sr_assignments
145: WHERE inventory_item_id = x_item_id
146: AND assignment_set_id = x_assignment_set_id
147: AND sourcing_rule_type = 1
148: AND assignment_type = 3;

Line 411: INSERT INTO MRP_SR_ASSIGNMENTS(

407:
408: x_progress := '150';
409: fnd_file.put_line(fnd_file.log, 'Assigning sourcing rule to item.');
410:
411: INSERT INTO MRP_SR_ASSIGNMENTS(
412: assignment_id,
413: assignment_type,
414: sourcing_rule_id,
415: sourcing_rule_type,