Order Discount Detail Report,Add SubTotals for Selling Price and List Price

TICKET 9: Order Discount Detail Report:

What Is:The Order Discount Detail Report reviews discounts applied to orders by order line detail. This report provides detailed line pricing information, including price list price, selling price, and discount information.

What it is: The Order Discount Detail Report reviews discounts applied to orders by order line detail. This report provides detailed line pricing information, including price list price, selling price, and discount information.

Customization: To Add SubTotals for Selling Price and List Price unit_list_price,unit_sell_price Formula columns(list_price,sell_price) IN some data group(line_template)

Parameters:Sort by,Customer Number(From),Customer Number(To),Order Date(From),Order Date (To),Order Type(From),Order Type(To),Line Type(From),Line Type(To)

Manditory Parameters:Open Order Only,Item Display,Mixed Precision

TABLES: OE_ORDER_LINES_ALL, OE_ORDER_TYPES_V, OE_LINE_TYPES_V, HZ_CUST_SITE_USES_ALL ,HZ_CUST_ACCT_SITES_ALL,HZ_LOCATIONS,HZ_PARTY_SITES,

 MTL_SYSTEM_ITEMS_TL ,MTL_SYSTEM_ITEMS_B_KFV,RA_SALESREPS,  OE_SOLD_TO_ORGS_V           

OE_PRICE_ADJUSTMENTS,QP_LIST_HEADERS_VL ,OE_ORDER_HEADERS_ALL