根据描述性弹性域的标题查找描述性弹性域表和列

--根据描述性弹性域的标题查找描述性弹性域表和列
select fnd_dfv.title,
       fnd_dfv.descriptive_flexfield_name,
       fnd_dfv.application_table_name,
       fnd_dfu.application_column_name,
       fnd_dfu.form_left_prompt,
       fnd_dfu.form_above_prompt
  from fnd_descriptive_flexs_vl    fnd_dfv,
       fnd_descr_flex_col_usage_vl fnd_dfu
where fnd_dfv.title = ‘物料‘ --如：物料
   and fnd_dfu.descriptive_flexfield_name = fnd_dfv.descriptive_flexfield_name

根据描述性弹性域的标题查找描述性弹性域表和列

原文：http://www.cnblogs.com/quanweiru/p/4869913.html