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
hans.mulyadi
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,
oha.context,oha.ORDERED_DATE,oha.QUOTE_DATE,
oha.QUOTE_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

Regards,

Hans

[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: gl transfer program
Goto Forum:
  


Current Time: Wed Dec 07 03:08:26 CST 2016

Total time taken to generate the page: 0.16396 seconds