5.3 Item Supply Demand Query

  • Form Application: Inventory
  • Form Name: INVDVDSD
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVDVDSD.fmx

Item Supply Demand screen is very popular screen to query supply/demand information in the near future. It shows current onhand of any item queried then displays the supply demand information sorted by supply/demand date along with projected on-hand information.

Navigation: Login to Oracle Apps -> Select Inventory responsibility -> On-hand, Availability -> Item Supply/Demand

  • Item: Enter the item number to be queried. Only one can use be entered.
  • Cut-off date: Optionally enter cut-off date upto which you would like to view the supply/demand information.
  • UOM: Enter UOM code into which you would like to see the quantity
  • Include: Select ATP/Non-ATP subinventories.
  • Click ‘FIND’

Output shows the Item, UOM, current on-hand, date, supply/demand type, supply/deamand identifier, quantity (supply/demand), Projected available quantity.

Item Supply Demand

Item Supply Demand

1 response to 5.3 Item Supply Demand Query

  1. I did a last query on this form. I was able to locate the from and where clauses in the palette but I couldn’t locate the ‘SELECT’ portion. Anybody know where this is at??????
    Thanks…

Leave a reply

Your email address will not be published. Required fields are marked *