值集查询

 

SELECT fe.executable_name 注册名
,fe.execution_file_name 执行文件名
,fcp.user_concurrent_program_name 程序
,fcp.concurrent_program_name 简称
,fdf.column_seq_num 参数序号
--,fdf.descriptive_flexfield_name
,fdf.end_user_column_name 参数名称
,fdf.description 参数描述
,fdf.enabled_flag 是否有效
,ff.flex_value_set_name 值集名称
,fdf.default_type 默认类型
,fdf.default_value 默认值
,fdf.required_flag 是否必须
,fdf.display_flag 是否显示
,fdf.display_size 显示大小
,fdf.maximum_description_len 说明大小
,fdf.concatenation_description_len 级连说明大小
,fdf.form_left_prompt 提示
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;