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:
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(*)
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
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;
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,