APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_LABOR_PLANNING

Line 1233: ----- cursor to get the details of all the resources from wms_wp_labor_planning table ----

1229:
1230: --x_tasks_tbl labor_time_tbl; -- Gonna contain details of the planned tasks
1231: ---------- TASK DETAILS ----------------------
1232:
1233: ----- cursor to get the details of all the resources from wms_wp_labor_planning table ----
1234:
1235: /* cursor get the details of resource. First fetch persons (resouce type = 2) last fetch machines (resource type = 1)*/
1236:
1237: CURSOR c_get_labor_details(p_plan_id NUMBER) IS

Line 1248: FROM wms_wp_labor_planning wlp,

1244: wlp.processing_overhead_duration,
1245: wlp.category_id,
1246: Decode(plan_type, 'A', -1, 'R', wlp.operation_plan_id) operation_plan_id,
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

Line 1263: FROM wms_wp_labor_planning

1259: --- cursor to get the distinct resources ----
1260:
1261: CURSOR c_get_distinct_resource(p_plan_id NUMBER) IS
1262: SELECT DISTINCT resource_type
1263: FROM wms_wp_labor_planning
1264: WHERE planning_criteria_id = p_plan_id;
1265:
1266: position NUMBER := 0;
1267: current_load NUMBER := 0;

Line 4720: from wms_wp_labor_planning

4716: print_debug('Checking if Labor Planning Set up or Department Setup is done ',
4717: l_debug);
4718: select count(1)
4719: into v_labor_count
4720: from wms_wp_labor_planning
4721: where planning_Criteria_id = p_planning_Criteria_id;
4722:
4723: if v_labor_count > 0 and l_enable_labor_planning = 'Y' then
4724:

Line 6608: from wms_wp_labor_planning

6604: print_debug('Checking if Labor Planning Set up or Department Setup is done ',
6605: l_debug);
6606: select count(1)
6607: into v_labor_count
6608: from wms_wp_labor_planning
6609: where planning_Criteria_id = p_planning_Criteria_id;
6610:
6611: if v_labor_count > 0 and l_enable_labor_planning = 'Y' then
6612:

Line 7047: from wms_wp_labor_planning

7043: pick_uom,
7044: transaction_time,
7045: travel_time,
7046: processing_overhead_duration
7047: from wms_wp_labor_planning
7048: where planning_criteria_id = p_planning_criteria_id
7049: and resource_type = p_resource;
7050:
7051: l_unit_of_measure varchar2(10);

Line 7586: FROM wms_wp_labor_planning

7582: pick_uom,
7583: transaction_time,
7584: travel_time,
7585: resource_type
7586: FROM wms_wp_labor_planning
7587: WHERE planning_criteria_id = p_planning_criteria_id
7588: group by source_subinventory,
7589: destination_subinventory,
7590: pick_uom,

Line 7597: FROM wms_wp_labor_planning

7593: resource_type; -- group by added by
7594:
7595: cursor c_labor_resource is
7596: SELECT distinct resource_type
7597: FROM wms_wp_labor_planning
7598: WHERE planning_criteria_id = p_planning_criteria_id;
7599:
7600: /* cursor c_labor_resource is
7601: SELECT distinct wwlp.resource_type

Line 7602: FROM wms_wp_labor_planning wwlp,BOM_DEPARTMENT_RESOURCES_V bdr,wms_wp_planning_criteria_vl wwp

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