eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_SOURCING_RULES_SV dependencies on MRP_SR_SOURCE_ORG

Line 15: -- mrp_sr_receipt_org, mrp_sr_source_org depending on the create or update

11: --Pre-reqs:
12: -- None
13: --Modifies:
14: -- This API inserts row into mrp_sr_assignments, mrp_sourcing_rules,
15: -- mrp_sr_receipt_org, mrp_sr_source_org depending on the create or update
16: -- flag from the approval flag.
17: --Locks:
18: -- None.
19: --Function:

Line 523: PO_DEBUG.put_line(' Inserting Record in Mrp Sr Source Org');

519: l_organization_id----
520: );
521:
522: IF (g_po_pdoi_write_to_file = 'Y') THEN
523: PO_DEBUG.put_line(' Inserting Record in Mrp Sr Source Org');
524: END IF;
525:
526: X_progress := '050';
527: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

Line 527: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

523: PO_DEBUG.put_line(' Inserting Record in Mrp Sr Source Org');
524: END IF;
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:

Line 532: INSERT INTO MRP_SR_SOURCE_ORG(

528: INTO x_sr_source_id
529: FROM SYS.DUAL;
530:
531:
532: INSERT INTO MRP_SR_SOURCE_ORG(
533: sr_source_id,
534: sr_receipt_id,
535: vendor_id,
536: vendor_site_id,

Line 875: mrp_sr_source_org msso

871: SELECT count(*) into x_within_vendor_cnt
872: FROM
873: mrp_sr_receipt_org msro,
874: mrp_sourcing_rules msr,
875: mrp_sr_source_org msso
876: WHERE msr.sourcing_rule_id = msro.sourcing_rule_id
877: AND msro.sr_receipt_id = msso.sr_receipt_id
878: AND msr.sourcing_rule_id = x_sourcing_rule_id
879: AND x_start_date between msro.effective_date and msro.disable_date

Line 1008: from mrp_sr_source_org

1004: -- bug fix 2320143 Throw error if vendor is different or vendor and site is different
1005: X_progress := '050';
1006: select count(*)
1007: into x_vendor_count
1008: from mrp_sr_source_org
1009: where sr_receipt_id = x_sr_receipt_id
1010: and (
1011: (vendor_id <> X_vendor_id)
1012: or

Line 1129: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

1125: );
1126:
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

Line 1135: FROM MRP_SR_SOURCE_ORG MSSO

1131: FROM SYS.DUAL;
1132:
1133: SELECT nvl(max(rank),0) +1
1134: INTO x_vendor_rank
1135: FROM MRP_SR_SOURCE_ORG MSSO
1136: WHERE sr_receipt_id = x_sr_receipt_id;
1137:
1138: INSERT INTO MRP_SR_SOURCE_ORG(
1139: sr_source_id,

Line 1138: INSERT INTO MRP_SR_SOURCE_ORG(

1134: INTO x_vendor_rank
1135: FROM MRP_SR_SOURCE_ORG MSSO
1136: WHERE sr_receipt_id = x_sr_receipt_id;
1137:
1138: INSERT INTO MRP_SR_SOURCE_ORG(
1139: sr_source_id,
1140: sr_receipt_id,
1141: vendor_id,
1142: vendor_site_id,

Line 1233: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

1229: );
1230:
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

Line 1239: FROM MRP_SR_SOURCE_ORG MSSO

1235: FROM SYS.DUAL;
1236:
1237: SELECT nvl(max(rank),0) +1
1238: INTO x_vendor_rank
1239: FROM MRP_SR_SOURCE_ORG MSSO
1240: WHERE sr_receipt_id = x_sr_receipt_id;
1241:
1242: IF (g_po_pdoi_write_to_file = 'Y') THEN
1243: PO_DEBUG.put_line(' Vendor Rank' || to_char(x_vendor_rank));

Line 1247: INSERT INTO MRP_SR_SOURCE_ORG(

1243: PO_DEBUG.put_line(' Vendor Rank' || to_char(x_vendor_rank));
1244: PO_DEBUG.put_line(' Inserting Record MSSO for existing rule');
1245: END IF;
1246:
1247: INSERT INTO MRP_SR_SOURCE_ORG(
1248: sr_source_id,
1249: sr_receipt_id,
1250: vendor_id,
1251: vendor_site_id,

Line 1295: FROM mrp_sr_source_org msso

1291: corresponding ASL consists of no supplier_site_code - making the provision for
1292: vendor_site_id and x_vendor_site_id to be null without an error.*/
1293: SELECT count(*)
1294: INTO x_vendor_count_on_sr
1295: FROM mrp_sr_source_org msso
1296: WHERE
1297: sr_receipt_id = x_sr_receipt_id
1298: AND vendor_id = x_vendor_id
1299: AND (vendor_site_id = x_vendor_site_id

Line 1317: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

1313:
1314: X_progress := '100';
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

Line 1323: FROM MRP_SR_SOURCE_ORG MSSO

1319: FROM SYS.DUAL;
1320:
1321: SELECT nvl(max(rank),0) +1
1322: INTO x_vendor_rank
1323: FROM MRP_SR_SOURCE_ORG MSSO
1324: WHERE sr_receipt_id = x_sr_receipt_id;
1325:
1326: IF (g_po_pdoi_write_to_file = 'Y') THEN
1327: PO_DEBUG.put_line(' New Vendor Rank ' || to_char(x_vendor_rank));

Line 1330: INSERT INTO MRP_SR_SOURCE_ORG(

1326: IF (g_po_pdoi_write_to_file = 'Y') THEN
1327: PO_DEBUG.put_line(' New Vendor Rank ' || to_char(x_vendor_rank));
1328: END IF;
1329:
1330: INSERT INTO MRP_SR_SOURCE_ORG(
1331: sr_source_id,
1332: sr_receipt_id,
1333: vendor_id,
1334: vendor_site_id,