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,
ooha.order_number,
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, hou.name Operating_Unit,
qph.name 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;

5 comments:

  1. 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

    ReplyDelete
  2. Oh my goodness! an incredible article dude. Thank you Nevertheless I am experiencing concern with ur rss . Don’t know why Unable to subscribe to it. Is there anyone getting similar rss drawback? Anybody who is aware of kindly respond. Thnkx bovada casino

    ReplyDelete
  3. I would highly recommend Mr, Benjamin services to any person in need financial help and they will keep you on top of high directories for any further needs. Once again I commend yourself and your staff for extraordinary service and customer service, as this is a great asset to your company and a pleasant experience to customers such as myself. Wishing you all the best for the future.Mr, Benjamin is best way to get an easy loan,here is there email..  247officedept@gmail.com     Or talk to Mr Benjamin On WhatsApp Via_+1-989-394-3740 Thank You for helping me with loan once again in my sincerely heart I'm forever grateful.

    ReplyDelete