List Concurrent Programs/Value Sets relationships

Depending on the parameter used, the following select lists all Concurrent Programs that use a certain Value Set, and all Value Sets used by a certain a Concurrent Program.

select cp.concurrent_program_name
,      df.column_seq_num
,      df.end_user_column_name
,      fvs.flex_value_set_name
from fnd_concurrent_programs cp
,    fnd_descr_flex_column_usages df
,    fnd_flex_value_sets fvs
where ‘$SRS$.’||cp.concurrent_program_name = df.descriptive_flexfield_name
and   df.flex_value_set_id = fvs.flex_value_set_id
and   fvs.flex_value_set_name = nvl(:P_FLEX_VALUE_SET_NAME, fvs.flex_value_set_name)
and   cp.concurrent_program_name = nvl(:P_CONCURRENT_PROGRAM_NAME, cp.concurrent_program_name)