VIEW: APPS.MRPFV_REPLENISHMENT_SOURCES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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