EBS:并发程序查询

EBS并发程序查询

SELECT FCP.APPLICATION_ID,
       FCP.CONCURRENT_PROGRAM_ID,
       FCP.CONCURRENT_PROGRAM_NAME AS "简称",
       FCP.USER_CONCURRENT_PROGRAM_NAME AS "程序",
       FCP.ENABLED_FLAG AS "启用",
       FCP.DESCRIPTION AS "并发程序-说明",
       FCP.OUTPUT_FILE_TYPE AS "输出-格式",
      -- FCP.EXECUTABLE_ID,
       (SELECT  FE.EXECUTABLE_NAME  FROM APPS.FND_EXECUTABLES_VL fe 
       WHERE FE.APPLICATION_ID = FCP.APPLICATION_ID
        AND FE.EXECUTABLE_ID = FCP.EXECUTABLE_ID
        and rownum =1  
        ) AS "可执行名称", 
       (SELECT  FE.EXECUTION_FILE_NAME  FROM APPS.FND_EXECUTABLES_VL fe 
       WHERE FE.APPLICATION_ID = FCP.APPLICATION_ID
        AND FE.EXECUTABLE_ID = FCP.EXECUTABLE_ID
        and rownum =1 
        ) AS "可执行程序文件",
       decode(fe.execution_method_code,'P',
              'Oracle Reports',
              'I',
              'PL/SQL 存储过程',
              'L','SQL*Loader 程序',
              'H','主机',
              'E','Perl 并发程序',
              'Q','SQL*Plus',
              'A','派生',
              'B','请求集阶段函数',
              'M','多语言功能',
              'K','Java 并发程序',
              'J','Java 存储过程',
              'S','立即',
              fe.execution_method_code 
       ) as "执行方法",
       FE.CREATION_DATE AS "创建日期"
     --   ,FCP.*  
  FROM APPS.FND_CONCURRENT_PROGRAMS_VL FCP,
       APPS.FND_EXECUTABLES_VL fe 
 WHERE 1=1
   AND  FE.APPLICATION_ID = FCP.APPLICATION_ID
   AND FE.EXECUTABLE_ID = FCP.EXECUTABLE_ID
   AND FCP.APPLICATION_ID = 20003