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):
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)
——————————–
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
November 24, 2009 at 11:47 pm
In R12, Where are or where I see the Available to Reserve at Particular node/Sub Inventory level, Available to Reserve at higher nodes/ Inventory Organization Level for an Item?
I have this qry but this not retrive any rows. The table is null, why?
SELECT SUM (reservation_quantity) FROM mtl_reservations
WHERE inventory_item_id = :inventory_item_id AND organization_id = :p_org_id;
Thanks in advance