VbzCart/queries/qryRstkItms active

Details

 * Returns: Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled).
 * Requires: ,
 * Used by:
 * Note: This is different from qryRstkLines_en_route (deprecated):
 * Grouped by Item instead of Restock Line
 * Uses new Restock tables
 * History:
 * 2008-11-18 Created for new restock process
 * 2010-01-04 now allowing QtyExp to override QtyOrd; resulting field renamed from QtyOrd to QtyExp

SQL
CREATE OR REPLACE VIEW qryRstkItms_active AS SELECT rrq.ID_Restock, rrq.ID_Item, SUM(IFNULL(rrq.QtyExp,rrq.QtyOrd)) AS QtyExp FROM rstk_req_item AS rrq LEFT JOIN qryRstks_active AS rq ON rrq.ID_Restock=rq.ID WHERE rq.ID IS NOT NULL GROUP BY rrq.ID_Restock, rrq.ID_Item;