Search This Blog

Friday, April 6, 2012

SQL Query to extract Oracle Sales Order Information

select fu.user_name,fu.email_address,ooha.header_id,
to_date(ooha.creation_date,'DD-MON-YYYY HH:MI:SS:'),
hca.account_number Customer_Number,
hca.account_name customer_name,
otta.order_category_code "Order Type",
ooha.demand_class_code, Operating_Unit, PriceList, ooha.flow_status_code Order_Status,
oola.line_id, oola.line_number, oola.ordered_item, oola.ordered_quantity, oola.unit_selling_price,
oola.flow_status_code Line_Status,
mp.organization_code warehouse 
from apps.oe_order_headers_all ooha,
apps.fnd_user fu,
apps.oe_order_lines_all oola,
apps.hr_operating_units hou,
apps.qp_list_headers_all qph,
apps.hz_cust_accounts_all hca,
apps.oe_transaction_types_all otta,
apps.mtl_parameters mp
where 1=1
and ooha.header_id = oola.header_id
and mp.organization_id = oola.ship_from_org_id
and hou.organization_id = ooha.org_id
and ooha.price_list_id = qph.list_header_id
and ooha.sold_to_org_id = hca.cust_account_id
and ooha.order_type_id = otta.transaction_type_id
and ooha.created_by = fu.user_id
and ooha.order_number = &Order_Number
order by 3 desc;


  1. It would be a great to share a bit more on this matter. I’m glad I come across your site really informative post. Thanks for sharing this material.

  2. This is thing which is really appreciable. You provided such a nice information. It helps a lot to others and by you post they get to know about it. Thanks for sharing ....

    Order Management System

  3. I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.

  4. It is great to have the opportunity to read a good quality article with useful information on topics that plenty are interested on.