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 |
保留,以作记录。
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了