DBA Data[Home] [Help]

VIEW: APPS.WSH_TRANSIT_TIMES_V

Source

View Text - Preformatted

SELECT DISTINCT FROM_LOCATION_ID, nvl(DESTINATION_TYPE, 'L') DESTINATION_TYPE, TO_LOCATION_ID, TO_REGION_ID, nvl(ORIGIN_TYPE, 'L') ORIGIN_TYPE, FROM_REGION_ID FROM MTL_INTERORG_SHIP_METHODS MTL
View Text - HTML Formatted

SELECT DISTINCT FROM_LOCATION_ID
, NVL(DESTINATION_TYPE
, 'L') DESTINATION_TYPE
, TO_LOCATION_ID
, TO_REGION_ID
, NVL(ORIGIN_TYPE
, 'L') ORIGIN_TYPE
, FROM_REGION_ID
FROM MTL_INTERORG_SHIP_METHODS MTL