'Item Supply/Demand' Form
bsc1000May 27 2009 — edited May 28 2009Hi All,
Our requirement is to find out the available quantity which shown on ‘Item supply/Demand’ form through custom concurrent program .
So we have used code from Form which calls package INV_TM.LAUNCH which in turns
Call concurrent program INXDSD. Using above pack we can able to produce data
In table MTL_SUPPLY_DEMAND_TEMP but we could find following mismatch :
1.Column Value ‘ON_HAND_QUANTITY’ from table and ‘Avail Quantity’ Field from FORM do not match .
2.Above package return two values for variables TOTAL_TEMP and AVAIL_QTY_TEMP
In our code package returns NULL for these two columns.
These two values are used to show ‘Avail Quantity’ Field in form.
do anyone know why two values are returned as NULL or any alternative aprroach for this ?
Appreciate help on this.