-- Group: summarizedBacklogByWarehouse
-- Name: qtys
-- Notes: 
-- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
-- See www.xtuple.com/CPAL for the full text of the software license.

SELECT formatQty(COALESCE(SUM(coitem_qtyord - coitem_qtyshipped + coitem_qtyreturned), 0)) AS f_totalqty 
         FROM cohead, coitem, itemsite, item, custinfo
		     WHERE ( (coitem_cohead_id=cohead_id)
		      AND (coitem_itemsite_id=itemsite_id)
		      AND (itemsite_item_id=item_id)
		      AND (cohead_cust_id=cust_id)
		      AND (coitem_status NOT IN ('C','X'))
		      AND (coitem_scheddate BETWEEN <? value("startDate") ?>
		                                AND <? value("endDate") ?>)
		     <? if exists("warehous_id") ?>
		      AND (itemsite_warehous_id=<? value("warehous_id") ?>)
		     <? endif ?>
		     <? if exists("custtype_id") ?>
		      AND (cust_custtype_id=<? value("custtype_id") ?>)
		     <? elseif exists("custtype_pattern") ?>
		      AND (cust_custtype_id IN (SELECT custtype_id FROM custtype
		       WHERE (custtype_code ~ <? value("custtype_pattern") ?>)))
		     <? endif ?>
		     );