[Home] [Help]
View: WSH_TRIP_STOPS_V
View Text
SELECT TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, S.ROWID
, S.STOP_ID
, S.TRIP_ID
, T.NAME
, S.STOP_LOCATION_ID
, S.STATUS_CODE
, WL.MEANING
, S.PLANNED_ARRIVAL_DATE
, S.PLANNED_DEPARTURE_DATE
, S.ACTUAL_ARRIVAL_DATE
, S.ACTUAL_DEPARTURE_DATE
, S.DEPARTURE_SEAL_CODE
, S.STOP_SEQUENCE_NUMBER
, S.WV_FROZEN_FLAG
, S.DEPARTURE_GROSS_WEIGHT
, (S.DEPARTURE_GROSS_WEIGHT-NVL(S.DEPARTURE_NET_WEIGHT
, 0))
, S.DEPARTURE_NET_WEIGHT
, S.WEIGHT_UOM_CODE
, S.DEPARTURE_VOLUME
, S.VOLUME_UOM_CODE
, S.DEPARTURE_FILL_PERCENT
, TO_CHAR(NULL)
, S.ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1
, S.ATTRIBUTE2
, S.ATTRIBUTE3
, S.ATTRIBUTE4
, S.ATTRIBUTE5
, S.ATTRIBUTE6
, S.ATTRIBUTE7
, S.ATTRIBUTE8
, S.ATTRIBUTE9
, S.ATTRIBUTE10
, S.ATTRIBUTE11
, S.ATTRIBUTE12
, S.ATTRIBUTE13
, S.ATTRIBUTE14
, S.ATTRIBUTE15
, S.TP_ATTRIBUTE_CATEGORY
, S.TP_ATTRIBUTE1
, S.TP_ATTRIBUTE2
, S.TP_ATTRIBUTE3
, S.TP_ATTRIBUTE4
, S.TP_ATTRIBUTE5
, S.TP_ATTRIBUTE6
, S.TP_ATTRIBUTE7
, S.TP_ATTRIBUTE8
, S.TP_ATTRIBUTE9
, S.TP_ATTRIBUTE10
, S.TP_ATTRIBUTE11
, S.TP_ATTRIBUTE12
, S.TP_ATTRIBUTE13
, S.TP_ATTRIBUTE14
, S.TP_ATTRIBUTE15
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_LOGIN
, S.PROGRAM_APPLICATION_ID
, S.PROGRAM_ID
, S.PROGRAM_UPDATE_DATE
, S.REQUEST_ID
, S.WSH_LOCATION_ID
, S.TRACKING_DRILLDOWN_FLAG
, S.TRACKING_REMARKS
, S.CARRIER_EST_DEPARTURE_DATE
, S.CARRIER_EST_ARRIVAL_DATE
, S.LOADING_START_DATETIME
, S.LOADING_END_DATETIME
, S.UNLOADING_START_DATETIME
, S.UNLOADING_END_DATETIME
, NVL(S.SHIPMENTS_TYPE_FLAG
, 'O')
, S.WKEND_LAYOVER_STOPS
, S.WKDAY_LAYOVER_STOPS
, S.TP_STOP_ID
, S.PHYSICAL_STOP_ID
, S.PHYSICAL_LOCATION_ID
FROM WSH_TRIP_STOPS S
, WSH_TRIPS T
, WSH_LOOKUPS WL
WHERE T.TRIP_ID = S.TRIP_ID
AND WL.LOOKUP_TYPE = 'TRIP_STOP_STATUS'
AND WL.LOOKUP_CODE = S.STATUS_CODE
AND NVL(S.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M')
Columns
| DELIVERY_ID |
| DELIVERY_DETAIL_ID |
| ROW_ID |
| STOP_ID |
| TRIP_ID |
| TRIP_NAME |
| STOP_LOCATION_ID |
| STATUS_CODE |
| STATUS_NAME |
| PLANNED_ARRIVAL_DATE |
| PLANNED_DEPARTURE_DATE |
| ACTUAL_ARRIVAL_DATE |
| ACTUAL_DEPARTURE_DATE |
| DEPARTURE_SEAL_CODE |
| STOP_SEQUENCE_NUMBER |
| WV_FROZEN_FLAG |
| DEPARTURE_GROSS_WEIGHT |
| DEPARTURE_TARE_WEIGHT |
| DEPARTURE_NET_WEIGHT |
| WEIGHT_UOM_CODE |
| DEPARTURE_VOLUME |
| VOLUME_UOM_CODE |
| DEPARTURE_FILL_PERCENT |
| ACTIVITY_CODE |
| ATTRIBUTE_CATEGORY |
| ATTRIBUTE1 |
| ATTRIBUTE2 |
| ATTRIBUTE3 |
| ATTRIBUTE4 |
| ATTRIBUTE5 |
| ATTRIBUTE6 |
| ATTRIBUTE7 |
| ATTRIBUTE8 |
| ATTRIBUTE9 |
| ATTRIBUTE10 |
| ATTRIBUTE11 |
| ATTRIBUTE12 |
| ATTRIBUTE13 |
| ATTRIBUTE14 |
| ATTRIBUTE15 |
| 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 |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| PROGRAM_APPLICATION_ID |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| REQUEST_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 |
| SHIPMENTS_TYPE_FLAG |
| WKEND_LAYOVER_STOPS |
| WKDAY_LAYOVER_STOPS |
| TP_STOP_ID |
| PHYSICAL_STOP_ID |
| PHYSICAL_LOCATION_ID |
| Name |
APPS.WSH_TRIP_STOPS_V