-- 上下文段值 FND_DESCR_FLEX_CONTEXTS_VL
-- 段信息 段摘要 FND_DESCR_FLEX_COL_USAGE_VL
--说明性弹性域段
FND_DESCRIPTIVE_FLEXS_VL
SELECT fa.application_name 应用
,descriptive_flexs.title
标题
,descriptive_flexs.freeze_flex_definition_flag
冻结弹性域定义
,descriptive_flexs.form_context_prompt
提示
,descriptive_flexs.descriptive_flexfield_name
--,descriptive_flexs.context_override_value_set_id
上下文段值集ID
,descriptive_flexs.default_context_value
上下文段默认值
,descriptive_flexs.default_context_field_name
上下文段参考字段
,descriptive_flexs.context_required_flag
上下文段必需
,descriptive_flexs.context_user_override_flag 上下文段显示
,descriptive_flexs.context_synchronization_flag
上下文与参考字段同步
,flex_context.descriptive_flex_context_code 上下文段值代码
,flex_context.descriptive_flex_context_name 上下文段值名称
,flex_context.description 上下文段值描述
,flex_context.enabled_flag 上下文段值启用
,descr_col.row_id
,descr_col.end_user_column_name 段名称
,descr_col.application_column_name 段列
,descr_col.column_seq_num 段摘要编号
,descr_col.end_user_column_name 段摘要名称
,descr_col.form_left_prompt
段摘要窗口提示
,descr_col.application_column_name 段摘要列
,ffvs.flex_value_set_name 段摘要值集
,descr_col.enabled_flag
段摘要是否启用
,descr_col.required_flag
段是否必需
,descr_col.security_enabled_flag 段启用安全性
,descr_col.display_flag
段是否显示
,descr_col.display_size 段尺寸显示大小
,descr_col.maximum_description_len 段尺寸说明大小
,descr_col.concatenation_description_len
段尺寸级连说明大小
,descr_col.flex_value_set_id 段验证值集ID
,ffvs.flex_value_set_name 段验证值集
,descr_col.range_code 段范围
,descr_col.default_type 段默认类型
,descr_col.default_value 段默认值
,descr_col.form_left_prompt
段窗口
,descr_col.form_above_prompt 段值列表
FROM
fnd_descriptive_flexs_vl
descriptive_flexs
,fnd_application_vl
fa
,fnd_descr_flex_contexts_vl flex_context
,fnd_descr_flex_col_usage_vl descr_col
,fnd_flex_value_sets ffvs
WHERE descriptive_flexs.application_id =
fa.application_id
AND
descriptive_flexs.application_id = 101
AND
(descriptive_flexs.title = &your_title_en OR
descriptive_flexs.title = &your_title_zhs)
AND
descriptive_flexs.application_id =
flex_context.application_id
AND
descriptive_flexs.descriptive_flexfield_name =
flex_context.descriptive_flexfield_name
AND
descr_col.descriptive_flexfield_name =
flex_context.descriptive_flexfield_name
AND
descr_col.descriptive_flex_context_code =
flex_context.descriptive_flex_context_code
AND
descr_col.flex_value_set_id = ffvs.flex_value_set_id
加载中…
(2025-08-14 19:57:14)