Line 141: SELECT mtl_sales_orders_s.nextval into l_so_id from dual ;
137: EXCEPTION
138: WHEN NO_DATA_FOUND THEN
139: -- sales order does not exist, create a new one
140: 141: SELECT mtl_sales_orders_s.nextval into l_so_id from dual ; 142:
143: INSERT into MTL_SALES_ORDERS (sales_order_id, segment1, segment2, segment3, last_updated_by,
144: last_update_date, last_update_login, creation_date, created_by,
145: summary_flag, enabled_flag) values