Query to get concurrent Program details with Parameter list and value set attached to parameter.
Query : SELECT fcpt.user_concurrent_program_name, fcp.concurrent_program_name, fcp.concurrent_program_id, fav.application_short_name, fav.application_name, fav.application_id, fdfcuv.column_seq_num, fdfcuv.end_user_column_name, fdfcuv.form_left_prompt prompt, ffvs.flex_value_set_name, fdfcuv.enabled_flag, fdfcuv.required_flag, fdfcuv.display_flag FROM apps.fnd_concurrent_programs fcp, apps.fnd_concurrent_programs_tl fcpt, apps.fnd_descr_flex_col_usage_vl fdfcuv, apps.fnd_application_vl fav, apps.fnd_flex_value_sets ffvs WHERE fcp.concurrent_program_id = fcpt.concurrent_program_id AND fav.application_id = fcp.application_id AND fcpt.language = 'US' AND ffvs.flex_value_set_id ...