1 SELECT app.application_name 应用产品
2 ,des.title 标题
3 ,des.application_table_name 表名
4 ,dfc.descriptive_flex_context_code 上下文字段值代码
5 ,dfd.column_seq_num 编号
6 ,dfd.application_column_name 列
7 ,dfd.end_user_column_name 字段名称
8 ,dfd.form_left_prompt 窗口提示
9 ,dfd.flex_value_set_id 值集id
10 ,des.concatenated_segs_view_name dfv视图名称
11 ,des.context_column_name 结构列
12 ,des.freeze_flex_definition_flag 是否冻结弹性域定义
13 ,des.concatenated_segment_delimiter 段分隔符
14 ,des.form_context_prompt 上下文提示
15 ,des.default_context_field_name 参考字段
16 ,des.context_override_value_set_id 值集
17 ,dfc.descriptive_flex_context_name 上下文字段值名称
18 ,dfc.description 上下文字段值说明
19 ,dfc.enabled_flag 是否启用
20 ,des.descriptive_flexfield_name 名称
21 FROM fnd_descr_flex_col_usage_vl dfd
22 ,fnd_descr_flex_contexts_vl dfc
23 ,fnd_descriptive_flexs_vl des
24 ,fnd_application_all_view app
25 WHERE 1 = 1
26 AND dfc.descriptive_flexfield_name = dfd.descriptive_flexfield_name(+)
27 AND dfc.descriptive_flex_context_code =
28 dfd.descriptive_flex_context_code(+)
29 AND des.application_id = dfc.application_id(+)
30 AND des.descriptive_flexfield_name = dfc.descriptive_flexfield_name(+)
31 AND des.application_id = app.application_id
