How to retrieve the allocated inventory quantity in the active position in Oracle WMS Cloud?

Hello everyone!

I am creating a Web Report in Oracle WMS Cloud and need to retrieve the allocated inventory quantity in the active position. My report already includes data from orders (order_hdr, order_dtl), inventory (inventory), locations (ActLocation, ResLocation), and containers (container).

However, I am having trouble correctly retrieving the total allocated quantity of an item in the active position. I am using the following join:

pythonCopyEditallocation.from_inventory_id = inventory.id  AND allocation.to_inventory_id = inventory.id  

Even so, the returned values do not correctly reflect the total allocated quantity of the item in the active position.