APPS.MRP_SOURCING_RULE_PVT dependencies on MRP_SR_SOURCE_ORG

Line 1262: FROM MRP_SR_SOURCE_ORG SO1,

1258:
1259: /**** Bug 2263575
1260: SELECT count(*)
1261: INTO l_count
1262: FROM MRP_SR_SOURCE_ORG SO1,
1263: MRP_SR_SOURCE_ORG SO2
1264: WHERE SO1.sr_receipt_id =
1265: l_Shipping_Org_rec.sr_receipt_id
1266: AND SO1.sr_source_id = l_Shipping_Org_rec.sr_source_id

Line 1263: MRP_SR_SOURCE_ORG SO2

1259: /**** Bug 2263575
1260: SELECT count(*)
1261: INTO l_count
1262: FROM MRP_SR_SOURCE_ORG SO1,
1263: MRP_SR_SOURCE_ORG SO2
1264: WHERE SO1.sr_receipt_id =
1265: l_Shipping_Org_rec.sr_receipt_id
1266: AND SO1.sr_source_id = l_Shipping_Org_rec.sr_source_id
1267: AND SO2.sr_receipt_id = SO1.sr_receipt_id

Line 1305: UPDATE mrp_sr_source_org

1301: AND supplier_site_id = to_char(l_Shipping_Org_rec.vendor_site_id);
1302:
1303: IF l_organization_id IS NOT NULL AND
1304: l_organization_id <> FND_API.G_MISS_NUM THEN
1305: UPDATE mrp_sr_source_org
1306: SET source_organization_id = l_organization_id
1307: WHERE sr_source_id = l_Shipping_Org_rec.sr_source_id;
1308:
1309: END IF;

Line 1365: FROM MRP_SR_SOURCE_ORG

1361:
1362: FOR I IN 1..l_Receiving_Org_tbl.COUNT LOOP
1363: SELECT count(*)
1364: INTO l_count
1365: FROM MRP_SR_SOURCE_ORG
1366: WHERE sr_receipt_id = l_Receiving_Org_tbl(I).Sr_Receipt_Id;
1367:
1368: IF l_count = 0 THEN
1369: -- dbms_output.put_line ('At least one source req');