Awaiting Shipping Query pICKED BUT NOT SHIPPED,UNSHIPPED ORDERS:

--Awaiting Shipping Query

pICKED BUT NOT SHIPPED

select h.order_number,l.line_number,l.flow_status_code,w.released_status,l.* from apps.oe_order_headers_all h,apps.oe_order_lines_all l,apps.wsh_delivery_details w
where h.header_id=l.header_id
and l.line_id=w.source_line_id
and h.org_id='3061'
and l.flow_status_code='AWAITING_SHIPPING'
and w.released_status='Y';


----------

UNSHIPPED ORDERS:

SELECT h.order_number,
  l.line_number,
  l.flow_status_code,
  w.released_status,
  l.*
FROM apps.oe_order_headers_all h,
  apps.oe_order_lines_all l,
  apps.wsh_delivery_details w
WHERE h.header_id     =l.header_id
AND l.line_id         =w.source_line_id
AND h.org_id          ='3061'
--AND l.flow_status_code='AWAITING_SHIPPING'
AND w.released_status ='R';