ITPub博客

首页 > 数据库 > Oracle > EBS导出键弹性域

EBS导出键弹性域

原创 Oracle 作者:游兮不归 时间:2018-10-15 14:04:18 0 删除 编辑
SELECT gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
                                             1,
                                             gcc.segment1) || '-' ||
       gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
                                             2,
                                             gcc.segment2) || '-' ||
       gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
                                             3,
                                             gcc.segment3) || '-' ||
       gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
                                             4,
                                             gcc.segment4) || '-' ||
       gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
                                             5,
                                             gcc.segment5) || '-' ||
       gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
                                             6,
                                             gcc.segment6) || '-' ||
       gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
                                             7,
                                             gcc.segment7) || '-' ||
       gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,
                                             8,
                                             gcc.segment8) AS 描述,
  FROM gl_code_combinations gcc
 WHERE gcc.code_combination_id = code_combination_id;


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31558081/viewspace-2216395/,如需转载,请注明出处,否则将追究法律责任。

上一篇: EBS服务器管理
请登录后发表评论 登录
全部评论

注册时间:2018-10-12

  • 博文量
    15
  • 访问量
    14215