VbzCart/docs/queries/qryRstkItms expected byItem

About

• Purpose: Returns a list of items we're currently expecting to receive in restocks,
• Requires: Template:Vbzcart/query
• Used by : restock request generation admin page
• History:
  • 2010-01-05 Created for VbzAdmin; replaced Template:Vbzcart/query
  • 2016-03-02 No longer works; dropped from database.

SQL

<mysql>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;</mysql>