projects
/
xtuple
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
b31ce4c
)
Issue #23166: Inventory Availability by Work Order issue with irrelevant orders being...
author
Greg Pazo
<gpazo@xtuple.com>
Tue, 15 Apr 2014 17:23:42 +0000
(13:23 -0400)
committer
Greg Pazo
<gpazo@xtuple.com>
Tue, 15 Apr 2014 17:23:42 +0000
(13:23 -0400)
foundation-database/public/functions/woinvavail.sql
patch
|
blob
|
history
diff --git
a/foundation-database/public/functions/woinvavail.sql
b/foundation-database/public/functions/woinvavail.sql
index
4e83408
..
b62f972
100644
(file)
--- a/
foundation-database/public/functions/woinvavail.sql
+++ b/
foundation-database/public/functions/woinvavail.sql
@@
-208,7
+208,7
@@
BEGIN
qtyOrdered(itemsite_id, wo_duedate) AS ordered,
CASE WHEN(itemsite_useparams) THEN itemsite_reorderlevel ELSE 0.0 END AS reorderlevel
FROM wo, itemsite, item, uom
- WHERE ((wo_ordid = pwoid)
+ WHERE ((wo_ordid = pwoid
AND wo_ordtype = 'W'
)
AND NOT (wo_status = 'C')
AND (itemsite_id = wo_itemsite_id)
AND (itemsite_item_id=item_id)
@@
-247,3
+247,4
@@
BEGIN
END;
$$ LANGUAGE 'plpgsql';
+