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)
Added returned quantity….
Return reason, Credit Order date from, to, Credit order type, Item (for particular item), description,precision….
Oe_order_headers, oe_order_lines, oe_order_transactions, mtl_system_items_b
COLUMNS ADDED IN PAPER LAYOUT: