Home » Applications » Oracle Fusion Apps & E-Business Suite » Get Sales Quotation for Each Sales Order (EBS R12.05)
Get Sales Quotation for Each Sales Order [message #401911] Wed, 06 May 2009 23:27
Messages: 1
Registered: May 2009
Junior Member
Dear All,

I want to create a report to know the Sales Quotation for each Sales Order.
I select it from oe_order_headers_all like this

select oha.header_id,oha.order_category_code,oha.order_number,
from oe_order_headers_all oha
where oha.quote_number is not null

but the for my opinion the result is
1. when Sales Quotation created into Sales Order, it lost it's Quotation Date and Quotation number
2. when oha.context is Sales Quotation, means it has not yet been created into Sales Order.

I search in oe_order_lines history for the lines, but I still can't find the header information that was lost when Sales Quotation updated into Sales Order and oe_order_header_history is all null.

Please help, sorry for my bad english and thank you



[Updated on: Wed, 06 May 2009 23:33]

Report message to a moderator

Previous Topic: Unable to assign 'Installed Base' to the users
Next Topic: Oracle Financials
Goto Forum:

Current Time: Sat Aug 19 08:16:42 CDT 2017

Total time taken to generate the page: 0.05165 seconds