SQL or view to see undelivered quantity under a receive?

We need a good way to confirm the quantity delivered and ideally also the PO distribution the items were delivered to.   This is simple when you receive a quantity and deliver it all at once, but in real life there can be multiple partial quantities delivered, in inspection, corrected, re-delivered, or returned to supplier.  So we need a way to take a receive transaction and know what is actually in inventory.   We tried the RCV_Supply view, but that doesn't distinguish between inspection, transfer, RTS, or deliver.

Thanks for any ideas!

J