标签归档:并发

EBS并发程序相关SQL

–所有客户化并发程序
SELECT FC.USER_CONCURRENT_PROGRAM_NAME,
       FC.DESCRIPTION,
       FC.CONCURRENT_PROGRAM_NAME,
       UPPER(FE.EXECUTION_FILE_NAME)
  FROM FND_CONCURRENT_PROGRAMS_VL FC,
       FND_EXECUTABLES_FORM_V     FE,
       FND_APPLICATION            FA
 WHERE 1 = 1
   AND FA.APPLICATION_ID = FC.APPLICATION_ID
   AND FA.APPLICATION_SHORT_NAME = 'CUX'
   AND FC.CONCURRENT_PROGRAM_NAME = FE.EXECUTABLE_NAME
   AND FC.ENABLED_FLAG = 'Y'
 ORDER BY FC.CREATION_DATE DESC;

–并发程序对应参数
SELECT FV.COLUMN_SEQ_NUM                序号,
       FV.END_USER_COLUMN_NAME          参数,
       FV.DESCRIPTIVE_FLEXFIELD_NAME    可执行程序,
       FV.ENABLED_FLAG                  是否启用,
       FV.DISPLAY_FLAG                  显示,
       FFVS.FLEX_VALUE_SET_NAME         值集名称,
       FV.DEFAULT_TYPE                  默认类型,
       FV.DEFAULT_VALUE                 默认值,
       FV.REQUIRED_FLAG                 必需,
       FV.SECURITY_ENABLED_FLAG         启用安全性,
       FV.RANGE_CODE                    范围,
       FV.DISPLAY_SIZE                  显示大小,
       FV.MAXIMUM_DESCRIPTION_LEN       说明大小,
       FV.CONCATENATION_DESCRIPTION_LEN 级联说明大小,
       FV.FORM_ABOVE_PROMPT             提示,
       FV.SRW_PARAM                     变量
  FROM FND_DESCR_FLEX_COL_USAGE_VL FV, FND_FLEX_VALUE_SETS FFVS
 WHERE FV.FLEX_VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID
   AND SUBSTR(FV.DESCRIPTIVE_FLEXFIELD_NAME, 7) IN
       (SELECT FC.CONCURRENT_PROGRAM_NAME
          FROM FND_CONCURRENT_PROGRAMS_VL FC,
               FND_EXECUTABLES_FORM_V     FE,
               FND_APPLICATION            FA
         WHERE 1 = 1
           AND FA.APPLICATION_ID = FC.APPLICATION_ID
           AND FA.APPLICATION_SHORT_NAME = 'CUX'
           AND FC.CONCURRENT_PROGRAM_NAME = FE.EXECUTABLE_NAME
           AND FC.ENABLED_FLAG = 'Y')
 ORDER BY FV.DESCRIPTIVE_FLEXFIELD_NAME, FV.COLUMN_SEQ_NUM;