APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_LABOR_GTMP

Line 17906: delete from wms_wp_labor_gtmp;

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

Line 19248: insert into wms_wp_labor_gtmp_v(

19244: shipped
19245: from wms_wp_wave_exceptions_vl where wave_header_id = p_wave_header_id
19246: and lower(status) <> 'closed';
19247:
19248: insert into wms_wp_labor_gtmp_v(
19249: RESOURCE_NAME,
19250: NUMBER_OF_ACTUAL_TASKS,
19251: NUMBER_OF_PLANNED_TASKS,
19252: ACTUAL_WORKLOAD,