EBS:并发程序查询

EBS并发程序查询

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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

  

保留,以作记录。

posted @   samrv  阅读(91)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
点击右上角即可分享
微信分享提示