查询Flexfields segments definitions(备查)

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10359218/viewspace-703298/