src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
changeset 3052 dc3cf1513510
parent 3049 b4f024448c42
child 3057 ace8bf1d5ef9
equal deleted inserted replaced
3051:262a3c3564b8 3052:dc3cf1513510
   305        SELECT AD_Client_ID as Node_ID, AD_Tree_ID AS ID, NAME, 2 AS SEQNO
   305        SELECT AD_Client_ID as Node_ID, AD_Tree_ID AS ID, NAME, 2 AS SEQNO
   306         FROM AD_Tree 
   306         FROM AD_Tree 
   307         WHERE AD_Client_ID IN ('2') 
   307         WHERE AD_Client_ID IN ('2') 
   308         AND AD_Client_id = '0'
   308         AND AD_Client_id = '0'
   309         AND TreeType = ?
   309         AND TreeType = ?
   310         AND IsActive = 'Y') 
   310         AND IsActive = 'Y') f
   311         ORDER BY SEQNO
   311         ORDER BY SEQNO
   312       </Sql>
   312       </Sql>
   313         <Parameter name="adClientId" optional="true" type="replace" after="AD_Client_ID IN (" text="'1'"/>
   313         <Parameter name="adClientId" optional="true" type="replace" after="AD_Client_ID IN (" text="'1'"/>
   314         <Parameter name="treetype"/>
   314         <Parameter name="treetype"/>
   315         <Parameter name="adClientId" optional="true" type="replace" after="AD_Client_id IN (" text="'2'"/>
   315         <Parameter name="adClientId" optional="true" type="replace" after="AD_Client_id IN (" text="'2'"/>