VIEW: APPS.WSH_DELIVERY_STOPS_V

Source

View Text - Preformatted

SELECT dl.delivery_id, to_number(null), s.row_id, s.stop_id, s.trip_id, s.trip_name, s.stop_location_id, s.status_code, s.status_name, 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_tare_weight, s.departure_net_weight, s.weight_uom_code, s.departure_volume, s.volume_uom_code, s.departure_fill_percent, decode(s.status_code, 'OP', 'AP', 'AR', 'AP', 'CL', 'PU'), 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, s.shipments_type_flag, s.wkend_layover_stops, s.wkday_layover_stops, s.tp_stop_id, s.physical_stop_id, s.physical_location_id, s.tms_interface_flag from wsh_trip_stops_v s, wsh_delivery_legs dl WHERE s.stop_id = dl.pick_up_stop_id /*--*/ union select dl.delivery_id, to_number(null), s.row_id, s.stop_id, s.trip_id, s.trip_name, s.stop_location_id, s.status_code, s.status_name, 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_tare_weight, s.departure_net_weight, s.weight_uom_code, s.departure_volume, s.volume_uom_code, s.departure_fill_percent, decode(s.status_code, 'OP', 'AD', 'AR', 'AD', 'CL', 'DO'), 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, s.shipments_type_flag, s.wkend_layover_stops, s.wkday_layover_stops, s.tp_stop_id, s.physical_stop_id, s.physical_location_id, s.tms_interface_flag from wsh_trip_stops_v s, wsh_delivery_legs dl where s.stop_id = dl.drop_off_stop_id

View Text - HTML Formatted

SELECT DL.DELIVERY_ID
, TO_NUMBER(NULL)
, S.ROW_ID
, S.STOP_ID
, S.TRIP_ID
, S.TRIP_NAME
, S.STOP_LOCATION_ID
, S.STATUS_CODE
, S.STATUS_NAME
, 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_TARE_WEIGHT
, S.DEPARTURE_NET_WEIGHT
, S.WEIGHT_UOM_CODE
, S.DEPARTURE_VOLUME
, S.VOLUME_UOM_CODE
, S.DEPARTURE_FILL_PERCENT
, DECODE(S.STATUS_CODE
, 'OP'
, 'AP'
, 'AR'
, 'AP'
, 'CL'
, 'PU')
, 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
, S.SHIPMENTS_TYPE_FLAG
, S.WKEND_LAYOVER_STOPS
, S.WKDAY_LAYOVER_STOPS
, S.TP_STOP_ID
, S.PHYSICAL_STOP_ID
, S.PHYSICAL_LOCATION_ID
, S.TMS_INTERFACE_FLAG
FROM WSH_TRIP_STOPS_V S
, WSH_DELIVERY_LEGS DL
WHERE S.STOP_ID = DL.PICK_UP_STOP_ID /*--*/ UNION SELECT DL.DELIVERY_ID
, TO_NUMBER(NULL)
, S.ROW_ID
, S.STOP_ID
, S.TRIP_ID
, S.TRIP_NAME
, S.STOP_LOCATION_ID
, S.STATUS_CODE
, S.STATUS_NAME
, 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_TARE_WEIGHT
, S.DEPARTURE_NET_WEIGHT
, S.WEIGHT_UOM_CODE
, S.DEPARTURE_VOLUME
, S.VOLUME_UOM_CODE
, S.DEPARTURE_FILL_PERCENT
, DECODE(S.STATUS_CODE
, 'OP'
, 'AD'
, 'AR'
, 'AD'
, 'CL'
, 'DO')
, 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
, S.SHIPMENTS_TYPE_FLAG
, S.WKEND_LAYOVER_STOPS
, S.WKDAY_LAYOVER_STOPS
, S.TP_STOP_ID
, S.PHYSICAL_STOP_ID
, S.PHYSICAL_LOCATION_ID
, S.TMS_INTERFACE_FLAG
FROM WSH_TRIP_STOPS_V S
, WSH_DELIVERY_LEGS DL
WHERE S.STOP_ID = DL.DROP_OFF_STOP_ID