VbzCart/queries/qryPkgLines byOrdLine andItem

Details

 * Requires:
 * Used by:

SQL
CREATE OR REPLACE VIEW qryPkgLines_byOrdLine_andItem AS SELECT ID_OrdLine, ID_Item, Sum(   IFNULL(pl.QtyShipped,0)+    IFNULL(pl.QtyNotAvail,0)+    IFNULL(pl.QtyKilled,0)    ) AS QtyDone, Sum(pl.QtyShipped) AS QtyShipped, Sum(pl.QtyNotAvail) AS QtyNotAvail, Sum(pl.QtyKilled) AS QtyKilled, Sum(pl.QtyExtra) AS QtyExtra FROM ord_pkg_lines AS pl GROUP BY ID_OrdLine, ID_Item;