Query to get concurrent Program details with Parameter list and value set attached to parameter.

Query :

SELECT fcpt.user_concurrent_program_name,
  fcp.concurrent_program_name,
  fcp.concurrent_program_id,
  fav.application_short_name,
  fav.application_name,
  fav.application_id,
  fdfcuv.column_seq_num,
  fdfcuv.end_user_column_name,
  fdfcuv.form_left_prompt prompt,
  ffvs.flex_value_set_name,
  fdfcuv.enabled_flag,
  fdfcuv.required_flag,
  fdfcuv.display_flag
FROM apps.fnd_concurrent_programs fcp,
  apps.fnd_concurrent_programs_tl fcpt,
  apps.fnd_descr_flex_col_usage_vl fdfcuv,
  apps.fnd_application_vl fav,
  apps.fnd_flex_value_sets ffvs
WHERE fcp.concurrent_program_id       = fcpt.concurrent_program_id
AND fav.application_id                = fcp.application_id
AND fcpt.language                     = 'US'
AND ffvs.flex_value_set_id            = fdfcuv.flex_value_set_id
AND fdfcuv.descriptive_flexfield_name = '$SRS$.'  || fcp.concurrent_program_name
AND fcpt.user_concurrent_program_name = 'Trial Balance'
ORDER BY fdfcuv.column_seq_num;

Output of query :