View: WSH_TRIP_STOPS_OB_GRP_V

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

View Text

SELECT STOP_ID
, TRIP_ID
, STOP_LOCATION_ID
, STATUS_CODE
, STOP_SEQUENCE_NUMBER
, PLANNED_ARRIVAL_DATE
, PLANNED_DEPARTURE_DATE
, ACTUAL_ARRIVAL_DATE
, ACTUAL_DEPARTURE_DATE
, DEPARTURE_GROSS_WEIGHT
, DEPARTURE_NET_WEIGHT
, WEIGHT_UOM_CODE
, DEPARTURE_VOLUME
, VOLUME_UOM_CODE
, DEPARTURE_SEAL_CODE
, DEPARTURE_FILL_PERCENT
, TP_ATTRIBUTE_CATEGORY
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LOCK_STOP_ID
, PENDING_INTERFACE_FLAG
, TRANSACTION_HEADER_ID
, WSH_LOCATION_ID
, TRACKING_DRILLDOWN_FLAG
, TRACKING_REMARKS
, CARRIER_EST_DEPARTURE_DATE
, CARRIER_EST_ARRIVAL_DATE
, LOADING_START_DATETIME
, LOADING_END_DATETIME
, UNLOADING_START_DATETIME
, UNLOADING_END_DATETIME
, TP_STOP_ID
, WKEND_LAYOVER_STOPS
, WKDAY_LAYOVER_STOPS
, SHIPMENTS_TYPE_FLAG
, WV_FROZEN_FLAG
, BATCH_ID
, PHYSICAL_STOP_ID
, PHYSICAL_LOCATION_ID
, TMS_INTERFACE_FLAG
FROM WSH_TRIP_STOPS
WHERE NVL(SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M')

Columns