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