View: WSHBV_TRIP_STOPS

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSHBV_TRIP_STOPS

View Text

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

Columns