Can I ask what you mean by ‘shortage date’?

Linda

From my understanding, they use shortage date as a date they will no longer have inventory available. So if they have inventory today and they look up the shortage date it could show a date of a month from now and that’s the date we can expect to run out. The date I am using currently is for sure a customization so it’s possible nothing like it exists in out of box API’s. 

It feels like you’d be looking to return the date when Projected hits zero?  This is on the Inventory Parts Availability Planning/All tab

If it’s any help - this is from Apps9.  Can you extract the date for when projected = 0?  

Logical Unit:    OrderSupplyDemand
View:               &AO.ORDER_SUPP_DEM_EXT_TMP_VIEW
Package:        &AO.ORDER_SUPPLY_DEMAND_API

FUNCTION Get_Projected_Quantity (
   contract_               IN VARCHAR2,
   part_no_                IN VARCHAR2,
   configuration_id_       IN VARCHAR2,
   date_required_          IN DATE,
   order_no_               IN VARCHAR2,
   line_no_                IN VARCHAR2,
   rel_no_                 IN VARCHAR2,
   line_item_no_           IN NUMBER,
   order_supp_demand_type_ IN VARCHAR2) RETURN NUMBER