View: MSC_SR_VIEW_REC_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_SR_VIEW_REC_V

View Text

SELECT DISTINCT REC.SOURCING_RULE_ID
, REC.RECEIPT_ORGANIZATION_ID
, REC.RECEIPT_ORG_INSTANCE_ID
, REC.ORGANIZATION_CODE
FROM MSC_SR_RECEIPT_ORG_V REC
WHERE NOT EXISTS (SELECT NULL
FROM MSC_SR_RECEIPT_ORG REC1
, MSC_SR_SOURCE_ORG SOUR
WHERE SOUR.SOURCE_ORGANIZATION_ID = REC1.SR_RECEIPT_ORG
AND SOUR.SOURCE_TYPE = 1
AND REC1.SR_RECEIPT_ID = SOUR.SR_RECEIPT_ID
AND REC1.SOURCING_RULE_ID = REC.SOURCING_RULE_ID)

Columns