ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 查询Flexfields segments definitions(备查)

查询Flexfields segments definitions(备查)

原创 Linux操作系统 作者:asiaidea 时间:2011-07-28 11:07:42 0 删除 编辑

SELECT c.*
  FROM   apps.fnd_descriptive_flexs_vl    a,
                apps.fnd_descr_flex_contexts_vl  b,
                apps.fnd_descr_flex_col_usage_vl c
 WHERE      title = 'Receiving Transactions'
       AND      a.descriptive_flexfield_name = b.descriptive_flexfield_name
       AND      b.descriptive_flex_context_code = 'Global Data Elements'
       AND      c.descriptive_flexfield_name = b.descriptive_flexfield_name
       AND      b.descriptive_flex_context_code = c.descriptive_flex_context_code


select d.application_short_name
,      b.application_table_name
,      b.descriptive_flexfield_name
,      a.descriptive_flex_context_code
,      a.application_column_name
,      a.end_user_column_name
,      a.form_left_prompt
,      a.description
,      c.flex_value_set_name
from fnd_descr_flex_col_usage_vl  a
,    fnd_descriptive_flexs b
,    fnd_flex_value_sets c
,    fnd_application  d
where a.application_id =d.application_id
and   a.descriptive_flexfield_name = b.descriptive_flexfield_name
and   a.flex_value_set_id = c.flex_value_set_id
and   d.application_short_name in ('OFA','PA')
and   a.created_by <>1
and   b.application_table_name <>'FND_SRS_MASTER'
order by 1,2

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10359218/viewspace-703298/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-11-04

  • 博文量
    140
  • 访问量
    478312