VIEW: APPS.WSH_SRS_TRIP_STOPS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')