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  
    
     

  

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