APPS.WMS_WAVE_PLANNING_PVT dependencies on BOM_DEPARTMENT_RESOURCES_V

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 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;