VIEW: APPS.MSC_SR_VIEW_EXP_V

Source

View Text - Preformatted

SELECT REC.SOURCING_RULE_ID , REC.SR_RECEIPT_ID , REC.SR_RECEIPT_ORG , REC.RECEIPT_ORG_INSTANCE_ID , REC.SR_INSTANCE_ID , SOUR.SR_SOURCE_ID , LOOK.MEANING SOURCE_TYPE , NVL(SOUR.SOURCE_ORGANIZATION_ID, 0) SOURCE_ORGANIZATION_ID , SOUR.SOURCE_ORG_INSTANCE_ID , SOUR.SOURCE_ORGANIZATION_CODE , SOUR.VENDOR_NAME , SOUR.VENDOR_SITE , SOUR.ALLOCATION_PERCENT , SOUR.RANK , SOUR.SHIP_METHOD , NULL , SOUR.SOURCE_ORGANIZATION_CODE||SOUR.VENDOR_NAME FROM MFG_LOOKUPS LOOK, MSC_SR_SOURCE_ORG_V SOUR, MSC_SR_RECEIPT_ORG REC WHERE REC.SR_RECEIPT_ID = SOUR.SR_RECEIPT_ID AND SOUR.SOURCE_TYPE != 2 AND LOOK.LOOKUP_TYPE = 'MRP_SOURCE_TYPE' AND LOOK.LOOKUP_CODE = SOUR.SOURCE_TYPE

View Text - HTML Formatted

SELECT REC.SOURCING_RULE_ID
, REC.SR_RECEIPT_ID
, REC.SR_RECEIPT_ORG
, REC.RECEIPT_ORG_INSTANCE_ID
, REC.SR_INSTANCE_ID
, SOUR.SR_SOURCE_ID
, LOOK.MEANING SOURCE_TYPE
, NVL(SOUR.SOURCE_ORGANIZATION_ID
, 0) SOURCE_ORGANIZATION_ID
, SOUR.SOURCE_ORG_INSTANCE_ID
, SOUR.SOURCE_ORGANIZATION_CODE
, SOUR.VENDOR_NAME
, SOUR.VENDOR_SITE
, SOUR.ALLOCATION_PERCENT
, SOUR.RANK
, SOUR.SHIP_METHOD
, NULL
, SOUR.SOURCE_ORGANIZATION_CODE||SOUR.VENDOR_NAME
FROM MFG_LOOKUPS LOOK
, MSC_SR_SOURCE_ORG_V SOUR
, MSC_SR_RECEIPT_ORG REC
WHERE REC.SR_RECEIPT_ID = SOUR.SR_RECEIPT_ID
AND SOUR.SOURCE_TYPE != 2
AND LOOK.LOOKUP_TYPE = 'MRP_SOURCE_TYPE'
AND LOOK.LOOKUP_CODE = SOUR.SOURCE_TYPE