I am working on oracle R12 implementation process.
I have the Requirement for Matching the oe_order_headers_all table and aso_quote_headers_all table. Is there any sql query for matching or linking these two tables.
Please help me on this.
Thanks & Regards,
Also please refer to http://www.oracleappstips.com/2011/06/oracle-order-capture-overview.html
Please look in to the comment section which has full details on the joins between these two modules
I had referred the above link , now i clear and it is useful for my issue.
Also i have another issue in istore. i.e If the order is confirmed in istore means , customer needs to get the order confirmation emails for every order. Could you please help me, how to enable order confirmation email notification for istore customer in R12.