APPS.AHL_OSP_PO_PVT dependencies on WIP_DISCRETE_JOBS

Line 337: -- WIP_DISCRETE_JOBS to get the work order department

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
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: /**

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;