b.flex_value_set_id,
t.application_column_name,
t.form_left_promptFROMfnd_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 fcWHERE t.application_id =b.application_idAND t.descriptive_flexfield_name =b.descriptive_flexfield_nameAND t.descriptive_flex_context_code =b.descriptive_flex_context_codeAND t.application_column_name =b.application_column_nameAND t.language = userenv(‘LANG‘)AND fdfl.descriptive_flexfield_name =t.descriptive_flexfield_nameAND fdf.application_id =fdfl.application_idAND fdf.descriptive_flexfield_name =fdfl.descriptive_flexfield_nameAND fdfl.language = userenv(‘LANG‘)AND fc.descriptive_flex_context_code =b.descriptive_flex_context_codeAND 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
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:https://www.cnblogs.com/jenrry/p/10006857.html