Find out items received against the purchase order from the supplier. SELECT APS.VENDOR_NAME "SUPPLIER", ph.segment1 "PO NUM", MSI.DESCRIPTION, RCT.SOURCE_DOC_QUANTITY "RECIEVED", TO_NUMBER (QUANTITY_RECEIVED) " NET RECIEVED", rct.transaction_type, TRUNC (RCT.TRANSACTION_DATE) TRANSACTION_DATE FROM...
/ Posted by Kapil