List Concurrent Programs using a specific valueset in its parameter list

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

SELECT fcp.user_concurrent_program_name, fat.application_name, fdfc.column_seq_num Seq, fdfc.form_left_prompt "Parameter Name", fdfc.enabled_flag Active FROM FND_DESCR_FLEX_COL_USAGE_VL fdfc , fnd_flex_value_sets ffvs , fnd_concurrent_programs_vl fcp , fnd_application_tl fat WHERE 1 =1 AND ffvs.flex_value_set_id = fdfc.flex_value_set_id and fdfc.descriptive_flexfield_name = '$SRS$.'||fcp.concurrent_program_name and fcp.application_id = fat.application_id and ffvs.flex_value_set_name = :p_valuesetname -- Enter value set name --and fcp.user_concurrent_program_name = :p_conc_program_name -- use this condition to find out for a specific conc program ;