DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_ORDERS_GTMP

Line 17902: delete wms_wp_orders_gtmp;

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;

Line 17911: insert into wms_wp_orders_gtmp (order_number,

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,