EBS 查看描述性弹性域配置

SELECT fnd_dfv.title, -- title名称
       fnd_dfv.default_context_value,
       fnd_dfv.descriptive_flexfield_name,
       fnd_dfv.application_table_name, --  那个表
       fnd_dfv.context_column_name, -- 分类字段
       fnd_dfv.default_context_field_name,
       fnd_dfv.form_context_prompt, -- 分类字段 页面显示名称
       c_v.descriptive_flex_context_code, -- 分类，选项编码
       c_v.descriptive_flex_context_name, -- 分类，选项名称
       c_v.description, -- 分类，选项描述
       fnd_dfu.application_column_name, -- 弹性域 列
       fnd_dfu.form_left_prompt, -- 弹性域 列 对应的页面名称
       fnd_dfu.form_above_prompt, -- 弹性域 列 对应的页面名称
       fnd_dfv.*,
       fnd_dfu.*
  FROM apps.fnd_descriptive_flexs_vl    fnd_dfv,
       fnd_descr_flex_contexts_vl       c_v,
       apps.fnd_descr_flex_col_usage_vl fnd_dfu
WHERE fnd_dfv.application_id = c_v.application_id
   AND fnd_dfv.application_id = fnd_dfu.application_id
   AND fnd_dfu.descriptive_flexfield_name = fnd_dfv.descriptive_flexfield_name
   AND fnd_dfv.descriptive_flexfield_name = c_v.descriptive_flexfield_name
   AND c_v.descriptive_flex_context_code = fnd_dfu.descriptive_flex_context_code
   AND fnd_dfv.application_table_name = 'xxx_table' --- 那个表的
   AND fnd_dfv.title = 'JG_HR_LOCATIONS'
   AND fnd_dfv.context_column_name = 'GLOBAL_ATTRIBUTE_CATEGORY' -- 上下文列
   AND c_v.descriptive_flex_context_code = 'xxx_value' --- 上下文列的值是什么时
   AND fnd_dfu.application_column_name = 'xxx_column' --那个扩展列，如GLOBAL_ATTRIBUTE5;


--值配置
select * from FND_FLEX_VALUE_SETS t where t.flex_value_set_id in (101340,1018449);
select * from FND_FLEX_VALIDATION_TABLES t where t.flex_value_set_id=101340;
select * from FND_FLEX_VALUES t where t.flex_value_set_id=1018449;
select * from FND_FLEX_VALUES_VL t where t.flex_value_set_id=1018449;
select * from FND_FLEX_VALUE_DESTINATION_V t where t.flex_value_set_id=1018449;
select * from FND_FLEX_VALUE_CHILDREN_V t where t.flex_value_set_id=1018449;
select * from FND_FLEX_VALUE_RULES_VL t where t.flex_value_set_id=1018449;