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 401: FROM BOM_DEPARTMENTS

397: IF (p_department_id IS NOT NULL)
398: THEN
399: SELECT department_id
400: INTO x_department_id
401: FROM BOM_DEPARTMENTS
402: WHERE organization_id = p_organization_id
403: AND department_id = p_department_id
404: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);
405: ELSE

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

400: INTO x_department_id
401: FROM BOM_DEPARTMENTS
402: WHERE organization_id = p_organization_id
403: AND department_id = p_department_id
404: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);
405: ELSE
406: SELECT department_id
407: INTO x_department_id
408: FROM BOM_DEPARTMENTS

Line 408: FROM BOM_DEPARTMENTS

404: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);
405: ELSE
406: SELECT department_id
407: INTO x_department_id
408: FROM BOM_DEPARTMENTS
409: WHERE organization_id = p_organization_id
410: AND description = p_dept_description
411: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);
412: END IF;

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

407: INTO x_department_id
408: FROM BOM_DEPARTMENTS
409: WHERE organization_id = p_organization_id
410: AND description = p_dept_description
411: AND EXISTS ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = BOM_DEPARTMENTS.DEPARTMENT_ID);
412: END IF;
413: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
414: EXCEPTION
415: WHEN NO_DATA_FOUND THEN