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_OSP_PO_REQ_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 258: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU, WIP_DISCRETE_JOBS WDJ

254: DECODE(OL.WORKORDER_ID, NULL, HAOU.LOCATION_ID, BOM.LOCATION_ID),
255: WO.WIP_ENTITY_ID,
256: WDJ.PROJECT_ID,
257: WDJ.TASK_ID
258: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU, WIP_DISCRETE_JOBS WDJ
259: WHERE OL.OSP_ORDER_ID = p_osp_order_id AND
260: WO.WORKORDER_ID (+) = OL.WORKORDER_ID AND
261: WDJ.WIP_ENTITY_ID (+) = WO.WIP_ENTITY_ID AND
262: BOM.DEPARTMENT_ID (+) = WDJ.OWNING_DEPARTMENT AND

Line 268: FROM oe_order_lines_all oola, ahl_osp_order_lines aool, HR_ALL_ORGANIZATION_UNITS HAOU

264: ORDER BY OL.OSP_LINE_NUMBER;
265:
266: CURSOR get_return_to_org_csr(p_osp_line_id IN NUMBER) IS
267: SELECT oola.ship_from_org_id, HAOU.LOCATION_ID
268: FROM oe_order_lines_all oola, ahl_osp_order_lines aool, HR_ALL_ORGANIZATION_UNITS HAOU
269: WHERE oola.line_id = aool.oe_return_line_id and
270: HAOU.ORGANIZATION_ID = oola.ship_from_org_id and
271: aool.osp_order_line_id = p_osp_line_id;
272: