[Home] [Help]
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)
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)
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
2633: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2634: BEGIN
2635: Select 'EXISTS' into
2636: l_exists
2637: from oe_order_lines_all
2638: where service_reference_line_id = l_line_id;
2639: p_result := 1;
2640:
2641: EXCEPTION
3176: FETCH option_lines BULK COLLECT INTO l_line_ids, l_option_numbers;
3177: CLOSE option_lines;
3178:
3179: FORALL i IN 1..l_line_ids.count
3180: UPDATE oe_order_lines_all
3181: SET option_number = l_option_numbers(i)
3182: WHERE service_reference_line_id = l_line_ids(i)
3183: AND service_reference_type_code = l_ref_type_code; -- For Bug 3087370
3184: