DBA Data[Home] [Help]

APPS.PO_SOURCING_RULES_SV dependencies on MRP_SR_RECEIPT_ORG_S

Line 492: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL

488: IF (g_po_pdoi_write_to_file = 'Y') THEN
489: PO_DEBUG.put_line(' Inserting Record in Mrp Sr Receipt Org');
490: END IF;
491:
492: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL
493: INTO x_sr_receipt_id
494: FROM SYS.DUAL;
495:
496:

Line 1098: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL

1094: */
1095: /* Create a new record for the new start and
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(

Line 1201: SELECT MRP_SR_RECEIPT_ORG_S.NEXTVAL

1197: AND x_end_date between msro.effective_date and msro.disable_date;
1198:
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: