EBS导出键弹性域 - 博客园
文章推薦指數: 80 %
SELECT gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id, 1, gcc.segment1) || '-. 首页 新闻 博问 专区 闪存 班级 我的博客 我的园子 账号设置 简洁模式... 退出登录 注册 登录 漫谈数据程序人生 EBS导出键弹性域 SELECTgl_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描述, FROMgl_code_combinationsgcc WHEREgcc.code_combination_id=code_combination_id; posted@ 2020-05-3122:16 游兮游兮 阅读(82) 评论(0) 编辑 收藏 举报 刷新评论刷新页面返回顶部 Copyright©2022游兮游兮 Poweredby.NET6onKubernetes
延伸文章資訊
- 1API: GL_FLEXFIELDS _PKG to get the description of GL Account
apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,5,gcc.segment5) Segment5_des...
- 2如何直接抓取GL的科目Description @ Oracle Notes - 痞客邦
使用Oracle內建的Package gl_flexfields_pkg.get_description_sql,以後就不用自己寫Code去抓Account Description了SQL Sc...
- 3Alternative for GL_FLEXFIELDS_PKG.get_description_sql to ...
We are using the standard GL API, GL_FLEXFIELDS_PKG.get_description_sql, recommended by Oracle to...
- 4Unknown Description Field of Segment5 in the User Query
You can use the package GL_FLEXFIELDS_PKG.get_sd_description_sql, this package can return the seg...
- 5PACKAGE BODY - APPS.GL_FLEXFIELDS_PKG - Oracle ...
1 PACKAGE BODY gl_flexfields_pkg AS 2 /* $Header: glumsflb.pls 120.16 2006/04/03 17:01:52 cma shi...