[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 |
APPS.WSH_XC_TRIP_STOPS_V