APPS.WMS_WAVE_PLANNING_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 1249: bom_department_resources bdr,

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
1253: AND wpl.planning_criteria_id = p_plan_id

Line 1556: from bom_department_resources_v bdrv

1552:
1553: select nvl(utilization, 100) / 100,
1554: nvl(efficiency, 100) / 100
1555: into l_utilization, l_efficiency
1556: from bom_department_resources_v bdrv
1557: where department_id = l_dept_id
1558: and resource_code = x_resource_capacity_tbl(cap_det)
1559: .resource_name;
1560:

Line 7098: from bom_department_resources_v

7094: l_unit_of_measure,
7095: l_resource_id,
7096: l_org_id,
7097: l_24hrs
7098: from bom_department_resources_v
7099: where department_id = l_dept_id
7100: and resource_code = p_resource;
7101:
7102: l_current_workload := 0;

Line 7130: FROM BOM_DEPARTMENT_RESOURCES

7126: FROM bom_resources
7127: WHERE resource_code = p_resource
7128: AND resource_id IN
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));

Line 7173: FROM BOM_DEPARTMENT_RESOURCES

7169: FROM bom_resources
7170: WHERE resource_code = p_resource
7171: AND resource_id IN
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));

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

Line 7631: FROM BOM_DEPARTMENT_RESOURCES_V

7627: (nvl(utilization, 100) / 100) utilization,
7628: (nvl(efficiency, 100) / 100) efficiency,
7629: unit_of_measure,
7630: capacity_units
7631: FROM BOM_DEPARTMENT_RESOURCES_V
7632: WHERE department_id = v_department_id; */
7633:
7634: -- declare variables
7635: x_current_load number := 0;