1 -- Group: reorderExceptionsByPlannerCode
3 -- Notes: used by dspReorderExceptionsByPlannerCode
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, itemtype, warehous_code, item_number,
8 (item_descrip1 || ' ' || item_descrip2) AS itemdescrip,
9 reorderdate, reorderlevel,
10 (qtyNetable(itemsite_id) - qtyAllocated(itemsite_id, reorderdate) +
11 qtyOrdered(itemsite_id, reorderdate)) AS projavail,
12 'qty' AS reorderlevel_xtnumericrole,
13 'qty' AS projavail_xtnumericrole
14 FROM (SELECT itemsite_id,
15 CASE WHEN (item_type IN ('M', 'B', 'T')) THEN 1
16 WHEN (item_type IN ('P', 'O')) THEN 2
19 warehous_code, item_number, item_descrip1,
21 reorderDate(itemsite_id,
22 <? value("lookAheadDays") ?>,
23 <? value("includePlannedOrders") ?>)
26 FROM (SELECT itemsite_id, itemsite_item_id,
28 CASE WHEN(itemsite_useparams) THEN itemsite_reorderlevel
33 <? if exists("warehous_id") ?>
34 AND (itemsite_warehous_id=<? value("warehous_id") ?>)
36 <? if exists("plancode_id") ?>
37 AND (itemsite_plancode_id=<? value("plancode_id") ?>)
38 <? elseif exists("plancode_pattern") ?>
39 AND (itemsite_plancode_id IN (SELECT plancode_id
41 WHERE (plancode_code ~ <? value("plancode_pattern") ?>)))
44 ) AS itemsitedata, item, whsinfo
45 WHERE ((itemsite_item_id=item_id)
46 AND (itemsite_warehous_id=warehous_id))
48 WHERE (reorderdate IS NOT NULL)
49 ORDER BY reorderdate, item_number;