Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_SR_VIEW_EXP_V |
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
, SOUR.INTRANSIT_TIME
, 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