View: MRPFV_REPLENISHMENT_SOURCES

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

View Text

SELECT DISTINCT LO.MEANING
, PA.ORGANIZATION_CODE
, AL.NAME
, VE.VENDOR_NAME
, VESI.VENDOR_SITE_CODE
, SR.ALLOCATION_PERCENT
, SR.RANK
, SR.SHIP_METHOD
, INTER.INTRANSIT_TIME
, '_DF:MRP:MRP_SR_SOURCE_ORG:SR'
, 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
, PO_VENDOR_SITES_ALL VESI
, PO_VENDORS VE
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MRP_SR_SOURCE_ORG SR
WHERE SR.SOURCE_ORGANIZATION_ID = PA.ORGANIZATION_ID(+)
AND SR.SOURCE_ORGANIZATION_ID = AL.ORGANIZATION_ID(+)
AND SR.VENDOR_ID = VE.VENDOR_ID(+)
AND SR.VENDOR_SITE_ID = VESI.VENDOR_SITE_ID(+)
AND SR.SOURCE_ORGANIZATION_ID = VESI.ORG_ID(+)
AND SR.SHIP_METHOD = INTER.SHIP_METHOD(+)
AND ( (SR.SHIP_METHOD IS NULL) OR (SR.SOURCE_ORGANIZATION_ID = INTER.FROM_ORGANIZATION_ID
AND INTER.TO_ORGANIZATION_ID = (SELECT RECEIPT_ORGANIZATION_ID
FROM MRP_SR_RECEIPT_ORG SR2
WHERE SR2.SR_RECEIPT_ID = SR.SR_RECEIPT_ID)))
AND LO.LOOKUP_TYPE(+) = 'MRP_SOURCE_TYPE'
AND LO.LOOKUP_CODE(+) = SR.SOURCE_TYPE
AND '_SEC:SR.SOURCE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns