VbzCart/queries/qryRstkItms active

Details

• Returns: Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled).
• Requires:

1. REDIRECT Template:l/vc/table,
2. REDIRECT Template:l/vc/query

• Used by: qryRstkItms_expected
• Note: This is different from qryRstkLines_en_route (deprecated):
  • Grouped by Item instead of Restock Line
  • Uses new Restock tables
• History:
  • 2008-11-18 Created for new restock process

SQL

<mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS SELECT

 rrq.ID_Restock,
 rrq.ID_Item,
 SUM(rrq.QtyOrd) AS QtyOrd

FROM

     rstk_req_item AS rrq
   LEFT JOIN qryRstks_active AS rq ON rrq.ID_Restock=rq.ID

WHERE rq.ID IS NOT NULL GROUP BY rrq.ID_Restock, rrq.ID_Item;</mysql>