1       08:39:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20107007.000000
2       08:39:53  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000,
 (select SBMC00 from  SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00
from yj_ywmx00 a
where yjdjh0=?

3       08:39:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20107006.000000
4       08:39:53  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000,
 (select SBMC00 from  SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00
from yj_ywmx00 a
where yjdjh0=?

5       08:39:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20107007.000000
6       08:39:53  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000,
 (select SBMC00 from  SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00
from yj_ywmx00 a
where yjdjh0=?

7       08:39:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 833978.000000
8       08:39:53  SQL Execute: ORACLE - select B.YBZXLB,A.YBBRLB, A.FBBH00  from   BM_BRXXB0 a,IC_YBBRLB b  where  A.BRID00=? AND B.YBLB00=a.YBLB00 and B.FBBH00=a.FBBH00 

9       08:39:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20107007.000000
10      08:39:53  SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00,
J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and Yjdjh0=?

11      08:39:53  SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20107007.000000
12      08:39:53  SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
13      08:39:53  SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
14      08:39:53  SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
15      08:39:53  SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6667
16      08:39:53  SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
17      08:39:53  SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END;
18      08:39:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20107007.000000
19      08:39:54  SQL Execute: ORACLE - select b.LBBH00,DCBZ00 from YJ_YW0000 a,BM_ZLZD00 b WHERE a.YJDJH0=? AND a.ZLXMID=b.ZLXMID 

20      08:39:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20107006.000000
21      08:39:54  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000,
 (select SBMC00 from  SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00
from yj_ywmx00 a
where yjdjh0=?

22      08:39:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 833978.000000
23      08:39:54  SQL Execute: ORACLE - select B.YBZXLB,A.YBBRLB, A.FBBH00  from   BM_BRXXB0 a,IC_YBBRLB b  where  A.BRID00=? AND B.YBLB00=a.YBLB00 and B.FBBH00=a.FBBH00 

24      08:39:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20107006.000000
25      08:39:54  SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00,
J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and Yjdjh0=?

26      08:39:54  SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20107006.000000
27      08:39:54  SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
28      08:39:54  SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
29      08:39:54  SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
30      08:39:54  SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6667
31      08:39:54  SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
32      08:39:54  SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END;
33      08:39:55  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20107006.000000
34      08:39:55  SQL Execute: ORACLE - select b.LBBH00,DCBZ00 from YJ_YW0000 a,BM_ZLZD00 b WHERE a.YJDJH0=? AND a.ZLXMID=b.ZLXMID 

35      08:39:55  SQL Execute: ORACLE - Select SYSDATE from Dual

36      08:39:55  SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'

37      08:39:55  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')

38      08:39:55  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = '0221094090255529'
and ICKNBH = '0221094090255529'

39      08:39:55  SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 833978.000000
40      08:39:55  SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
41      08:39:55  SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
42      08:39:55  SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
43      08:39:55  SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
44      08:39:55  SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
45      08:39:55  SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
46      08:39:55  SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
47      08:39:55  SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
48      08:39:55  SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
49      08:39:55  SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
50      08:39:55  SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
51      08:39:55  SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
52      08:39:55  SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
53      08:39:55  SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
54      08:39:55  SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
55      08:39:55  SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
56      08:39:55  SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END;
57      08:39:55  SQL Execute: ORACLE - select a.DAXXID,a.SBMC00 from VW_SB_SYKS00_YJ a,BM_ZLZD00 b,XT_KSZXXM c
 where b.ZLXMID=c.ZLXMID and a.DAXXID=c.DAXXID and c.ZXKSBH= 57 
 and c.ZLXMID= 2389 

58      08:39:55  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 833978.000000
59      08:39:55  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
60      08:39:55  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
61      08:39:55  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
62      08:39:55  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ,57,
63      08:39:55  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20141121
64      08:39:55  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20141128
65      08:39:55  SQL Execute: ORACLE - select rownum xh0000,decode(g.mzzybz,'0',g.zyhghh,to_char(g.zyghid)) JKSJH0,g.* from (
Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,(select BRBLH0 from bm_brxxb0 where BRID00=b.BRID00) BRBLH0,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,substr(b.brnl00,1,100) brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC, b.BRZJBH,b.YBKH00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' 
 and xmzt00 in ('0','1','2')
 and b.mzzybz='0'
 and brid00=?
 and (YJKSBH=? or ( (((b.Zlxmid,b.kdksbh) in 
 (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) ))   
 and ( (',0,'=',0,') or  (instr(',0,',? )>0) ) )
)
 and kdrq00 between ? and ? 
 and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0
 order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid) g

66      08:39:55  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
67      08:39:55  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000,
 (select SBMC00 from  SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00
from yj_ywmx00 a
where yjdjh0=?