APPS.PO_ASL_UPGRADE_SV dependencies on MRP_SR_RECEIPT_ORG

Line 89: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL

85: SELECT MRP_SOURCING_RULES_S.NEXTVAL
86: FROM SYS.DUAL;
87:
88: CURSOR I2 is
89: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL
90: FROM SYS.DUAL;
91:
92: CURSOR I3 is
93: SELECT MRP_SR_ASSIGNMENTS_S.NEXTVAL

Line 287: -- Get new sr_receipt_id and insert into mrp_sr_receipt_org

283: x_first_rule := 'N';
284:
285: END IF;
286:
287: -- Get new sr_receipt_id and insert into mrp_sr_receipt_org
288:
289: OPEN I2;
290: FETCH I2 into x_sr_receipt_id;
291: IF (I2%NOTFOUND) THEN

Line 301: INSERT INTO MRP_SR_RECEIPT_ORG(

297:
298: x_progress := '110';
299: fnd_file.put_line(fnd_file.log, 'Upgrading autosource rule. AUTOSOURCE_RULE_ID = '||x_autosource_rule_id);
300:
301: INSERT INTO MRP_SR_RECEIPT_ORG(
302: sr_receipt_id,
303: sourcing_rule_id,
304: effective_date,
305: disable_date,