VbzCart/queries/qryRstkItms expected byItem
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Purpose: Returns a list of items we're currently expecting to receive in restocks,
- Requires: qryRstkItms_expected
- Used by : restock request generation admin page
- History:
- 2010-01-05 Created for VbzAdmin; replaced qryRstkReq_Items_expected
SQL
<section begin=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> <section end=sql />
