src/org/openbravo/erpReports/RptMA_ProcessPlan_data.xsql
changeset 799 fef2c5e2feb7
parent 0 0247c26f10c6
child 6701 690d2af86089
equal deleted inserted replaced
798:4994e5a604bb 799:fef2c5e2feb7
    30           SELECT pp.NAME as processplan, pp.CONVERSIONRATE as ratio, pp.SECONDARYUNIT as secud, v.DATEFROM as desde, 
    30           SELECT pp.NAME as processplan, pp.CONVERSIONRATE as ratio, pp.SECONDARYUNIT as secud, v.DATEFROM as desde, 
    31               v.DATETO as hasta, s.NAME as secuencia, s.VALUE as sec, s.DESCRIPTION, pr.NAME as proceso,
    31               v.DATETO as hasta, s.NAME as secuencia, s.VALUE as sec, s.DESCRIPTION, pr.NAME as proceso,
    32               s.SEQNO, AD_MESSAGE_GET2(s.GROUPUSE, to_char(?)) as groupuse, AD_MESSAGE_GET2(s.NOQTY, to_char(?)) as vacio,
    32               s.SEQNO, AD_MESSAGE_GET2(s.GROUPUSE, to_char(?)) as groupuse, AD_MESSAGE_GET2(s.NOQTY, to_char(?)) as vacio,
    33               p.name as producto, sp.PRODUCTIONTYPE as tipo, AD_MESSAGE_GET2(sp.PRODUCTIONTYPE, to_char(?)) as bold,
    33               p.name as producto, sp.PRODUCTIONTYPE as tipo, AD_MESSAGE_GET2(sp.PRODUCTIONTYPE, to_char(?)) as bold,
    34               sp.QUANTITY, c.UOMSYMBOL as ud, sp.COMPONENTCOST, sp.DECREASE, sp.REJECTED,
    34               sp.QUANTITY, c.UOMSYMBOL as ud, sp.COMPONENTCOST, sp.DECREASE, sp.REJECTED,
    35               AD_MESSAGE_GET2(sp.CONSUMERM, to_char(?)) as consumerm, AD_MESSAGE_GET2(sp.DECREASEIND, to_char(?)) as decreaseind, 
       
    36               pp.MA_ProcessPlan_ID, s.MA_Sequence_ID, AD_MESSAGE_GET2(pp.EXPLODEPHASES, to_char(?)) as explodephases
    35               pp.MA_ProcessPlan_ID, s.MA_Sequence_ID, AD_MESSAGE_GET2(pp.EXPLODEPHASES, to_char(?)) as explodephases
    37           FROM MA_Processplan pp, MA_processplan_version v, ma_sequence s, ma_sequenceproduct sp, 
    36           FROM MA_Processplan pp, MA_processplan_version v, ma_sequence s, ma_sequenceproduct sp, 
    38               m_product p, ma_process pr, C_UOM c
    37               m_product p, ma_process pr, C_UOM c
    39           where pp.MA_PROCESSPLAN_ID = v.MA_PROCESSPLAN_ID
    38           where pp.MA_PROCESSPLAN_ID = v.MA_PROCESSPLAN_ID
    40             and v.MA_PROCESSPLAN_VERSION_ID = s.MA_PROCESSPLAN_VERSION_ID
    39             and v.MA_PROCESSPLAN_VERSION_ID = s.MA_PROCESSPLAN_VERSION_ID
    50       </Sql>
    49       </Sql>
    51       <Parameter name="language"/>
    50       <Parameter name="language"/>
    52       <Parameter name="language"/>
    51       <Parameter name="language"/>
    53       <Parameter name="language"/>
    52       <Parameter name="language"/>
    54       <Parameter name="language"/>
    53       <Parameter name="language"/>
    55       <Parameter name="language"/>
       
    56       <Parameter name="language"/>
       
    57       <Parameter name="maProcessPlanId" optional="true" type="argument" after="and 1=1">
    54       <Parameter name="maProcessPlanId" optional="true" type="argument" after="and 1=1">
    58         <![CDATA[ and pp.ma_processplan_id IN ]]>
    55         <![CDATA[ and pp.ma_processplan_id IN ]]>
    59       </Parameter>
    56       </Parameter>
    60    </SqlMethod>
    57    </SqlMethod>
    61    <SqlMethod name="set" type="constant" return="multiple">
    58    <SqlMethod name="set" type="constant" return="multiple">