View: MRP_SR_VIEW_REC_V

Product:	MRP - Master Scheduling/MRP
Description:	Sourcing rule receipt only view
Implementation/DBA Data:	APPS.MRP_SR_VIEW_REC_V

View Text

SELECT DISTINCT REC.SOURCING_RULE_ID
, REC.RECEIPT_ORGANIZATION_ID
, REC.ORGANIZATION_CODE
FROM MRP_SR_RECEIPT_ORG_V REC
WHERE NOT EXISTS (SELECT NULL
FROM MRP_SR_RECEIPT_ORG REC1
, MRP_SR_SOURCE_ORG SOUR
WHERE SOUR.SOURCE_ORGANIZATION_ID = REC1.RECEIPT_ORGANIZATION_ID
AND SOUR.SOURCE_TYPE = 1
AND REC1.SR_RECEIPT_ID = SOUR.SR_RECEIPT_ID
AND REC1.SOURCING_RULE_ID = REC.SOURCING_RULE_ID)

Columns