1       15:57:31  Log started for: Yjsystem
2       15:57:31  SQL Prepare: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.15.15','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20110216','15:57:29','scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

3       15:57:31  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.15.15','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20110216','15:57:29','scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

4       15:57:31  SQL Prepare: ORACLE - Commit

5       15:57:31  SQL Execute: ORACLE - Commit

6       15:57:31  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

7       15:57:31  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

8       15:57:31  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

9       15:57:31  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

10      15:57:31  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

11      15:57:31  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

12      15:57:31  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.15.15','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20110216','15:57:29','sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

13      15:57:31  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.15.15','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20110216','15:57:29','sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

14      15:57:31  SQL Prepare: ORACLE - Commit

15      15:57:31  SQL Execute: ORACLE - Commit

16      15:57:31  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7'

17      15:57:31  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7'

18      15:57:31  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

19      15:57:31  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

20      15:57:31  SQL Prepare: ORACLE - Select SYSDATE from Dual

21      15:57:31  SQL Execute: ORACLE - Select SYSDATE from Dual

22      15:57:31  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

23      15:57:31  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

24      15:57:31  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

25      15:57:31  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

26      15:57:31  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7'

27      15:57:31  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7'

28      15:57:31  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

29      15:57:31  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

30      15:57:31  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

31      15:57:31  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

32      15:57:31  SQL Prepare: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('0',',','1','5',',','1')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 order by BH0000

33      15:57:31  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('0',',','1','5',',','1')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 order by BH0000

34      15:57:33  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'9998'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'7' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))

35      15:57:33  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'9998'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'7' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))

36      15:57:33  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

37      15:57:33  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

38      15:57:33  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

39      15:57:33  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

40      15:57:33  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

41      15:57:33  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

42      15:57:33  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

43      15:57:33  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

44      15:57:33  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

45      15:57:33  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

46      15:57:33  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'))

47      15:57:34  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'))

48      15:57:34  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2454664,476,'wlzx-2','7',nvl('3461016',' '),'192.168.15.15#84:478@YJsystem.exe+医技管理系统',76)

49      15:57:34  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2454664,476,'wlzx-2','7',nvl('3461016',' '),'192.168.15.15#84:478@YJsystem.exe+医技管理系统',76)

50      15:57:34  SQL Prepare: ORACLE - Commit

51      15:57:34  SQL Execute: ORACLE - Commit

52      15:57:34  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 76

53      15:57:34  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 76

54      15:57:34  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137'

55      15:57:34  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137'

56      15:57:34  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15'

57      15:57:34  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15'

58      15:57:34  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG')

59      15:57:34  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG')

60      15:57:34  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
76 and FLAG00 like '%'
 order by decode(CKBH00,21     --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

61      15:57:34  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
76 and FLAG00 like '%'
 order by decode(CKBH00,21     --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

62      15:57:34  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN'

63      15:57:34  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN'

64      15:57:34  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='7') and YXQ000>='20110216'

65      15:57:34  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='7') and YXQ000>='20110216'

66      15:57:34  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

67      15:57:34  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

68      15:57:34  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

69      15:57:34  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

70      15:57:34  SQL Prepare: ORACLE - select sysdate from dual

71      15:57:34  SQL Execute: ORACLE - select sysdate from dual

72      15:57:34  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='7' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='7' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

73      15:57:34  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='7' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='7' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

74      15:57:34  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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

75      15:57:34  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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

76      15:57:34  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 ((476= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476))))  

77      15:57:34  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 ((476= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476))))  

78      15:57:34  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

79      15:57:34  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

80      15:57:34  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

81      15:57:34  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

82      15:57:34  SQL Prepare: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1

83      15:57:34  SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1

84      15:57:34  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY')
 and YGBH00 = 476

85      15:57:34  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY')
 and YGBH00 = 476

86      15:57:34  SQL Prepare: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YJ_YXCXTS','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_SYKSFZDDY','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YJ_XMZJYSWSSKS','YJ_XSKDYGS','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','YJ_SYHDSFDY','YJ_ZJLZDYDY','YJ_XMWHCKSFKYZXXM','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY','YJ_XMAPSFAKSCX','YJ_XMAPDYZDYID','YJ_XMSQKSYSSFMRWK','YJ_SYGCDZDYDY','YJ_CFFWFXWHXZ','YJ_TXMDYSFFY','YJ_YJCXD_ZDY','XT_ZYXTGBDW')

87      15:57:34  SQL Execute: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YJ_YXCXTS','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_SYKSFZDDY','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YJ_XMZJYSWSSKS','YJ_XSKDYGS','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','YJ_SYHDSFDY','YJ_ZJLZDYDY','YJ_XMWHCKSFKYZXXM','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY','YJ_XMAPSFAKSCX','YJ_XMAPDYZDYID','YJ_XMSQKSYSSFMRWK','YJ_SYGCDZDYDY','YJ_CFFWFXWHXZ','YJ_TXMDYSFFY','YJ_YJCXD_ZDY','XT_ZYXTGBDW')

88      15:57:34  SQL Prepare: ORACLE -  select YYID00 from xt_yyxx00 where rownum=1

89      15:57:34  SQL Execute: ORACLE -  select YYID00 from xt_yyxx00 where rownum=1

90      15:57:34  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='YJ_QSBRLB'

91      15:57:34  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='YJ_QSBRLB'

92      15:57:34  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

93      15:57:34  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

94      15:57:36  SQL Prepare: ORACLE - select yyqc00 from xt_yyxx00

95      15:57:36  SQL Execute: ORACLE - select yyqc00 from xt_yyxx00

96      15:57:36  SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=:1

97      15:57:36  SQL Prepare: ORACLE - 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.brybmc,b.zxsj00,b.cxsl00,b.txm000,b.SYLSH0
from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and yjdjh0=1
 

98      15:57:36  SQL Execute: ORACLE - 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.brybmc,b.zxsj00,b.cxsl00,b.txm000,b.SYLSH0
from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and yjdjh0=1
 

99      15:57:36  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=?

100     15:57:36  SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='YJ_YZXSFTXYCXJL'

101     15:57:36  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='YJ_YZXSFTXYCXJL'

102     15:57:36  SQL Prepare: ORACLE - select value0 from xt_xtcs00 where (name00='YJ_QZZXQR' and value0='Y') and  exists (select 1 from XT_XTCS00 where NAME00='YJ_ZYZLDYXQF' and trim(Value0)='Y')

103     15:57:36  SQL Execute: ORACLE - select value0 from xt_xtcs00 where (name00='YJ_QZZXQR' and value0='Y') and  exists (select 1 from XT_XTCS00 where NAME00='YJ_ZYZLDYXQF' and trim(Value0)='Y')

104     15:57:36  SQL Prepare: ORACLE -  SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='YJ_TMCF_TMHZ'

105     15:57:36  SQL Execute: ORACLE -  SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='YJ_TMCF_TMHZ'

106     15:57:36  SQL Prepare: ORACLE - select 1 from dual where 76 in (-1)

107     15:57:36  SQL Execute: ORACLE - select 1 from dual where 76 in (-1)

108     15:57:36  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where name00='YJ_JCDZZGD'

109     15:57:36  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where name00='YJ_JCDZZGD'

110     15:57:36  SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

111     15:57:36  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

112     15:57:36  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

113     15:57:36  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

114     15:57:36  SQL Prepare: ORACLE - select bmbh00,bmmc00 from bm_bmbm00  where bmxz00='9' and flag00='1'

115     15:57:36  SQL Execute: ORACLE - select bmbh00,bmmc00 from bm_bmbm00  where bmxz00='9' and flag00='1'

116     15:57:36  SQL Prepare: ORACLE - select count(*) from xt_zldczl where rownum=1

117     15:57:36  SQL Execute: ORACLE - select count(*) from xt_zldczl where rownum=1

118     15:57:41  SQL Prepare: ORACLE - SELECT A.*,'1' PCMC00 FROM YF_MZCFMX A WHERE CFID00=1

119     15:57:41  SQL Execute: ORACLE - SELECT A.*,'1' PCMC00 FROM YF_MZCFMX A WHERE CFID00=1

120     15:57:41  SQL Prepare: ORACLE - select * from BQ_YPYZMX
where YZID00=:1

121     15:57:41  SQL Execute: ORACLE - select * from BQ_YPYZMX
where YZID00=?

122     15:57:41  SQL Prepare: ORACLE - select * from BQ_YPYZMX
where YZMXID=:1

123     15:57:41  SQL Execute: ORACLE - select * from BQ_YPYZMX
where YZMXID=?

124     15:57:41  SQL Prepare: ORACLE - 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 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' 
 and ( (xmzt00 in ('3','4')) or  ( xmzt00='2' and B.ZXSL00>0))
 and b.mzzybz='0'

 and (YJKSBH=:1 or (((b.Zlxmid,kdksbh) in 
 (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=:2)) and ( (',0,'=',0,') or  (instr(',0,',:3 )>0) ) )
)
 and kdrq00 between :4 and :5 
 order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid

125     15:57:41  SQL Execute: ORACLE - 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 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' 
 and ( (xmzt00 in ('3','4')) or  ( xmzt00='2' and B.ZXSL00>0))
 and b.mzzybz='0'

 and (YJKSBH=? or (((b.Zlxmid,kdksbh) in 
 (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) and ( (',0,'=',0,') or  (instr(',0,',? )>0) ) )
)
 and kdrq00 between ? and ? 
 order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid

126     15:57:41  SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=:1

127     15:57:41  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=?

128     15:57:41  SQL Prepare: 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 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and Yjdjh0=:1

129     15:57:41  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 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and Yjdjh0=?

130     15:57:42  SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=:1

131     15:57:42  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=?

132     15:57:42  SQL Prepare: 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 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and Yjdjh0=:1

133     15:57:42  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 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and Yjdjh0=?

134     15:57:42  SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=:1

135     15:57:42  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=?

136     15:57:45  SQL Prepare: ORACLE - select b.LBBH00,C.ZYZBMC from YJ_YW0000 a,BM_ZLZD00 b,BM_JYZYZB C WHERE a.YJDJH0=:1 AND a.ZLXMID=b.ZLXMID AND C.ZYZBID(+)=b.ZYZBID

137     15:57:45  SQL Execute: ORACLE - select b.LBBH00,C.ZYZBMC from YJ_YW0000 a,BM_ZLZD00 b,BM_JYZYZB C WHERE a.YJDJH0=? AND a.ZLXMID=b.ZLXMID AND C.ZYZBID(+)=b.ZYZBID

138     15:57:45  SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=:1

139     15:57:45  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=?

140     15:57:45  SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=:1

141     15:57:45  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=?

142     15:57:45  SQL Prepare: 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 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and Yjdjh0=:1

143     15:57:45  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 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and Yjdjh0=?

144     15:57:45  SQL Prepare: ORACLE - select sf_yj_get_exec_order(:1) from dual

145     15:57:45  SQL Execute: ORACLE - select sf_yj_get_exec_order(?) from dual

146     15:57:45  SQL Prepare: ORACLE - select ghrq00,sf_bq_csrqtonl(csrq00) from sf_brxxb0 where ghid00=:1

147     15:57:45  SQL Execute: ORACLE - select ghrq00,sf_bq_csrqtonl(csrq00) from sf_brxxb0 where ghid00=?

148     15:57:45  SQL Prepare: ORACLE - select zxcs00,zxrq00 from yj_ywzxjl where yjdjh0=:1 order by zxrq00 desc,zxsj00 desc

149     15:57:45  SQL Execute: ORACLE - select zxcs00,zxrq00 from yj_ywzxjl where yjdjh0=? order by zxrq00 desc,zxsj00 desc

150     15:57:45  SQL Prepare: ORACLE - select zxsj00 from yj_ywzxjl where yjdjh0=:1 union select zxsj00 from yj_ywmx00 where zxrq00 is not null and yjdjh0=:2

151     15:57:45  SQL Execute: ORACLE - select zxsj00 from yj_ywzxjl where yjdjh0=? union select zxsj00 from yj_ywmx00 where zxrq00 is not null and yjdjh0=?