出货后还在stage的so

---出货后还在stage的状态
select stp1.stop_description, wdd.oe_interfaced_flag, wdd.inv_interfaced_flag,
decode(stops.pending_interface_flag, NULL, 'Not Pending', 'Y', 'Pending', stops.pending_interface_flag) pending_interface_flag,
wdd.source_header_id, wdd.source_line_id, assign.delivery_id, assign.delivery_detail_id,
deli.name deli_name, deli.status_code deli_status,
legs.pick_up_stop_id,legs.drop_off_stop_id,
stops.status_code trip_stop_status,stops.actual_departure_date,
trips.name trip_name, trips.trip_id,trips.status_code trip_status
from wsh_delivery_details wdd, wsh_delivery_assignments assign,
wsh_new_deliveries deli,wsh_delivery_legs legs,
wsh_trip_stops stops,wsh_trips trips,
oe_order_headers_all ooh, WSH_SRS_TRIP_STOPS_V stp1,
oe_order_lines_all ool
where wdd.source_header_id = ooh.header_id
and ooh.header_id = ool.header_id
and ool.flow_status_code = 'CLOSED'
and wdd.delivery_detail_id =assign.delivery_detail_id
and assign.delivery_id = deli.delivery_id
and deli.delivery_id=legs.delivery_id
and legs.pick_up_stop_id = stops.stop_id
and stp1.stop_id = stops.stop_id
and stops.trip_id = trips.trip_id
and ooh.order_number = &order_number
and nvl(inv_interfaced_flag, 'N') <> 'Y'
order by assign.delivery_assignment_id, assign.delivery_id, assign.delivery_detail_id;