VIEW: APPS.MRP_INTER_LOCATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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