VbzCart/queries/qryRpt Pkg Lines

About

 * Requires:, ,
 * History:
 * 2011-05-31 ported from MS Access so I can print packing slips from web interface (final major piece?)
 * 2011-06-01 added p.ID_Item so we can pull in the results from ; added PriceShipped so I don't have to implement expressions in w3tpl yet

SQL
CREATE OR REPLACE VIEW qryRpt_Pkg_Lines AS SELECT p.ID AS ID, p.ID_Pkg, o.Seq, IFNULL(o.CatNum,i.CatNum) AS CatNum, IFNULL(o.Descr,i.Descr) AS Descr, o.QtyOrd, p.QtyShipped, p.QtyExtra, p.QtyNotAvail, p.QtyKilled, o.Price, o.Price * p.QtyShipped AS PriceShipped, o.ShipItm, o.ShipPkg, p.ID_Item, i.ID_Title FROM ( ord_pkg_lines AS p LEFT JOIN  ord_lines AS o ON p.ID_OrdLine=o.ID) LEFT JOIN qryCat_Items AS i ON p.ID_Item=i.ID;