123: planned_arrival_date DATE,
124: planned_departure_date DATE,
125: departure_gross_weight NUMBER,
126: departure_net_weight NUMBER,
127: weight_uom_code WSH_TRIP_STOPS.WEIGHT_UOM_CODE%TYPE,
128: departure_volume NUMBER,
129: volume_uom_code WSH_TRIP_STOPS.VOLUME_UOM_CODE%TYPE,
130: departure_seal_code WSH_TRIP_STOPS.DEPARTURE_SEAL_CODE%TYPE,
131: departure_fill_percent NUMBER,
125: departure_gross_weight NUMBER,
126: departure_net_weight NUMBER,
127: weight_uom_code WSH_TRIP_STOPS.WEIGHT_UOM_CODE%TYPE,
128: departure_volume NUMBER,
129: volume_uom_code WSH_TRIP_STOPS.VOLUME_UOM_CODE%TYPE,
130: departure_seal_code WSH_TRIP_STOPS.DEPARTURE_SEAL_CODE%TYPE,
131: departure_fill_percent NUMBER,
132: wkend_layover_stops WSH_TRIP_STOPS.wkend_layover_stops%TYPE,
133: wkday_layover_stops WSH_TRIP_STOPS.wkday_layover_stops%TYPE,
126: departure_net_weight NUMBER,
127: weight_uom_code WSH_TRIP_STOPS.WEIGHT_UOM_CODE%TYPE,
128: departure_volume NUMBER,
129: volume_uom_code WSH_TRIP_STOPS.VOLUME_UOM_CODE%TYPE,
130: departure_seal_code WSH_TRIP_STOPS.DEPARTURE_SEAL_CODE%TYPE,
131: departure_fill_percent NUMBER,
132: wkend_layover_stops WSH_TRIP_STOPS.wkend_layover_stops%TYPE,
133: wkday_layover_stops WSH_TRIP_STOPS.wkday_layover_stops%TYPE,
134: shipments_type_flag WSH_TRIP_STOPS.shipments_type_flag%TYPE,
128: departure_volume NUMBER,
129: volume_uom_code WSH_TRIP_STOPS.VOLUME_UOM_CODE%TYPE,
130: departure_seal_code WSH_TRIP_STOPS.DEPARTURE_SEAL_CODE%TYPE,
131: departure_fill_percent NUMBER,
132: wkend_layover_stops WSH_TRIP_STOPS.wkend_layover_stops%TYPE,
133: wkday_layover_stops WSH_TRIP_STOPS.wkday_layover_stops%TYPE,
134: shipments_type_flag WSH_TRIP_STOPS.shipments_type_flag%TYPE,
135: wv_frozen_flag WSH_TRIP_STOPS.wv_frozen_flag%TYPE,
136: internal_do_count NUMBER, -- count of internal customer location drop-offs
129: volume_uom_code WSH_TRIP_STOPS.VOLUME_UOM_CODE%TYPE,
130: departure_seal_code WSH_TRIP_STOPS.DEPARTURE_SEAL_CODE%TYPE,
131: departure_fill_percent NUMBER,
132: wkend_layover_stops WSH_TRIP_STOPS.wkend_layover_stops%TYPE,
133: wkday_layover_stops WSH_TRIP_STOPS.wkday_layover_stops%TYPE,
134: shipments_type_flag WSH_TRIP_STOPS.shipments_type_flag%TYPE,
135: wv_frozen_flag WSH_TRIP_STOPS.wv_frozen_flag%TYPE,
136: internal_do_count NUMBER, -- count of internal customer location drop-offs
137: external_pd_count NUMBER, -- count of pickup/dropoff activities at this physical stop
130: departure_seal_code WSH_TRIP_STOPS.DEPARTURE_SEAL_CODE%TYPE,
131: departure_fill_percent NUMBER,
132: wkend_layover_stops WSH_TRIP_STOPS.wkend_layover_stops%TYPE,
133: wkday_layover_stops WSH_TRIP_STOPS.wkday_layover_stops%TYPE,
134: shipments_type_flag WSH_TRIP_STOPS.shipments_type_flag%TYPE,
135: wv_frozen_flag WSH_TRIP_STOPS.wv_frozen_flag%TYPE,
136: internal_do_count NUMBER, -- count of internal customer location drop-offs
137: external_pd_count NUMBER, -- count of pickup/dropoff activities at this physical stop
138: wsh_physical_location_id NUMBER -- if populated, plan stop has been mapped to a TE internal stop
131: departure_fill_percent NUMBER,
132: wkend_layover_stops WSH_TRIP_STOPS.wkend_layover_stops%TYPE,
133: wkday_layover_stops WSH_TRIP_STOPS.wkday_layover_stops%TYPE,
134: shipments_type_flag WSH_TRIP_STOPS.shipments_type_flag%TYPE,
135: wv_frozen_flag WSH_TRIP_STOPS.wv_frozen_flag%TYPE,
136: internal_do_count NUMBER, -- count of internal customer location drop-offs
137: external_pd_count NUMBER, -- count of pickup/dropoff activities at this physical stop
138: wsh_physical_location_id NUMBER -- if populated, plan stop has been mapped to a TE internal stop
139: );