VbzCart/queries/qryRstkItms expected byItem

About

 * Purpose: Returns a list of items we're currently expecting to receive in restocks,
 * Requires:
 * Used by : restock request generation admin page
 * History:
 * 2010-01-05 Created for VbzAdmin; replaced

SQL
CREATE OR REPLACE VIEW qryRstkItms_expected_byItem AS SELECT ID_Item, SUM(QtyExp) AS QtyExp, SUM(QtyRecd) AS QtyRecd FROM qryRstkItms_expected GROUP BY ID_Item;