VbzCart/queries/qryItems needed forStock

About

 * Returns: catalog items we need to order more of in order to satisfy stock minima
 * Items may be needed for other reasons, but they will not be listed here unless they satisfy that criterion.
 * History:
 * 2010-01-02 Created
 * Used by: VbzAdminStkItems::Needed - restock request creation in VbzAdmin
 * Requires:

SQL
CREATE OR REPLACE VIEW qryItems_needed_forStock AS SELECT i.ID, i.QtyMin_Stk, s.QtyForSale FROM cat_items AS i LEFT JOIN qryStkItms_for_sale AS s  ON s.ID_Item=i.ID WHERE i.isForSale AND ((i.QtyMin_Stk - s.QtyForSale) > 0);