VIEW: APPS.WSH_TRIP_STOPS_OB_GRP_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')