https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryOrdLines_PkgdQtys VbzCart/queries/qryOrdLines PkgdQtys - Revision history 2026-07-08T03:32:29Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryOrdLines_PkgdQtys&diff=10926&oldid=prev Woozle: New page: ==Details== * '''Requires''': {{vbzcart/query|qryPkgLines_byOrdLine_andItem}}, {{vbzcart/table|core_orders}} * '''Used by''': order detail in Item table * '''History''': ** '''2008-11-21''... 2008-12-03T23:43:09Z <p>New page: ==Details== * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/query|qryPkgLines_byOrdLine_andItem}}, {{vbzcart/table|core_orders}} * &#039;&#039;&#039;Used by&#039;&#039;&#039;: order detail in Item table * &#039;&#039;&#039;History&#039;&#039;&#039;: ** &#039;&#039;&#039;2008-11-21&#039;&#039;...</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/query|qryPkgLines_byOrdLine_andItem}}, {{vbzcart/table|core_orders}}<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;: order detail in Item table<br /> * &#039;&#039;&#039;History&#039;&#039;&#039;:<br /> ** &#039;&#039;&#039;2008-11-21&#039;&#039;&#039;: Added CatNum, Descr, OrdNum, WhenStarted, ID_Pull fields<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryOrdLines_PkgdQtys AS<br /> SELECT<br /> ol.ID,<br /> ol.ID_Order,<br /> o.Number AS OrdNum,<br /> o.WhenStarted AS OrdDate,<br /> o.ID_Pull,<br /> ol.ID_Item,<br /> ol.CatNum,<br /> ol.Descr,<br /> ol.QtyOrd,<br /> pl.QtyDone,<br /> pl.QtyShipped,<br /> pl.QtyExtra,<br /> pl.QtyNotAvail,<br /> pl.QtyKilled<br /> FROM<br /> (ord_lines AS ol<br /> LEFT JOIN qryPkgLines_byOrdLine_andItem AS pl ON pl.ID_OrdLine=ol.ID)<br /> LEFT JOIN core_orders AS o ON ol.ID_Order=o.ID;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div> Woozle