日期:2014-05-16  浏览次数:20437 次

通过值集名称 找到所有用到该值集的并发请求
SELECT DISTINCT FFVS.FLEX_VALUE_SET_NAME,
                FFVS.DESCRIPTION,
                FCP.CONCURRENT_PROGRAM_NAME,
                FCP.USER_CONCURRENT_PROGRAM_NAME,
                FCP.*
  FROM FND_FLEX_VALUE_SETS         FFVS,
       FND_CONCURRENT_PROGRAMS_VL  FCP,
       FND_DESCR_FLEX_COL_USAGE_VL FDFCU
WHERE '$SRS$.' || FCP.CONCURRENT_PROGRAM_NAME =
       FDFCU.DESCRIPTIVE_FLEXFIELD_NAME
   AND FDFCU.FLEX_VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID

   AND FFVS.FLEX_VALUE_SET_NAME = '值集名称code'