VIEW: WSH.WSH_TRIP_STOPS#

Source

View Text - Preformatted

select STOP_ID STOP_ID, TRIP_ID TRIP_ID, STOP_LOCATION_ID STOP_LOCATION_ID, STATUS_CODE STATUS_CODE, STOP_SEQUENCE_NUMBER STOP_SEQUENCE_NUMBER, PLANNED_ARRIVAL_DATE PLANNED_ARRIVAL_DATE, PLANNED_DEPARTURE_DATE PLANNED_DEPARTURE_DATE, ACTUAL_ARRIVAL_DATE ACTUAL_ARRIVAL_DATE, ACTUAL_DEPARTURE_DATE ACTUAL_DEPARTURE_DATE, DEPARTURE_GROSS_WEIGHT DEPARTURE_GROSS_WEIGHT, DEPARTURE_NET_WEIGHT DEPARTURE_NET_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, DEPARTURE_VOLUME DEPARTURE_VOLUME, VOLUME_UOM_CODE VOLUME_UOM_CODE, DEPARTURE_SEAL_CODE DEPARTURE_SEAL_CODE, DEPARTURE_FILL_PERCENT DEPARTURE_FILL_PERCENT, TP_ATTRIBUTE_CATEGORY TP_ATTRIBUTE_CATEGORY, TP_ATTRIBUTE1 TP_ATTRIBUTE1, TP_ATTRIBUTE2 TP_ATTRIBUTE2, TP_ATTRIBUTE3 TP_ATTRIBUTE3, TP_ATTRIBUTE4 TP_ATTRIBUTE4, TP_ATTRIBUTE5 TP_ATTRIBUTE5, TP_ATTRIBUTE6 TP_ATTRIBUTE6, TP_ATTRIBUTE7 TP_ATTRIBUTE7, TP_ATTRIBUTE8 TP_ATTRIBUTE8, TP_ATTRIBUTE9 TP_ATTRIBUTE9, TP_ATTRIBUTE10 TP_ATTRIBUTE10, TP_ATTRIBUTE11 TP_ATTRIBUTE11, TP_ATTRIBUTE12 TP_ATTRIBUTE12, TP_ATTRIBUTE13 TP_ATTRIBUTE13, TP_ATTRIBUTE14 TP_ATTRIBUTE14, TP_ATTRIBUTE15 TP_ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, LOCK_STOP_ID LOCK_STOP_ID, PENDING_INTERFACE_FLAG PENDING_INTERFACE_FLAG, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, WSH_LOCATION_ID WSH_LOCATION_ID, TRACKING_DRILLDOWN_FLAG TRACKING_DRILLDOWN_FLAG, TRACKING_REMARKS TRACKING_REMARKS, CARRIER_EST_DEPARTURE_DATE CARRIER_EST_DEPARTURE_DATE, CARRIER_EST_ARRIVAL_DATE CARRIER_EST_ARRIVAL_DATE, LOADING_START_DATETIME LOADING_START_DATETIME, LOADING_END_DATETIME LOADING_END_DATETIME, UNLOADING_START_DATETIME UNLOADING_START_DATETIME, UNLOADING_END_DATETIME UNLOADING_END_DATETIME, TP_STOP_ID TP_STOP_ID, WKEND_LAYOVER_STOPS WKEND_LAYOVER_STOPS, WKDAY_LAYOVER_STOPS WKDAY_LAYOVER_STOPS, SHIPMENTS_TYPE_FLAG SHIPMENTS_TYPE_FLAG, WV_FROZEN_FLAG WV_FROZEN_FLAG, BATCH_ID BATCH_ID, PHYSICAL_STOP_ID PHYSICAL_STOP_ID, PHYSICAL_LOCATION_ID PHYSICAL_LOCATION_ID, DISTANCE_TO_NEXT_STOP DISTANCE_TO_NEXT_STOP, DISTANCE_UOM DISTANCE_UOM, PICK_UP_WEIGHT PICK_UP_WEIGHT, DROP_OFF_WEIGHT DROP_OFF_WEIGHT, PICK_UP_VOLUME PICK_UP_VOLUME, DROP_OFF_VOLUME DROP_OFF_VOLUME, TMS_INTERFACE_FLAG TMS_INTERFACE_FLAG from "WSH"."WSH_TRIP_STOPS"

View Text - HTML Formatted

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