根据描述性弹性域的标题查找描述性弹性域表和列
--根据描述性弹性域的标题查找描述性弹性域表和列
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