APPS.AHL_OSP_PO_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 340: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_OSP_V WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU

336: , WO.WIP_ENTITY_ID
337: , WDJ.PROJECT_ID
338: , WDJ.TASK_ID
339: /*
340: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_OSP_V WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU
341: */
342: -- Changes made by jaramana on December 19, 2005
343: -- to improve the performace of this SQL.
344: -- Removed reference to AHL_WORKORDERS_OSP_V and instead joined directly with

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

342: -- Changes made by jaramana on December 19, 2005
343: -- to improve the performace of this SQL.
344: -- Removed reference to AHL_WORKORDERS_OSP_V and instead joined directly with
345: -- WIP_DISCRETE_JOBS to get the work order department
346: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU, WIP_DISCRETE_JOBS WDJ
347: WHERE OL.OSP_ORDER_ID = p_osp_order_id AND
348: WO.WORKORDER_ID (+) = OL.WORKORDER_ID AND
349: /**
350: BOM.DEPARTMENT_ID (+) = WO.DEPARTMENT_ID;

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

359: -- Added by jaramana on June 24, 2005 to get the updated Return to Org
360: -- Updated by jaramana on March 20, 2006 to get the Org Location for fixing Bug 5104282
361: CURSOR get_return_to_org_csr(p_osp_line_id IN NUMBER) IS
362: SELECT oola.ship_from_org_id, HAOU.LOCATION_ID
363: FROM oe_order_lines_all oola, ahl_osp_order_lines aool, HR_ALL_ORGANIZATION_UNITS HAOU
364: WHERE oola.line_id = aool.oe_return_line_id and
365: HAOU.ORGANIZATION_ID = oola.ship_from_org_id and
366: aool.osp_order_line_id = p_osp_line_id;
367: