VbzCart/queries/qryStk lines remaining byBin

About

 * Returns: list of bins, with stock quantities for each (for sale, for shipping, existing)
 * Requires:
 * Used by:
 * History:
 * 2009-04-29 Created for Special:VbzAdmin
 * 2009-11-29 Updated to reflect name change of source query

SQL
CREATE OR REPLACE VIEW qryStk_lines_remaining_byBin AS SELECT ID_Bin, SUM(QtyForSale) AS QtyForSale, SUM(QtyForShip) AS QtyForShip, SUM(QtyExisting) AS QtyExisting FROM qryStk_lines_remaining GROUP BY ID_Bin;