View: WSHFV_TRIP_STOPS

Product:	WSH - Shipping Execution
Description:	Full BIS Business View for Trip Stops.
Implementation/DBA Data:	APPS.WSHFV_TRIP_STOPS

View Text

SELECT WSTS.STOP_ID
, WSTS.TRIP_ID
, WSTP.NAME TRIP_NAME
, LOC.SOURCE_LOCATION_ID
, LOC.UI_LOCATION_CODE
, '_LA:WSTS.STATUS_CODE:WSH_LOOKUPS:TRIP_STOP_STATUS:MEANING'
, WSTS.STOP_SEQUENCE_NUMBER
, WSTS.PLANNED_ARRIVAL_DATE
, WSTS.ACTUAL_ARRIVAL_DATE
, WSTS.PLANNED_DEPARTURE_DATE
, WSTS.ACTUAL_DEPARTURE_DATE
, WSTS.DEPARTURE_GROSS_WEIGHT
, WSTS.DEPARTURE_NET_WEIGHT
, WSTS.WEIGHT_UOM_CODE
, WSTS.DEPARTURE_VOLUME
, WSTS.VOLUME_UOM_CODE
, WSTS.DEPARTURE_SEAL_CODE
, WSTS.DEPARTURE_FILL_PERCENT
, '_LA:WSTS.PENDING_INTERFACE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:WSH:WSH_TRIP_STOPS:WSTS'
, '_DF:WSH:WSH_VEA_TRIP_STOPS:WSTS'
, WSTS.CREATION_DATE
, WSTS.CREATED_BY
, WSTS.LAST_UPDATE_DATE
, WSTS.LAST_UPDATED_BY
, WSTS.LAST_UPDATE_LOGIN
, WSTS.SHIPMENTS_TYPE_FLAG
FROM WSH_TRIP_STOPS WSTS
, WSH_TRIPS WSTP
, WSH_LOCATIONS LOC
WHERE WSTS.TRIP_ID = WSTP.TRIP_ID
AND WSTS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID(+)
AND NVL(WSTS.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M') WITH READ ONLY

Columns