Unbooked Orders Detail Report,PRINT ORDERS BY CUSTOMER WISE

TICKET 8: Unbooked Orders Detail Report

What Is:Use the Unbooked Orders Report to review orders you have entered but not booked. This report shows you the order number, order date, ordered item and line amount for each unbooked order line you choose, as well as the user who entered the order.

What it is:

Customization: TO PRINT ORDERS BY CUSTOMER WISE

Parameters: Sort by -Order Number:Manager:Created by, Created by (From),  Created by (To),Order Date(From),Order Date (To),Order Type(From),Order Type(To), Manager (From), Manager(To),Use Ledger Currency

TABLES: fnd_user, mtl_system_items_vl,oe_order_lines_all , oe_order_headers_all ,oe_order_types_v , mtl_customer_items, hz_cust_site_uses_all  , hz_cust_acct_sites_all, hz_party_sites,hz_parties bill_to_party, hz_cust_accounts, hz_parties,  hz_cust_accounts, per_all_people_f,per_all_assignments_f,per_all_people_f

QUERY:

sold_to_party.party_name sp,