src/org/openbravo/erpCommon/modules/ApplyModule_data.xsql
changeset 15522 459c8c6700f5
parent 13016 4f22d41ef45d
equal deleted inserted replaced
15521:eb48f353d1d3 15522:459c8c6700f5
    29                            ON L.AD_LANGUAGE = M.AD_LANGUAGE
    29                            ON L.AD_LANGUAGE = M.AD_LANGUAGE
    30        WHERE (STATUS = 'I' OR STATUS = 'P')
    30        WHERE (STATUS = 'I' OR STATUS = 'P')
    31          AND ISTRANSLATIONMODULE = 'Y'
    31          AND ISTRANSLATIONMODULE = 'Y'
    32     ]]></Sql>
    32     ]]></Sql>
    33   </SqlMethod>
    33   </SqlMethod>
       
    34   <SqlMethod name="selectAllTranslationModules" type="preparedStatement" return="multiple">
       
    35     <SqlMethodComment></SqlMethodComment>
       
    36     <Sql>
       
    37     <![CDATA[
       
    38       SELECT M.JAVAPACKAGE, M.NAME, M.AD_LANGUAGE, L.ISSYSTEMLANGUAGE, '' as DS_NAME, '' AS AD_MODULE_ID
       
    39         FROM AD_MODULE M LEFT JOIN AD_LANGUAGE L
       
    40                            ON L.AD_LANGUAGE = M.AD_LANGUAGE
       
    41        WHERE ISTRANSLATIONMODULE = 'Y'
       
    42     ]]></Sql>
       
    43   </SqlMethod>
    34   
    44   
    35   <SqlMethod name="selectClientReferenceModules" type="preparedStatement" return="multiple">
    45   <SqlMethod name="selectClientReferenceModules" type="preparedStatement" return="multiple">
    36     <SqlMethodComment></SqlMethodComment>
    46     <SqlMethodComment></SqlMethodComment>
    37     <Sql>
    47     <Sql>
    38     <![CDATA[
    48     <![CDATA[
    39       SELECT M.JAVAPACKAGE, M.NAME, M.AD_MODULE_ID, D.NAME as DS_NAME
    49       SELECT M.JAVAPACKAGE, M.NAME, M.AD_MODULE_ID, D.NAME as DS_NAME
    40         FROM AD_MODULE M, AD_DATASET D
    50         FROM AD_MODULE M, AD_DATASET D
    41        WHERE (M.STATUS = 'I' OR M.STATUS = 'P')
    51        WHERE (M.STATUS = 'I' OR M.STATUS = 'P')
    42          AND M.HASREFERENCEDATA = 'Y'
    52          AND M.HASREFERENCEDATA = 'Y'
       
    53          AND D.AD_MODULE_ID = M.AD_MODULE_ID
       
    54          AND D.ACCESSLEVEL = '4'
       
    55     ]]></Sql>
       
    56   </SqlMethod>
       
    57   
       
    58   <SqlMethod name="selectAllClientReferenceModules" type="preparedStatement" return="multiple">
       
    59     <SqlMethodComment></SqlMethodComment>
       
    60     <Sql>
       
    61     <![CDATA[
       
    62       SELECT M.JAVAPACKAGE, M.NAME, M.AD_MODULE_ID, D.NAME as DS_NAME
       
    63         FROM AD_MODULE M, AD_DATASET D
       
    64        WHERE M.HASREFERENCEDATA = 'Y'
    43          AND D.AD_MODULE_ID = M.AD_MODULE_ID
    65          AND D.AD_MODULE_ID = M.AD_MODULE_ID
    44          AND D.ACCESSLEVEL = '4'
    66          AND D.ACCESSLEVEL = '4'
    45     ]]></Sql>
    67     ]]></Sql>
    46   </SqlMethod>
    68   </SqlMethod>
    47   
    69