Oracle ebs 弹性域表关联关系（关键性和说明性弹性域）

YUA.L

于 2024-08-07 17:13:20 发布

阅读量110

点赞数 2

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/YUAGEL/article/details/140996709

版权

--关键性弹性域--
SELECT ff.application_table_name   弹性域表,
       ff.id_flex_name             弹性域标题,
       fsv.id_flex_structure_name  标题,
       fgv.segment_name            弹性域名称,
       fgv.application_column_name 字段,
       ffvs.flex_value_set_name    值集
  FROM fnd_id_flexs              ff,
       fnd_id_flex_structures_vl fsv,
       fnd_id_flex_segments_vl   fgv,
       fnd_flex_value_sets       ffvs
 WHERE ff.application_id = fsv.application_id
   AND ff.id_flex_code = fsv.id_flex_code
   AND fsv.application_id = fgv.application_id
   AND fsv.id_flex_code = fgv.id_flex_code
   AND fgv.flex_value_set_id = ffvs.flex_value_set_id(+)
      --AND fsv.application_id = 140
   AND ff.id_flex_name = 'Category Flexfield';

--说明性弹性域--
SELECT fdv.application_table_name        弹性域表,
       fdv.title                         弹性域标题,
       fuv.descriptive_flex_context_code 上下文,
       fuv.end_user_column_name          弹性域名称,
       fuv.application_column_name       字段,
       ffvs.flex_value_set_name          值集
  FROM fnd_descriptive_flexs_vl    fdv,
       fnd_descr_flex_contexts_vl  fcv,
       fnd_descr_flex_col_usage_vl fuv,
       fnd_flex_value_sets         ffvs
 WHERE fdv.application_id = fcv.application_id
   AND fdv.descriptive_flexfield_name = fcv.descriptive_flexfield_name
   AND fcv.application_id = fuv.application_id
   AND fcv.descriptive_flexfield_name = fuv.descriptive_flexfield_name
   AND fuv.flex_value_set_id = ffvs.flex_value_set_id(+)
      --and fdv.APPLICATION_ID = 201
   AND fdv.title = 'PO 行'