APPS.MRP_RHX_RESOURCE_AVAILABILITY dependencies on BOM_DEPARTMENTS

Line 681: bom_departments dept

677: select dept_res.department_id,
678: dept_res.resource_id,
679: NVL(dept_res.available_24_hours_flag, 2)
680: from bom_department_resources dept_res,
681: bom_departments dept
682: where dept_res.department_id = dept.department_id
683: AND dept_res.share_from_dept_id is null
684: AND dept.organization_id = arg_organization_id;
685: