VbzCart/queries/qryRstkReq Item status

Details

 * Returns: Information about items Restock Requested and how many have been Received
 * Status: possibly no longer in use (2010-01-04), unless it turns out to be faster this way
 * Requires: ,
 * Used by: ,
 * History:
 * 2008-11-21 Created for new restock process
 * 2010-01-04 QtyExp replaces QtyOrd
 * Fields:
 * WhenFirstOrder / WhenFinalorder are timestamps of customer orders for this item

SQL
CREATE OR REPLACE VIEW qryRstkReq_Item_status AS SELECT rci.*, IFNULL(rqi.QtyExp,rqi.QtyOrd) AS QtyExp, rqi.Notes FROM rstk_req_item AS rqi LEFT JOIN qryRstkReq_Item_Rcd_status AS rci ON (rqi.ID_Restock=rci.ID_RstkReq) AND (rqi.ID_Item=rci.ID_Item) WHERE rci.ID_RstkReq IS NOT NULL ORDER BY rci.ID_RstkReq, rci.ID_Item;