1 08:39:05 SQL Prepare: ORACLE - select 'N' sfxz00, rybh00, z.ghid00, je0000, zhje00, ROUND (100 * zhje00 / DECODE (je0000, 0, 1, je0000), 0) zkl000, fjf000, brxm00, brnl00, brxb00 FROM (SELECT ghid00, SUM (zje000) je0000, SUM (zhje00) zhje00, SUM (fjf000) fjf000 FROM (SELECT ghid00, jzje00 - fjf000 zje000, ROUND ( (jzje00 - fjf000) * (zhje00 / DECODE (zje000, 0, 1, zje000)),2) zhje00,fjf000 FROM ( (select a.GHID00,SUM(b.jzje00) jzje00,a.yjdjh0, nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,(select nvl(sum(jzje00),0) from yj_ywjj00 where yjdjh0=a.yjdjh0 and FJFYBZ='Y') FJF000 from TJ_YJDJH0 a,YJ_YWJJ00 b where a.yjdjh0=b.yjdjh0 and a.YJDJH0 in (select distinct e.YJDJH0 from SF_BRFY00 d,SF_FYMX00 e,TJ_YJDJH0 c where d.JZDH00='1911793' and d.DJH000=e.DJH000 and e.yjdjh0=c.yjdjh0 ) and a.dwid00='1089' and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) group by a.GHID00,a.zje000,a.zhje00,a.fjf000,a.yjdjh0 )) ) y GROUP BY ghid00) z,tj_brxxb0 s WHERE s.ghid00 = z.ghid00 AND z.je0000 <> 0 ORDER BY rybh00 2 08:39:05 SQL Execute: ORACLE - select 'N' sfxz00, rybh00, z.ghid00, je0000, zhje00, ROUND (100 * zhje00 / DECODE (je0000, 0, 1, je0000), 0) zkl000, fjf000, brxm00, brnl00, brxb00 FROM (SELECT ghid00, SUM (zje000) je0000, SUM (zhje00) zhje00, SUM (fjf000) fjf000 FROM (SELECT ghid00, jzje00 - fjf000 zje000, ROUND ( (jzje00 - fjf000) * (zhje00 / DECODE (zje000, 0, 1, zje000)),2) zhje00,fjf000 FROM ( (select a.GHID00,SUM(b.jzje00) jzje00,a.yjdjh0, nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,(select nvl(sum(jzje00),0) from yj_ywjj00 where yjdjh0=a.yjdjh0 and FJFYBZ='Y') FJF000 from TJ_YJDJH0 a,YJ_YWJJ00 b where a.yjdjh0=b.yjdjh0 and a.YJDJH0 in (select distinct e.YJDJH0 from SF_BRFY00 d,SF_FYMX00 e,TJ_YJDJH0 c where d.JZDH00='1911793' and d.DJH000=e.DJH000 and e.yjdjh0=c.yjdjh0 ) and a.dwid00='1089' and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) group by a.GHID00,a.zje000,a.zhje00,a.fjf000,a.yjdjh0 )) ) y GROUP BY ghid00) z,tj_brxxb0 s WHERE s.ghid00 = z.ghid00 AND z.je0000 <> 0 ORDER BY rybh00 3 08:39:07 SQL Prepare: ORACLE - select z.fjf000+z.zhje00 zje000,z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000, decode(z.je0000, 0, 0, ROUND(100 * z.zhje00 / decode(z.je0000,0,1,z.je0000), 0)) 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(b.jzje00) jzje00,b.yjdjh0, nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,a.zlxmid,(select nvl(sum(jzje00),0) from yj_ywjj00 where yjdjh0=b.yjdjh0 and FJFYBZ='Y') FJF000 from TJ_YJDJH0 a,YJ_YWJJ00 b where a.yjdjh0=b.yjdjh0 and a.YJDJH0 in (select distinct e.YJDJH0 from SF_BRFY00 d,SF_FYMX00 e,TJ_YJDJH0 c where d.JZDH00='1911793' and d.DJH000=e.DJH000 and e.yjdjh0=c.yjdjh0 ) and a.dwid00='1089' and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) group by b.YJDJH0,A.sl0000,a.zje000,a.zhje00,a.zlxmid,a.FJF000) ) y group by zlxmid,zhje00,dj0000 ) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid 4 08:39:07 SQL Execute: ORACLE - select z.fjf000+z.zhje00 zje000,z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000, decode(z.je0000, 0, 0, ROUND(100 * z.zhje00 / decode(z.je0000,0,1,z.je0000), 0)) 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(b.jzje00) jzje00,b.yjdjh0, nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,a.zlxmid,(select nvl(sum(jzje00),0) from yj_ywjj00 where yjdjh0=b.yjdjh0 and FJFYBZ='Y') FJF000 from TJ_YJDJH0 a,YJ_YWJJ00 b where a.yjdjh0=b.yjdjh0 and a.YJDJH0 in (select distinct e.YJDJH0 from SF_BRFY00 d,SF_FYMX00 e,TJ_YJDJH0 c where d.JZDH00='1911793' and d.DJH000=e.DJH000 and e.yjdjh0=c.yjdjh0 ) and a.dwid00='1089' and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) group by b.YJDJH0,A.sl0000,a.zje000,a.zhje00,a.zlxmid,a.FJF000) ) y group by zlxmid,zhje00,dj0000 ) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid 5 08:39:10 SQL Prepare: 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; 6 08:39:10 SQL Data In: ORACLE - Param = 1, Name = PDWID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1089.000000 7 08:39:10 SQL Data In: ORACLE - Param = 2, Name = PDWTJCS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 8 08:39:10 SQL Data In: ORACLE - Param = 3, Name = PTJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 9 08:39:10 SQL Data In: ORACLE - Param = 4, Name = PJSFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 10 08:39:10 SQL Data In: ORACLE - Param = 5, Name = PJZDH00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1911793 11 08:39:10 SQL Data In: ORACLE - Param = 6, Name = PDWZBID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 12 08:39:10 SQL Data In: ORACLE - Param = 7, Name = PBMMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 13 08:39:10 SQL Data In: ORACLE - Param = 8, Name = PQSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 14 08:39:10 SQL Data In: ORACLE - Param = 9, Name = PJSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 15 08:39:10 SQL Data In: ORACLE - Param = 10, Name = PSFJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 16 08:39:10 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; 17 08:39:10 SQL Prepare: 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),0) ZKL000 FROM TJ_DWSFTJ WHERE SFXMID <> -1 AND DWID00 = '1089' UNION ALL SELECT FPXMID, FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(100*ZHJE00/decode(HJJE00,0,1,HJJE00),0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND DWID00='1089' UNION ALL SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000),TO_CHAR(nvl(TJDJ00,ROUND(HJJE00/SL0000,3))) DJ0000,ROUND(100*ZHJE00/decode(HJJE00,0,1,HJJE00),0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID <> -1 AND DWID00='1089' ORDER BY FPXMID, SFXMID 18 08:39:10 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),0) ZKL000 FROM TJ_DWSFTJ WHERE SFXMID <> -1 AND DWID00 = '1089' UNION ALL SELECT FPXMID, FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(100*ZHJE00/decode(HJJE00,0,1,HJJE00),0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND DWID00='1089' UNION ALL SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000),TO_CHAR(nvl(TJDJ00,ROUND(HJJE00/SL0000,3))) DJ0000,ROUND(100*ZHJE00/decode(HJJE00,0,1,HJJE00),0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID <> -1 AND DWID00='1089' ORDER BY FPXMID, SFXMID 19 08:39:10 SQL Prepare: ORACLE - select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='4177944' and b.xmbh00= '2917' and JZDH00 ='1911793' 20 08:39:10 SQL Execute: ORACLE - select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='4177944' and b.xmbh00= '2917' and JZDH00 ='1911793' 21 08:39:10 SQL Prepare: ORACLE - Select NVL(sum(HJJE00),0) ZKE000 FROM sf_fymx00 WHERE DJH000 = '' 22 08:39:10 SQL Execute: ORACLE - Select NVL(sum(HJJE00),0) ZKE000 FROM sf_fymx00 WHERE DJH000 = ''