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.
Charlie said on January 13, 2012
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…