VIEW: APPS.MRPBV_REPLENISHMENT_SOURCES

Source

View Text - Preformatted

SELECT DISTINCT LO.MEANING , SR.ALLOCATION_PERCENT , SR.RANK , SR.SHIP_METHOD , SR.SR_SOURCE_ID , SR.SR_RECEIPT_ID , SR.SOURCE_ORGANIZATION_ID , SR.VENDOR_ID , SR.VENDOR_SITE_ID , SR.LAST_UPDATE_DATE , SR.LAST_UPDATED_BY , SR.CREATION_DATE , SR.CREATED_BY FROM MFG_LOOKUPS LO ,MTL_INTERORG_SHIP_METHODS INTER ,MRP_SR_SOURCE_ORG SR WHERE SR.SHIP_METHOD = INTER.SHIP_METHOD(+) AND ( (SR.SHIP_METHOD IS NULL) OR (INTER.FROM_ORGANIZATION_ID = SR.SOURCE_ORGANIZATION_ID AND INTER.TO_ORGANIZATION_ID = (SELECT RECEIPT_ORGANIZATION_ID FROM MRP_SR_RECEIPT_ORG WHERE SR_RECEIPT_ID = SR.SR_RECEIPT_ID)) ) AND LO.LOOKUP_TYPE(+) = 'MRP_SOURCE_TYPE' AND LO.LOOKUP_CODE(+) = SR.SOURCE_TYPE WITH READ ONLY

View Text - HTML Formatted

SELECT DISTINCT LO.MEANING
, SR.ALLOCATION_PERCENT
, SR.RANK
, SR.SHIP_METHOD
, SR.SR_SOURCE_ID
, SR.SR_RECEIPT_ID
, SR.SOURCE_ORGANIZATION_ID
, SR.VENDOR_ID
, SR.VENDOR_SITE_ID
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
, SR.CREATION_DATE
, SR.CREATED_BY
FROM MFG_LOOKUPS LO
, MTL_INTERORG_SHIP_METHODS INTER
, MRP_SR_SOURCE_ORG SR
WHERE SR.SHIP_METHOD = INTER.SHIP_METHOD(+)
AND ( (SR.SHIP_METHOD IS NULL) OR (INTER.FROM_ORGANIZATION_ID = SR.SOURCE_ORGANIZATION_ID
AND INTER.TO_ORGANIZATION_ID = (SELECT RECEIPT_ORGANIZATION_ID
FROM MRP_SR_RECEIPT_ORG
WHERE SR_RECEIPT_ID = SR.SR_RECEIPT_ID)) )
AND LO.LOOKUP_TYPE(+) = 'MRP_SOURCE_TYPE'
AND LO.LOOKUP_CODE(+) = SR.SOURCE_TYPE WITH READ ONLY