Query to Find Concurrent Program and its Parameters List

SELECT cp.user_concurrent_program_name ,
cp.concurrent_program_name ,
ap.application_name ,
cp.description,
cp.enabled_flag,
cp.output_file_type ,
cx.executable_name ,
lv.meaning ,
cx.user_executable_name ,
df.column_seq_num ,
df.end_user_column_name ,
df.description,
df.enabled_flag,
df.required_flag ,
df.security_enabled_flag ,
df.display_flag ,
fvs.flex_value_set_name ,
df.default_type ,
df.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 fvs.flex_value_set_id=df.flex_value_set_id
AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND lv.lookup_code = cx.execution_method_code
AND cp.user_concurrent_program_name like 'Concurrent Program Name'
AND df.descriptive_flexfield_name = '$SRS$.'||cp.concurrent_program_name
AND lv.language='US'
ORDER BY df.column_seq_num