View: MRPBV_REPLENISHMENT_SOURCES

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPBV_REPLENISHMENT_SOURCES

View Text

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

Columns