Oracle 说明性弹性域定义查询

 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