Oracle EBS 获取说明性弹性域全局数据元
时间:2021-07-01 10:21:17
帮助过:17人阅读
b.flex_value_set_id,
t.application_column_name,
t.form_left_prompt
FROM fnd_descriptive_flexs_tl fdfl,
fnd_descriptive_flexs fdf,
fnd_descr_flex_col_usage_tl t,
fnd_descr_flex_column_usages b,
fnd_descr_flex_contexts_vl fc
WHERE t.application_id
= b.application_id
AND t.descriptive_flexfield_name
= b.descriptive_flexfield_name
AND t.descriptive_flex_context_code
= b.descriptive_flex_context_code
AND t.application_column_name
= b.application_column_name
AND t.language
= userenv(
‘LANG‘)
AND fdfl.descriptive_flexfield_name
= t.descriptive_flexfield_name
AND fdf.application_id
= fdfl.application_id
AND fdf.descriptive_flexfield_name
= fdfl.descriptive_flexfield_name
AND fdfl.language
= userenv(
‘LANG‘)
AND fc.descriptive_flex_context_code
= b.descriptive_flex_context_code
AND fdfl.title
= ‘输入日记账:行‘
AND fc.descriptive_flexfield_name
= ‘GL_JE_LINES‘
AND b.enabled_flag
= ‘Y‘
AND (b.descriptive_flex_context_code
= ‘Global Data Elements‘ OR b.descriptive_flex_context_code
= g_gl_access_set_id)
ORDER BY t.application_column_name;
Oracle EBS 获取说明性弹性域全局数据元
标签:ges flex cat oba span lines enable and set