Returns by Reason Report

TICKET 3        : Returns by Reason Report 
                    We Need to Add a Column To Get RETURN QUANTITY(IN PAPER LAYOUT).
WHAT IS:  The Returns by Reason Report reviews all return material authorizations for various return reasons. Oracle Order Entry/Shipping automatically sorts this report by currency, return reason, and then item.
IN QUERY: l.ordered_quantity-l.shipped_quantity(from oe_order_lines_all l)
Customization:
Added returned quantity.
Parameters:
Return reason, Credit Order date from, to, Credit order type, Item (for particular item), description,precision.
Tables:
Oe_order_headers,  oe_order_lines, oe_order_transactions, mtl_system_items_b



COLUMNS ADDED IN PAPER LAYOUT:



Post a Comment