VbzCart/docs/queries/qryRstkReq Items expected

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: Template:Vbzcart/query
• Used by : "items needed" admin page
• Related: Like Template:Vbzcart/query, 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 />