src/org/openbravo/erpCommon/ad_process/AssetDelivery_data.xsql
changeset 799 fef2c5e2feb7
parent 423 ecf368072c48
child 1605 8a0fe0193bef
--- a/src/org/openbravo/erpCommon/ad_process/AssetDelivery_data.xsql	Wed Apr 30 10:48:47 2008 +0000
+++ b/src/org/openbravo/erpCommon/ad_process/AssetDelivery_data.xsql	Mon May 05 06:59:24 2008 +0000
@@ -93,28 +93,6 @@
     </Sql>
     <Parameter name="adClientId"/>
   </SqlMethod>
-  <SqlMethod name="documentDir" type="preparedStatement" return="String">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-      SELECT DOCUMENTDIR FROM AD_CLIENT
-      WHERE AD_CLIENT_ID = TO_NUMBER(?)
-      ]]>
-    </Sql>
-    <Parameter name="AdClientId"/>
-  </SqlMethod>
-  <SqlMethod name="selectProductRMailTextID" type="preparedStatement" return="String">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-      SELECT P.R_MAILTEXT_ID 
-      FROM M_PRODUCT P, A_ASSET A
-      WHERE P.M_PRODUCT_ID = A.M_PRODUCT_ID
-      AND A. A_ASSET_ID = TO_NUMBER(?)
-      ]]>
-    </Sql>
-    <Parameter name="aAssetId"/>
-  </SqlMethod>
   <SqlMethod name="selectAssetHelp" type="preparedStatement" return="String">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
@@ -161,7 +139,7 @@
     <SqlMethodComment></SqlMethodComment>
     <Sql>
       <![CDATA[
-      SELECT P.DOWNLOADURL, P.VERSIONNO, P.R_MAILTEXT_ID, P.M_PRODUCT_ID
+      SELECT P.DOWNLOADURL, P.VERSIONNO, P.M_PRODUCT_ID
       FROM M_PRODUCT P, A_ASSET A
       WHERE P.M_PRODUCT_ID = A.M_PRODUCT_ID
       AND A.A_ASSET_ID = TO_NUMBER(?)