看到个有趣的方法批量下载rtf模板

时间：2023-03-08 15:45:01

一般想要批量下载rtf模板我们都是用fndload来实现或者 perl download.pl来实现，今天看到一个比较有趣的方法

Hi,



Blob column 'template file data' below is just what you want, open it in PLSQL-DEVELOPER and save it as a rtf file or you can write programs that work with 'BLOB' objects to export them. 
select fa.application_name concurrent_program_appl_name

      ,fcp.user_concurrent_program_name

      ,fcp.concurrent_program_name

      ,(select decode(fe.execution_method_code

                     ,'K'

                     ,fl.meaning

                     ,'P'

                     ,fl.meaning || ' : ' || '$' || fa.basepath ||

                      '/reports/US/' || fe.execution_file_name || '.rdf')

          from fnd_application fa

         where fa.application_id = fe.application_id) execution_method

      ,xdd.data_source_name

      ,xdd.data_source_code

      ,xl_xdd.file_name     data_source_file_name

      ,xl_xdd.file_data     data_source_file_data

      ,xt.template_name

      ,xt.template_code

      ,xl_xt.file_name  template_file_name

      ,xl_xt.file_data  template_file_data

  from fnd_concurrent_programs_vl fcp

      ,fnd_application_vl         fa

      ,fnd_executables_vl         fe

      ,fnd_lookups                fl

      ,fnd_application       fa2

      ,xdo_ds_definitions_vl xdd

      ,xdo.xdo_lobs          xl_xdd

      ,xdo_templates_vl xt

      ,xdo.xdo_lobs     xl_xt

where fcp.application_id = fa.application_id

   and fcp.executable_application_id = fe.application_id

   and fcp.executable_id = fe.executable_id

   and fe.execution_method_code = fl.lookup_code

   and fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'

   and fcp.output_file_type = 'XML'

   and fcp.application_id = fa2.application_id

   and fa.application_short_name = xdd.application_short_name

   and fcp.concurrent_program_name = xdd.data_source_code

   and xdd.application_short_name = xl_xdd.application_short_name(+)

   and xdd.data_source_code = xl_xdd.lob_code(+)

   and trunc(sysdate) between trunc(nvl(xdd.start_date

                                       ,sysdate)) and

       trunc(nvl(xdd.end_date

                ,sysdate))

   and xl_xdd.xdo_file_type(+) = 'XML-DATA-TEMPLATE'

   and xdd.application_short_name = xt.ds_app_short_name

   and xdd.data_source_code = xt.data_source_code

   and xt.application_short_name = xl_xt.application_short_name(+)

   and xt.template_code = xl_xt.lob_code(+)

   and trunc(sysdate) between trunc(nvl(xt.start_date

                                       ,sysdate)) and

       trunc(nvl(xt.end_date

                ,sysdate))

   and xl_xt.xdo_file_type(+) = 'RTF'

   and fcp.concurrent_program_name = 'XLAAARPT' --Concurrent Program Name

order by fcp.user_concurrent_program_name

         ,xdd.data_source_name

         ,xt.template_name;

或者

写个SQL，批量生成下面的语句，执行就可以自动在指定的路径下生成了。

本帖最后由 yxplove 于 2014-8-11 09:14 编辑

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \

-DB_USERNAME apps \

-DB_PASSWORD xxxxxx \

-JDBC_CONNECTION 192.168.66.xxx:1523:TEST \

-LOB_TYPE TEMPLATE_SOURCE \

-APPS_SHORT_NAME CUX \

-LOB_CODE CUXxxxx \

-LANGUAGE zh \

-XDO_FILE_TYPE RTF \

-FILES_DIR /home/appltest/patch_rtf/xxxx.rtf;

相关文章