Query To Find Concurrent Program's Parameters and Value Sets

SELECT

  fcp.user_concurrent_program_name "Concurrent Program Name",

  fcp.concurrent_program_name "Short Name",

  fdfcuv.column_seq_num "Column Seq Number",

  fdfcuv.end_user_column_name "Parameter Name",

  fdfcuv.form_left_prompt "Prompt",

  fdfcuv.srw_param,

  ffvs.flex_value_set_name "Value Set Name",

  flv.meaning "Default Type",

  fdfcuv.DEFAULT_VALUE "Default Value"

FROM

  fnd_concurrent_programs_vl fcp,

  fnd_descr_flex_col_usage_vl fdfcuv,

  fnd_flex_value_sets ffvs,

  fnd_lookup_values flv

WHERE 1=1

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

  AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id

  AND flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'

  AND flv.lookup_code(+) = fdfcuv.default_type

--  AND fcp.user_concurrent_program_name like 'XXAA%Report'

--  AND ffvs.flex_value_set_name  LIKE '%JOB%'

ORDER BY

 fcp.user_concurrent_program_name

 ,fdfcuv.column_seq_num

;