1       11:05:12  Log started for: 库存物资管理子系统
2       11:05:12  SQL Transact: ORACLE - Set autocommit on/off
3       11:05:12  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

4       11:05:12  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.0.104','K','prjSB_KCWZ.exe'||'+'||'库存物资管理子系统','724','3927' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@yj:6587EF097EA4D57056F73EF93DAD7DFF' from dual

5       11:05:12  SQL Data In: ORACLE - Rows affected = 1
6       11:05:12  SQL Execute: ORACLE - Commit

7       11:05:12  SQL Data In: ORACLE - Rows affected = 0
8       11:05:12  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

9       11:05:12  SQL Connect: ORACLE - Disconnect GENERAL
10      11:05:12  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221218'

11      11:05:12  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='YJ' and CZBZ00 in ('1') 

12      11:05:12  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

13      11:05:12  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.0.104','K','prjSB_KCWZ.exe'||'+'||'库存物资管理子系统','855','2674' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@yj:63A2035D2E81CC4C9AFD7390729D93B5' from dual

14      11:05:12  SQL Data In: ORACLE - Rows affected = 1
15      11:05:12  SQL Execute: ORACLE - Commit

16      11:05:12  SQL Data In: ORACLE - Rows affected = 0
17      11:05:12  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='K'

18      11:05:12  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='YJ' and CZBZ00 in ('1') 

19      11:05:12  SQL Execute: ORACLE - Select SYSDATE from Dual

20      11:05:12  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

21      11:05:12  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

22      11:05:12  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K'

23      11:05:12  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

24      11:05:12  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = 'SLE4442'

25      11:05:12  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = 'YB-MMRK'

26      11:05:12  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = 'YB-SBK'

27      11:05:12  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='K'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='YJ')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('a','b','c')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='K'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='YJ'))
 order by b.PLXH00,a.BH0000

28      11:05:14  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'yj'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'K' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='YJ'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='K' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='YJ') 

29      11:05:15  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=157

30      11:05:15  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

31      11:05:15  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

32      11:05:15  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

33      11:05:15  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

34      11:05:15  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'))

35      11:05:15  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(1652029,157,'D','K',nvl('10320957',' '),'192.168.3.99-192.168.0.104#855:2674@prjSB_KCWZ.exe+库存物资管理子系统',115)

36      11:05:15  SQL Data In: ORACLE - Rows affected = 1
37      11:05:15  SQL Execute: ORACLE - Commit

38      11:05:15  SQL Data In: ORACLE - Rows affected = 0
39      11:05:15  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 115

40      11:05:15  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '221218'

41      11:05:15  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

42      11:05:15  SQL Blob IO: ORACLE - Return blob data
43      11:05:15  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.104'

44      11:05:15  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

45      11:05:15  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
115 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

46      11:05:15  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221218') 

47      11:05:15  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'K'||',')>0 

48      11:05:15  SQL Blob IO: ORACLE - Return blob data
49      11:05:15  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='157' and name00='SYSTEMSKIN'

50      11:05:15  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

51      11:05:15  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20140228'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',115,' )>0 )

52      11:05:15  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

53      11:05:15  SQL Blob IO: ORACLE - Return blob data
54      11:05:15  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

55      11:05:15  SQL Blob IO: ORACLE - Return blob data
56      11:05:15  SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=115

57      11:05:15  SQL Execute: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%'

58      11:05:15  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID'

59      11:05:15  SQL Execute: ORACLE - delete  SD_SB.WZ_TEMP00

60      11:05:16  SQL Data In: ORACLE - Rows affected = 888
61      11:05:16  SQL Execute: ORACLE - Commit

62      11:05:16  SQL Data In: ORACLE - Rows affected = 0
63      11:05:16  SQL Execute: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%'

64      11:05:16  SQL Blob IO: ORACLE - Return blob data
65      11:05:16  SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=157

66      11:05:16  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='K' and (( 
157= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=157 and XTDM00='K'))) 

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

68      11:05:16  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 ((157= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=157 and XTDM00='0 '))) 

69      11:05:16  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

70      11:05:16  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
157= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=157 and XTDM00='+ '))) 

71      11:05:23  SQL Execute: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 
WHERE RCKBZ0 = '2' AND SFYX00 = 'Y' order by RCKBBH

72      11:05:23  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=157 and BMBH00=115
 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKSR'

73      11:05:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL

74      11:05:32  SQL Execute: ORACLE - SELECT * FROM VW_WZ_RCKMX0 WHERE RCKMXH=''

75      11:05:33  SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

76      11:05:33  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
77      11:05:33  SQL Execute: ORACLE - Select * from (select BMMC00,BMBH00,PYSM00,WBSM00,BMID00 from VW_WZ_CJBM00 where (PYSM00 Like ?) and(  YWCJBZ = 'N' )  Order By PYSM00) where Rownum<=20

78      11:05:35  SQL Execute: ORACLE - SELECT YGBH00,ZWXM00 FROM BM_YGBM00 WHERE BMBH00 ='172'