EBS:并发程序参数查询

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