View: MRP_INTER_LOCATIONS_V

Product:	MRP - Master Scheduling/MRP
Description:	Inter-Location Ship Methods view
Implementation/DBA Data:	APPS.MRP_INTER_LOCATIONS_V

View Text

SELECT DISTINCT MTL.FROM_LOCATION_ID
, DECODE(HR1.LOCATION_CODE
, NULL
, SUBSTR(HZ1.ADDRESS1
, 1
, 20)
, HR1.LOCATION_CODE) FROM_LOCATION
, DECODE(HR1.DESCRIPTION
, NULL
, SUBSTR(HZ1.ADDRESS1
, 1
, 50)
, HR1.DESCRIPTION) FROM_LOC_DESC
, MTL.TO_LOCATION_ID
, DECODE(HR2.LOCATION_CODE
, NULL
, SUBSTR(HZ2.ADDRESS1
, 1
, 20)
, HR2.LOCATION_CODE) TO_LOCATION
, DECODE(HR2.DESCRIPTION
, NULL
, SUBSTR(HZ2.ADDRESS1
, 1
, 50)
, HR2.DESCRIPTION) TO_LOC_DESC
FROM HR_LOCATIONS HR2
, HR_LOCATIONS HR1
, HZ_LOCATIONS HZ2
, HZ_LOCATIONS HZ1
, MTL_INTERORG_SHIP_METHODS MTL
WHERE HR2.LOCATION_ID(+) = MTL.TO_LOCATION_ID
AND HR1.LOCATION_ID(+) = MTL.FROM_LOCATION_ID
AND HZ2.LOCATION_ID(+) = MTL.TO_LOCATION_ID
AND HZ1.LOCATION_ID(+) = MTL.FROM_LOCATION_ID

Columns