Concurrent Program Name with Parameter and Value set

On request here is the query to list concurrent program name with its parameter, values set and default value/type

SELECT fcpl.user_concurrent_program_name

      , fcp.concurrent_program_name

      , par.column_seq_num     

      , par.end_user_column_name

      , par.form_left_prompt prompt

      , par.enabled_flag

      , par.required_flag

      , par.display_flag

      , par.flex_value_set_id

      , ffvs.flex_value_set_name

      , flv.meaning default_type

      , par.DEFAULT_VALUE

 FROM   fnd_concurrent_programs fcp

      , fnd_concurrent_programs_tl fcpl

      , fnd_descr_flex_col_usage_vl par

      , fnd_flex_value_sets ffvs

      , fnd_lookup_values flv

 WHERE  fcp.concurrent_program_id = fcpl.concurrent_program_id

 AND    fcpl.user_concurrent_program_name = :conc_prg_name

 AND    fcpl.LANGUAGE = 'US'

 AND    par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name

 AND    ffvs.flex_value_set_id = par.flex_value_set_id

 AND    flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'

 AND    flv.lookup_code(+) = par.default_type

 AND    flv.LANGUAGE(+) = USERENV ('LANG')

 ORDER BY par.column_seq_num