--- a/src-db/database/model/functions/C_ORDER_POST1.xml	Fri Apr 23 15:50:49 2010 +0530
+++ b/src-db/database/model/functions/C_ORDER_POST1.xml	Fri Apr 23 15:53:55 2010 +0530
@@ -619,6 +619,7 @@
             AND C_DISCOUNT.M_PRODUCT_ID=M_PRODUCT.M_PRODUCT_ID
             AND C_ORDER_DISCOUNT.C_ORDER_ID=v_Record_ID
             AND C_ORDER_DISCOUNT.ISACTIVE='Y'
+            AND C_DISCOUNT.ISACTIVE='Y'
           ORDER BY C_ORDER_DISCOUNT.LINE
           )
         LOOP