[Home] [Help]
View: WSH_XC_TRIP_STOPS_V
View Text
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')
Columns
Name |
TRIP_STOP_ID |
TRIP_ID |
TRIP_NAME |
STOP_LOCATION_ID |
STOP_SEQUENCE_NUMBER |
LOCATION_CODE |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
POSTAL_CODE |
COUNTRY |