Orders by Item Report

TICKET 7: Orders by Item Report
               Added column: ITEM_TYPE
What it is: The Orders by Item Report reviews all sales for a particular item or group of items. You can restrict the output of this report by customer, order number range or range of order dates.
Customization:add a field ITEM_TYPE_CODE from table OE_ORDER_LINES_ALL  and report was order by Item Name and Item_Type and then  Customer_name
Parameters: Customer Number(From),Customer Number(To),Order Date(From),Order Date (To),Order Type(From),Order Type(To),Line Category,Item Category
Mandatory Parameters:Display Item
TABLES: oe_order_headers_all , hz_parties ,  hz_cust_accounts, oe_order_lines_all ,oe_transaction_types_tl ,mtl_system_items_b_kfv , mtl_system_items_tl 

QUERY:
select distinct item_type_code from  oe_order_lines_all
Here various Item Types Are:
1)Standard
2)Class
3)kit
4)Model
5)Config
6)Option
7)Service






Post a Comment