issue 021199: Module script DeleteInventoryLines is incomplete.
authorJavier Etxarri <javier.echarri@openbravo.com>
Wed, 25 Jul 2012 12:40:51 +0200
changeset 17898 90d2a49c5544
parent 17897 9af9c20db94b
child 17899 827ee476b859
issue 021199: Module script DeleteInventoryLines is incomplete.
The character ; is not necessary and create a fail in oracle
src-util/modulescript/build/classes/org/openbravo/modulescript/DeleteInventoryLinesData.class
src-util/modulescript/src/org/openbravo/modulescript/DeleteInventoryLines_data.xsql
Binary file src-util/modulescript/build/classes/org/openbravo/modulescript/DeleteInventoryLinesData.class has changed
--- a/src-util/modulescript/src/org/openbravo/modulescript/DeleteInventoryLines_data.xsql	Wed Jul 25 12:27:17 2012 +0200
+++ b/src-util/modulescript/src/org/openbravo/modulescript/DeleteInventoryLines_data.xsql	Wed Jul 25 12:40:51 2012 +0200
@@ -42,7 +42,7 @@
 	        AND PREQTYONHAND = 0 
 	        AND (QTYORDERONHAND=0 OR QTYORDERONHAND IS NULL)
 	        AND (PREQTYORDERONHAND=0 OR PREQTYORDERONHAND IS NULL)
-	        AND NOT EXISTS (SELECT 1 FROM m_stock_aux SA WHERE SA.M_STORAGE_DETAIL_ID = MS.M_STORAGE_DETAIL_ID));
+	        AND NOT EXISTS (SELECT 1 FROM m_stock_aux SA WHERE SA.M_STORAGE_DETAIL_ID = MS.M_STORAGE_DETAIL_ID))
       ]]>
     </Sql>
   </SqlMethod>
@@ -63,7 +63,7 @@
 	        AND (QTYORDERONHAND=0 OR QTYORDERONHAND IS NULL)
 	        AND (PREQTYORDERONHAND=0 OR PREQTYORDERONHAND IS NULL))
 	        AND COALESCE(quantity, 0) = 0
-			AND COALESCE(qtyorder, 0) = 0;
+			AND COALESCE(qtyorder, 0) = 0
       ]]>
     </Sql>
   </SqlMethod>