查询请求SQL

-- 查询请求定义

SELECT fcpt.user_concurrent_program_name,
       decode(fe.execution_method_code,
              'H',
              '主机',
              'S',
              '立即',
              'J',
              'Java 存储过程',
              'K',
              'Java 并发程序',
              'M',
              '多语言功能',
              'P',
              'Oracle Reports',
              'I',
              'PL/SQL 存储过程',
              'B',
              '请求集阶段函数',
              'A',
              '派生',
              'L',
              'SQL*Loader 程序',
              'Q',
              'SQL*Plus',
              'E',
              'Perl 并发程序',
              'Others') execution_method_name,
       fe.execution_file_name,
       fat.description program_application,
       fcp.concurrent_program_name,
       fet.user_executable_name,
       fe.executable_name,
       fat1.description executable_application
  FROM fnd_concurrent_programs    fcp,
       fnd_concurrent_programs_tl fcpt,
       fnd_application            fa,
       fnd_application_tl         fat,
       fnd_executables            fe,
       fnd_executables_tl         fet,
       fnd_application            fa1,
       fnd_application_tl         fat1
 WHERE fcp.concurrent_program_id = fcpt.concurrent_program_id
   AND fcpt.language = userenv('lang')
   AND fcp.application_id = fa.application_id
   AND fa.application_id = fat.application_id
   AND fat.language = userenv('lang')
   AND fcp.executable_id = fe.executable_id
   AND fe.executable_id = fet.executable_id
   AND fet.language = userenv('lang')
   AND fe.application_id = fa1.application_id
   AND fa1.application_id = fat1.application_id
   AND fat1.language = userenv('lang')
      ------------------- 查询条件 ---------------------
   AND fcpt.user_concurrent_program_name = 'SOHU_账龄报告_AR'
      -- AND fcpt.user_concurrent_program_name like '%SOHU_账龄报告_AR%'
      -- and fcp.concurrent_program_name = 'CUX_PKG'
      ------------------- 查询条件 ---------------------
   AND 1 = 1;

来自为知笔记(Wiz)