[Home] [Help]
1247: br.resource_type resource_type
1248: FROM wms_wp_labor_planning wlp,
1249: bom_department_resources bdr,
1250: bom_Resources br,
1251: wms_wp_planning_Criteria_vl wpl
1252: WHERE wlp.planning_criteria_id = p_plan_id
1253: AND wpl.planning_criteria_id = p_plan_id
1254: AND br.resource_code = wlp.resource_type
1255: AND br.resource_id = bdr.resource_id
1309: begin
1310: print_debug('In labor_resource_planning API', l_debug);
1311: select department_id
1312: into l_dept_id
1313: from wms_wp_planning_criteria_vl
1314: where planning_criteria_id = l_planning_criteria_id;
1315: exception
1316: when no_data_found then
1317: l_dept_id := -1;
1947: select labor_setup_mode, allocation_method, destination_subinventory
1948: into l_labor_setup_mode,
1949: l_allocation_method,
1950: v_destination_subinventory
1951: from wms_wp_planning_criteria_vl
1952: where PLANNING_CRITERIA_ID = p_planning_criteria_id;
1953:
1954: if v_destination_subinventory is null THEN
1955:
2316: wdd.requested_quantity_uom,
2317: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) demand_source_header_id
2318: from wms_wp_wave_headers_vl wwh,
2319: wms_wp_wave_lines wwl, --11775489 get from wdd... FIXED
2320: wms_wp_planning_criteria_vl wwp,
2321: wsh_delivery_details wdd,
2322: wms_wp_rules_simulation wwr
2323: where wwh.wave_header_id = p_wave_header_id
2324: and wwp.planning_criteria_id = p_planning_criteria_id
4709: ----call labor planning api-----
4710:
4711: select enable_labor_planning
4712: into l_enable_labor_planning
4713: from wms_wp_planning_Criteria_vl
4714: where planning_criteria_id = p_planning_criteria_id;
4715:
4716: print_debug('Checking if Labor Planning Set up or Department Setup is done ',
4717: l_debug);
5087: decode(wdd.source_document_type_id, 10, 8, 2) demand_source_type_id,
5088: wwl.wave_line_id
5089: from wms_wp_wave_headers_vl wwh,
5090: wms_wp_wave_lines wwl, --11775489 get from wdd... FIXED...may have performance impact...
5091: wms_wp_planning_criteria_vl wwp,
5092: wsh_delivery_details wdd
5093: where wwh.wave_header_id = p_wave_header_id
5094: and wwl.organization_id = l_org_id
5095: and wdd.inventory_item_id = l_item_id
5331: l_debug);
5332:
5333: select enable_labor_planning
5334: into l_enable_labor_planning
5335: from wms_wp_planning_Criteria_vl
5336: where planning_criteria_id = p_planning_criteria_id;
5337:
5338: print_debug('Validating the Start time ', l_debug);
5339:
5424: l_planning_method,
5425: l_crossdock_criteria,
5426: l_crossdock_criteria_id,
5427: l_allocation_method
5428: from wms_wp_planning_criteria_vl
5429: where planning_criteria_id = p_planning_criteria_id;
5430:
5431: print_debug('pick_subinventory in Plan Wave CP is:' ||
5432: l_pick_subinventory,
7072: st_exception EXCEPTION; -- start time changes
7073:
7074: begin
7075: -- ssk
7076: select LABOR_SETUP_MODE into l_LABOR_SETUP_MODE from wms_wp_planning_criteria_vl
7077: where PLANNING_CRITERIA_ID = p_planning_criteria_id;
7078: -- ssk
7079: select department_id
7080: into l_dept_id
7077: where PLANNING_CRITERIA_ID = p_planning_criteria_id;
7078: -- ssk
7079: select department_id
7080: into l_dept_id
7081: from wms_wp_planning_criteria_vl
7082: where planning_criteria_id = p_planning_criteria_id;
7083: print_debug('In get_current_work_load procedure', l_debug);
7084: select (nvl(utilization, 100) / 100),
7085: (nvl(efficiency, 100) / 100),
7129: (SELECT DISTINCT resource_id
7130: FROM BOM_DEPARTMENT_RESOURCES
7131: WHERE department_id IN
7132: (SELECT DISTINCT department_id
7133: FROM wms_wp_planning_criteria_vl
7134: WHERE planning_criteria_id = p_planning_criteria_id));
7135: end;
7136: elsif l_labor_setup_mode = 'Z' then
7137: begin
7172: (SELECT DISTINCT resource_id
7173: FROM BOM_DEPARTMENT_RESOURCES
7174: WHERE department_id IN
7175: (SELECT DISTINCT department_id
7176: FROM wms_wp_planning_criteria_vl
7177: WHERE planning_criteria_id = p_planning_criteria_id));
7178: END;
7179: end if;
7180: l_tasks := l_tasks + l_number_of_tasks;
7191: end loop;
7192:
7193: select time_uom
7194: into l_uom
7195: from wms_wp_planning_criteria_vl
7196: where planning_Criteria_id = p_planning_criteria_id;
7197:
7198: x_current_workload := round((l_current_workload) /
7199: (l_utilization * l_efficiency));
7598: WHERE planning_criteria_id = p_planning_criteria_id;
7599:
7600: /* cursor c_labor_resource is
7601: SELECT distinct wwlp.resource_type
7602: FROM wms_wp_labor_planning wwlp,BOM_DEPARTMENT_RESOURCES_V bdr,wms_wp_planning_criteria_vl wwp
7603: WHERE wwlp.planning_criteria_id = p_planning_criteria_id
7604: AND wwp.planning_criteria_id=wwlp.planning_criteria_id
7605: and wwp.department_id=v_department_id
7606: and wwp.department_id=bdr.department_id
7672: l_bulk_planning,
7673: v_department_id,
7674: v_time_uom,
7675: l_allocation_method
7676: from wms_wp_planning_criteria_vl wwp
7677: where planning_Criteria_id = p_planning_criteria_id;
7678:
7679: print_debug('The Picking Subinventory specified is ' ||
7680: v_picking_subinventory,
13861: -- Checking if Pick Subinventory is mentioned in Planning Criteria
13862: begin
13863: select picking_subinventory
13864: into l_pick_subinventory
13865: from wms_wp_planning_criteria_vl wwp, wms_wp_wave_headers_vl wwh
13866: where wave_header_id = p_wave_header_id
13867: and wwh.planning_Criteria_id = wwp.planning_Criteria_id;
13868: print_debug('pick_subinventory :' || l_pick_subinventory, l_debug);
13869: exception
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
19270: AND wpl.planning_criteria_id = wwl.planning_criteria_id;