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_LTP_SPACE_ASSIGN_PVT dependencies on BOM_DEPARTMENTS

Line 142: FROM BOM_DEPARTMENTS

138: IF (p_department_id IS NOT NULL)
139: THEN
140: SELECT department_id
141: INTO x_department_id
142: FROM BOM_DEPARTMENTS
143: WHERE organization_id = p_organization_id
144: AND department_id = p_department_id
145: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);
146: ELSE

Line 145: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);

141: INTO x_department_id
142: FROM BOM_DEPARTMENTS
143: WHERE organization_id = p_organization_id
144: AND department_id = p_department_id
145: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);
146: ELSE
147: SELECT department_id
148: INTO x_department_id
149: FROM BOM_DEPARTMENTS

Line 149: FROM BOM_DEPARTMENTS

145: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);
146: ELSE
147: SELECT department_id
148: INTO x_department_id
149: FROM BOM_DEPARTMENTS
150: WHERE organization_id = p_organization_id
151: AND description = p_dept_description
152: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);
153: END IF;

Line 152: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);

148: INTO x_department_id
149: FROM BOM_DEPARTMENTS
150: WHERE organization_id = p_organization_id
151: AND description = p_dept_description
152: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);
153: END IF;
154: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
155: EXCEPTION
156: WHEN NO_DATA_FOUND THEN