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 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 | SELECT FCP.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID, FCP.CONCURRENT_PROGRAM_NAME AS "简称" , FCP.USER_CONCURRENT_PROGRAM_NAME 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 存储过程' , fe.execution_method_code ) as "执行方法" , DFCU.COLUMN_SEQ_NUM AS "参数-序号" , DFCU.APPLICATION_COLUMN_NAME AS "参数-系统列名" , DFCU.END_USER_COLUMN_NAME AS "参数-参数" , DFCU.DESCRIPTION AS "参数-说明" , DFCU.ENABLED_FLAG AS "参数-启用" , DFCU.FLEX_VALUE_SET_ID AS "验证-值集ID" , ( SELECT FVS.FLEX_VALUE_SET_NAME FROM APPS.FND_FLEX_VALUE_SETS FVS WHERE FVS.FLEX_VALUE_SET_ID = DFCU.FLEX_VALUE_SET_ID ) AS "验证-值集名称" , ( SELECT FVS.DESCRIPTION FROM APPS.FND_FLEX_VALUE_SETS FVS WHERE FVS.FLEX_VALUE_SET_ID = DFCU.FLEX_VALUE_SET_ID ) AS "验证-值集说明" , DECODE(DFCU.DEFAULT_TYPE, 'C' , '常数' , 'P' , '配置文件' , 'S' , 'SQL 语句' , 'D' , '当前日期' , 'T' , '当前时间' , DFCU.DEFAULT_TYPE ) AS "验证-默认类型" , DFCU.DEFAULT_VALUE AS "验证-默认值" , DFCU.REQUIRED_FLAG AS "验证-必需" , DFCU.SEGMENT_INSERT_FLAG AS "验证-允许更新" , DFCU.DISPLAY_FLAG AS "显示" , DFCU.FORM_LEFT_PROMPT AS "显示-提示" , DFCU.FORM_ABOVE_PROMPT AS "显示-值列表提示" --DFCU.CREATION_DATE -- ,DFCU.* FROM APPS.FND_CONCURRENT_PROGRAMS_VL FCP, APPS.FND_EXECUTABLES_VL fe , APPS.FND_DESCR_FLEX_COL_USAGE_VL DFCU WHERE 1=1 AND FE.APPLICATION_ID = FCP.APPLICATION_ID AND FE.EXECUTABLE_ID = FCP.EXECUTABLE_ID AND DFCU.APPLICATION_ID = FCP.APPLICATION_ID -- 20003 AND DESCRIPTIVE_FLEXFIELD_NAME LIKE '$SRS$.' || FCP.CONCURRENT_PROGRAM_NAME -- '%CUX2051%' AND FCP.APPLICATION_ID = 20003 -- AND FCP.CONCURRENT_PROGRAM_ID = 148858 -- AND FCP.CONCURRENT_PROGRAM_NAME LIKE '%CUX2051%' -- 'RVCTP' 简称 -- AND FCP.USER_CONCURRENT_PROGRAM_NAME LIKE 'CUX订单直发' ORDER BY FCP.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_NAME, DFCU.COLUMN_SEQ_NUM |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了