View: WSH_SRS_TRIP_STOPS_V

Product:	WSH - Shipping Execution
Description:	/* 1924581 changes: HR_LOCATIONS, 8/15 */
Implementation/DBA Data:	APPS.WSH_SRS_TRIP_STOPS_V

View Text

SELECT TS.STOP_ID
, T.NAME || '-' || WL.LOCATION_CODE||':'|| NVL(WL.CITY
, SUBSTRB(WL.ADDRESS1
, 1
, 60))|| '-' || TO_CHAR(NVL(TS.ACTUAL_DEPARTURE_DATE
, TS.PLANNED_DEPARTURE_DATE)
, 'DD\MM\YYYY') STOP_DESCRIPTION
, TS.STOP_LOCATION_ID
, WL.LOCATION_CODE || ':' ||NVL(WL.CITY
, SUBSTRB(WL.ADDRESS1
, 1
, 60)) LOCATION_CODE
, WL.UI_LOCATION_CODE LOCATION_DESCRIPTION
, T.TRIP_ID
, TS.PENDING_INTERFACE_FLAG
FROM WSH_TRIPS T
, WSH_TRIP_STOPS TS
, WSH_LOCATIONS WL
WHERE TS.TRIP_ID = T.TRIP_ID
AND TS.STOP_LOCATION_ID = WL.WSH_LOCATION_ID
AND NVL(TS.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M')

Columns