APPS.MRP_SOURCING_RULE_PVT dependencies on MRP_SR_RECEIPT_ORG

Line 1045: FROM MRP_SR_RECEIPT_ORG RO1,

1041: -- overlapping effectivity dates
1042:
1043: SELECT count(*)
1044: INTO l_count
1045: FROM MRP_SR_RECEIPT_ORG RO1,
1046: MRP_SR_RECEIPT_ORG RO2
1047: WHERE RO1.sourcing_rule_id =
1048: l_sourcing_rule_rec.sourcing_rule_id
1049: AND RO1.sr_receipt_id = l_Receiving_Org_rec.sr_receipt_id

Line 1046: MRP_SR_RECEIPT_ORG RO2

1042:
1043: SELECT count(*)
1044: INTO l_count
1045: FROM MRP_SR_RECEIPT_ORG RO1,
1046: MRP_SR_RECEIPT_ORG RO2
1047: WHERE RO1.sourcing_rule_id =
1048: l_sourcing_rule_rec.sourcing_rule_id
1049: AND RO1.sr_receipt_id = l_Receiving_Org_rec.sr_receipt_id
1050: AND RO2.sourcing_rule_id = RO1.sourcing_rule_id

Line 1349: FROM MRP_SR_RECEIPT_ORG

1345: -- and every receiving org should have at least one source org
1346:
1347: SELECT count(*)
1348: INTO l_count
1349: FROM MRP_SR_RECEIPT_ORG
1350: WHERE sourcing_rule_id = l_sourcing_rule_rec.sourcing_rule_id;
1351:
1352: IF l_count = 0 THEN
1353: -- dbms_output.put_line ('At least one receiving org req');