Need backend SQL table or API to extract below values from “Item Quantities” screen

Summary:

Need backend SQL table or API to extract below values from “Item Quantities” screen to populate the data in On Hand custom screen.

Available to Reserve

Available to Transact

Secondary Available to Reserve

Secondary Available to Transact

As per oracle document , “Available to Reserve” & “Available to Transact” column are calculation fields . We need to check which table contains “Pending Transactions” & “Reservations” to calculate the fields.

Link : https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/25b/famml/available-to-reserve-and-available-to-transact-values.html

These fields are calculated fields and in of km-article # KB17259 , Oracle has mentioned there is complex algorithm to calculate the fields and suggesting to check directly from UI.