src/org/openbravo/erpReports/RptMA_ProcessPlan_data.xsql
changeset 799 fef2c5e2feb7
parent 0 0247c26f10c6
child 6701 690d2af86089
--- a/src/org/openbravo/erpReports/RptMA_ProcessPlan_data.xsql	Wed Apr 30 10:48:47 2008 +0000
+++ b/src/org/openbravo/erpReports/RptMA_ProcessPlan_data.xsql	Mon May 05 06:59:24 2008 +0000
@@ -32,7 +32,6 @@
               s.SEQNO, AD_MESSAGE_GET2(s.GROUPUSE, to_char(?)) as groupuse, AD_MESSAGE_GET2(s.NOQTY, to_char(?)) as vacio,
               p.name as producto, sp.PRODUCTIONTYPE as tipo, AD_MESSAGE_GET2(sp.PRODUCTIONTYPE, to_char(?)) as bold,
               sp.QUANTITY, c.UOMSYMBOL as ud, sp.COMPONENTCOST, sp.DECREASE, sp.REJECTED,
-              AD_MESSAGE_GET2(sp.CONSUMERM, to_char(?)) as consumerm, AD_MESSAGE_GET2(sp.DECREASEIND, to_char(?)) as decreaseind, 
               pp.MA_ProcessPlan_ID, s.MA_Sequence_ID, AD_MESSAGE_GET2(pp.EXPLODEPHASES, to_char(?)) as explodephases
           FROM MA_Processplan pp, MA_processplan_version v, ma_sequence s, ma_sequenceproduct sp, 
               m_product p, ma_process pr, C_UOM c
@@ -52,8 +51,6 @@
       <Parameter name="language"/>
       <Parameter name="language"/>
       <Parameter name="language"/>
-      <Parameter name="language"/>
-      <Parameter name="language"/>
       <Parameter name="maProcessPlanId" optional="true" type="argument" after="and 1=1">
         <![CDATA[ and pp.ma_processplan_id IN ]]>
       </Parameter>