EBS:并发程序参数查询

EBS:并发程序参数查询

 

-- FND-并发程序参数查询.sql 

select FA.APPLICATION_SHORT_NAME AS APP_NAME,
      -- FA.APPLICATION_NAME, 
       FCP.USER_CONCURRENT_PROGRAM_NAME,  -- 程序
       FCP.CONCURRENT_PROGRAM_NAME,       -- 简称
       DFCU.COLUMN_SEQ_NUM,               -- 序号
       DFCU.END_USER_COLUMN_NAME,         -- 参数
       DFCU.DESCRIPTION AS PARAMETER_DESCRIPTION, -- 参数说明
       ffvs.flex_value_set_name,                  -- 值集
       ffvs.description as flex_set_description,  -- 值集说明
       DFCU.DISPLAY_SIZE,        -- 显示大小
       decode(DFCU.DEFAULT_TYPE,'C','常数','D','当前日期',
        'S','SQL 语句','P','配置文件',
        'T','当前时间','A','段', DFCU.DEFAULT_TYPE
         ) AS DEFAULT_TYPE,        -- 默认类型
       DFCU.DEFAULT_VALUE,         -- 默认值
       DFCU.FORM_LEFT_PROMPT,      -- 提示
       DFCU.FORM_ABOVE_PROMPT,       
       DFCU.LAST_UPDATE_DATE
  from FND_APPLICATION_VL FA,             -- 应用程序 
       FND_CONCURRENT_PROGRAMS_VL  FCP,   -- 并发程序
       FND_DESCR_FLEX_COL_USAGE_VL  dfcu, -- 并发程序参数
       FND_FLEX_VALUE_SETS ffvs           -- 值集
 where FA.APPLICATION_ID = FCP.APPLICATION_ID
   AND DFCU.DESCRIPTIVE_FLEXFIELD_NAME(+) = '$SRS$.'|| FCP.CONCURRENT_PROGRAM_NAME 
-- AND DFCU.DESCRIPTIVE_FLEXFIELD_NAME LIKE '$SRS$.CUXSALESCOSTREV%'
   and dfcu.FLEX_VALUE_SET_ID = ffvs.flex_value_set_id(+)
   AND FCP.CONCURRENT_PROGRAM_NAME LIKE 'CUX%'
 --  AND DFCU.DEFAULT_TYPE NOT IN ('A','C','P','S','D','T')
--   AND DFCU.FLEX_VALUE_SET_ID 
--  AND END_USER_COLUMN_NAME LIKE 'p_cost_type'
order by FCP.CONCURRENT_PROGRAM_NAME ,dfcu.COLUMN_SEQ_NUM