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 824: FROM oe_order_lines_all l, oe_order_headers h

820: , l_inventory_item_id
821: , l_blanket_number
822: , l_cust_po_number
823: , l_fulfilled_quantity --5699215
824: FROM oe_order_lines_all l, oe_order_headers h
825: WHERE h.order_number = p_x_line_rec.service_ref_order_number
826: AND l.line_number = p_x_line_rec.service_ref_line_number
827: AND l.shipment_number = p_x_line_rec.service_ref_shipment_number
828: AND NVL(l.option_number,0) = NVL(p_x_line_rec.service_ref_option_number, 0)

Line 854: FROM oe_order_lines_all l, oe_order_headers h

850: , l_header_id
851: , l_line_id
852: , l_inventory_item_id
853: , l_fulfilled_quantity --5699215
854: FROM oe_order_lines_all l, oe_order_headers h
855: WHERE h.order_number = p_x_line_rec.service_ref_order_number
856: AND l.line_number = p_x_line_rec.service_ref_line_number
857: AND l.shipment_number = p_x_line_rec.service_ref_shipment_number
858: AND NVL(l.option_number,0) = NVL(p_x_line_rec.service_ref_option_number, 0)

Line 2047: FROM oe_order_lines_all l, oe_order_headers h

2043: p_shipment_number is not null Then
2044:
2045: SELECT /* MOAC_SQL_CHANGE */ l.line_id
2046: INTO x_reference_line_id
2047: FROM oe_order_lines_all l, oe_order_headers h
2048: WHERE h.order_number = p_order_number
2049: AND h.header_id = l.header_id
2050: AND l.line_number = p_line_number
2051: AND l.shipment_number = p_shipment_number