1 CREATE OR REPLACE FUNCTION itemInventoryUOMInUse(INTEGER) RETURNS BOOLEAN AS '
2 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
3 -- See www.xtuple.com/CPAL for the full text of the software license.
9 SELECT item_inv_uom_id INTO _uomid
11 WHERE(item_id=pItemid);
13 SELECT itemuomconv_id INTO _result
15 WHERE(itemuomconv_item_id=pItemid)
21 SELECT itemsite_id INTO _result
22 FROM itemsite WHERE ( (itemsite_item_id=pItemid)
23 AND ((itemsite_qtyonhand <> 0) OR (itemsite_nnqoh <> 0)) )