1       15:21:52  Log started for: 药房管理系统
2       15:21:52  SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

3       15:21:52  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) 
 Select '192.168.3.217','2',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

4       15:21:52  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) 
 Select '192.168.3.217','2',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

5       15:21:52  SQL Data In: ORACLE - Rows affected = 1
6       15:21:52  SQL Prepare: ORACLE - Commit

7       15:21:52  SQL Execute: ORACLE - Commit

8       15:21:52  SQL Data In: ORACLE - Rows affected = 0
9       15:21:52  SQL Prepare: ORACLE - Select SYSDATE from Dual

10      15:21:52  SQL Execute: ORACLE - Select SYSDATE from Dual

11      15:21:52  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

12      15:21:52  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

13      15:21:52  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2'

14      15:21:52  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2'

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

16      15:21:52  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

17      15:21:52  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

18      15:21:52  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

19      15:21:52  SQL Prepare: ORACLE -  Select DLFS00 from XT_YYXT00 where XTDM00='2'

20      15:21:52  SQL Execute: ORACLE -  Select DLFS00 from XT_YYXT00 where XTDM00='2'

21      15:21:53  SQL Prepare: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('2','3')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9996'))
 order by BH0000

22      15:21:53  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('2','3')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9996'))
 order by BH0000

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

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

25      15:21:57  SQL Prepare: ORACLE -  Select * from BM_YGBM00 where UPPER(XKH000)='9996'
 and CZBZ00='1'

26      15:21:57  SQL Execute: ORACLE -  Select * from BM_YGBM00 where UPPER(XKH000)='9996'
 and CZBZ00='1'

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

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

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

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

31      15:21:57  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.3.217'

32      15:21:57  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.3.217'

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

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

35      15:21:57  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
45 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

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

37      15:21:57  SQL Data In: ORACLE - Rows affected = 0
38      15:21:57  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

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

40      15:21:57  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

41      15:21:57  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

42      15:21:57  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(940294,181,'mqxyy091','2',nvl('853256',' '),'',45)

43      15:21:57  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(940294,181,'mqxyy091','2',nvl('853256',' '),'',45)

44      15:21:57  SQL Data In: ORACLE - Rows affected = 1
45      15:21:57  SQL Prepare: ORACLE - Commit

46      15:21:57  SQL Execute: ORACLE - Commit

47      15:21:57  SQL Data In: ORACLE - Rows affected = 0
48      15:21:57  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45

49      15:21:57  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45

50      15:21:57  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20090414'

51      15:21:57  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20090414'

52      15:21:57  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID'

53      15:21:57  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID'

54      15:21:57  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID'

55      15:21:57  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID'

56      15:21:57  SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED'

57      15:21:57  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED'

58      15:21:57  SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45

59      15:21:57  SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45

60      15:21:57  SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual

61      15:21:57  SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual

62      15:21:57  SQL Prepare: ORACLE - select * from XT_XTCS00

63      15:21:57  SQL Execute: ORACLE - select * from XT_XTCS00

64      15:21:57  SQL Prepare: ORACLE - select * from BM_YPLB00

65      15:21:57  SQL Execute: ORACLE - select * from BM_YPLB00

66      15:21:57  SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=181

67      15:21:57  SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=181

68      15:21:58  SQL Prepare: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and (( 
181= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=181))))

69      15:21:58  SQL Execute: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and (( 
181= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=181))))

70      15:21:58  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||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 ((181= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=181)))) ORDER BY B.F_TEMPTYPE,A.MKDM00

71      15:21:58  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||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 ((181= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=181)))) ORDER BY B.F_TEMPTYPE,A.MKDM00

72      15:21:58  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 ((181= 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=181))))  

73      15:21:58  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 ((181= 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=181))))  

74      15:21:58  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

75      15:21:58  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

76      15:21:58  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
181= 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=181))))

77      15:21:58  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
181= 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=181))))

78      15:21:58  SQL Prepare: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX 
 WHERE YFBMBH=45
 AND YKKCSL<KCXX00 AND PDXH00<>'0'

79      15:21:58  SQL Execute: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX 
 WHERE YFBMBH=45
 AND YKKCSL<KCXX00 AND PDXH00<>'0'

80      15:22:00  SQL Prepare: ORACLE - Select 'X' 
 From YK_YPTJMX X,YK_YPTJ00 T
 Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=45
 and X.SFQR00='N'
 and T.SFQR00='Y'

81      15:22:00  SQL Execute: ORACLE - Select 'X' 
 From YK_YPTJMX X,YK_YPTJ00 T
 Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=45
 and X.SFQR00='N'
 and T.SFQR00='Y'

82      15:22:02  SQL Prepare: ORACLE -  Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2'

83      15:22:02  SQL Execute: ORACLE -  Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2'

84      15:22:02  SQL Prepare: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('2','3')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9996'))

85      15:22:02  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('2','3')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9996'))

86      15:22:03  SQL Prepare: ORACLE -  Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2'

87      15:22:03  SQL Execute: ORACLE -  Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2'

88      15:22:03  SQL Prepare: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('2','3')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9996'))

89      15:22:03  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('2','3')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9996'))

90      15:22:06  SQL Prepare: ORACLE -  Select '00' as XTDM00 from dual where 
'9996'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'2' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9996'))

91      15:22:06  SQL Execute: ORACLE -  Select '00' as XTDM00 from dual where 
'9996'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'2' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9996'))

92      15:22:06  SQL Prepare: ORACLE -  Select * from BM_YGBM00 where UPPER(XKH000)='9996'
 and CZBZ00='1'

93      15:22:06  SQL Execute: ORACLE -  Select * from BM_YGBM00 where UPPER(XKH000)='9996'
 and CZBZ00='1'

94      15:22:06  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

95      15:22:06  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

96      15:22:06  SQL Prepare: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=940294

97      15:22:06  SQL Execute: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=940294

98      15:22:06  SQL Data In: ORACLE - Rows affected = 1
99      15:22:06  SQL Prepare: ORACLE - Commit

100     15:22:06  SQL Execute: ORACLE - Commit

101     15:22:06  SQL Data In: ORACLE - Rows affected = 0
102     15:22:06  SQL Prepare: ORACLE -  update XT_SQIPDZ set ZT0000='0' where JQBH00=0

103     15:22:06  SQL Execute: ORACLE -  update XT_SQIPDZ set ZT0000='0' where JQBH00=0

104     15:22:06  SQL Data In: ORACLE - Rows affected = 0
105     15:22:06  SQL Prepare: ORACLE - Commit

106     15:22:06  SQL Execute: ORACLE - Commit

107     15:22:06  SQL Data In: ORACLE - Rows affected = 0
108     15:22:06  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.3.217'

109     15:22:06  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.3.217'

110     15:22:06  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG')

111     15:22:06  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG')

112     15:22:06  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
46 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

113     15:22:06  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
46 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

114     15:22:06  SQL Data In: ORACLE - Rows affected = 0
115     15:22:06  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

116     15:22:06  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

117     15:22:06  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

118     15:22:06  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

119     15:22:06  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(940296,181,'mqxyy091','2',nvl('853256',' '),'',46)

120     15:22:06  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(940296,181,'mqxyy091','2',nvl('853256',' '),'',46)

121     15:22:06  SQL Data In: ORACLE - Rows affected = 1
122     15:22:06  SQL Prepare: ORACLE - Commit

123     15:22:06  SQL Execute: ORACLE - Commit

124     15:22:06  SQL Data In: ORACLE - Rows affected = 0
125     15:22:06  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 46

126     15:22:06  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 46

127     15:22:06  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20090414'

128     15:22:06  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20090414'

129     15:22:06  SQL Prepare: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=940296

130     15:22:06  SQL Execute: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=940296

131     15:22:06  SQL Data In: ORACLE - Rows affected = 1
132     15:22:06  SQL Prepare: ORACLE - Commit

133     15:22:06  SQL Execute: ORACLE - Commit

134     15:22:06  SQL Data In: ORACLE - Rows affected = 0
135     15:22:06  SQL Prepare: ORACLE -  update XT_SQIPDZ set ZT0000='0' where JQBH00=0

136     15:22:06  SQL Execute: ORACLE -  update XT_SQIPDZ set ZT0000='0' where JQBH00=0

137     15:22:06  SQL Data In: ORACLE - Rows affected = 0
138     15:22:06  SQL Prepare: ORACLE - Commit

139     15:22:06  SQL Execute: ORACLE - Commit

140     15:22:06  SQL Data In: ORACLE - Rows affected = 0
141     15:22:06  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

142     15:22:06  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

143     15:22:06  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

144     15:22:06  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

145     15:22:06  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(940297,181,'mqxyy091','2',nvl('853256',' '),'',46)

146     15:22:06  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(940297,181,'mqxyy091','2',nvl('853256',' '),'',46)

147     15:22:06  SQL Data In: ORACLE - Rows affected = 1
148     15:22:06  SQL Prepare: ORACLE - Commit

149     15:22:06  SQL Execute: ORACLE - Commit

150     15:22:06  SQL Data In: ORACLE - Rows affected = 0
151     15:22:06  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 46

152     15:22:06  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 46

153     15:22:06  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID'

154     15:22:06  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID'

155     15:22:06  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID'

156     15:22:06  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID'

157     15:22:06  SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED'

158     15:22:06  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED'

159     15:22:06  SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=46

160     15:22:06  SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=46

161     15:22:06  SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual

162     15:22:06  SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual

163     15:22:06  SQL Prepare: ORACLE - select * from XT_XTCS00

164     15:22:06  SQL Execute: ORACLE - select * from XT_XTCS00

165     15:22:07  SQL Prepare: ORACLE - select * from BM_YPLB00

166     15:22:07  SQL Execute: ORACLE - select * from BM_YPLB00

167     15:22:07  SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=181

168     15:22:07  SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=181

169     15:22:07  SQL Prepare: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and (( 
181= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=181))))

170     15:22:07  SQL Execute: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and (( 
181= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=181))))

171     15:22:07  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||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 ((181= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=181)))) ORDER BY B.F_TEMPTYPE,A.MKDM00

172     15:22:07  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||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 ((181= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=181)))) ORDER BY B.F_TEMPTYPE,A.MKDM00

173     15:22:07  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 ((181= 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=181))))  

174     15:22:07  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 ((181= 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=181))))  

175     15:22:07  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

176     15:22:07  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

177     15:22:07  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
181= 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=181))))

178     15:22:07  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
181= 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=181))))

179     15:22:15  SQL Prepare: ORACLE - SELECT B.BMBH00,B.BMMC00 FROM BM_BQFYZT F,BM_BMBM00 B
 WHERE F.BQBMBH=B.BMBH00
   AND F.YFBMBH=46
   AND B.BMXZ00='9' AND B.FLAG00='1'
 ORDER BY B.BH0000

180     15:22:15  SQL Execute: ORACLE - SELECT B.BMBH00,B.BMMC00 FROM BM_BQFYZT F,BM_BMBM00 B
 WHERE F.BQBMBH=B.BMBH00
   AND F.YFBMBH=46
   AND B.BMXZ00='9' AND B.FLAG00='1'
 ORDER BY B.BH0000

181     15:22:15  SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B
 WHERE F.BQBMBH=B.BMBH00
   AND F.YFBMBH=46
   AND B.BMXZ00='9' AND B.FLAG00='1'
 ORDER BY B.BH0000

182     15:22:15  SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B
 WHERE F.BQBMBH=B.BMBH00
   AND F.YFBMBH=46
   AND B.BMXZ00='9' AND B.FLAG00='1'
 ORDER BY B.BH0000

183     15:22:18  SQL Prepare: ORACLE - SELECT 1 FROM YF_YZYPSQ 
 WHERE YFBMBH=46
   AND  BQBMBH=62
   AND QLZT00 IN ('0','1')AND THBZ00='0'
   AND HZBZ00='1'

184     15:22:18  SQL Execute: ORACLE - SELECT 1 FROM YF_YZYPSQ 
 WHERE YFBMBH=46
   AND  BQBMBH=62
   AND QLZT00 IN ('0','1')AND THBZ00='0'
   AND HZBZ00='1'

185     15:22:18  SQL Prepare: ORACLE - SELECT 'X' FROM YF_YZYPSQ 
 WHERE YFBMBH=46
   AND  BQBMBH=62
   AND QLZT00 IN ('0','1') AND THBZ00='0'
   AND HZBZ00='0' AND ROWNUM=1

186     15:22:18  SQL Execute: ORACLE - SELECT 'X' FROM YF_YZYPSQ 
 WHERE YFBMBH=46
   AND  BQBMBH=62
   AND QLZT00 IN ('0','1') AND THBZ00='0'
   AND HZBZ00='0' AND ROWNUM=1

187     15:22:19  SQL Prepare: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2'
 WHERE YFBMBH=46
   AND BQBMBH=62

188     15:22:19  SQL Execute: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2'
 WHERE YFBMBH=46
   AND BQBMBH=62

189     15:22:19  SQL Data In: ORACLE - Rows affected = 1
190     15:22:19  SQL Prepare: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='1'
 WHERE YFBMBH=46
   AND BQBMBH=62
   AND QLZT00 IN('0','1')
   AND FYBZ00='0'
   AND THBZ00='0'
   AND CXBZ00='Z'

191     15:22:19  SQL Execute: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='1'
 WHERE YFBMBH=46
   AND BQBMBH=62
   AND QLZT00 IN('0','1')
   AND FYBZ00='0'
   AND THBZ00='0'
   AND CXBZ00='Z'

192     15:22:19  SQL Data In: ORACLE - Rows affected = 75
193     15:22:19  SQL Prepare: ORACLE - COMMIT

194     15:22:19  SQL Execute: ORACLE - COMMIT

195     15:22:19  SQL Data In: ORACLE - Rows affected = 0
196     15:22:20  SQL Prepare: ORACLE - SELECT Y.YPNM00,Y.YPMC00,Y.YPGG00,Y.LSDJ00,SUM(Y.YPZSL0) AS YPZSL0,
Y.QLDW00,Y.BQBMBH,Y.YFBMBH,D.DXSYBZ,X.GZDJ00,D.YPTYM0 
FROM YF_YZYPSQ Y,BM_YD0000 D,YF_YPKCXX X
WHERE Y.BQBMBH=:1
  AND Y.YFBMBH=:2
  AND Y.CLBZ00 LIKE :3
  AND Y.QLZT00 IN ('0','1')
  AND Y.HZBZ00='0'
  AND Y.FYBZ00='1'
  AND Y.YPNM00=D.YPNM00
  AND Y.YPNM00=X.YPNM00
  AND Y.YFBMBH=X.YFBMBH
  AND CXBZ00='Z'
GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,
         Y.YPNM00,Y.YPMC00,Y.YPGG00,
         Y.LSDJ00,Y.QLDW00,Y.BQBMBH,
         Y.YFBMBH,D.YPTYM0

197     15:22:20  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 62.000000
198     15:22:20  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 46.000000
199     15:22:20  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
200     15:22:20  SQL Execute: ORACLE - SELECT Y.YPNM00,Y.YPMC00,Y.YPGG00,Y.LSDJ00,SUM(Y.YPZSL0) AS YPZSL0,
Y.QLDW00,Y.BQBMBH,Y.YFBMBH,D.DXSYBZ,X.GZDJ00,D.YPTYM0 
FROM YF_YZYPSQ Y,BM_YD0000 D,YF_YPKCXX X
WHERE Y.BQBMBH=?
  AND Y.YFBMBH=?
  AND Y.CLBZ00 LIKE ?
  AND Y.QLZT00 IN ('0','1')
  AND Y.HZBZ00='0'
  AND Y.FYBZ00='1'
  AND Y.YPNM00=D.YPNM00
  AND Y.YPNM00=X.YPNM00
  AND Y.YFBMBH=X.YFBMBH
  AND CXBZ00='Z'
GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,
         Y.YPNM00,Y.YPMC00,Y.YPGG00,
         Y.LSDJ00,Y.QLDW00,Y.BQBMBH,
         Y.YFBMBH,D.YPTYM0

201     15:22:20  SQL Prepare: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000
FROM YF_YZYPSQ
WHERE YPNM00+0=:1
  AND BQBMBH=:2
  AND YFBMBH=:3
  AND QLZT00 IN ('0','1') 
  AND HZBZ00='0'
  AND FYBZ00='1'
  AND CXBZ00='Z'
ORDER BY CH0000

202     15:22:20  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1068.000000
203     15:22:20  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 62.000000
204     15:22:20  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 46.000000
205     15:22:20  SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000
FROM YF_YZYPSQ
WHERE YPNM00+0=?
  AND BQBMBH=?
  AND YFBMBH=?
  AND QLZT00 IN ('0','1') 
  AND HZBZ00='0'
  AND FYBZ00='1'
  AND CXBZ00='Z'
ORDER BY CH0000

206     15:22:33  SQL Prepare: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00
 where UPPER(XKH000)='H317'
 and BMBH00='62'
 and (YGXZ00 like '%2%' or YGXZ00 like '%4%')

207     15:22:33  SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00
 where UPPER(XKH000)='H317'
 and BMBH00='62'
 and (YGXZ00 like '%2%' or YGXZ00 like '%4%')

208     15:22:33  SQL Prepare: ORACLE - Commit

209     15:22:33  SQL Execute: ORACLE - Commit

210     15:22:33  SQL Data In: ORACLE - Rows affected = 0
211     15:22:33  SQL Prepare: ORACLE - BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE); END;
212     15:22:33  SQL Data In: ORACLE - Param = 1, Name = P_YPNM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
213     15:22:33  SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 46.000000
214     15:22:33  SQL Data In: ORACLE - Param = 3, Name = P_BQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 62.000000
215     15:22:33  SQL Data In: ORACLE - Param = 4, Name = P_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
216     15:22:33  SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
217     15:22:33  SQL Data In: ORACLE - Param = 6, Name = P_HZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
218     15:22:33  SQL Data In: ORACLE - Param = 7, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 181.000000
219     15:22:33  SQL Data In: ORACLE - Param = 8, Name = P_LYRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 344.000000
220     15:22:33  SQL Data In: ORACLE - Param = 9, Name = P_CKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
221     15:22:33  SQL Data In: ORACLE - Param = 10, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
222     15:22:33  SQL Execute: ORACLE - BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE); END;