View: WSH_SRS_DSNO_TRIP_STOPS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.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