VIEW: APPS.WSH_SRS_DSNO_TRIP_STOPS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'