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_PVT dependencies on WIP_DISCRETE_JOBS

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

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

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;