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.OE_SERVICE_UTIL dependencies on OE_ORDER_HEADERS

Line 819: FROM oe_order_lines_all l, oe_order_headers h

815: , l_inventory_item_id
816: , l_blanket_number
817: , l_cust_po_number
818: , l_fulfilled_quantity --5699215
819: FROM oe_order_lines_all l, oe_order_headers h
820: WHERE h.order_number = p_x_line_rec.service_ref_order_number
821: AND l.line_number = p_x_line_rec.service_ref_line_number
822: AND l.shipment_number = p_x_line_rec.service_ref_shipment_number
823: AND NVL(l.option_number,0) = NVL(p_x_line_rec.service_ref_option_number, 0)

Line 849: FROM oe_order_lines_all l, oe_order_headers h

845: , l_header_id
846: , l_line_id
847: , l_inventory_item_id
848: , l_fulfilled_quantity --5699215
849: FROM oe_order_lines_all l, oe_order_headers h
850: WHERE h.order_number = p_x_line_rec.service_ref_order_number
851: AND l.line_number = p_x_line_rec.service_ref_line_number
852: AND l.shipment_number = p_x_line_rec.service_ref_shipment_number
853: AND NVL(l.option_number,0) = NVL(p_x_line_rec.service_ref_option_number, 0)

Line 2007: FROM oe_order_lines_all l, oe_order_headers h

2003: p_shipment_number is not null Then
2004:
2005: SELECT /* MOAC_SQL_CHANGE */ l.line_id
2006: INTO x_reference_line_id
2007: FROM oe_order_lines_all l, oe_order_headers h
2008: WHERE h.order_number = p_order_number
2009: AND h.header_id = l.header_id
2010: AND l.line_number = p_line_number
2011: AND l.shipment_number = p_shipment_number