APPS.WPS_COMMON dependencies on BOM_DEPARTMENTS

Line 506: bom_departments dept

502: select dept_res.department_id,
503: dept_res.resource_id,
504: NVL(dept_res.available_24_hours_flag, 2)
505: from bom_department_resources dept_res,
506: bom_departments dept
507: where dept_res.department_id = dept.department_id
508: AND dept_res.share_from_dept_id is null
509: AND dept.organization_id = p_organization_id;
510:

Line 652: bom_departments dept

648: dept_ins.instance_id,
649: dept_ins.serial_number
650: from bom_dept_res_instances dept_ins,
651: bom_department_resources dept_res,
652: bom_departments dept
653: where dept_res.department_id = dept.department_id
654: AND dept_res.share_from_dept_id is null
655: AND dept_ins.resource_id = dept_res.resource_id
656: AND dept_ins.department_id = dept_res.department_id

Line 851: bom_departments dept

847: cursor dept_res is
848: select dept_res.department_id,
849: NVL(dept_res.available_24_hours_flag, 2)
850: from bom_department_resources dept_res,
851: bom_departments dept
852: where dept_res.department_id = dept.department_id
853: AND dept_res.resource_id = p_resource_id
854: AND dept_res.share_from_dept_id is null
855: AND dept.organization_id = p_organization_id

Line 905: bom_departments dept

901: select dept_ins.department_id,
902: NVL(dept_res.available_24_hours_flag, 2)
903: from bom_dept_res_instances dept_ins,
904: bom_department_resources dept_res,
905: bom_departments dept
906: where dept_ins.department_id = dept.department_id
907: AND dept_res.department_id = dept_ins.department_id
908: and dept_res.resource_id = p_resource_id
909: AND dept_ins.resource_id = p_resource_id