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: