1       09:33:44  SQL Prepare: ORACLE - select SDMC00,SDID00 from YJ_YYSD00

2       09:33:44  SQL Execute: ORACLE - select SDMC00,SDID00 from YJ_YYSD00

3       09:33:44  SQL Prepare: ORACLE - select a.*,(select JCLBMC from BM_JCLB00 where JCLBID=a.JCLBID) YYDLMC ,(select CKMC00 from BM_CKBM00 where CKBH00=a.CKBH00) CKMC00,(select YYXMMC from YJ_YYZLZD where XMWHID=a.XMWHID and XMWHID>0 and rownum=1) SBZMC0,a.YYXHS0 YYXHS0_O   from YJ_KSPBHB a where YYRQ00>='20150209' and YYRQ00<='20150216' and YJKSBH=531
 order by YYRQ00 

4       09:33:44  SQL Execute: ORACLE - select a.*,(select JCLBMC from BM_JCLB00 where JCLBID=a.JCLBID) YYDLMC ,(select CKMC00 from BM_CKBM00 where CKBH00=a.CKBH00) CKMC00,(select YYXMMC from YJ_YYZLZD where XMWHID=a.XMWHID and XMWHID>0 and rownum=1) SBZMC0,a.YYXHS0 YYXHS0_O   from YJ_KSPBHB a where YYRQ00>='20150209' and YYRQ00<='20150216' and YJKSBH=531
 order by YYRQ00 

5       09:35:40  SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

6       09:35:40  SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

7       09:35:40  SQL Prepare: ORACLE - Select * from (select YYXMMC,XMWHID,KSBH00 from YJ_YYZLZD where (XMWHID Like :1) and( KSBH00=531 )  Order By XMWHID) where Rownum<=30

8       09:35:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
9       09:35:40  SQL Execute: ORACLE - Select * from (select YYXMMC,XMWHID,KSBH00 from YJ_YYZLZD where (XMWHID Like ?) and( KSBH00=531 )  Order By XMWHID) where Rownum<=30

10      09:35:42  SQL Prepare: ORACLE - select a.*,(select JCLBMC from BM_JCLB00 where JCLBID=a.JCLBID) YYDLMC ,(select CKMC00 from BM_CKBM00 where CKBH00=a.CKBH00) CKMC00,(select YYXMMC from YJ_YYZLZD where XMWHID=a.XMWHID and XMWHID>0 and rownum=1) SBZMC0,a.YYXHS0 YYXHS0_O   from YJ_KSPBHB a where YYRQ00>='20150209' and YYRQ00<='20150216' and YJKSBH=531
 and XMWHID=19
 order by YYRQ00 

11      09:35:42  SQL Execute: ORACLE - select a.*,(select JCLBMC from BM_JCLB00 where JCLBID=a.JCLBID) YYDLMC ,(select CKMC00 from BM_CKBM00 where CKBH00=a.CKBH00) CKMC00,(select YYXMMC from YJ_YYZLZD where XMWHID=a.XMWHID and XMWHID>0 and rownum=1) SBZMC0,a.YYXHS0 YYXHS0_O   from YJ_KSPBHB a where YYRQ00>='20150209' and YYRQ00<='20150216' and YJKSBH=531
 and XMWHID=19
 order by YYRQ00 

12      09:35:43  SQL Prepare: ORACLE - select a.*,(select JCLBMC from BM_JCLB00 where JCLBID=a.JCLBID) YYDLMC ,(select CKMC00 from BM_CKBM00 where CKBH00=a.CKBH00) CKMC00,(select YYXMMC from YJ_YYZLZD where XMWHID=a.XMWHID and XMWHID>0 and rownum=1) SBZMC0,a.YYXHS0 YYXHS0_O   from YJ_KSPBHB a where YYRQ00>='20150209' and YYRQ00<='20150216' and YJKSBH=531
 and XMWHID=19
 order by YYRQ00 

13      09:35:43  SQL Execute: ORACLE - select a.*,(select JCLBMC from BM_JCLB00 where JCLBID=a.JCLBID) YYDLMC ,(select CKMC00 from BM_CKBM00 where CKBH00=a.CKBH00) CKMC00,(select YYXMMC from YJ_YYZLZD where XMWHID=a.XMWHID and XMWHID>0 and rownum=1) SBZMC0,a.YYXHS0 YYXHS0_O   from YJ_KSPBHB a where YYRQ00>='20150209' and YYRQ00<='20150216' and YJKSBH=531
 and XMWHID=19
 order by YYRQ00 

14      09:35:45  SQL Prepare: ORACLE - select * from YJ_JCHBXH where PBHBID=:1 order by XH0000

15      09:35:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 12858
16      09:35:45  SQL Execute: ORACLE - select * from YJ_JCHBXH where PBHBID=? order by XH0000

17      09:41:14  SQL Prepare: ORACLE - select a.*,(select JCLBMC from BM_JCLB00 where JCLBID=a.JCLBID) YYDLMC ,(select CKMC00 from BM_CKBM00 where CKBH00=a.CKBH00) CKMC00,(select YYXMMC from YJ_YYZLZD where XMWHID=a.XMWHID and XMWHID>0 and rownum=1) SBZMC0,a.YYXHS0 YYXHS0_O   from YJ_KSPBHB a where YYRQ00>='20150209' and YYRQ00<='20150216' and YJKSBH=531
 and XMWHID=19
 order by YYRQ00 

18      09:41:14  SQL Execute: ORACLE - select a.*,(select JCLBMC from BM_JCLB00 where JCLBID=a.JCLBID) YYDLMC ,(select CKMC00 from BM_CKBM00 where CKBH00=a.CKBH00) CKMC00,(select YYXMMC from YJ_YYZLZD where XMWHID=a.XMWHID and XMWHID>0 and rownum=1) SBZMC0,a.YYXHS0 YYXHS0_O   from YJ_KSPBHB a where YYRQ00>='20150209' and YYRQ00<='20150216' and YJKSBH=531
 and XMWHID=19
 order by YYRQ00 

19      09:41:16  Log started for: SQL Navigator for Oracle
20      09:57:22  Log started for: 临床路径维护系统
21      09:57:22  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

22      09:57:22  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

23      09:57:22  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.88','CP','Prj_CP.exe'||'+'||'临床路径维护系统','310','63425' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@hjh:98AB33836834C0CECEBFA60734004AC1' from dual

24      09:57:22  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.88','CP','Prj_CP.exe'||'+'||'临床路径维护系统','310','63425' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@hjh:98AB33836834C0CECEBFA60734004AC1' from dual

25      09:57:22  SQL Data In: ORACLE - Rows affected = 1
26      09:57:22  SQL Prepare: ORACLE - Commit

27      09:57:22  SQL Execute: ORACLE - Commit

28      09:57:22  SQL Data In: ORACLE - Rows affected = 0
29      09:57:22  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

30      09:57:22  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

31      09:57:22  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='220007'

32      09:57:22  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='220007'

33      09:57:22  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 

34      09:57:22  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 

35      09:57:22  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

36      09:57:22  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

37      09:57:22  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.88','CP','Prj_CP.exe'||'+'||'临床路径维护系统','744','50825' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@hjh:77844FD675E54EFCB1A80903D03C9B60' from dual

38      09:57:22  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.88','CP','Prj_CP.exe'||'+'||'临床路径维护系统','744','50825' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@hjh:77844FD675E54EFCB1A80903D03C9B60' from dual

39      09:57:22  SQL Data In: ORACLE - Rows affected = 1
40      09:57:22  SQL Prepare: ORACLE - Commit

41      09:57:22  SQL Execute: ORACLE - Commit

42      09:57:22  SQL Data In: ORACLE - Rows affected = 0
43      09:57:22  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='CP'

44      09:57:22  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='CP'

45      09:57:22  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 

46      09:57:22  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 

47      09:57:22  SQL Prepare: ORACLE - Select SYSDATE from Dual

48      09:57:22  SQL Execute: ORACLE - Select SYSDATE from Dual

49      09:57:22  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

50      09:57:22  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

51      09:57:22  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='CP'

52      09:57:22  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='CP'

53      09:57:22  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

54      09:57:22  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

55      09:57:22  SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

56      09:57:22  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

57      09:57:22  SQL Prepare: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='CP'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('8','a')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='CP'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH'))
 order by b.PLXH00,a.BH0000

58      09:57:22  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='CP'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('8','a')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='CP'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH'))
 order by b.PLXH00,a.BH0000

59      09:57:22  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'hjh'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'CP' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='CP' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH') 

60      09:57:22  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'hjh'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'CP' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='CP' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH') 

61      09:57:22  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1372

62      09:57:22  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1372

63      09:57:22  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

64      09:57:22  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

65      09:57:22  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

66      09:57:22  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

67      09:57:22  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

68      09:57:22  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

69      09:57:22  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

70      09:57:22  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

71      09:57:22  SQL Prepare: ORACLE -  select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 
 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

72      09:57:22  SQL Execute: ORACLE -  select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 
 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

73      09:57:24  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(7284765,1372,'PC-20120208YHGY','CP',nvl('56736864',' '),'192.168.1.88#744:50825@Prj_CP.exe+临床路径维护系统',335)

74      09:57:24  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(7284765,1372,'PC-20120208YHGY','CP',nvl('56736864',' '),'192.168.1.88#744:50825@Prj_CP.exe+临床路径维护系统',335)

75      09:57:24  SQL Data In: ORACLE - Rows affected = 1
76      09:57:24  SQL Prepare: ORACLE - Commit

77      09:57:24  SQL Execute: ORACLE - Commit

78      09:57:24  SQL Data In: ORACLE - Rows affected = 0
79      09:57:24  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 335

80      09:57:24  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 335

81      09:57:24  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= 'A'

82      09:57:24  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= 'A'

83      09:57:24  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

84      09:57:24  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

85      09:57:24  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.88'

86      09:57:24  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.88'

87      09:57:24  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

88      09:57:24  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

89      09:57:24  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
335 and FLAG00 like '%'
 order by decode(CKBH00,83,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

90      09:57:24  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
335 and FLAG00 like '%'
 order by decode(CKBH00,83,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

91      09:57:24  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('A') 

92      09:57:24  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('A') 

93      09:57:24  SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'CP'||',')>0 

94      09:57:24  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'CP'||',')>0 

95      09:57:25  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1372' and name00='SYSTEMSKIN'

96      09:57:25  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1372' and name00='SYSTEMSKIN'

97      09:57:25  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

98      09:57:25  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

99      09:57:25  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20150209'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',335,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='CP')

100     09:57:25  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20150209'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',335,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='CP')

101     09:57:26  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

102     09:57:26  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

103     09:57:26  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

104     09:57:26  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

105     09:57:26  SQL Prepare: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

106     09:57:26  SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

107     09:57:26  SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a

108     09:57:26  SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a

109     09:57:26  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='CP' and (( 
1372= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='CP'))) 

110     09:57:26  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='CP' and (( 
1372= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='CP'))) 

111     09:57:26  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'CP$%' and A.XTDM00='CP' and trim(A.MKDM00)='CP$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00

112     09:57:26  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'CP$%' and A.XTDM00='CP' and trim(A.MKDM00)='CP$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00

113     09:57:26  SQL Prepare: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1372= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='0 '))) 

114     09:57:26  SQL Execute: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1372= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='0 '))) 

115     09:57:26  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

116     09:57:26  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

117     09:57:26  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
1372= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='+ '))) 

118     09:57:26  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
1372= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='+ '))) 

119     09:57:26  SQL Prepare: ORACLE -  Select XTBB00  from XT_YYXT00 where XTDM00='CP'

120     09:57:26  SQL Execute: ORACLE -  Select XTBB00  from XT_YYXT00 where XTDM00='CP'

121     09:57:26  SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%'  or name00 in ('ZS_SFSYBYLCLJ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_LJMBWHMS','ZS_LJBMSFKBJ','ZS_LJSFSYZLJ','ZS_FPSYSFYXSRPS','ZS_SFXSBBMC','ZS_SFKYSRZLYZ','CP_LJWHYYGXH','CP_LSYZZLSFKXG','CP_XSSSXMJC','CP_XZJDZDJRMRZ','CP_XZLJSFMRTSBY','CP_ZBLJXSFS','CP_ZDTJSFLYZDKSFP','CP_LZJHSFZXSDJD','CP_JHYZXLXSYF','CP_JHYZGLYF'       )

122     09:57:26  SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%'  or name00 in ('ZS_SFSYBYLCLJ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_LJMBWHMS','ZS_LJBMSFKBJ','ZS_LJSFSYZLJ','ZS_FPSYSFYXSRPS','ZS_SFXSBBMC','ZS_SFKYSRZLYZ','CP_LJWHYYGXH','CP_LSYZZLSFKXG','CP_XSSSXMJC','CP_XZJDZDJRMRZ','CP_XZLJSFMRTSBY','CP_ZBLJXSFS','CP_ZDTJSFLYZDKSFP','CP_LZJHSFZXSDJD','CP_JHYZXLXSYF','CP_JHYZGLYF'       )

123     09:57:26  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 1372

124     09:57:26  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 1372

125     09:57:26  SQL Prepare: ORACLE - select count(*) cou from  XT_XTCZRZ where cztable='LJ_JDYZMX'  and CZRYBM=0 

126     09:57:26  SQL Execute: ORACLE - select count(*) cou from  XT_XTCZRZ where cztable='LJ_JDYZMX'  and CZRYBM=0 

127     09:57:29  SQL Prepare: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='CP' and MKDM00='CP013' and ( 
 (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='CP' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=1372))))

128     09:57:29  SQL Execute: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='CP' and MKDM00='CP013' and ( 
 (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='CP' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=1372))))

129     09:57:29  SQL Prepare: ORACLE - select 1 from BM_YGBM00 where YGBH00=1372 and YGXZ00 like '%5%' 

130     09:57:29  SQL Execute: ORACLE - select 1 from BM_YGBM00 where YGBH00=1372 and YGXZ00 like '%5%' 

131     09:57:29  SQL Prepare: ORACLE -   SELECT a.*,(select count(*) from LJ_JDYZMX b  where  b.YZZT00='0' and  CLBZ00 in('0','1') and SYFW00=0 and LJID00=a.LJID00 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,YPNM00,335,0,ZLXMID)=1) YZZT00 FROM VW_ZY_LJ_MBXX a where  LJZT00<>'2'  and (a.KSBH00=0 or exists(select 1 from  BM_BMBM00 d where a.KSBH00=d.BMBH00 and d.YYID00='A')  ) order by to_number(LJBM00)

132     09:57:29  SQL Execute: ORACLE -   SELECT a.*,(select count(*) from LJ_JDYZMX b  where  b.YZZT00='0' and  CLBZ00 in('0','1') and SYFW00=0 and LJID00=a.LJID00 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,YPNM00,335,0,ZLXMID)=1) YZZT00 FROM VW_ZY_LJ_MBXX a where  LJZT00<>'2'  and (a.KSBH00=0 or exists(select 1 from  BM_BMBM00 d where a.KSBH00=d.BMBH00 and d.YYID00='A')  ) order by to_number(LJBM00)

133     09:57:32  SQL Prepare: ORACLE - select count(*) COU from LJ_YZLBZD a where LJID00=25 and YXBZ00='1' 

134     09:57:32  SQL Execute: ORACLE - select count(*) COU from LJ_YZLBZD a where LJID00=25 and YXBZ00='1' 

135     09:57:32  SQL Prepare: ORACLE - SELECT * FROM VW_ZY_LJ_MBXX  where  LJZT00<>'2'  and LJID00=:1

136     09:57:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 25
137     09:57:32  SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_MBXX  where  LJZT00<>'2'  and LJID00=?

138     09:57:32  SQL Prepare: ORACLE - SELECT * FROM VW_ZY_LJ_LJMBTJXX where LJID00=:1 and TJZT00='0' order by ZDLB00

139     09:57:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 25
140     09:57:32  SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_LJMBTJXX where LJID00=? and TJZT00='0' order by ZDLB00

141     09:57:32  SQL Prepare: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'A',0,1),YYID00  from BM_BMBM00 where  FLAG00='1' and CZBZ00<>'2'  
 and instr(',20,188,55,',','||BMBH00||',')>0 
order by decode(trim(YYID00),'A',0,1),PXXH00 

142     09:57:32  SQL Execute: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'A',0,1),YYID00  from BM_BMBM00 where  FLAG00='1' and CZBZ00<>'2'  
 and instr(',20,188,55,',','||BMBH00||',')>0 
order by decode(trim(YYID00),'A',0,1),PXXH00 

143     09:57:32  SQL Prepare: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'A',0,1),YYID00  from BM_BMBM00 where BMXZ00 in('2','3') and FLAG00='1' and CZBZ00<>'2' and (BMMC00 like '%中药%' or BMMC00 like '%全成%') order by decode(trim(YYID00),'A',0,1),nvl(PXXH00,0) 

144     09:57:32  SQL Execute: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'A',0,1),YYID00  from BM_BMBM00 where BMXZ00 in('2','3') and FLAG00='1' and CZBZ00<>'2' and (BMMC00 like '%中药%' or BMMC00 like '%全成%') order by decode(trim(YYID00),'A',0,1),nvl(PXXH00,0) 

145     09:57:32  SQL Prepare: ORACLE - select * from YS_JYFS00 order by bh0000

146     09:57:32  SQL Execute: ORACLE - select * from YS_JYFS00 order by bh0000

147     09:57:33  SQL Prepare: ORACLE - BEGIN "SP_ZY_LJ_GETLJTZYPTS" (AD_LJID00 => :AD_LJID00,AS_RETURN => :AS_RETURN,AS_ERROR0 => :AS_ERROR0,ad_DEPTID => :ad_DEPTID,AS_ZLXMTS => :AS_ZLXMTS); END;
148     09:57:33  SQL Data In: ORACLE - Param = 1, Name = AD_LJID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
149     09:57:33  SQL Data In: ORACLE - Param = 2, Name = AS_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
150     09:57:33  SQL Data In: ORACLE - Param = 3, Name = AS_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
151     09:57:33  SQL Data In: ORACLE - Param = 4, Name = ad_DEPTID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 335.000000
152     09:57:33  SQL Data In: ORACLE - Param = 5, Name = AS_ZLXMTS, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
153     09:57:33  SQL Execute: ORACLE - BEGIN "SP_ZY_LJ_GETLJTZYPTS" (AD_LJID00 => :AD_LJID00,AS_RETURN => :AS_RETURN,AS_ERROR0 => :AS_ERROR0,ad_DEPTID => :ad_DEPTID,AS_ZLXMTS => :AS_ZLXMTS); END;
154     09:57:34  SQL Prepare: ORACLE - select count(*) cou from all_objects where object_name='ZS_BLZCXM' 

155     09:57:34  SQL Execute: ORACLE - select count(*) cou from all_objects where object_name='ZS_BLZCXM' 

156     09:57:34  SQL Prepare: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='路径医嘱排序' 

157     09:57:34  SQL Execute: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='路径医嘱排序' 

158     09:57:34  SQL Prepare: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=1372) and  (BMBH00=0 or  BMBH00=335)
 and DLXTMC='临床路径维护系统' and CTMC00='FrmCP_LJMBWH' order by YGBH00 

159     09:57:34  SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=1372) and  (BMBH00=0 or  BMBH00=335)
 and DLXTMC='临床路径维护系统' and CTMC00='FrmCP_LJMBWH' order by YGBH00 

160     09:57:35  SQL Prepare: ORACLE - select count(*) COU from LJ_YZLBZD a where LJID00=76 and YXBZ00='1' 

161     09:57:35  SQL Execute: ORACLE - select count(*) COU from LJ_YZLBZD a where LJID00=76 and YXBZ00='1' 

162     09:57:35  SQL Prepare: ORACLE - SELECT * FROM VW_ZY_LJ_MBXX  where  LJZT00<>'2'  and LJID00=:1

163     09:57:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 76
164     09:57:35  SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_MBXX  where  LJZT00<>'2'  and LJID00=?

165     09:57:35  SQL Prepare: ORACLE - SELECT * FROM VW_ZY_LJ_LJMBTJXX where LJID00=:1 and TJZT00='0' order by ZDLB00

166     09:57:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 76
167     09:57:35  SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_LJMBTJXX where LJID00=? and TJZT00='0' order by ZDLB00

168     09:57:36  SQL Prepare: ORACLE - select count(*) from LJ_MBZLJD  where JDZT00='0' and LJID00=76

169     09:57:36  SQL Execute: ORACLE - select count(*) from LJ_MBZLJD  where JDZT00='0' and LJID00=76

170     09:57:36  SQL Prepare: ORACLE - select A.*,B.LJMC00 from LJ_MBZLJD A,LJ_MB0000 B where  A.LJID00=76 and  JDZT00='0' and A.LJID00=B.LJID00 order by xh0000 

171     09:57:36  SQL Execute: ORACLE - select A.*,B.LJMC00 from LJ_MBZLJD A,LJ_MB0000 B where  A.LJID00=76 and  JDZT00='0' and A.LJID00=B.LJID00 order by xh0000 

172     09:57:36  SQL Prepare: ORACLE - select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=76 and  RCID00=276  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)=1 

173     09:57:36  SQL Execute: ORACLE - select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=76 and  RCID00=276  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)=1 

174     09:57:36  SQL Prepare: ORACLE - select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=76 and  RCID00=277  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)=1 

175     09:57:36  SQL Execute: ORACLE - select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=76 and  RCID00=277  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)=1 

176     09:57:36  SQL Prepare: ORACLE - select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=76 and  RCID00=278  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)=1 

177     09:57:36  SQL Execute: ORACLE - select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=76 and  RCID00=278  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)=1 

178     09:57:36  SQL Prepare: ORACLE - select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=76 and  RCID00=279  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)=1 

179     09:57:36  SQL Execute: ORACLE - select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=76 and  RCID00=279  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)=1 

180     09:57:36  SQL Prepare: ORACLE - select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=76 and  RCID00=280  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)=1 

181     09:57:36  SQL Execute: ORACLE - select  count(*) COU from VW_ZY_LJ_MBYZXX a where  LJID00=76 and  RCID00=280  and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)=1 

182     09:57:36  SQL Prepare: ORACLE - select * from VW_ZY_LJ_MBKJXX  where LJID00=:1 and RCID00=:2   
 and LB0000=0
 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 

183     09:57:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 76.000000
184     09:57:36  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 276.000000
185     09:57:36  SQL Execute: ORACLE - select * from VW_ZY_LJ_MBKJXX  where LJID00=? and RCID00=?   
 and LB0000=0
 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 

186     09:57:38  SQL Prepare: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00,0 TEMPNO  from VW_ZY_LJ_MBYZXX a   where  CYCFBZ='0' 
 and   RCID00=276 and KSTS00>=1 and KSTS00<=1
order by CLBZ00,RCID00,LBID00,YZXZLX,PXH000,NO0000,TLBZXH

187     09:57:38  SQL Execute: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00,0 TEMPNO  from VW_ZY_LJ_MBYZXX a   where  CYCFBZ='0' 
 and   RCID00=276 and KSTS00>=1 and KSTS00<=1
order by CLBZ00,RCID00,LBID00,YZXZLX,PXH000,NO0000,TLBZXH

188     09:57:38  SQL Prepare: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf

189     09:57:38  SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf

190     09:57:38  SQL Prepare: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=76 and RCID00= 276

191     09:57:38  SQL Execute: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=76 and RCID00= 276

192     09:57:38  SQL Prepare: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,335,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=276
 and  KSTS00>=1 and KSTS00<=1
 order by LBIDXH,NO0000

193     09:57:38  SQL Execute: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,335,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=276
 and  KSTS00>=1 and KSTS00<=1
 order by LBIDXH,NO0000

194     09:57:38  SQL Prepare: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

195     09:57:38  SQL Execute: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

196     09:57:38  SQL Prepare: ORACLE - select a.*,(select JDMC00 from LJ_MBZLJD where RCID00=a.RCID00) JDMC00 from LJ_YZLBZD a where LJID00=76 and RCID00=276 order by CC0000,PXH000

197     09:57:38  SQL Execute: ORACLE - select a.*,(select JDMC00 from LJ_MBZLJD where RCID00=a.RCID00) JDMC00 from LJ_YZLBZD a where LJID00=76 and RCID00=276 order by CC0000,PXH000

198     09:57:39  SQL Prepare: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00,0 TEMPNO  from VW_ZY_LJ_MBYZXX a   where  CYCFBZ='0' 
 and   RCID00=276 and KSTS00>=1 and KSTS00<=1
order by CLBZ00,RCID00,LBID00,YZXZLX,PXH000,NO0000,TLBZXH

199     09:57:39  SQL Execute: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00,0 TEMPNO  from VW_ZY_LJ_MBYZXX a   where  CYCFBZ='0' 
 and   RCID00=276 and KSTS00>=1 and KSTS00<=1
order by CLBZ00,RCID00,LBID00,YZXZLX,PXH000,NO0000,TLBZXH

200     09:57:39  SQL Prepare: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

201     09:57:39  SQL Execute: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

202     09:57:39  SQL Prepare: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf

203     09:57:39  SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf

204     09:57:39  SQL Prepare: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=76 and RCID00= 276

205     09:57:39  SQL Execute: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=76 and RCID00= 276

206     09:57:39  SQL Prepare: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,335,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=276
 and  KSTS00>=1 and KSTS00<=1
 order by LBIDXH,NO0000

207     09:57:39  SQL Execute: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,335,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=276
 and  KSTS00>=1 and KSTS00<=1
 order by LBIDXH,NO0000

208     09:57:39  SQL Prepare: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

209     09:57:39  SQL Execute: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

210     09:57:42  SQL Prepare: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00,0 TEMPNO  from VW_ZY_LJ_MBYZXX a   where  CYCFBZ='0' 
 and   RCID00=276 and KSTS00>=1 and KSTS00<=1
 and LBID00 in (810)
order by CLBZ00,RCID00,LBID00,YZXZLX,PXH000,NO0000,TLBZXH

211     09:57:42  SQL Execute: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00,0 TEMPNO  from VW_ZY_LJ_MBYZXX a   where  CYCFBZ='0' 
 and   RCID00=276 and KSTS00>=1 and KSTS00<=1
 and LBID00 in (810)
order by CLBZ00,RCID00,LBID00,YZXZLX,PXH000,NO0000,TLBZXH

212     09:57:42  SQL Prepare: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

213     09:57:42  SQL Execute: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

214     09:57:42  SQL Prepare: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf

215     09:57:42  SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf

216     09:57:42  SQL Prepare: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=76 and RCID00= 276

217     09:57:42  SQL Execute: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=76 and RCID00= 276

218     09:57:42  SQL Prepare: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,335,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=276
 and  KSTS00>=1 and KSTS00<=1
 and LBID00 in (810)
 order by LBIDXH,NO0000

219     09:57:42  SQL Execute: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,335,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=276
 and  KSTS00>=1 and KSTS00<=1
 and LBID00 in (810)
 order by LBIDXH,NO0000

220     09:57:42  SQL Prepare: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

221     09:57:42  SQL Execute: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

222     09:57:43  SQL Prepare: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

223     09:57:43  SQL Execute: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

224     09:57:43  SQL Prepare: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

225     09:57:43  SQL Execute: ORACLE - select  a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,335,0,a.ZLXMID)  YPZT00   from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and  RCID00=276  and NO0000=6300 order BY XH0000 

226     09:57:48  SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

227     09:57:48  SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

228     09:57:48  SQL Prepare: ORACLE - Select * from (select ypmc00,ypnm00,ypgg00,SJKCXX,ypbm00,pysm00,wbsm00,mzfydw,zyfydw,kcdw00,m2j000,z2j000,k2j000,cyl000,jldw00,CZFLMC,LSDJ00,YPCZFL from VW_ZS_LJ_YD0000 where (pysm00 Like :1) and(  XMBZ00=0 and LBBZ00='1' and YPCZFL='0'  and exists(select 1 from LJ_YPFLMX a,BM_YD0000 b where  a.YPNM00=b.YPNM00 and b.LBBH00=2 and a.FLID00=VW_ZS_LJ_YD0000.YPNM00)  )  Order By pysm00) where Rownum<=100

229     09:57:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
230     09:57:48  SQL Execute: ORACLE - Select * from (select ypmc00,ypnm00,ypgg00,SJKCXX,ypbm00,pysm00,wbsm00,mzfydw,zyfydw,kcdw00,m2j000,z2j000,k2j000,cyl000,jldw00,CZFLMC,LSDJ00,YPCZFL from VW_ZS_LJ_YD0000 where (pysm00 Like ?) and(  XMBZ00=0 and LBBZ00='1' and YPCZFL='0'  and exists(select 1 from LJ_YPFLMX a,BM_YD0000 b where  a.YPNM00=b.YPNM00 and b.LBBH00=2 and a.FLID00=VW_ZS_LJ_YD0000.YPNM00)  )  Order By pysm00) where Rownum<=100