eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_LABOR_STATISTICS

Line 2237: DELETE FROM wms_wp_labor_Statistics

2233:
2234: end if;
2235:
2236:
2237: DELETE FROM wms_wp_labor_Statistics
2238: WHERE wave_header_id = p_wave_header_id;
2239:
2240: l_tbl_count := x_resource_capacity_tbl.count;
2241:

Line 2245: insert into wms_wp_labor_statistics

2241:
2242: if x_resource_capacity_tbl.count > 0 then
2243: --forall i in 0 .. l_tbl_count -- dbchange1
2244: for i in x_resource_capacity_tbl.first .. x_resource_capacity_tbl.last loop
2245: insert into wms_wp_labor_statistics
2246: (wave_header_id,
2247: resource_name,
2248: planned_wave_load,
2249: total_capacity,

Line 4745: delete from wms_wp_labor_statistics

4741: else
4742:
4743: print_debug('Setup is not available for Labor Planning. Please check the Labor Planning setup',
4744: l_debug);
4745: delete from wms_wp_labor_statistics
4746: where wave_header_id = p_wave_header_id;
4747: commit;
4748: end if;
4749:

Line 6649: delete from wms_wp_labor_statistics

6645: else
6646:
6647: print_debug('Setup is not available for Labor Planning. Please check the Labor Planning setup',
6648: l_debug);
6649: delete from wms_wp_labor_statistics
6650: where wave_header_id = p_wave_header_id;
6651: commit;
6652: end if;
6653:

Line 8074: DELETE FROM wms_wp_labor_Statistics

8070:
8071: print_debug('Time Uom is ' || v_time_uom, l_debug);
8072:
8073:
8074: DELETE FROM wms_wp_labor_Statistics
8075: WHERE wave_header_id = p_wave_header_id;
8076:
8077: l_tbl_count := x_resource_capacity_tbl.count;
8078:

Line 8083: insert into wms_wp_labor_statistics

8079: if x_resource_capacity_tbl.count > 0 then
8080: --forall i in x_resource_capacity_tbl.first .. x_resource_capacity_tbl.last
8081: for i in x_resource_capacity_tbl.first .. x_resource_capacity_tbl.last LOOP --dbchange14
8082:
8083: insert into wms_wp_labor_statistics
8084: (wave_header_id,
8085: resource_name,
8086: planned_wave_load,
8087: total_capacity,

Line 19265: from wms_wp_labor_statistics wls,

19261: wls.planned_wave_load,
19262: wls.available_capacity,
19263: wls.total_capacity,
19264: wpl.time_uom
19265: from wms_wp_labor_statistics wls,
19266: wms_wp_planning_criteria_vl wpl,
19267: wms_wp_wave_headers_vl wwl
19268: WHERE wwl.wave_header_id = p_wave_header_id
19269: and wls.wave_header_id = wwl.wave_header_id