Oracle 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 = 'title'
   AND fnd_dfv.context_column_name = 'GLOBAL_ATTRIBUTE_CATEGORY' -- 上下文列
   AND c_v.descriptive_flex_context_code = 'context_value' --- 上下文列的值是什么时
   AND fnd_dfu.application_column_name = 'xxx_column' --那个扩展列