[Home] [Help]
View: MSC_SR_VIEW_MAKE_AT_V
View Text
SELECT REC.SOURCING_RULE_ID
, REC.SR_RECEIPT_ID
, REC.SR_RECEIPT_ORG
, REC.SR_INSTANCE_ID
, SOUR.SR_SOURCE_ID
, LOOK.MEANING SOURCE_TYPE
, SOUR.SOURCE_ORGANIZATION_ID
, SOUR.SOURCE_ORGANIZATION_CODE
, SOUR.VENDOR_NAME
, SOUR.VENDOR_SITE
, SOUR.ALLOCATION_PERCENT
, SOUR.RANK
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
Columns
Name |
SOURCING_RULE_ID |
SR_RECEIPT_ID |
RECEIPT_ORGANIZATION_ID |
SR_INSTANCE_ID |
SR_SOURCE_ID |
SOURCE_TYPE |
SOURCE_ORGANIZATION_ID |
SOURCE_ORGANIZATION_CODE |
VENDOR_NAME |
VENDOR_SITE |
ALLOCATION_PERCENT |
RANK |