VbzCart/queries/qryRstkItms expected byItem

About

• Purpose: Returns a list of items we're currently expecting to receive in restocks,
• Requires:

1. REDIRECT Template:l/vc/query

• Used by : restock request generation admin page
• History:
  • 2010-01-05 Created for VbzAdmin; replaced qryRstkReq_Items_expected
  • 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>