VbzCart/queries/qryOrdItms Pkg qtys

Details

 * Requires: qryOrderLines_Active, qry_PkgItem_qtys_byOrder
 * Used by:
 * History:
 * 2008-11-16 created for new restocking process

SQL
CREATE OR REPLACE VIEW qryOrdItms_Pkg_qtys AS SELECT oi.ID_Item, oi.ID_Order, oi.QtyOrd, piq.QtySent, piq.QtyDone, oi.QtyOrd-IFNULL(piq.QtyDone,0) AS QtyOpen FROM qryOrderItems_Active AS oi LEFT JOIN qry_PkgItem_qtys_byOrder AS piq ON (piq.ID_Item=oi.ID_Item) AND (piq.ID_Order=oi.ID_Order) ORDER BY oi.ID_Item, oi.ID_Order;