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/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
