【OracleEBS】 科目余额SQL

 

复制代码
select gb.period_year 会计年度,
       gb.period_name 会计期间,
       gcck.concatenated_segments 科目代码,
       gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,
                                             '',
                                             gcck.segment1) 公司,
       '',
       gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,
                                             '',
                                             gcck.segment2) 成本中心,
       gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,
                                             '',
                                             gcck.segment3) 会计科目,
       gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,
                                             '',
                                             gcck.segment4) 子科目,
       gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,
                                             '',
                                             gcck.segment5) 产品段,
       gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,
                                             '',
                                             gcck.segment6) 片区,
       gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,
                                             '',
                                             gcck.segment7) 备用,
       gb.begin_balance_dr - gb.begin_balance_cr 期初余额,
       gb.period_net_dr 本期借方发生,
       gb.period_net_cr 本期贷方发生,
       nvl(gb.period_net_dr, 0) - nvl(gb.period_net_cr, 0) 本期净额,
       nvl(gb.begin_balance_dr, 0) + nvl(gb.period_net_dr, 0) -
       nvl(gb.begin_balance_cr, 0) - nvl(gb.period_net_cr, 0) 期末余额
  from gl.gl_balances gb, gl_code_combinations_kfv gcck
 where gb.code_combination_id = gcck.code_combination_id
   and gb.currency_code = 'CNY'
   and gcck.summary_flag = 'N'
   and gb.actual_flag = 'A'
   AND gb.period_name = '2010-11'
   AND gcck.concatenated_segments like '02.021200.6501.%.0000.0000.000'
复制代码

 

posted @   Iven_lin  阅读(90)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 【.NET】调用本地 Deepseek 模型
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
点击右上角即可分享
微信分享提示