1       09:23:35  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'T') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',125,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1143
  AND b.JSKSBH = '125')
  AND (INSTR (',' || a.jsksbh || ',',',125,') > 0 or a.jsksbh is null)  

2       09:23:36  SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=1297

3       09:23:36  SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00
 where DWID00='1297'

4       09:23:36  SQL Execute: ORACLE - select distinct BMMC00 from BM_BRXXB0 where TYDWID='1297'

5       09:23:36  SQL Execute: ORACLE - select z.fjf000+z.zhje00 zje000,z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000,round(100*z.zhje00/decode(z.je0000,0,1,z.je0000),2) zkl000,z.FJF000 FJF000,z.rs0000,ROUND(z.dj0000,3) dj0000,z.zlxmid,s.zlxmjc xmmc00 from ( select sum(sl0000) rs0000,dj0000,sum(zje000) je0000,sum(zhje00) zhje00,sum(FJF000) FJF000,zlxmid from 
(select sl0000,jzje00-FJF000 zje000,round((jzje00-FJF000)*(zhje00/decode(zje000,0,1,zje000)),2) zhje00,fjf000,zlxmid,zje000/sl0000 dj0000 from ( select a.sl0000,sum(d.jzje00) jzje00,nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,a.fjf000 fjf001,(select nvl(sum(jzje00),0) from yj_ywjj00  where yjdjh0=a.yjdjh0 and FJFYBZ='Y') FJF000,a.zlxmid
from TJ_YJDJH0 a,yj_ywjj00 d,tj_brxxb0 c,bm_tydwb0 e where  a.yjdjh0=d.yjdjh0 and c.dwid00=e.dwid00 and  exists (select 1 from sf_brfy00 f,sf_fymx00 h  where f.jzdh00+0=0 and f.djh000=h.djh000 and f.brid00=e.brid00 and h.yjdjh0=a.yjdjh0) and  c.dwid00='1297' and c.dwtjcs='1' and c.dwid00=a.dwid00 and a.ghid00=c.ghid00 and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null))  and a.xmzt00 in ('2','3','D') and NVL(a.SFJZ00,'N')<>'Y' group by a.sl0000,a.zje000,a.zhje00,a.FJF000,a.zlxmid,a.yjdjh0,a.yjksbh)) y group by zlxmid,zhje00,fjf000,dj0000) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid  and (z.je0000<>0 or FJF000<>0) 

6       09:23:39  SQL Execute: ORACLE - BEGIN "SP_TJ_DWSFTJ" (PDWID00 => :PDWID00,PDWTJCS => :PDWTJCS,PTJLB00 => :PTJLB00,PJSFS00 => :PJSFS00,PJZDH00 => :PJZDH00,PDWZBID => :PDWZBID,PBMMC00 => :PBMMC00,PQSRQ00 => :PQSRQ00,PJSRQ00 => :PJSRQ00,PSFJS00 => :PSFJS00); END;
7       09:23:42  SQL Execute: ORACLE - commit

8       09:23:42  SQL Execute: ORACLE - SELECT 0 FPXMID,'×ܼÆ' XMMC00,0 SFXMID,ROUND(SUM(HJJE00),2) HJJE00,ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000,'' DJ0000,ROUND(100*SUM(ZHJE00)/SUM(HJJE00),2) ZKL000 FROM TJ_DWSFTJ WHERE SFXMID<>-1 AND DWID00='1297' UNION ALL SELECT FPXMID,FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(100*ZHJE00/HJJE00,2) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND HJJE00<>0 AND DWID00='1297' UNION ALL SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000) SL0000,TO_CHAR(nvl(TJDJ00,ROUND(HJJE00/SL0000,3))) DJ0000,ROUND(100*ZHJE00/HJJE00,2) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID<>-1 AND HJJE00<>0 AND DWID00='1297' ORDER BY FPXMID,SFXMID

9       09:23:42  SQL Execute: ORACLE - select NVL(sum(ZFJE00),0) ZFJE from sf_fymx00 where DJH000 in (select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='4425359' and b.xmbh00= '2917' and jzdh00 = '0')

10      09:23:45  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'T') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',125,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1143
  AND b.JSKSBH = '125')
  AND (INSTR (',' || a.jsksbh || ',',',125,') > 0 or a.jsksbh is null)