APPS.PO_SOURCING_RULES_SV dependencies on DUAL

Line 468: FROM SYS.DUAL;

464: END IF;
465:
466: SELECT MRP_SOURCING_RULES_S.NEXTVAL
467: INTO x_sourcing_rule_id
468: FROM SYS.DUAL;
469:
470: INSERT INTO MRP_SOURCING_RULES(
471: sourcing_rule_id,
472: sourcing_rule_name,

Line 502: FROM SYS.DUAL;

498: END IF;
499:
500: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL
501: INTO x_sr_receipt_id
502: FROM SYS.DUAL;
503:
504:
505: X_progress := '040';
506: INSERT INTO MRP_SR_RECEIPT_ORG(

Line 537: FROM SYS.DUAL;

533:
534: X_progress := '050';
535: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
536: INTO x_sr_source_id
537: FROM SYS.DUAL;
538:
539:
540: INSERT INTO MRP_SR_SOURCE_ORG(
541: sr_source_id,

Line 628: FROM SYS.DUAL;

624:
625:
626: SELECT MRP_SR_ASSIGNMENTS_S.NEXTVAL
627: INTO x_assignment_id
628: FROM SYS.DUAL;
629:
630: INSERT INTO MRP_SR_ASSIGNMENTS(
631: assignment_id,
632: assignment_type,

Line 1162: FROM SYS.DUAL;

1158: end dates */
1159:
1160: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL
1161: INTO x_sr_receipt_id
1162: FROM SYS.DUAL;
1163:
1164: INSERT INTO MRP_SR_RECEIPT_ORG(
1165: sr_receipt_id,
1166: sourcing_rule_id,

Line 1193: FROM SYS.DUAL;

1189: -- update existing links to sourcing rule
1190:
1191: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1192: INTO x_sr_source_id
1193: FROM SYS.DUAL;
1194:
1195: SELECT nvl(max(rank),0) +1
1196: INTO x_vendor_rank
1197: FROM MRP_SR_SOURCE_ORG MSSO

Line 1265: FROM SYS.DUAL;

1261: if (x_sourcing_rule_within = 0) then
1262:
1263: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL
1264: INTO x_sr_receipt_id
1265: FROM SYS.DUAL;
1266:
1267:
1268: INSERT INTO MRP_SR_RECEIPT_ORG(
1269: sr_receipt_id,

Line 1297: FROM SYS.DUAL;

1293: -- update existing links to sourcing rule
1294:
1295: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1296: INTO x_sr_source_id
1297: FROM SYS.DUAL;
1298:
1299: SELECT nvl(max(rank),0) +1
1300: INTO x_vendor_rank
1301: FROM MRP_SR_SOURCE_ORG MSSO

Line 1381: FROM SYS.DUAL;

1377: -- update existing links to sourcing rule
1378:
1379: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1380: INTO x_sr_source_id
1381: FROM SYS.DUAL;
1382:
1383: -- #13961772 POASLGEN IS NOT PROPERLY UPDATING SOURCING RULES
1384: -- the new source org has the top rank, always set the
1385: -- rank to 1, and update the existings to self increasing 1

Line 1539: from dual where not exists

1535: -- Bug 3692799: organization_id should be null
1536: -- when assignment_type is 3 (item assignment)
1537: l_organization_id, ----
1538: x_item_id
1539: from dual where not exists
1540: (select 'The item has to be attached to the assignment set' from
1541: mrp_sr_assignments where
1542: sourcing_rule_id=X_sourcing_rule_id --FPH
1543: and inventory_item_id= X_item_id);