From 3fd49043058548aad755194723f70d3d5ded4782 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Tue, 19 Jan 2010 00:27:04 +0000 Subject: [PATCH] Rerun --- includes/db/manufacturing_db.inc | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/includes/db/manufacturing_db.inc b/includes/db/manufacturing_db.inc index ca1841d..e3f494f 100644 --- a/includes/db/manufacturing_db.inc +++ b/includes/db/manufacturing_db.inc @@ -102,7 +102,9 @@ function get_demand_asm_qty($stock_id, $location) FROM ".TB_PREF."sales_order_details, ".TB_PREF."sales_orders, ".TB_PREF."stock_master - WHERE ".TB_PREF."sales_orders.order_no = ".TB_PREF."sales_order_details.order_no AND "; + WHERE ".TB_PREF."sales_orders.order_no = ".TB_PREF."sales_order_details.order_no AND + ".TB_PREF."sales_orders.trans_type=".ST_SALESORDER." AND + ".TB_PREF."sales_orders.trans_type=".TB_PREF."sales_order_details.trans_type AND "; if ($location != "") $sql .= TB_PREF."sales_orders.from_stk_loc =".db_escape($location)." AND "; $sql .= TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_sent > 0 AND -- 2.30.2