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_ORDERS_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 5446: --Get the PO Line attributes and the need_by_date from the first record of po_line_locations_all

5442: AND arb.service_item_id = mtls.inventory_item_id(+)
5443: AND vts.instance_id = csii.instance_id;
5444:
5445: -- Added by jaramana on January 10, 2008 for the Bug 5358438/5967633/5417460
5446: --Get the PO Line attributes and the need_by_date from the first record of po_line_locations_all
5447: CURSOR get_po_line_attrs(c_po_line_id NUMBER) IS
5448: SELECT pol.line_num,
5449: pol.item_id,
5450: pol.item_description,

Line 5455: from po_line_locations_all

5451: pol.line_type_id,
5452: uom.uom_code,
5453: pol.quantity,
5454: (select min(need_by_date)
5455: from po_line_locations_all
5456: where po_line_id = pol.po_line_id
5457: and po_header_id = pol.po_header_id) need_by_date
5458: FROM po_lines_all pol,
5459: mtl_units_of_measure_vl uom