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)
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)
|
|
|