1       17:05:41  SQL Execute: ORACLE - select z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000,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(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='1639' 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) 

2       17:05:41  SQL Data In: ORACLE - Param = 1, Name = PDWID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1639.000000
3       17:05:41  SQL Data In: ORACLE - Param = 2, Name = PDWTJCS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
4       17:05:41  SQL Data In: ORACLE - Param = 3, Name = PTJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
5       17:05:41  SQL Data In: ORACLE - Param = 4, Name = PJSFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
6       17:05:41  SQL Data In: ORACLE - Param = 5, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
7       17:05:41  SQL Data In: ORACLE - Param = 6, Name = PDWZBID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
8       17:05:41  SQL Data In: ORACLE - Param = 7, Name = PBMMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
9       17:05:41  SQL Data In: ORACLE - Param = 8, Name = PQSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20131228
10      17:05:41  SQL Data In: ORACLE - Param = 9, Name = PJSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20131228
11      17:05:41  SQL Data In: ORACLE - Param = 10, Name = PSFJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
12      17:05:41  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;
13      17:05:41  SQL Execute: ORACLE - commit

14      17:05:41  SQL Data In: ORACLE - Rows affected = 0
15      17:05:41  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='1639' UNION SELECT FPXMID,FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(100*ZHJE00/HJJE00,0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND HJJE00<>0 AND DWID00='1639' UNION SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000) SL0000,TO_CHAR(nvl(TJDJ00,ROUND(HJJE00/SL0000,3))) DJ0000,ROUND(100*ZHJE00/HJJE00,0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID<>-1 AND HJJE00<>0 AND DWID00='1639' ORDER BY FPXMID,SFXMID