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

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

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