src/org/openbravo/erpCommon/ad_reports/ReportRawMaterial_data.xsql
changeset 799 fef2c5e2feb7
parent 423 ecf368072c48
child 1605 8a0fe0193bef
equal deleted inserted replaced
798:4994e5a604bb 799:fef2c5e2feb7
    39         AND pl.M_Product_ID = p.M_Product_ID
    39         AND pl.M_Product_ID = p.M_Product_ID
    40         AND wp.MA_Sequence_ID = sp.MA_Sequence_ID
    40         AND wp.MA_Sequence_ID = sp.MA_Sequence_ID
    41         AND sp.M_Product_ID = wpp.M_Product_ID
    41         AND sp.M_Product_ID = wpp.M_Product_ID
    42         AND pp.M_ProductionPlan_ID = TO_NUMBER(?)
    42         AND pp.M_ProductionPlan_ID = TO_NUMBER(?)
    43         AND pl.Productiontype = '-'
    43         AND pl.Productiontype = '-'
    44         AND sp.DecreaseInd = 'N'
       
    45     ]]></Sql>
    44     ]]></Sql>
    46     <Parameter name="productionplan"/>
    45     <Parameter name="productionplan"/>
    47   </SqlMethod>
    46   </SqlMethod>
    48   <SqlMethod name="set" type="constant" return="multiple">
    47   <SqlMethod name="set" type="constant" return="multiple">
    49     <SqlMethodComment></SqlMethodComment>
    48     <SqlMethodComment></SqlMethodComment>