eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WSH_XC_TRIP_STOPS_V

Source

View Text - Preformatted


SELECT wsh_trip_stops.stop_id, wsh_trip_stops.trip_id, wsh_trips.name, wsh_trip_stops.stop_location_id, wsh_trip_stops.stop_sequence_number, loc.ui_location_code, loc.address2, loc.address3, loc.address4, loc.postal_code, loc.country from wsh_trip_stops, wsh_trips, wsh_locations loc WHERE wsh_trips.trip_id = wsh_trip_stops.trip_id AND wsh_trip_stops.stop_location_id = loc.wsh_location_id(+) AND nvl(wsh_trip_stops.shipments_type_flag, 'O') IN ('O', 'M')

View Text - HTML Formatted

SELECT WSH_TRIP_STOPS.STOP_ID
, WSH_TRIP_STOPS.TRIP_ID
, WSH_TRIPS.NAME
, WSH_TRIP_STOPS.STOP_LOCATION_ID
, WSH_TRIP_STOPS.STOP_SEQUENCE_NUMBER
, LOC.UI_LOCATION_CODE
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.POSTAL_CODE
, LOC.COUNTRY
FROM WSH_TRIP_STOPS
, WSH_TRIPS
, WSH_LOCATIONS LOC
WHERE WSH_TRIPS.TRIP_ID = WSH_TRIP_STOPS.TRIP_ID
AND WSH_TRIP_STOPS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID(+)
AND NVL(WSH_TRIP_STOPS.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M')