APPS.OE_SERVICE_UTIL dependencies on OE_ORDER_LINES_ALL

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

Line 2683: from oe_order_lines_all

2679: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2680: BEGIN
2681: Select 'EXISTS' into
2682: l_exists
2683: from oe_order_lines_all
2684: where service_reference_line_id = l_line_id;
2685: p_result := 1;
2686:
2687: EXCEPTION

Line 3226: UPDATE oe_order_lines_all

3222: FETCH option_lines BULK COLLECT INTO l_line_ids, l_option_numbers;
3223: CLOSE option_lines;
3224:
3225: FORALL i IN 1..l_line_ids.count
3226: UPDATE oe_order_lines_all
3227: SET option_number = l_option_numbers(i)
3228: WHERE service_reference_line_id = l_line_ids(i)
3229: AND service_reference_type_code = l_ref_type_code; -- For Bug 3087370
3230: