ORACLE EBS 取科目组合描述

获取科目组合说明的函数
1 fnd_flex_ext.get_segs(‘SQLGL’,
‘GL#’,
b.chart_of_accounts_id,
lines.code_combination_id）
2 gl_flexfields_pkg.get_concat_description(b.chart_of_accounts_id,
lines.code_combination_id)
3 gl_flexfields_pkg.get_description_sql(w.chart_of_accounts_id, 3, w.segment3)

SELECT Gl_Flexfields_Pkg.Get_Description_Sql(Gcc.Chart_Of_Accounts_Id
                                            ,1
                                            ,Gcc.Segment1)
      ,Gcc.Concatenated_Segments
      ,Xla_Oa_Functions_Pkg.Get_Ccid_Description(Gcc.Chart_Of_Accounts_Id
                                                ,Gcc.Code_Combination_Id)
  FROM Gl_Code_Combinations_Kfv Gcc
 --WHERE Rownum = 1