Value set Query

SELECT Fe.executable_name Registered Name
, fe.execution_file_name execution file name
, fcp.user_concurrent_program_name Program
, fcp.concurrent_program_name abbreviation
, fdf.column_seq_num parameter number
--, Fdf.descriptive_flexfield_name
, the Fdf.end_user_column_name parameter name
, fdf.description parameter description
, Fdf.enabled_flag is effective
, Ff.flex_value_set_name value set name
, fdf.default_type default Type
, fdf.default_value default value
, whether Fdf.required_flag must
, fdf.display_flag whether to show
, fdf.display_size display size
, Fdf.maximum_description_len description Size
, Fdf.concatenation_description_len-Level connection Description size
, Fdf.form_left_prompt Tips
From FND_DESCR_FLEX_COL_USAGE_VL FDF
, Fnd_flex_value_sets FF
, FND_APPLICATION_VL FV
, FND_CONCURRENT_PROGRAMS_VL FCP
, Fnd_executables_form_v FE
WHERE fdf.application_id = fv.application_id
and fv.application_short_name = ' Cux '
and fcp.executable_id = fe.executable_id
and ff.flex_value_set_id = fdf.flex_value_set_id
--and ff.flex_value_set_name = ' Cuxzsd_status_type '
and Fdf.descriptive_flexfield_name = (' $SRS $. Cux_wip_complett_rate ')
and REPLACE (Fdf.descriptive_flexfield_name, ' $SRS $. ', ') = Fcp.concurrent_program_name (+)
ORDER by Column_seq_num ASC;

Value set Query