1 CREATE OR REPLACE FUNCTION qtyAvailable(INTEGER, INTEGER) RETURNS NUMERIC AS '
2 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
3 -- See www.xtuple.com/CPAL for the full text of the software license.
5 pItemsiteid ALIAS FOR $1;
6 pLookAheadDays ALIAS FOR $2;
10 RETURN ( ( SELECT qtyNetable(itemsite_id)
12 WHERE (itemsite_id=pItemsiteid) ) +
13 (SELECT qtyOrdered(pItemsiteid, pLookAheadDays)) -
14 (SELECT qtyAllocated(pitemsiteid, pLookAheadDays)) );
16 ' LANGUAGE 'plpgsql' STABLE;
19 CREATE OR REPLACE FUNCTION qtyAvailable(INTEGER, DATE) RETURNS NUMERIC AS '
20 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
21 -- See www.xtuple.com/CPAL for the full text of the software license.
23 pItemsiteid ALIAS FOR $1;
28 RETURN ( ( SELECT qtyNetable(itemsite_id)
30 WHERE (itemsite_id=pItemsiteid) ) +
31 (SELECT qtyOrdered(pItemsiteid, (pDate - CURRENT_DATE))) -
32 (SELECT qtyAllocated(pItemsiteid, (pDate - CURRENT_DATE))) );
34 ' LANGUAGE 'plpgsql' STABLE;