oracle说明性弹性域,Oracle EBS 获取说明性弹性域全局数据元

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