Query to find out concurrent program details and its parameters

select fcpl.user_concurrent_program_name

      , fcp.concurrent_program_name

      , fcp.concurrent_program_id

      , fav.application_short_name

      , fav.application_name

      , fav.application_id

      , fdfcuv.end_user_column_name

      , fdfcuv.form_left_prompt prompt

      , fdfcuv.enabled_flag

      , fdfcuv.required_flag

      , fdfcuv.display_flag

from   fnd_concurrent_programs fcp

      , fnd_concurrent_programs_tl fcpl

      , fnd_descr_flex_col_usage_vl fdfcuv

      , fnd_application_vl fav

where  fcp.concurrent_program_id = fcpl.concurrent_program_id

and    fcpl.user_concurrent_program_name = :conc_prg_name

and    fav.application_id=fcp.application_id

and    fcpl.language = 'US'

and    fdfcuv.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name;