1 -- Group: unbalancedQOHByClassCode
3 -- Notes: used by dspUnbalancedQOHByClassCode
4 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
5 -- See www.xtuple.com/CPAL for the full text of the software license.
7 SELECT itemsite_id, warehous_code, item_number,
8 (item_descrip1 || ' ' || item_descrip2) AS itemdescrip, uom_name,
10 detailedQOH(itemsite_id, FALSE) AS detailedqoh,
12 detailedNNQOH(itemsite_id, FALSE) AS detailednnqoh,
13 'qty' AS itemsite_qtyonhand_xtnumericrole,
14 'qty' AS detailedqoh_xtnumericrole,
15 'qty' AS itemsite_nnqoh_xtnumericrole,
16 'qty' AS detailednnqoh_xtnumericrole
17 FROM whsinfo, item, itemsite, uom
18 WHERE ( (itemsite_item_id=item_id)
19 AND (item_inv_uom_id=uom_id)
20 AND (itemsite_warehous_id=warehous_id)
21 AND ((itemsite_loccntrl) OR (itemsite_controlmethod IN ('L', 'S')))
22 AND ((itemsite_qtyonhand <> detailedQOH(itemsite_id, FALSE))
23 OR (itemsite_nnqoh <> detailedNNQOH(itemsite_id, FALSE)))
24 <? if exists("classcode_id") ?>
25 AND (item_classcode_id=<? value("classcode_id") ?>)
26 <? elseif exists("classcode_pattern") ?>
27 AND (item_classcode_id IN (SELECT classcode_id
29 WHERE (classcode_code ~ <? value("classcode_pattern") ?>)))
31 <? if exists("warehous_id") ?>
32 AND (warehous_id=<? value("warehous_id") ?>)