Get Report With Parameters list

Get Report With Parameters list:-
--------------------------------------

When we design report in the Oracle Application, we may set the parameters to the reports. And from backend if you want to know the name of the Parameters and it's sequence, then use the following query.

This will work in all 11i Instances.

SELECT a.concurrent_program_name AS concurrent_program_name,
a.user_concurrent_program_name AS user_concurrent_program_name,
c.application_short_name AS application_short_name,
b.column_seq_num AS column_seq_num, b.srw_param AS param_seq,
b.form_left_prompt AS prompt,
d.flex_value_set_name AS values_set_name
FROM fnd_concurrent_programs_vl a,
fnd_descr_flex_col_usage_vl b,
fnd_application c,
fnd_flex_value_sets d
WHERE a.enabled_flag = 'Y'
AND a.concurrent_program_name =
SUBSTR (b.descriptive_flexfield_name, 7, 100)
AND a.application_id = c.application_id
AND b.enabled_flag = 'Y'
AND b.flex_value_set_id = d.flex_value_set_id
--AND a.user_concurrent_program_name = 'Your Concurrent Name'
ORDER BY a.concurrent_program_id, b.column_seq_num