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 5096: --Get the PO Line attributes and the need_by_date from the first record of po_line_locations_all

5092: AND arb.service_item_id = mtls.inventory_item_id(+)
5093: AND vts.instance_id = csii.instance_id;
5094:
5095: -- Added by jaramana on January 10, 2008 for the Bug 5358438/5967633/5417460
5096: --Get the PO Line attributes and the need_by_date from the first record of po_line_locations_all
5097: CURSOR get_po_line_attrs(c_po_line_id NUMBER) IS
5098: SELECT pol.line_num,
5099: pol.item_id,
5100: pol.item_description,

Line 5105: from po_line_locations_all

5101: pol.line_type_id,
5102: uom.uom_code,
5103: pol.quantity,
5104: (select min(need_by_date)
5105: from po_line_locations_all
5106: where po_line_id = pol.po_line_id
5107: and po_header_id = pol.po_header_id) need_by_date
5108: FROM po_lines_all pol,
5109: mtl_units_of_measure_vl uom