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