本文详细介绍了如何根据物料标题查找描述性弹性域表和列，包括标题、描述性弹性字段名、应用表名、应用列名等关键信息。
/*根据描述性弹性域的标题查找描述性弹性域表和列*/ --
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
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
扫一扫
2758
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
