通过值集名称 找到所有用到该值集的并发请求
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'