3 -- Notes: used by dspMRPDetail
4 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
5 -- See www.xtuple.com/CPAL for the full text of the software license.
7 SELECT qtyNetable(itemsite_id) AS qoh, formatQty(qtyNetable(itemsite_id)) AS f_qoh,
8 qtyAllocated(itemsite_id, findPeriodStart(<? value("cursorId") ?>),
9 findPeriodEnd(<? value("cursorId") ?>)) AS allocations<? value("counter") ?>,
10 qtyOrdered(itemsite_id, findPeriodStart(<? value("cursorId") ?>),
11 findPeriodEnd(<? value("cursorId") ?>)) AS orders<? value("counter") ?>,
12 qtyFirmedAllocated(itemsite_id, findPeriodStart(<? value("cursorId") ?>),
13 findPeriodEnd(<? value("cursorId") ?>)) AS firmedallocations<? value("counter") ?>,
14 qtyFirmed(itemsite_id, findPeriodStart(<? value("cursorId") ?>),
15 findPeriodEnd(<? value("cursorId") ?>)) AS firmedorders<? value("counter") ?>
17 WHERE (itemsite_id=<? value("itemsite_id") ?>);