1       15:33:42  SQL Prepare: 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=:1

2       15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68407149.000000
3       15:33:42  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=?

4       15:33:42  SQL Prepare: 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=:1

5       15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68416375.000000
6       15:33:42  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       15:33:42  SQL Prepare: 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=:1

8       15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68420136.000000
9       15:33:42  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=?

10      15:33:42  SQL Prepare: 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=:1

11      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68423610.000000
12      15:33:42  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=?

13      15:33:42  SQL Prepare: 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=:1

14      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68425023.000000
15      15:33:42  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=?

16      15:33:42  SQL Prepare: 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=:1

17      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68425266.000000
18      15:33:42  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=?

19      15:33:42  SQL Prepare: 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=:1

20      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68428272.000000
21      15:33:42  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      15:33:42  SQL Prepare: 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=:1

23      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68429552.000000
24      15:33:42  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=?

25      15:33:42  SQL Prepare: 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=:1

26      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68429793.000000
27      15:33:42  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=?

28      15:33:42  SQL Prepare: 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=:1

29      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68429789.000000
30      15:33:42  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=?

31      15:33:42  SQL Prepare: 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=:1

32      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68429858.000000
33      15:33:42  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=?

34      15:33:42  SQL Prepare: 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=:1

35      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68429904.000000
36      15:33:42  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=?

37      15:33:42  SQL Prepare: 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=:1

38      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68430694.000000
39      15:33:42  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=?

40      15:33:42  SQL Prepare: 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=:1

41      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68431122.000000
42      15:33:42  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=?

43      15:33:42  SQL Prepare: 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=:1

44      15:33:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68431122.000000
45      15:33:42  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=?

46      15:33:42  SQL Prepare: ORACLE - select a.*  from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') 
 and  XMWHID=20
 and a.YYRQ00='20150505'
 and a.PBSXW0='上午'
 order by a.KSPBSJ,a.XH0000  

47      15:33:42  SQL Execute: ORACLE - select a.*  from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') 
 and  XMWHID=20
 and a.YYRQ00='20150505'
 and a.PBSXW0='上午'
 order by a.KSPBSJ,a.XH0000  

48      15:33:42  SQL Prepare: ORACLE - select SF_YJ_YYYRSXS(94,20,16240,0,'20150505') TS0000 from dual 

49      15:33:42  SQL Execute: ORACLE - select SF_YJ_YYYRSXS(94,20,16240,0,'20150505') TS0000 from dual 

50      15:33:43  SQL Prepare: 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=:1

51      15:33:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68407149.000000
52      15:33:43  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=?

53      15:33:43  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68407149) MSG000 from dual

54      15:33:43  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68407149) MSG000 from dual

55      15:33:43  SQL Prepare: 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=:1

56      15:33:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68416375.000000
57      15:33:43  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=?

58      15:33:43  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68416375) MSG000 from dual

59      15:33:43  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68416375) MSG000 from dual

60      15:33:44  SQL Prepare: 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=:1

61      15:33:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68420136.000000
62      15:33:44  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=?

63      15:33:44  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68420136) MSG000 from dual

64      15:33:44  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68420136) MSG000 from dual

65      15:33:44  SQL Prepare: 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=:1

66      15:33:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68423610.000000
67      15:33:44  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=?

68      15:33:44  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68423610) MSG000 from dual

69      15:33:44  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68423610) MSG000 from dual

70      15:33:44  SQL Prepare: 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=:1

71      15:33:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68425023.000000
72      15:33:44  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=?

73      15:33:44  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68425023) MSG000 from dual

74      15:33:44  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68425023) MSG000 from dual

75      15:33:45  SQL Prepare: 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=:1

76      15:33:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68425266.000000
77      15:33:45  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=?

78      15:33:45  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68425266) MSG000 from dual

79      15:33:45  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68425266) MSG000 from dual

80      15:33:45  SQL Prepare: 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=:1

81      15:33:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68428272.000000
82      15:33:45  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=?

83      15:33:45  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68428272) MSG000 from dual

84      15:33:45  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68428272) MSG000 from dual

85      15:33:45  SQL Prepare: 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=:1

86      15:33:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68429552.000000
87      15:33:45  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=?

88      15:33:45  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68429552) MSG000 from dual

89      15:33:45  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68429552) MSG000 from dual

90      15:33:46  SQL Prepare: 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=:1

91      15:33:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68429793.000000
92      15:33:46  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=?

93      15:33:46  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68429793) MSG000 from dual

94      15:33:46  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68429793) MSG000 from dual

95      15:33:46  SQL Prepare: 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=:1

96      15:33:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68429789.000000
97      15:33:46  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=?

98      15:33:46  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68429789) MSG000 from dual

99      15:33:46  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68429789) MSG000 from dual

100     15:33:47  SQL Prepare: 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=:1

101     15:33:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68429858.000000
102     15:33:47  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=?

103     15:33:47  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68429858) MSG000 from dual

104     15:33:47  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68429858) MSG000 from dual

105     15:33:47  SQL Prepare: 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=:1

106     15:33:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68429904.000000
107     15:33:47  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=?

108     15:33:47  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68429904) MSG000 from dual

109     15:33:47  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68429904) MSG000 from dual

110     15:33:47  SQL Prepare: 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=:1

111     15:33:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68430694.000000
112     15:33:47  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=?

113     15:33:47  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68430694) MSG000 from dual

114     15:33:47  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68430694) MSG000 from dual

115     15:33:48  SQL Prepare: 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=:1

116     15:33:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68431122.000000
117     15:33:48  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=?

118     15:33:48  SQL Prepare: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END;
119     15:33:48  SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68431122.000000
120     15:33:48  SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
121     15:33:48  SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
122     15:33:48  SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
123     15:33:48  SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1738
124     15:33:48  SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000
125     15:33:48  SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
126     15:33:48  SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END;
127     15:33:50  SQL Prepare: 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=:1

128     15:33:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68431122.000000
129     15:33:50  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=?

130     15:33:50  SQL Prepare: 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=:1

131     15:33:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68431122.000000
132     15:33:50  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=?

133     15:33:50  SQL Prepare: 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=:1

134     15:33:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68431122.000000
135     15:33:50  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=?

136     15:33:50  SQL Prepare: 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=:1

137     15:33:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68431122.000000
138     15:33:50  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=?

139     15:33:50  SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(68431122) MSG000 from dual

140     15:33:50  SQL Execute: ORACLE - select SF_YJ_CheckedLocked(68431122) MSG000 from dual

141     15:33:50  SQL Prepare: 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=:1

142     15:33:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68431122.000000
143     15:33:50  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=?

144     15:33:50  SQL Prepare: ORACLE - select a.* from VW_YJ_JCPBYHMX a where HBXHID=812028   and BRXM00='林松'

145     15:33:50  SQL Execute: ORACLE - select a.* from VW_YJ_JCPBYHMX a where HBXHID=812028   and BRXM00='林松'

146     15:33:51  SQL Prepare: ORACLE - select count(*) COU from YJ_YW0000 where YJDJH0 in (68431122) and (nvl(SFDJH0,0)=0 or nvl(CXDJH0,0)>0) 

147     15:33:51  SQL Execute: ORACLE - select count(*) COU from YJ_YW0000 where YJDJH0 in (68431122) and (nvl(SFDJH0,0)=0 or nvl(CXDJH0,0)>0) 

148     15:33:51  SQL Prepare: ORACLE - select SF_YJ_GETJCYYDLQZ(0,'68431122','N',16240,812028) QZ0000 from dual

149     15:33:51  SQL Execute: ORACLE - select SF_YJ_GETJCYYDLQZ(0,'68431122','N',16240,812028) QZ0000 from dual

150     15:33:51  SQL Prepare: ORACLE - BEGIN "P_PACS_SCHEDULE" (PAPPLYNO => :PAPPLYNO,PEXAMSUBCLASS => :PEXAMSUBCLASS,PEXAMORGAN => :PEXAMORGAN,PEXAMGROUP => :PEXAMGROUP,PEXAMDEVICE => :PEXAMDEVICE,PSCHEDULEDDATE => :PSCHEDULEDDATE,PSCHEDULEDAPM => :PSCHEDULEDAPM,PQUEUECLASS => :PQUEUECLASS,PSUCC => :PSUCC,PPATLOCALID => :PPATLOCALID,PQUEUEDATE => :PQUEUEDATE,PQUEUEAPM => :PQUEUEAPM,PQUEUENO => :PQUEUENO); END;
151     15:33:51  SQL Data In: ORACLE - Param = 1, Name = PAPPLYNO, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 68431122
152     15:33:51  SQL Data In: ORACLE - Param = 2, Name = PEXAMSUBCLASS, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 放射
153     15:33:51  SQL Data In: ORACLE - Param = 3, Name = PEXAMORGAN, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
154     15:33:51  SQL Data In: ORACLE - Param = 4, Name = PEXAMGROUP, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
155     15:33:51  SQL Data In: ORACLE - Param = 5, Name = PEXAMDEVICE, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
156     15:33:51  SQL Data In: ORACLE - Param = 6, Name = PSCHEDULEDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150504
157     15:33:51  SQL Data In: ORACLE - Param = 7, Name = PSCHEDULEDAPM, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 09:00-10:00
158     15:33:51  SQL Data In: ORACLE - Param = 8, Name = PQUEUECLASS, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通
159     15:33:51  SQL Data In: ORACLE - Param = 9, Name = PSUCC, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
160     15:33:51  SQL Data In: ORACLE - Param = 10, Name = PPATLOCALID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
161     15:33:51  SQL Data In: ORACLE - Param = 11, Name = PQUEUEDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150505
162     15:33:51  SQL Data In: ORACLE - Param = 12, Name = PQUEUEAPM, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 09:00-10:00
163     15:33:51  SQL Data In: ORACLE - Param = 13, Name = PQUEUENO, Type = fldZSTRING, Precision = 5, Scale = 0, Data = DR038
164     15:33:51  SQL Execute: ORACLE - BEGIN "P_PACS_SCHEDULE" (PAPPLYNO => :PAPPLYNO,PEXAMSUBCLASS => :PEXAMSUBCLASS,PEXAMORGAN => :PEXAMORGAN,PEXAMGROUP => :PEXAMGROUP,PEXAMDEVICE => :PEXAMDEVICE,PSCHEDULEDDATE => :PSCHEDULEDDATE,PSCHEDULEDAPM => :PSCHEDULEDAPM,PQUEUECLASS => :PQUEUECLASS,PSUCC => :PSUCC,PPATLOCALID => :PPATLOCALID,PQUEUEDATE => :PQUEUEDATE,PQUEUEAPM => :PQUEUEAPM,PQUEUENO => :PQUEUENO); END;
165     15:33:51  SQL Prepare: ORACLE - BEGIN "SP_YJ_JCYYDJ" (PYYID00 => :PYYID00,PYJDJH0 => :PYJDJH0,PBZ0000 => :PBZ0000,PYYRQ00 => :PYYRQ00,PYYSJ00 => :PYYSJ00,PYYXH00 => :PYYXH00,PCZRXM0 => :PCZRXM0,PCZBZ00 => :PCZBZ00,PJCSQDH => :PJCSQDH,PRESULT => :PRESULT,PERROR0 => :PERROR0,PTZBH00 => :PTZBH00,PYYSD00 => :PYYSD00,PXSYYXH => :PXSYYXH,PPBHBID => :PPBHBID,PJZBZ00 => :PJZBZ00,PCZZT00 => :PCZZT00); END;
166     15:33:51  SQL Data In: ORACLE - Param = 1, Name = PYYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
167     15:33:51  SQL Data In: ORACLE - Param = 2, Name = PYJDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 68431122
168     15:33:51  SQL Data In: ORACLE - Param = 3, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
169     15:33:51  SQL Data In: ORACLE - Param = 4, Name = PYYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150505
170     15:33:51  SQL Data In: ORACLE - Param = 5, Name = PYYSJ00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 09:14
171     15:33:51  SQL Data In: ORACLE - Param = 6, Name = PYYXH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 38
172     15:33:51  SQL Data In: ORACLE - Param = 7, Name = PCZRXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 李华灿
173     15:33:51  SQL Data In: ORACLE - Param = 8, Name = PCZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
174     15:33:51  SQL Data In: ORACLE - Param = 9, Name = PJCSQDH, Type = fldZSTRING, Precision = 11, Scale = 0, Data = DR201419175
175     15:33:51  SQL Data In: ORACLE - Param = 10, Name = PRESULT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
176     15:33:51  SQL Data In: ORACLE - Param = 11, Name = PERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
177     15:33:51  SQL Data In: ORACLE - Param = 12, Name = PTZBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
178     15:33:51  SQL Data In: ORACLE - Param = 13, Name = PYYSD00, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 09:00-10:00
179     15:33:51  SQL Data In: ORACLE - Param = 14, Name = PXSYYXH, Type = fldZSTRING, Precision = 5, Scale = 0, Data = DR038
180     15:33:51  SQL Data In: ORACLE - Param = 15, Name = PPBHBID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 16240
181     15:33:51  SQL Data In: ORACLE - Param = 16, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
182     15:33:51  SQL Data In: ORACLE - Param = 17, Name = PCZZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
183     15:33:51  SQL Execute: ORACLE - BEGIN "SP_YJ_JCYYDJ" (PYYID00 => :PYYID00,PYJDJH0 => :PYJDJH0,PBZ0000 => :PBZ0000,PYYRQ00 => :PYYRQ00,PYYSJ00 => :PYYSJ00,PYYXH00 => :PYYXH00,PCZRXM0 => :PCZRXM0,PCZBZ00 => :PCZBZ00,PJCSQDH => :PJCSQDH,PRESULT => :PRESULT,PERROR0 => :PERROR0,PTZBH00 => :PTZBH00,PYYSD00 => :PYYSD00,PXSYYXH => :PXSYYXH,PPBHBID => :PPBHBID,PJZBZ00 => :PJZBZ00,PCZZT00 => :PCZZT00); END;
184     15:33:51  SQL Prepare: ORACLE - commit

185     15:33:51  SQL Execute: ORACLE - commit

186     15:33:51  SQL Data In: ORACLE - Rows affected = 0
187     15:33:52  SQL Prepare: ORACLE - select a.*  from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') 
 and  XMWHID=20
 and a.YYRQ00='20150505'
 and a.PBSXW0='上午'
 order by a.KSPBSJ,a.XH0000  

188     15:33:52  SQL Execute: ORACLE - select a.*  from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') 
 and  XMWHID=20
 and a.YYRQ00='20150505'
 and a.PBSXW0='上午'
 order by a.KSPBSJ,a.XH0000  

189     15:33:52  SQL Prepare: ORACLE - select SF_YJ_YYYRSXS(94,20,16240,0,'20150505') TS0000 from dual 

190     15:33:52  SQL Execute: ORACLE - select SF_YJ_YYYRSXS(94,20,16240,0,'20150505') TS0000 from dual 

191     15:33:52  SQL Prepare: ORACLE - select rownum xh0000,g.* from (
Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.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,(select BMMC00 from BM_BMBM00 where BMBH00=b.KDBQ00) KDBQMC ,b.SQID00,b.YYBZ00,HBDJH0,nvl(c.JCLBID,0) JCLBID,nvl(c.JCZID0,0) JCZID0,nvl(HBXHID,0) HBXHID,(select YYH000 from YJ_YYBRB0 where YYID00=b.YYID00 and YYZT00<>'2') YYXH00, (select JCLBMC from BM_JCLB00 where JCLBID=c.JCLBID) JCLBMC,nvl((select YYRQ00 from YJ_YYBRB0 where YYID00=b.YYID00),(select YYRQ00 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0)) YYRQ00, (select YYXMMC from YJ_YYZLZD where XMWHID=c.JCZID0 and rownum=1) JCZMC0,nvl(YYID00,0) YYID00,  (select XH0000 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0) SH0000, decode(YYZT00,'0','已预约','1','已检查','2','取消','-1','') YYZT00,0 XGBZ00,'         ' color0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and nvl(c.JCZID0,0)>0 and (not XMZT00  in('6') ) and SL0000>0  
 and not exists(select 1 from YJ_YW0000 where ZYHGHH=b.ZYHGHH and CXDJH0=b.YJDJH0) 
 and exists(select 1 from zy_brxxb0 where zyid00=b.ZYGHID and substr(brzt00,1,1)='2') 
 and (nvl(YYID00,0)=0 or  YYZT00='2')   
 and b.mzzybz='1'
 and nvl(c.JCZID0,0)=20
 and XMZT00 in('0','1','2') 
 and (YJKSBH=:1 or ( (((b.Zlxmid,b.kdksbh) in 
 (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=:2)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=:3) ))   
 and ( (',550,186,'=',0,') or  (instr(',550,186,',:4 )>0) ) )
)
 and kdrq00 between :5 and :6 
 order by kdrq00,KDSJ00,brid00) g

192     15:33:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000
193     15:33:52  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000
194     15:33:52  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000
195     15:33:52  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ,94,
196     15:33:52  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150502
197     15:33:52  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = 20150504 17:00:00
198     15:33:52  SQL Execute: ORACLE - select rownum xh0000,g.* from (
Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.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,(select BMMC00 from BM_BMBM00 where BMBH00=b.KDBQ00) KDBQMC ,b.SQID00,b.YYBZ00,HBDJH0,nvl(c.JCLBID,0) JCLBID,nvl(c.JCZID0,0) JCZID0,nvl(HBXHID,0) HBXHID,(select YYH000 from YJ_YYBRB0 where YYID00=b.YYID00 and YYZT00<>'2') YYXH00, (select JCLBMC from BM_JCLB00 where JCLBID=c.JCLBID) JCLBMC,nvl((select YYRQ00 from YJ_YYBRB0 where YYID00=b.YYID00),(select YYRQ00 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0)) YYRQ00, (select YYXMMC from YJ_YYZLZD where XMWHID=c.JCZID0 and rownum=1) JCZMC0,nvl(YYID00,0) YYID00,  (select XH0000 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0) SH0000, decode(YYZT00,'0','已预约','1','已检查','2','取消','-1','') YYZT00,0 XGBZ00,'         ' color0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and nvl(c.JCZID0,0)>0 and (not XMZT00  in('6') ) and SL0000>0  
 and not exists(select 1 from YJ_YW0000 where ZYHGHH=b.ZYHGHH and CXDJH0=b.YJDJH0) 
 and exists(select 1 from zy_brxxb0 where zyid00=b.ZYGHID and substr(brzt00,1,1)='2') 
 and (nvl(YYID00,0)=0 or  YYZT00='2')   
 and b.mzzybz='1'
 and nvl(c.JCZID0,0)=20
 and XMZT00 in('0','1','2') 
 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 ( (',550,186,'=',0,') or  (instr(',550,186,',? )>0) ) )
)
 and kdrq00 between ? and ? 
 order by kdrq00,KDSJ00,brid00) g

199     15:33:53  SQL Prepare: 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=:1

200     15:33:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68407149.000000
201     15:33: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=?