Inventory

Get Involved. Join the Conversation.

Topic

    Arijit Pramanik
    Is there a way to get the available to reserve quantity for...
    Topic posted August 7, 2019 by Arijit PramanikRed Ribbon: 250+ Points, tagged Inventory Cloud, SCM 
    28 Views, 2 Comments
    Title:
    Is there a way to get the available to reserve quantity for an item from a table or query?
    Summary:
    Is there a way to get the available to reserve quantity for an item from a table or query?
    Content:

    Is there a way to get the available to reserve quantity for an item from a table or query? please share the table name or the query

    Comment

     

    • Phillip Erwin

      I'd be an advocate for an OTBI area for reservations.  I can see many uses for this!!

    • Pradeep Kumar

      Hi

      Please find the below query is helpful

      SELECT nvl(SUM (PRIMARY_RESERVATION_QUANTITY),0) as reserve_qty, 0 as temp_qty
        FROM inv_reservations
       WHERE inventory_item_id = 

      AND organization_id = 

      and SUBINVENTORY_CODE=

      Regards

      Pradeep