src/org/openbravo/erpCommon/ad_callouts/SE_Pricelist_Active_data.xsql
author RM packaging bot <staff.rm@openbravo.com>
Tue, 28 Jun 2011 10:33:23 +0000
changeset 9542 845811ab032b
parent 9072 79e55dfc8af0
permissions -rw-r--r--
Update AD_MODULE version to 2.50MP31
victor@1818
     1
<?xml version="1.0" encoding="UTF-8"?>
victor@1818
     2
<!--
victor@1818
     3
 *************************************************************************
victor@1818
     4
 * The contents of this file are subject to the Openbravo  Public  License
priya@9072
     5
 * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
victor@1818
     6
 * Version 1.1  with a permitted attribution clause; you may not  use this
victor@1818
     7
 * file except in compliance with the License. You  may  obtain  a copy of
victor@1818
     8
 * the License at http://www.openbravo.com/legal/license.html 
victor@1818
     9
 * Software distributed under the License  is  distributed  on  an "AS IS"
victor@1818
    10
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
victor@1818
    11
 * License for the specific  language  governing  rights  and  limitations
victor@1818
    12
 * under the License. 
victor@1818
    13
 * The Original Code is Openbravo ERP. 
ggi@6701
    14
 * The Initial Developer of the Original Code is Openbravo SLU 
ggi@6701
    15
 * All portions are Copyright (C) 2008 Openbravo SLU 
victor@1818
    16
 * All Rights Reserved. 
victor@1818
    17
 * Contributor(s):  ______________________________________.
victor@1818
    18
 ************************************************************************
victor@1818
    19
-->
victor@1818
    20
victor@1818
    21
victor@1818
    22
<SqlClass name="SEPricelistActiveData" package="org.openbravo.erpCommon.ad_callouts">
victor@1818
    23
 <SqlMethod name="getActivePricelistVersion" type="preparedStatement" return="multiple">
victor@1818
    24
    <SqlMethodComment></SqlMethodComment>
victor@1818
    25
    <Sql>
victor@1818
    26
      <![CDATA[
victor@1818
    27
        SELECT V.M_PRICELIST_ID AS PricelistVersion
victor@1818
    28
		FROM M_PRICELIST P, M_PRICELIST_VERSION V
victor@1818
    29
		WHERE P.M_PRICELIST_ID = V.M_PRICELIST_ID
victor@1818
    30
		AND V.ISACTIVE = 'Y'
victor@1818
    31
		AND P.M_PRICELIST_ID = ?
victor@1818
    32
      ]]>
victor@1818
    33
    </Sql>
victor@1818
    34
    <Parameter name="MPricelistId"/>
victor@1818
    35
  </SqlMethod>
victor@1818
    36
victor@1818
    37
</SqlClass>