Formula to Calculate Available to Reserve at Different levels

The formula is  

Actual Available to Reserve = Minimum (Available to Reserve at Particular node/Sub Inventory level, Available to Reserve at higher nodes/ Inventory Organization Level)Explanation

——————————–
1. Organization level (highest level):

On Hand Quantity for item A = 345 – 30 = 315

(Here Consider 30 is stuck quantity in MMTT, Mean unprocessed pending transactions in MMTT)

So Available to Reserve at Organization level = 315
——————————–
2. Sub Inv level:On Hand Quantity for item A = 345
Available to Reserve at Sub Inventory level= 315
Actual Available to Reserve = Minimum (Available to Reserve at Sub Inventory level, Available to Reserve at Organization level)

Insert value in a table column c

Select Min(c) from dual

Result will be 315 Available to Reserve is 315

If anyone have any observation / reservation then let me know