VIEW: APPS.WSH_DELIVERABLE_STOPS_V

Source

View Text - Preformatted

SELECT to_number(null), wda.delivery_detail_id, ts.row_id, ts.stop_id, ts.trip_id, ts.trip_name, ts.stop_location_id, ts.status_code, ts.status_name, ts.planned_arrival_date, ts.planned_departure_date, ts.actual_arrival_date, ts.actual_departure_date, ts.departure_seal_code, ts.stop_sequence_number, ts.wv_frozen_flag, ts.departure_gross_weight, ts.departure_tare_weight, ts.departure_net_weight, ts.weight_uom_code, ts.departure_volume, ts.volume_uom_code, ts.departure_fill_percent, decode(ts.status_code, 'OP', 'AP', 'AR', 'AP', 'CL', 'PU'), ts.attribute_category, ts.attribute1, ts.attribute2, ts.attribute3, ts.attribute4, ts.attribute5, ts.attribute6, ts.attribute7, ts.attribute8, ts.attribute9, ts.attribute10, ts.attribute11, ts.attribute12, ts.attribute13, ts.attribute14, ts.attribute15, ts.tp_attribute_category, ts.tp_attribute1, ts.tp_attribute2, ts.tp_attribute3, ts.tp_attribute4, ts.tp_attribute5, ts.tp_attribute6, ts.tp_attribute7, ts.tp_attribute8, ts.tp_attribute9, ts.tp_attribute10, ts.tp_attribute11, ts.tp_attribute12, ts.tp_attribute13, ts.tp_attribute14, ts.tp_attribute15, ts.creation_date, ts.created_by, ts.last_update_date, ts.last_updated_by, ts.last_update_login, ts.program_application_id, ts.program_id, ts.program_update_date, ts.request_id, nvl(ts.actual_arrival_date, nvl(ts.planned_arrival_date, nvl(ts.planned_departure_date, ts.actual_departure_date))) dates_for_ordering, ts.wsh_location_id, ts.tracking_drilldown_flag, ts.tracking_remarks, ts.carrier_est_departure_date, ts.carrier_est_arrival_date, ts.loading_start_datetime, ts.loading_end_datetime, ts.unloading_start_datetime, ts.unloading_end_datetime, ts.shipments_type_flag, ts.wkend_layover_stops, ts.wkday_layover_stops, ts.tp_stop_id, ts.physical_stop_id, ts.physical_location_id, ts.tms_interface_flag from wsh_delivery_assignments_v wda, wsh_new_deliveries nd, wsh_delivery_legs dl, wsh_trip_stops_v ts WHERE wda.delivery_id = nd.delivery_id and nd.delivery_id = dl.delivery_id and dl.pick_up_stop_id = ts.stop_id and nvl(nd.shipment_direction, 'O') IN ('O', 'IO') union select to_number(null), wda.delivery_detail_id, ts.row_id, ts.stop_id, ts.trip_id, ts.trip_name, ts.stop_location_id, ts.status_code, ts.status_name, ts.planned_arrival_date, ts.planned_departure_date, ts.actual_arrival_date, ts.actual_departure_date, ts.departure_seal_code, ts.stop_sequence_number, ts.wv_frozen_flag, ts.departure_gross_weight, ts.departure_tare_weight, ts.departure_net_weight, ts.weight_uom_code, ts.departure_volume, ts.volume_uom_code, ts.departure_fill_percent, decode(ts.status_code, 'OP', 'AD', 'AR', 'AD', 'CL', 'DO'), ts.attribute_category, ts.attribute1, ts.attribute2, ts.attribute3, ts.attribute4, ts.attribute5, ts.attribute6, ts.attribute7, ts.attribute8, ts.attribute9, ts.attribute10, ts.attribute11, ts.attribute12, ts.attribute13, ts.attribute14, ts.attribute15, ts.tp_attribute_category, ts.tp_attribute1, ts.tp_attribute2, ts.tp_attribute3, ts.tp_attribute4, ts.tp_attribute5, ts.tp_attribute6, ts.tp_attribute7, ts.tp_attribute8, ts.tp_attribute9, ts.tp_attribute10, ts.tp_attribute11, ts.tp_attribute12, ts.tp_attribute13, ts.tp_attribute14, ts.tp_attribute15, ts.creation_date, ts.created_by, ts.last_update_date, ts.last_updated_by, ts.last_update_login, ts.program_application_id, ts.program_id, ts.program_update_date, ts.request_id, nvl(ts.actual_arrival_date, nvl(ts.planned_arrival_date, nvl(ts.planned_departure_date, ts.actual_departure_date))) dates_for_ordering, ts.wsh_location_id, ts.tracking_drilldown_flag, ts.tracking_remarks, ts.carrier_est_departure_date, ts.carrier_est_arrival_date, ts.loading_start_datetime, ts.loading_end_datetime, ts.unloading_start_datetime, ts.unloading_end_datetime, ts.shipments_type_flag, ts.wkend_layover_stops, ts.wkday_layover_stops, ts.tp_stop_id, ts.physical_stop_id, ts.physical_location_id, ts.tms_interface_flag from wsh_delivery_assignments_v wda, wsh_new_deliveries nd, wsh_delivery_legs dl, wsh_trip_stops_v ts where wda.delivery_id = nd.delivery_id and nd.delivery_id = dl.delivery_id and dl.drop_off_stop_id = ts.stop_id and nvl(nd.shipment_direction, 'O') IN ('O', 'IO') order by dates_for_ordering

View Text - HTML Formatted

SELECT TO_NUMBER(NULL)
, WDA.DELIVERY_DETAIL_ID
, TS.ROW_ID
, TS.STOP_ID
, TS.TRIP_ID
, TS.TRIP_NAME
, TS.STOP_LOCATION_ID
, TS.STATUS_CODE
, TS.STATUS_NAME
, TS.PLANNED_ARRIVAL_DATE
, TS.PLANNED_DEPARTURE_DATE
, TS.ACTUAL_ARRIVAL_DATE
, TS.ACTUAL_DEPARTURE_DATE
, TS.DEPARTURE_SEAL_CODE
, TS.STOP_SEQUENCE_NUMBER
, TS.WV_FROZEN_FLAG
, TS.DEPARTURE_GROSS_WEIGHT
, TS.DEPARTURE_TARE_WEIGHT
, TS.DEPARTURE_NET_WEIGHT
, TS.WEIGHT_UOM_CODE
, TS.DEPARTURE_VOLUME
, TS.VOLUME_UOM_CODE
, TS.DEPARTURE_FILL_PERCENT
, DECODE(TS.STATUS_CODE
, 'OP'
, 'AP'
, 'AR'
, 'AP'
, 'CL'
, 'PU')
, TS.ATTRIBUTE_CATEGORY
, TS.ATTRIBUTE1
, TS.ATTRIBUTE2
, TS.ATTRIBUTE3
, TS.ATTRIBUTE4
, TS.ATTRIBUTE5
, TS.ATTRIBUTE6
, TS.ATTRIBUTE7
, TS.ATTRIBUTE8
, TS.ATTRIBUTE9
, TS.ATTRIBUTE10
, TS.ATTRIBUTE11
, TS.ATTRIBUTE12
, TS.ATTRIBUTE13
, TS.ATTRIBUTE14
, TS.ATTRIBUTE15
, TS.TP_ATTRIBUTE_CATEGORY
, TS.TP_ATTRIBUTE1
, TS.TP_ATTRIBUTE2
, TS.TP_ATTRIBUTE3
, TS.TP_ATTRIBUTE4
, TS.TP_ATTRIBUTE5
, TS.TP_ATTRIBUTE6
, TS.TP_ATTRIBUTE7
, TS.TP_ATTRIBUTE8
, TS.TP_ATTRIBUTE9
, TS.TP_ATTRIBUTE10
, TS.TP_ATTRIBUTE11
, TS.TP_ATTRIBUTE12
, TS.TP_ATTRIBUTE13
, TS.TP_ATTRIBUTE14
, TS.TP_ATTRIBUTE15
, TS.CREATION_DATE
, TS.CREATED_BY
, TS.LAST_UPDATE_DATE
, TS.LAST_UPDATED_BY
, TS.LAST_UPDATE_LOGIN
, TS.PROGRAM_APPLICATION_ID
, TS.PROGRAM_ID
, TS.PROGRAM_UPDATE_DATE
, TS.REQUEST_ID
, NVL(TS.ACTUAL_ARRIVAL_DATE
, NVL(TS.PLANNED_ARRIVAL_DATE
, NVL(TS.PLANNED_DEPARTURE_DATE
, TS.ACTUAL_DEPARTURE_DATE))) DATES_FOR_ORDERING
, TS.WSH_LOCATION_ID
, TS.TRACKING_DRILLDOWN_FLAG
, TS.TRACKING_REMARKS
, TS.CARRIER_EST_DEPARTURE_DATE
, TS.CARRIER_EST_ARRIVAL_DATE
, TS.LOADING_START_DATETIME
, TS.LOADING_END_DATETIME
, TS.UNLOADING_START_DATETIME
, TS.UNLOADING_END_DATETIME
, TS.SHIPMENTS_TYPE_FLAG
, TS.WKEND_LAYOVER_STOPS
, TS.WKDAY_LAYOVER_STOPS
, TS.TP_STOP_ID
, TS.PHYSICAL_STOP_ID
, TS.PHYSICAL_LOCATION_ID
, TS.TMS_INTERFACE_FLAG
FROM WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES ND
, WSH_DELIVERY_LEGS DL
, WSH_TRIP_STOPS_V TS
WHERE WDA.DELIVERY_ID = ND.DELIVERY_ID
AND ND.DELIVERY_ID = DL.DELIVERY_ID
AND DL.PICK_UP_STOP_ID = TS.STOP_ID
AND NVL(ND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO') UNION SELECT TO_NUMBER(NULL)
, WDA.DELIVERY_DETAIL_ID
, TS.ROW_ID
, TS.STOP_ID
, TS.TRIP_ID
, TS.TRIP_NAME
, TS.STOP_LOCATION_ID
, TS.STATUS_CODE
, TS.STATUS_NAME
, TS.PLANNED_ARRIVAL_DATE
, TS.PLANNED_DEPARTURE_DATE
, TS.ACTUAL_ARRIVAL_DATE
, TS.ACTUAL_DEPARTURE_DATE
, TS.DEPARTURE_SEAL_CODE
, TS.STOP_SEQUENCE_NUMBER
, TS.WV_FROZEN_FLAG
, TS.DEPARTURE_GROSS_WEIGHT
, TS.DEPARTURE_TARE_WEIGHT
, TS.DEPARTURE_NET_WEIGHT
, TS.WEIGHT_UOM_CODE
, TS.DEPARTURE_VOLUME
, TS.VOLUME_UOM_CODE
, TS.DEPARTURE_FILL_PERCENT
, DECODE(TS.STATUS_CODE
, 'OP'
, 'AD'
, 'AR'
, 'AD'
, 'CL'
, 'DO')
, TS.ATTRIBUTE_CATEGORY
, TS.ATTRIBUTE1
, TS.ATTRIBUTE2
, TS.ATTRIBUTE3
, TS.ATTRIBUTE4
, TS.ATTRIBUTE5
, TS.ATTRIBUTE6
, TS.ATTRIBUTE7
, TS.ATTRIBUTE8
, TS.ATTRIBUTE9
, TS.ATTRIBUTE10
, TS.ATTRIBUTE11
, TS.ATTRIBUTE12
, TS.ATTRIBUTE13
, TS.ATTRIBUTE14
, TS.ATTRIBUTE15
, TS.TP_ATTRIBUTE_CATEGORY
, TS.TP_ATTRIBUTE1
, TS.TP_ATTRIBUTE2
, TS.TP_ATTRIBUTE3
, TS.TP_ATTRIBUTE4
, TS.TP_ATTRIBUTE5
, TS.TP_ATTRIBUTE6
, TS.TP_ATTRIBUTE7
, TS.TP_ATTRIBUTE8
, TS.TP_ATTRIBUTE9
, TS.TP_ATTRIBUTE10
, TS.TP_ATTRIBUTE11
, TS.TP_ATTRIBUTE12
, TS.TP_ATTRIBUTE13
, TS.TP_ATTRIBUTE14
, TS.TP_ATTRIBUTE15
, TS.CREATION_DATE
, TS.CREATED_BY
, TS.LAST_UPDATE_DATE
, TS.LAST_UPDATED_BY
, TS.LAST_UPDATE_LOGIN
, TS.PROGRAM_APPLICATION_ID
, TS.PROGRAM_ID
, TS.PROGRAM_UPDATE_DATE
, TS.REQUEST_ID
, NVL(TS.ACTUAL_ARRIVAL_DATE
, NVL(TS.PLANNED_ARRIVAL_DATE
, NVL(TS.PLANNED_DEPARTURE_DATE
, TS.ACTUAL_DEPARTURE_DATE))) DATES_FOR_ORDERING
, TS.WSH_LOCATION_ID
, TS.TRACKING_DRILLDOWN_FLAG
, TS.TRACKING_REMARKS
, TS.CARRIER_EST_DEPARTURE_DATE
, TS.CARRIER_EST_ARRIVAL_DATE
, TS.LOADING_START_DATETIME
, TS.LOADING_END_DATETIME
, TS.UNLOADING_START_DATETIME
, TS.UNLOADING_END_DATETIME
, TS.SHIPMENTS_TYPE_FLAG
, TS.WKEND_LAYOVER_STOPS
, TS.WKDAY_LAYOVER_STOPS
, TS.TP_STOP_ID
, TS.PHYSICAL_STOP_ID
, TS.PHYSICAL_LOCATION_ID
, TS.TMS_INTERFACE_FLAG
FROM WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES ND
, WSH_DELIVERY_LEGS DL
, WSH_TRIP_STOPS_V TS
WHERE WDA.DELIVERY_ID = ND.DELIVERY_ID
AND ND.DELIVERY_ID = DL.DELIVERY_ID
AND DL.DROP_OFF_STOP_ID = TS.STOP_ID
AND NVL(ND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO') ORDER BY DATES_FOR_ORDERING