SQL Query to Retrieve Available to Transact Quantity

Summary:
SQL Query to Retrieve Available to Transact Quantity

Content (please ensure you mask any confidential information):

Hello Team,

I am working on developing a SQL query to calculate the Available to Transact (ATT) quantity in Oracle Fusion Cloud. While using the INV_RESERVATIONS table, I noticed that some reservation records have a null or blank value in the subinventory field.

Due to this, I am facing challenges in determining the correct ATT values at the Inventory Organization, Item, and Subinventory levels.

Could you please advise on the best approach to handle such cases and ensure accurate calculation of ATT? Any guidance or suggestions would be greatly appreciated.