[Home] [Help]
View: WSH_SRS_DSNO_TRIP_STOPS_V
View Text
SELECT WTS.STOP_ID
, WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION(WTS.STOP_LOCATION_ID
, 'D') DESCRIPTION
, WTP.NAME
FROM WSH_TRIPS WTP
, WSH_TRIP_STOPS WTS
, WSH_DELIVERY_LEGS WDL
WHERE WTP.TRIP_ID = WTS.TRIP_ID
AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID
AND 'THIS VIEW IS OBSOLETE
FROM PATCHSET I ONWARDS' = 'TRUE'
Columns
Name |
STOP_ID |
DESCRIPTION |
NAME |