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 BOM_DEPARTMENTS

Line 306: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_V WO, BOM_DEPARTMENTS BOM

302: SELECT OL.OSP_ORDER_LINE_ID, OL.OSP_LINE_NUMBER, OL.SERVICE_ITEM_ID,
303: OL.SERVICE_ITEM_DESCRIPTION, WO.QUANTITY, OL.NEED_BY_DATE,
304: OL.SERVICE_ITEM_UOM_CODE, OL.PO_LINE_TYPE_ID,
305: BOM.ORGANIZATION_ID, BOM.LOCATION_ID
306: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_V WO, BOM_DEPARTMENTS BOM
307: WHERE OL.OSP_ORDER_ID = p_osp_order_id AND
308: WO.WORKORDER_ID = OL.WORKORDER_ID AND
309: BOM.DEPARTMENT_ID (+) = WO.DEPARTMENT_ID;
310: */

Line 319: -- FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_OSP_V WO, BOM_DEPARTMENTS BOM

315: -- OL.SERVICE_ITEM_UOM_CODE, OL.PO_LINE_TYPE_ID,
316: ---- Changed by jaramana on May 26, 2005 to Fix bug 4393374
317: ---- BOM.ORGANIZATION_ID, BOM.LOCATION_ID
318: -- WO.ORGANIZATION_ID, BOM.LOCATION_ID
319: -- FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_OSP_V WO, BOM_DEPARTMENTS BOM
320: -- WHERE OL.OSP_ORDER_ID = p_osp_order_id AND
321: -- WO.WORKORDER_ID = OL.WORKORDER_ID AND
322: -- BOM.DEPARTMENT_ID (+) = WO.DEPARTMENT_ID;
323: -- End ER 266135 Fix

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

328: OL.SERVICE_ITEM_DESCRIPTION, OL.QUANTITY, OL.NEED_BY_DATE,
329: OL.SERVICE_ITEM_UOM_CODE, OL.PO_LINE_TYPE_ID,
330: /**
331: OL.INVENTORY_ORG_ID, BOM.LOCATION_ID
332: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_OSP_V WO, BOM_DEPARTMENTS BOM
333: **/
334: OL.INVENTORY_ORG_ID, DECODE(OL.WORKORDER_ID, NULL, HAOU.LOCATION_ID, BOM.LOCATION_ID)
335: -- Added by mpothuku on 10-oct-2007 to fix bug 6431740
336: , WO.WIP_ENTITY_ID

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;