Issue #23166: Inventory Availability by Work Order issue with irrelevant orders being...

[xtuple] / foundation-database / public / functions / woinvavail.sql

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';
 
+