VbzCart/queries/qryRstkReq Items expected
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, based on items requested (in active restock requests only) less items already received for those requests
- Requires: qryRstkReq_Item_status
- Used by : "items needed" admin page
- Related: Like qryRstkItms_expected, but grouped by Item (eliminates rstk_req data)
- History:
- 2010-01-03 Created for generating list of needed items
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Items_expected AS SELECT
ID_Item, SUM(QtyRecd) AS QtyRecd, SUM(QtyOrd) AS QtyOrd
FROM qryRstkReq_Item_status GROUP BY ID_Item HAVING SUM(QtyOrd)-SUM(QtyRecd)>0;</mysql> <section end=sql />
