DBA Data[Home] [Help]

APPS.INV_SALESORDER dependencies on DUAL

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