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.
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.
Tagged:
0