Query to find out concurrent program details and its parameters

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,fdfcuv.SRW_PARAM token,ffvs.FLEX_VALUE_SET_NAME VALUE_SET_NAME

FROM   fnd_concurrent_programs fcp

     , fnd_concurrent_programs_tl fcpl

     , fnd_descr_flex_col_usage_vl fdfcuv

     , fnd_application_vl fav

     ,fnd_flex_value_sets ffvs

WHERE  fcp.concurrent_program_id = fcpl.concurrent_program_id

AND    fcpl.user_concurrent_program_name = :conc_prg_name

AND ffvs.FLEX_VALUE_SET_ID = fdfcuv.FLEX_VALUE_SET_ID

AND    fav.application_id=fcp.application_id

AND    fcpl.LANGUAGE = 'US'

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