VbzCart/queries/qryStk lines remaining

About

 * Returns: actually in stock, which is actually different things:
 * "forSale": items which are visible as "in stock" to customers
 * "forShip": items which are available for shipping
 * items neither for shipping nor for sale (probably some kind of recordkeeping purpose)
 * Requires: ,
 * Used by:, , ,
 * History:
 * 2009-11-29 renamed from v_stk_lines_remaining to qryStk_lines_remaining
 * 2010-06-15 added BinCode (sb.Code) -- needed for clsStkItems::List_forItem

SQL
CREATE OR REPLACE VIEW qryStk_lines_remaining AS SELECT st.ID, st.ID_Bin, st.ID_Item, IF(sb.isForSale,st.Qty,0) AS QtyForSale, IF(sb.isForShip,st.Qty,0) AS QtyForShip, st.Qty AS QtyExisting, st.CatNum, st.WhenAdded, st.WhenChanged, st.WhenCounted, st.Notes, sb.Code AS BinCode, sb.ID_Place, sp.Name AS WhName FROM (       stk_items AS st        LEFT JOIN stk_bins AS sb          ON sb.ID=st.ID_Bin       ) LEFT JOIN stk_places AS sp        ON sb.ID_Place=sp.ID    WHERE (st.WhenRemoved IS NULL) AND (sb.WhenVoided IS NULL) AND (st.Qty <> 0);