Query to get Concurrent program details with Value sets

 SELECT cp.user_concurrent_program_name "Program Name",

cp.concurrent_program_name "Short Name",

ap.application_name "Application",

cp.description "Progam Description",

cp.enabled_flag "Enabled Flag",

cp.output_file_type "Output Format",

cx.executable_name "Executable Short Name",

lv.meaning "Executable Method",

cx.user_executable_name "Executable Name",

df.column_seq_num "Sequence",

df.end_user_column_name "Parameter" ,

df.description "Parameter Desciption",

df.enabled_flag "Parameter Enabled",

df.required_flag "Parameter Required",

df.security_enabled_flag "Enable Security",

df.display_flag "Parameter Display",

fvs.flex_value_set_name "Value Set",

df.default_type "Default Type",

df.default_value "Default Value"

FROM apps.fnd_concurrent_programs_vl cp,

apps.fnd_executables_form_v cx,

apps.fnd_application_vl ap,

apps.fnd_descr_flex_col_usage_vl df,

apps.fnd_flex_value_sets fvs,

apps.fnd_lookup_values lv

WHERE cp.executable_id            = cx.executable_id

AND cp.application_id                  = ap.application_id

AND cx.execution_method_code  = lv.lookup_code(+)

AND '$SRS$.'||cp.concurrent_program_name = df.descriptive_flexfield_name(+)

AND df.flex_value_set_id             = fvs.flex_value_set_id(+)

AND NVL(lv.lookup_type,'CP_EXECUTION_METHOD_CODE') = 'CP_EXECUTION_METHOD_CODE'

AND NVL(lv.language,'US') = 'US'

AND cp.user_concurrent_program_name = 'Enter your concurrent program name'

ORDER BY cp.user_concurrent_program_name, df.column_seq_num;