eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_TASKS_PUB dependencies on BOM_DEPARTMENTS

Line 201: SELECT department_id FROM bom_departments

197: WHERE visit_number = c_visit_number
198: AND status_code in ('RELEASED', 'PLANNING', 'PARTIALLY RELEASED');
199:
200: CURSOR validate_dept_id_csr(c_dept_id IN NUMBER, c_org_id IN NUMBER) IS
201: SELECT department_id FROM bom_departments
202: WHERE department_id = c_dept_id
203: AND organization_id = c_org_id;
204:
205: CURSOR validate_dept_code_csr(c_dept_code IN VARCHAR2, c_org_id IN NUMBER) IS

Line 206: SELECT department_id FROM bom_departments

202: WHERE department_id = c_dept_id
203: AND organization_id = c_org_id;
204:
205: CURSOR validate_dept_code_csr(c_dept_code IN VARCHAR2, c_org_id IN NUMBER) IS
206: SELECT department_id FROM bom_departments
207: WHERE department_code = c_dept_code
208: AND organization_id = c_org_id;
209:
210: CURSOR check_group_mr_csr(c_ue_id IN NUMBER) IS