APPS.AHL_OSP_PO_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

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

328: , WO.WIP_ENTITY_ID
329: , WDJ.PROJECT_ID
330: , WDJ.TASK_ID
331: /*
332: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_OSP_V WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU
333: */
334: -- Changes made by jaramana on December 19, 2005
335: -- to improve the performace of this SQL.
336: -- Removed reference to AHL_WORKORDERS_OSP_V and instead joined directly with

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

334: -- Changes made by jaramana on December 19, 2005
335: -- to improve the performace of this SQL.
336: -- Removed reference to AHL_WORKORDERS_OSP_V and instead joined directly with
337: -- WIP_DISCRETE_JOBS to get the work order department
338: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU, WIP_DISCRETE_JOBS WDJ
339: WHERE OL.OSP_ORDER_ID = p_osp_order_id AND
340: WO.WORKORDER_ID (+) = OL.WORKORDER_ID AND
341: /**
342: BOM.DEPARTMENT_ID (+) = WO.DEPARTMENT_ID;

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

351: -- Added by jaramana on June 24, 2005 to get the updated Return to Org
352: -- Updated by jaramana on March 20, 2006 to get the Org Location for fixing Bug 5104282
353: CURSOR get_return_to_org_csr(p_osp_line_id IN NUMBER) IS
354: SELECT oola.ship_from_org_id, HAOU.LOCATION_ID
355: FROM oe_order_lines_all oola, ahl_osp_order_lines aool, HR_ALL_ORGANIZATION_UNITS HAOU
356: WHERE oola.line_id = aool.oe_return_line_id and
357: HAOU.ORGANIZATION_ID = oola.ship_from_org_id and
358: aool.osp_order_line_id = p_osp_line_id;
359: