APPS.PO_SOURCING_RULES_SV dependencies on DUAL

Line 460: FROM SYS.DUAL;

456: END IF;
457:
458: SELECT MRP_SOURCING_RULES_S.NEXTVAL
459: INTO x_sourcing_rule_id
460: FROM SYS.DUAL;
461:
462: INSERT INTO MRP_SOURCING_RULES(
463: sourcing_rule_id,
464: sourcing_rule_name,

Line 494: FROM SYS.DUAL;

490: END IF;
491:
492: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL
493: INTO x_sr_receipt_id
494: FROM SYS.DUAL;
495:
496:
497: X_progress := '040';
498: INSERT INTO MRP_SR_RECEIPT_ORG(

Line 529: FROM SYS.DUAL;

525:
526: X_progress := '050';
527: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
528: INTO x_sr_source_id
529: FROM SYS.DUAL;
530:
531:
532: INSERT INTO MRP_SR_SOURCE_ORG(
533: sr_source_id,

Line 620: FROM SYS.DUAL;

616:
617:
618: SELECT MRP_SR_ASSIGNMENTS_S.NEXTVAL
619: INTO x_assignment_id
620: FROM SYS.DUAL;
621:
622: INSERT INTO MRP_SR_ASSIGNMENTS(
623: assignment_id,
624: assignment_type,

Line 1100: FROM SYS.DUAL;

1096: end dates */
1097:
1098: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL
1099: INTO x_sr_receipt_id
1100: FROM SYS.DUAL;
1101:
1102: INSERT INTO MRP_SR_RECEIPT_ORG(
1103: sr_receipt_id,
1104: sourcing_rule_id,

Line 1131: FROM SYS.DUAL;

1127: -- update existing links to sourcing rule
1128:
1129: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1130: INTO x_sr_source_id
1131: FROM SYS.DUAL;
1132:
1133: SELECT nvl(max(rank),0) +1
1134: INTO x_vendor_rank
1135: FROM MRP_SR_SOURCE_ORG MSSO

Line 1203: FROM SYS.DUAL;

1199: if (x_sourcing_rule_within = 0) then
1200:
1201: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL
1202: INTO x_sr_receipt_id
1203: FROM SYS.DUAL;
1204:
1205:
1206: INSERT INTO MRP_SR_RECEIPT_ORG(
1207: sr_receipt_id,

Line 1235: FROM SYS.DUAL;

1231: -- update existing links to sourcing rule
1232:
1233: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1234: INTO x_sr_source_id
1235: FROM SYS.DUAL;
1236:
1237: SELECT nvl(max(rank),0) +1
1238: INTO x_vendor_rank
1239: FROM MRP_SR_SOURCE_ORG MSSO

Line 1319: FROM SYS.DUAL;

1315: -- update existing links to sourcing rule
1316:
1317: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1318: INTO x_sr_source_id
1319: FROM SYS.DUAL;
1320:
1321: SELECT nvl(max(rank),0) +1
1322: INTO x_vendor_rank
1323: FROM MRP_SR_SOURCE_ORG MSSO

Line 1459: from dual where not exists

1455: -- Bug 3692799: organization_id should be null
1456: -- when assignment_type is 3 (item assignment)
1457: l_organization_id, ----
1458: x_item_id
1459: from dual where not exists
1460: (select 'The item has to be attached to the assignment set' from
1461: mrp_sr_assignments where
1462: sourcing_rule_id=X_sourcing_rule_id --FPH
1463: and inventory_item_id= X_item_id);