Find out items returned up against the purchase order to supplier. SELECT APS.VENDOR_NAME "SUPPLIER", ph.segment1 "PO NUM", MSI.DESCRIPTION, TO_NUMBER (QUANTITY_RECEIVED) " NET RECIEVED", (QUANTITY_SHIPPED - QUANTITY_RECEIVED) "RETURNED", rct.transaction_type, TRUNC (RCT.TRANSACTION_DATE)...
/ Posted by Kapil