Concurrent Program with parameters value sets and default values query in Oracle Applications or Concurrent program Details

  SELECT a.application_name,
         cp.concurrent_program_name,
         cp.user_concurrent_program_name,
         dfcu.form_left_prompt,
         dfcu.display_flag,
         dfcu.required_flag,
         fvs.flex_value_set_name,
         dfcu.default_type,
         dfcu.DEFAULT_VALUE,
         dfcu.srw_param
    FROM apps.fnd_concurrent_programs_vl cp,
         apps.fnd_descriptive_flexs_vl df,
         apps.fnd_application_vl a,
         apps.fnd_descr_flex_contexts_vl dfc,
         apps.fnd_descr_flex_col_usage_vl dfcu,
         apps.fnd_flex_value_sets fvs
   WHERE     nvl(:p_conc_program_name, cp.user_concurrent_program_name) = cp.user_concurrent_program_name
         AND df.application_id = cp.application_id
         AND df.descriptive_flexfield_name =
                '$SRS$.' || cp.concurrent_program_name
         AND a.application_id = df.application_id
         AND dfc.application_id = df.application_id
         AND dfc.descriptive_flexfield_name = df.descriptive_flexfield_name
         AND dfcu.application_id = dfc.application_id
         AND dfcu.descriptive_flexfield_name = dfc.descriptive_flexfield_name
         AND dfcu.descriptive_flex_context_code =
                dfc.descriptive_flex_context_code
         AND fvs.flex_value_set_id = dfcu.flex_value_set_id
ORDER BY a.application_name, cp.concurrent_program_name, dfcu.column_seq_num;