查找说明性弹性域SQL

发布时间 2023-12-06 10:38:13作者: shu'sblog

查找说明性弹性域:

SELECT fnd_dfv.title,
fnd_dfv.descriptive_flexfield_name,
fnd_dfv.form_context_prompt,
fnd_dfc.descriptive_flex_context_code,
fnd_dfc.descriptive_flex_context_name,
fnd_dfv.application_table_name,
fnd_dfv.default_context_value,
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_contexts_vl fnd_dfc,
fnd_descr_flex_col_usage_vl fnd_dfu
WHERE 1 = 1
AND fnd_dfv.descriptive_flexfield_name =
fnd_dfc.descriptive_flexfield_name
AND fnd_dfu.descriptive_flexfield_name =
fnd_dfv.descriptive_flexfield_name
AND fnd_dfu.form_left_prompt LIKE '%出票人全称%';