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 298: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_V WO, BOM_DEPARTMENTS BOM

294: SELECT OL.OSP_ORDER_LINE_ID, OL.OSP_LINE_NUMBER, OL.SERVICE_ITEM_ID,
295: OL.SERVICE_ITEM_DESCRIPTION, WO.QUANTITY, OL.NEED_BY_DATE,
296: OL.SERVICE_ITEM_UOM_CODE, OL.PO_LINE_TYPE_ID,
297: BOM.ORGANIZATION_ID, BOM.LOCATION_ID
298: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_V WO, BOM_DEPARTMENTS BOM
299: WHERE OL.OSP_ORDER_ID = p_osp_order_id AND
300: WO.WORKORDER_ID = OL.WORKORDER_ID AND
301: BOM.DEPARTMENT_ID (+) = WO.DEPARTMENT_ID;
302: */

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

307: -- OL.SERVICE_ITEM_UOM_CODE, OL.PO_LINE_TYPE_ID,
308: ---- Changed by jaramana on May 26, 2005 to Fix bug 4393374
309: ---- BOM.ORGANIZATION_ID, BOM.LOCATION_ID
310: -- WO.ORGANIZATION_ID, BOM.LOCATION_ID
311: -- FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_OSP_V WO, BOM_DEPARTMENTS BOM
312: -- WHERE OL.OSP_ORDER_ID = p_osp_order_id AND
313: -- WO.WORKORDER_ID = OL.WORKORDER_ID AND
314: -- BOM.DEPARTMENT_ID (+) = WO.DEPARTMENT_ID;
315: -- End ER 266135 Fix

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

320: OL.SERVICE_ITEM_DESCRIPTION, OL.QUANTITY, OL.NEED_BY_DATE,
321: OL.SERVICE_ITEM_UOM_CODE, OL.PO_LINE_TYPE_ID,
322: /**
323: OL.INVENTORY_ORG_ID, BOM.LOCATION_ID
324: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS_OSP_V WO, BOM_DEPARTMENTS BOM
325: **/
326: OL.INVENTORY_ORG_ID, DECODE(OL.WORKORDER_ID, NULL, HAOU.LOCATION_ID, BOM.LOCATION_ID)
327: -- Added by mpothuku on 10-oct-2007 to fix bug 6431740
328: , WO.WIP_ENTITY_ID

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;