From ce9359de6a277928ced2e434a0acb140db630e02 Mon Sep 17 00:00:00 2001 From: Greg Pazo Date: Tue, 15 Apr 2014 13:23:42 -0400 Subject: [PATCH] Issue #23166: Inventory Availability by Work Order issue with irrelevant orders being displayed --- foundation-database/public/functions/woinvavail.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/foundation-database/public/functions/woinvavail.sql b/foundation-database/public/functions/woinvavail.sql index 4e8340894..b62f972fa 100644 --- 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'; + -- 2.39.2