ebs财务报表用HTML方法实现

最新推荐文章于 2023-07-28 00:53:26 发布
最新推荐文章于 2023-07-28 00:53:26 发布
阅读量1.9k 收藏 1
点赞数
CC 4.0 BY-SA版权
文章标签： 报表 html books c null command
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/yanj_yz/article/details/6738491
这篇博客介绍了一个使用HTML方法实现Oracle EBS（企业业务套件）财务报表的PROCEDURE，包括资产负债表的计算和展示。通过注册PROCEDURE并在Form中调用，展示详细的财务数据。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

 

开发步骤：

一，创建一个PROCEDURE 类似如下：

CREATE OR REPLACE PROCEDURE xxafx_TEST(p_sob_id        NUMBER,
                                             p_period_year   NUMBER,
                                             p_period_name   VARCHAR2,
                                             p_start_date    varchar2,
                                             p_end_date      varchar2,
                                             p_period_num    NUMBER,
                                             p_period_id     number,
                                             p_company_id    varchar2,
                                             p_currency_code VARCHAR2,
                                             p_zbr           VARCHAR2,
                                             p_fhr           VARCHAR2) IS
----------------------------------------------------------------------
-- Purpose :资产负债表
-----------------------------------------------------------------------
  v_standard_code  VARCHAR2(30);
  v_converted_code VARCHAR2(30);
  v_description    VARCHAR2(240);
  v_currency_code  VARCHAR2(10);
  v_column_1_name  VARCHAR2(10);
  v_column_2_name  VARCHAR2(10);
  p_date_title_str VARCHAR2(50);
  n                NUMBER(20);
  v_balance_value  number;
  v_begin_balance  NUMBER(20, 2);
  v_period_balance NUMBER(20, 2);
  v_period_min_num NUMBER(13);
  v_company        VARCHAR2(1000);
  v_month          NUMBER(10);
  v_title_month    number(10);
  v_day            NUMBER(10);
  v_user           VARCHAR2(20);
  v_appro          VARCHAR2(20);
  v_r1_c1          NUMBER(30, 2); --行次为1,第一个变量
  v_r1_c2          NUMBER(30, 2); --行次为1,第二个变量
  v_r2_c1          NUMBER(30, 2);
  v_r2_c2          NUMBER(30, 2);
  v_r3_c1          NUMBER(30, 2);
  v_r3_c2          NUMBER(30, 2);
  v_r4_c1          NUMBER(30, 2);
  v_r4_c2          NUMBER(30, 2);
  v_r5_c1          NUMBER(30, 2);
  v_r5_c2          NUMBER(30, 2);
  v_r6_c1          NUMBER(30, 2); --应收帐款(1131-1141)
  v_r6_c2          NUMBER(30, 2);
  v_r7_c1          NUMBER(30, 2);
  v_r7_c2          NUMBER(30, 2);
  v_r8_c1          NUMBER(30, 2);
  v_r8_c2          NUMBER(30, 2);
  v_r9_c1          NUMBER(30, 2);
  v_r9_c2          NUMBER(30, 2);
  v_r10_c1         NUMBER(20, 2);
  v_r10_c2         NUMBER(20, 2);
  v_r11_c1         NUMBER(30, 2);
  v_r11_c2         NUMBER(30, 2);
  v_r24_c1         NUMBER(30, 2);
  v_r24_c2         NUMBER(30, 2);
  v_r31_c1         NUMBER(30, 2); --流动资产合计
  v_r31_c2         NUMBER(30, 2);
  v_r32_c1         NUMBER(30, 2);
  v_r32_c2         NUMBER(30, 2);
  v_r34_c1         NUMBER(30, 2);
  v_r34_c2         NUMBER(30, 2);
  v_r38_c1         NUMBER(30, 2); --长期投资合计
  v_r38_c2         NUMBER(30, 2);
  v_r39_c1         NUMBER(30, 2);
  v_r39_c2         NUMBER(30, 2);
  v_r40_c1         NUMBER(30, 2);
  v_r40_c2         NUMBER(30, 2);
  v_r41_c1         NUMBER(30, 2);
  v_r41_c2         NUMBER(30, 2);
  v_r42_c1         NUMBER(30, 2);
  v_r42_c2         NUMBER(30, 2);
  v_r43_c1         NUMBER(30, 2);
  v_r43_c2         NUMBER(30, 2);
  v_r44_c1         NUMBER(30, 2);
  v_r44_c2         NUMBER(30, 2);
  v_r45_c1         NUMBER(30, 2);
  v_r45_c2         NUMBER(30, 2);
  v_r46_c1         NUMBER(30, 2);
  v_r46_c2         NUMBER(30, 2);
  v_r50_c1         NUMBER(30, 2); --固定资产合计
  v_r50_c2         NUMBER(30, 2);
  v_r51_c1         NUMBER(30, 2);
  v_r51_c2         NUMBER(30, 2);
  v_r52_c1         NUMBER(30, 2);
  v_r52_c2         NUMBER(30, 2);
  v_r60_c1         NUMBER(30, 2); --无形资产及其他资产合计
  v_r60_c2         NUMBER(30, 2);
  v_r67_c2         NUMBER(30, 2); --资产总计
  v_r67_c1         NUMBER(30, 2);
  v_r68_c1         NUMBER(30, 2);
  v_r68_c2         NUMBER(30, 2);
  v_r69_c1         NUMBER(30, 2);
  v_r69_c2         NUMBER(30, 2);
  v_r70_c1         NUMBER(30, 2);
  v_r70_c2         NUMBER(30, 2);
  v_r71_c1         NUMBER(30, 2);
  v_r71_c2         NUMBER(30, 2);
  v_r72_c1         NUMBER(30, 2);
  v_r72_c2         NUMBER(30, 2);
  v_r73_c1         NUMBER(30, 2);
  v_r73_c2         NUMBER(30, 2);
  v_r74_c1         NUMBER(30, 2);
  v_r74_c2         NUMBER(30, 2);
  v_r75_c1         NUMBER(30, 2);
  v_r75_c2         NUMBER(30, 2);
  v_r76_c1         NUMBER(30, 2);
  v_r76_c2         NUMBER(30, 2);
  v_r81_c1         NUMBER(30, 2);
  v_r81_c2         NUMBER(30, 2);
  v_r82_c1         NUMBER(30, 2);
  v_r82_c2         NUMBER(30, 2);
  v_r83_c1         NUMBER(30, 2);
  v_r83_c2         NUMBER(30, 2);
  v_r90_c1         NUMBER(30, 2);
  v_r90_c2         NUMBER(30, 2);
  v_r100_c1        NUMBER(30, 2); --流动负债合计
  v_r100_c2        NUMBER(30, 2);
  v_r101_c1        NUMBER(30, 2);
  v_r101_c2        NUMBER(30, 2);
  v_r102_c1        NUMBER(30, 2);
  v_r102_c2        NUMBER(30, 2);
  v_r103_c1        NUMBER(30, 2);
  v_r103_c2        NUMBER(30, 2);
  v_r106_c1        NUMBER(30, 2);
  v_r106_c2        NUMBER(30, 2);
  v_r110_c1        NUMBER(30, 2); --长期负债合计
  v_r110_c2        NUMBER(30, 2);
  v_r111_c1        NUMBER(30, 2);
  v_r111_c2        NUMBER(30, 2);
  v_r114_c1        NUMBER(30, 2); --负债总计
  v_r114_c2        NUMBER(30, 2);
  v_r115_c1        NUMBER(30, 2);
  v_r115_c2        NUMBER(30, 2);
  v_r116_c1        NUMBER(30, 2);
  v_r116_c2        NUMBER(30, 2);
  v_r117_c1        NUMBER(30, 2);
  v_r117_c2        NUMBER(30, 2);
  v_r118_c1        NUMBER(30, 2);
  v_r118_c2        NUMBER(30, 2);
  v_r119_c1        NUMBER(30, 2);
  v_r119_c2        NUMBER(30, 2);
  v_r120_c1        NUMBER(30, 2);
  v_r120_c2        NUMBER(30, 2);
  v_r120_c3        NUMBER(30, 2);
  v_r120_c4        NUMBER(30, 2);
  v_r121_c2        NUMBER(30, 2);
  v_r121_c1        NUMBER(30, 2);
  v_r122_c1        NUMBER(30, 2);
  v_r122_c2        NUMBER(30, 2);
  v_r135_c1        NUMBER(30, 2);
  v_r135_c2        NUMBER(30, 2);
  v_internal_1     NUMBER(30, 2);
  v_internal_2     NUMBER(30, 2);
  v_reivable_1     NUMBER(30, 2);
  v_reivable_2     NUMBER(30, 2);
  v_r2176_c1       NUMBER(30, 2);
  v_r2176_c2       NUMBER(30, 2);
  v_period_name    varchar2(60);
  --====================取所有明细科目,余额用于计算======================
  CURSOR c_acc IS
    SELECT standard_code, converted_code, description
      FROM xxafx_stx_converted_account
     WHERE converted_code IS NOT NULL AND set_of_books_id = p_sob_id;

BEGIN
  DELETE FROM xxafx_afx_bs;
  COMMIT;

  HTP.htmlOpen;
  HTP.PRINT('<HEAD><META http-equiv=Content-Type content="text/html; charset=GB2312"></HEAD>');
  HTP.bodyOpen;
  
  ----min period num
 SELECT MIN(offset.period_num)
    INTO v_period_min_num
    FROM gl_period_statuses offset,
         gl_period_statuses poi,
         gl_period_types    ptype
   WHERE poi.period_year = p_period_year AND
         offset.period_type = poi.period_type AND
         ptype.period_type = poi.period_type AND
         poi.period_year * ptype.number_per_fiscal_year + poi.period_num + 0 >=
         offset.period_year * ptype.number_per_fiscal_year + 1 AND
         poi.period_year * ptype.number_per_fiscal_year + poi.period_num + 0 <=
         offset.period_year * ptype.number_per_fiscal_year +
         ptype.number_per_fiscal_year AND
         offset.application_id = poi.application_id AND
         offset.set_of_books_id = poi.set_of_books_id AND
         poi.set_of_books_id = p_sob_id AND poi.application_id = 101;

  --年初数用期初数代替
  --v_period_min_num:=p_period_num;
begin
  select user_name
    into v_user
    from xxafx_user_profile_line
   where user_id = p_zbr
     and rownum < 2;

  select user_name
    into v_appro
    from xxafx_user_profile_line
   where user_id = p_fhr
     and rownum < 2;
    
   --COMPANY为空时显示帐套名称2008-1-24 by yxh 
   if p_company_id is not null then   
  select company_name
    into v_company
    from xxafx_user_profile_line
   where company_id = p_company_id
     and rownum < 2;
   else
  select t.description
    into v_company
    from gl_sets_of_books t
   where t.set_of_books_id = p_sob_id
     and rownum < 2;
  end if;
 EXCEPTION
    WHEN OTHERS THEN
      htp.P('公司ID或USER ID参数有误！');
  end;
v_month := p_period_num;
 
INSERT INTO xxafx_afx_bs(
  PERIOD_NUM,
  STANDARD_CODE,
  CONVERTED_CODE,
  DESCRIPTION,
  RESULT_1,
  RESULT_2,
  SET_OF_BOOKS_ID,
  CURRENCY_CODE)
SELECT gb.period_num,
       ca.standard_code,
       ca.converted_code,
       ca.description,
       SUM(nvl(gb.begin_balance_dr, 0) - nvl(gb.begin_balance_cr, 0)),
       SUM(nvl(gb.begin_balance_dr, 0) - nvl(gb.begin_balance_cr, 0) +
               nvl(gb.period_net_dr, 0) - nvl(gb.period_net_cr, 0)),
       p_sob_id,
       p_currency_code 
      FROM gl_balances                 gb,
           xxafx_stx_converted_account ca,
           gl_code_combinations        gcc
     WHERE gcc.code_combination_id = gb.code_combination_id  AND
           gcc.segment3 = ca.converted_code  AND
           gcc.segment1 = nvl(p_company_id,gcc.segment1) and
           gb.currency_code = p_currency_code AND
           gb.period_year = p_period_year and
           nvl(gcc.summary_flag,'N') <> 'Y' and
           (gb.period_num = v_period_min_num or gb.period_num = v_month) and
           gb.set_of_books_id = p_sob_id  and
           ca.set_of_books_id = p_sob_id 
     group by ca.standard_code,
              ca.converted_code,
              ca.description,
              gb.period_num;
             
--取该区间的最后一天日期
   select substr(p_start_date,6,2),
          substr(p_end_date,9,2)
     into v_title_month,
          v_day
     from dual;

       --TITLE显示会计期间
    select gps.period_name
      into v_period_name
      from gl_period_statuses gps
     where gps.effective_period_num = p_period_id
       and gps.application_id = 101
       and gps.set_of_books_id = p_sob_id;
      
       p_date_title_str := v_period_name;
      
  --IF substr(p_start_date,6,2) = '12' THEN
  --p_date_title_str := p_period_year || '年度';
  --ELSE
  --p_date_title_str := p_period_year || '年' || v_title_month || '月' || v_day || '日';
  --END IF;
 
  --Fetch date accord to standard account for bs
  --------------------------------------------------ASSET-------------------------------------------------

  SELECT SUM(result_1) --货币资金r1
    INTO v_r1_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 3) = '100' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --货币资金r1
    INTO v_r1_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 3) = '100' AND period_num = v_month;

  SELECT SUM(result_1) --短期投资-短期投资跌价准备r2
    INTO v_r2_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         (SUBSTR(standard_code, 1, 4) = '1101' OR
         SUBSTR(standard_code, 1, 4) = '1102') AND period_num = v_period_min_num;

  SELECT SUM(result_2) --短期投资-短期投资跌价准备r2
    INTO v_r2_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         (SUBSTR(standard_code, 1, 4) = '1101' OR
         SUBSTR(standard_code, 1, 4) = '1102') AND period_num = v_month;

  SELECT SUM(result_1) --应收票据r3
    INTO v_r3_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1111' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --应收票据r3
    INTO v_r3_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1111' AND period_num = v_month;

  SELECT SUM(result_1) --应收股利r4
    INTO v_r4_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1121' AND period_num = v_period_min_num;

  SELECT SUM(result_2)  --应收股利r4
    INTO v_r4_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1121' AND period_num = v_month;

  SELECT SUM(result_1) --应收利息r5
    INTO v_r5_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1122' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --应收利息r5
    INTO v_r5_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1122' AND period_num = v_month;

  SELECT SUM(result_1) --应收账款+减:坏帐准备r6
    INTO v_r6_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         (SUBSTR(standard_code, 1, 4) = '1131' OR
         SUBSTR(standard_code, 1, 4) = '1141') AND period_num = v_period_min_num;

  SELECT SUM(result_2) --应收账款+减:坏帐准备r6
    INTO v_r6_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         (SUBSTR(standard_code, 1, 4) = '1131' OR
         SUBSTR(standard_code, 1, 4) = '1141') AND period_num = v_month;

  SELECT SUM(result_1) --其他应收款r7
    INTO v_r7_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1133' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --其他应收款r7
    INTO  v_r7_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1133' AND period_num = v_month;

  SELECT SUM(result_1) --预付账款r8
    INTO v_r8_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1151' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --预付账款r8
    INTO v_r8_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1151' AND period_num = v_month;

  SELECT SUM(result_1)--应收补贴款r9
    INTO v_r9_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1161' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --应收补贴款r9
    INTO v_r9_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1161' AND period_num = v_month;

  SELECT SUM(result_1) --Internal transaction
    INTO v_internal_1 --"1"开头,且未在以上科目中计算的,此处只含"待处理财产损溢"
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1181' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --Internal transaction
    INTO v_internal_2 --"1"开头,且未在以上科目中计算的,此处只含"待处理财产损溢"
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1181' AND period_num = v_month;

  SELECT SUM(result_1) --存货r10
    INTO v_r10_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         period_num = v_period_min_num AND
         SUBSTR(standard_code, 1, 2) = '12' OR LPAD(standard_code, 1) = 4;

  SELECT SUM(result_2) --存货r10
    INTO v_r10_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         period_num = v_month AND
         SUBSTR(standard_code, 1, 2) = '12' OR LPAD(standard_code, 1) = 4;
 
  SELECT SUM(result_1) --待摊费用r11
    INTO v_r11_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1301' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --待摊费用r11
    INTO v_r11_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1301' AND period_num = v_month;

  SELECT SUM(result_1) --其他流动资产r24
    INTO v_r24_c1 --"1"开头,且未在以上科目中计算的,此处只含"待处理财产损溢"
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) in ('1181','1191') AND period_num = v_period_min_num;

  SELECT SUM(result_2) --其他流动资产r24
    INTO v_r24_c2 --"1"开头,且未在以上科目中计算的,此处只含"待处理财产损溢"
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) in ('1181','1191') AND period_num = v_month;

  v_reivable_1 := NVL(v_internal_1, 0) + NVL(v_r24_c1, 0);
  v_reivable_2 := NVL(v_internal_2, 0) + NVL(v_r24_c2, 0);

  v_r31_c1 := NVL(v_r1_c1, 0) + NVL(v_r2_c1, 0) + --流动资产合计r31
              NVL(v_r3_c1, 0) + NVL(v_r4_c1, 0) + NVL(v_r5_c1, 0) +
              NVL(v_r7_c1, 0) + NVL(v_r8_c1, 0) + NVL(v_r9_c1, 0) +
              NVL(v_r10_c1, 0) + NVL(v_r11_c1, 0) + NVL(v_r6_c1, 0) +
              NVL(v_reivable_1, 0);

  v_r31_c2 := NVL(v_r1_c2, 0) + NVL(v_r2_c2, 0) + NVL(v_r3_c2, 0) +
              NVL(v_r4_c2, 0) + NVL(v_r5_c2, 0) + NVL(v_r7_c2, 0) +
              NVL(v_r8_c2, 0) + NVL(v_r9_c2, 0) + NVL(v_r10_c2, 0) +
              NVL(v_r11_c2, 0) + NVL(v_r6_c2, 0) + NVL(v_reivable_2, 0);

  SELECT SUM(result_1) --长期股权投资r32
    INTO v_r32_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1401' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --长期股权投资r32
    INTO v_r32_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1401' AND period_num = v_month;

  SELECT SUM(result_1) --长期债权投资+委托贷款r34
    INTO v_r34_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) in ('1402', '1421', '1431') AND period_num = v_period_min_num;

  SELECT SUM(result_2) --长期债权投资+委托贷款r34
    INTO v_r34_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) in ('1402', '1421', '1431') AND period_num = v_month;

  v_r38_c1 := NVL(v_r32_c1, 0) + NVL(v_r34_c1, 0); --长期投资合计r38
  v_r38_c2 := NVL(v_r32_c2, 0) + NVL(v_r34_c2, 0);

  SELECT SUM(result_1) --固定资产原价r39
    INTO v_r39_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1501' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --固定资产原价r39
    INTO v_r39_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1501' AND period_num = v_month;

  SELECT SUM(result_1) --减:累计折旧r40
    INTO v_r40_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1502' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --减:累计折旧r40
    INTO v_r40_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1502' AND period_num = v_month;

  v_r41_c1 := NVL(v_r39_c1, 0) + NVL(v_r40_c1, 0); --固定资产净值r41
  v_r41_c2 := NVL(v_r39_c2, 0) + NVL(v_r40_c2, 0);

  SELECT SUM(result_1) --减:固定资产减值准备r42
    INTO v_r42_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1505' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --减:固定资产减值准备r42
    INTO v_r42_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1505' AND period_num = v_month;

  v_r43_c1 := NVL(v_r41_c1, 0) + NVL(v_r42_c1, 0); --固定资产净额=固定资产净值+减:固定资产减值准备r43
  v_r43_c2 := NVL(v_r41_c2, 0) + NVL(v_r42_c2, 0);

  SELECT SUM(result_1) --工程物资r44
    INTO v_r44_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1601' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --工程物资r44
    INTO v_r44_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1601' AND period_num = v_month;

  SELECT SUM(result_1) --在建工程-在建工程减值准备r45
    INTO v_r45_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         (SUBSTR(standard_code, 1, 4) = '1603' OR
         SUBSTR(standard_code, 1, 4) = '1605') AND period_num = v_period_min_num;

  SELECT SUM(result_2) --在建工程-在建工程减值准备r45
    INTO v_r45_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         (SUBSTR(standard_code, 1, 4) = '1603' OR
         SUBSTR(standard_code, 1, 4) = '1605') AND period_num = v_month;

  SELECT SUM(result_1) --固定资产清理r46
    INTO v_r46_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1701' AND period_num = v_period_min_num;

  SELECT SUM(result_2) --固定资产清理r46
    INTO v_r46_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         SUBSTR(standard_code, 1, 4) = '1701' AND period_num = v_month;

  v_r50_c1 := NVL(v_r39_c1, 0) + NVL(v_r40_c1, 0) --固定资产合计r50
              + NVL(v_r42_c1, 0) + NVL(v_r44_c1, 0) + NVL(v_r45_c1, 0) +
              NVL(v_r46_c1, 0);

  v_r50_c2 := NVL(v_r39_c2, 0) + NVL(v_r40_c2, 0) + NVL(v_r42_c2, 0) +
              NVL(v_r44_c2, 0) + NVL(v_r45_c2, 0) + NVL(v_r46_c2, 0);

  SELECT SUM(result_1) --无形资产-无形资产减值准备r51
    INTO v_r51_c1
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books_id = p_sob_id AND
         (SUBSTR(standard_code, 1, 4) = '1801' OR
         SUBSTR(standard_code, 1, 4) = '1805') AND period_num = v_period_min_num;

  SELECT SUM(result_2) --无形资产-无形资产减值准备r51
    INTO v_r51_c2
    FROM xxafx_afx_bs
   WHERE currency_code = p_currency_code AND set_of_books

最低0.47元/天 解锁文章

200万优质内容无限畅学
yanj_yz
关注
EBS中HTML报表创建过程
IT一股清流的博客
08-25 1834
本文描述的HTML报表的创建过程只是作为一个操作的流程，具体说是一个创建思路，里面各种参数的设定还是用你们自己的数据，这里不涉及具体的数据设定。       需要的硬件：pc一台       需要的软件：PLSQL  Developer                             登陆EBS的账号密码                             pkg包（里面包括...
使用Razor+MVC+PartialView实现预览记账凭证的HTML页面
L.C's Tecnology Factory
11-14 4108
还是最近在搞的财务模块，由于WEB项目中是用datatables配合modal来实现凭证录入和管理的，看起来不够直观，所以尝试写了一个分部视图用来预览记账凭证。
EBS HTML报表开发过程
09-25
此手册为EBS html报表开发过程，包含如何在ebs中挂菜单等操作
oracle ebs 报表工具,Oracle EBS Html报表开发总结
weixin_36261385的博客
04-04 630
注意：在使用嵌套table的方法时要注意表头是作为一个table标签的，否则就会出现列不对应的情况，如下图。表头也使用嵌套，通过ID来标识它们的一一对应性。2) 在输出之前算好该标签的rowspan值例如在此报表中，月份的rospan值就应该是所有的二级组织的行数再加上所有的一级组织的行数(因为每个一级组织有个合计要算)，；然后一级组织的rospan值就是该一级组织下的所有二级组织的行数再加上1(...
ebs html报表文件名,Oracle EBS Html报表开发总结
weixin_39989939的博客
06-19 342
');for 一级组织 in (一级组织的所有信息)loop在此处查询该一级组织下的二级组织的个数 ln_row1fnd_file.put_line(fnd_file.output,'');for 二级组织 in(根据一级组织查询的所有二级组织的信息) loop从报表可知该rowspan 值为1fnd_file.put_line(fnd_file.output,'');endloop;end ...
财务表格大全.html
12-19
财务表格大全.html
Oracle EBS财务报表模块：自动化报表与决策支持的高效方法
本文详细介绍了Oracle EBS财务报表模块的基本概念、自动化理论、实践案例及决策支持系统的构建方法。通过阐述自动化报表设计原则、技术实现以及优化实践技巧，本文旨在提高报表的效率、用户体验和数据质量。同时，...
【Oracle EBS报表制作速成】：快速生成财务报表的5大高效方法
!... # 摘要 Oracle EBS（Enterprise Business Suite）报表是企业财务和运营分析的关键工具，它涉及从基础数据的...文章深入探讨了高效制作Oracle EBS财务报表的方法，如利用自动化工具、编写高效SQL查询以及报表的格式
EBS 多sheet页Excel动态报表开发过程
04-16
标题中的“EBS多sheet页Excel动态报表开发过程”指的是在企业资源规划系统（Enterprise Business Suite，简称EBS）中创建能够根据数据变化自动更新、包含多个工作表（sheet）的Excel报表的过程。EBS是Oracle公司提供...
EBS HTML报表开发指南及范本包
手册可能包含了模板使用方法、标记替换规则、样式设计指南和调试技巧等关键信息。 2. **cux_person_pql_html_pkg.pck**：这个文件的名称暗示它可能是一个包含了HTML报表模板的Oracle Personalization包（.pck）。在...
ebs html 图表无数据库,Oracle-EBS-Html报表开发总结（12页）-原创力文档
weixin_39908263的博客
06-04 166
Oracle EBS Html 报表开发总结一 需求分析1 确认需求1.1 确定参数类型、个数，可否为空，是否必输。1.2 提炼、分析和自习审查已经收集到的需求，以确保所有的风险承担者都明确其含义并找到其中的错误和其他不足的地方(在必要的情况下向顾问提出改进建议) ；1.3 确认报表样式、 title ...
账务账户Html页面
09-30
账务账户的HTML页面的编码，很有用的属于美工页面哦
html财务统计,财务统计.html
weixin_27038701的博客
06-04 130
众创数字资产综合运营管理平台年份请选择2017201620152014今日近7天近30天查询2016-12-01 至 2016-12-28共计：成交数量：1800商品成本：1200000.00成交金额：1200000.00成交AGR：1200000平台成交数量：1800平台商品成本：1200000.00平台成交金额：1200000.00平台成交AGR：1200000第三方成交数量：1800第三方商...
HTML 发展顺序 财务,HTML蓝色大气形式财务储蓄网页模板代码
weixin_31869579的博客
06-05 127
模板描述：蓝色 大气形式 财务储蓄。HTML蓝色大气形式财务储蓄网页模板代码HTML模板下载代码结构1. 引入CSS2. HTML代码Lorem ipsum dolor sit amet, consectetuepcing erat volutpat. Ut wisi enim ad minim veniam. Quis nostrud exerci tation ullamcorper ...
ebs htp 使用
cpcmsin069902805的博客
05-08 134
ebs htp 使用 产生html链接:http://space.itpub.net/11969955/viewspace-53138 ...
EBS WEB PL/SQL
weixin_34146410的博客
05-10 438
EBS的用户登录成功后，在数据库里用存储过程把该用户所拥有的权限以HTML连接的形式OUTPUT到浏览器里，用户可以点击连接来打开应用的，这里用到Web PL/SQL技术，就是用存储过程产生的东西可以OUTPUT到浏览器来。...................下面是一个例子，在数据库里有一存储过程，该过程OUTPUT一句话Hello Web PL/SQL到用户的浏览器中：1...
看懂财务报表<一>资产负债表
changyanmanman的专栏
06-23 2339
转载文章：
原生html—摆脱ps、excel 在线绘制财务表格加水印（html绘制表格js加水印）
编程知识分享，主打前端
07-28 3万+
大家好，我是yma16，本文分享原生html——绘制表格报表加水印。 背景：解决没有ps的情况下使用前端html制作表格报表。
EBS中二次开发FSG报表2(SQL)
Shawn的ADF空间
01-30 3050
环境： EBS R12, jasperreport, iReport 以资产负债表为例描述下EBS中二次开发FSG报表。 1，定义FSG报表（网上资料很多） Responsibility: GL 定义Row Set -> 定义Column Set -> 定义FSG Report Row Set：按顺序定义好各个Row Name（Line Items），可以使用Accoun
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值