17898: end loop;
17899:
17900:
17901:
17902: delete wms_wp_orders_gtmp;
17903: delete wms_wp_lines_gtmp;
17904: delete from wms_wp_exceptions_gtmp;
17905: delete from wms_wp_tasks_gtmp;
17906: delete from wms_wp_labor_gtmp;
17907:
17908: --Orders GTMP
17909: --bug12371804 query from base tables instead of from wms_wp_wwb_orders_v for performance
17910: --inner most select finds all lines associated with wave; next outer select groups by order number; outermost select adds in order-level information
17911: insert into wms_wp_orders_gtmp (order_number,
17912: customer,
17913: planned_fill_rate,
17914: release_fill_rate,
17915: pick_fill_rate,