In Oracle Order management we have option to create Sales Order from Sales Quote ( for more info plese refer my earlier post Quote to Order flow ).During this flow system will create only 1 record for Quote Header as well as for each line in the Quote, by that I mean when we creates the Quote , data for Quote header/lines got inserted into oe_order_headers_all/oe_order_lines all , and once Quote got converted into Order, same data will be used for order header /lines,only difference are
1.Flow Status Code for Order header will be updated to "Entered", plus
2.For Quote, system insert the data into workflow tables like
- wf_items and wf_item_activity_statuses with item_type ='OENH' , but once Quote got approved and converted to Orders , system will end_date the workflow with item_type ='OENH' and creates new workflow with item_type ='OEOH'( for order header) and OEOL (for order lines).
Please note that in Quotes there is no workflow for Order lines.
