SQL Query to get concurrent program's parameter details

 

Use the below query  to get concurrent program's parameter details

SELECT fcp.concurrent_program_id
     , fcpl.user_concurrent_program_name
     , fcp.concurrent_program_name
     , par.application_column_name     

     , par.end_user_column_name     

     , par.form_left_prompt prompt
     , par.enabled_flag
     , par.required_flag
     , par.display_flag
FROM   apps.fnd_concurrent_programs fcp
     , apps.fnd_concurrent_programs_tl fcpl
     , apps.fnd_descr_flex_col_usage_vl par
WHERE  fcp.concurrent_program_id = fcpl.concurrent_program_id
AND    fcpl.user_concurrent_program_name = '<Program Name>'
AND    fcpl.LANGUAGE = 'US'
AND    par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name

ORDER BY par.application_column_name;