1       16:18:20  SQL Prepare: ORACLE -  select  sysdate  N  from  dual 

2       16:18:20  SQL Execute: ORACLE -  select  sysdate  N  from  dual 

3       16:18:20  SQL Prepare: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2012 and  TQYF00 =2)

4       16:18:20  SQL Execute: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2012 and  TQYF00 =2)

5       16:18:21  SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_XGJJBB" (AD_CKBH00 => :AD_CKBH00,AD_TQNF00 => :AD_TQNF00,AD_TQYF00 => :AD_TQYF00,AS_TJFS00 => :AS_TJFS00,AS_XSFS00 => :AS_XSFS00,AS_SBMC00 => :AS_SBMC00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
6       16:18:21  SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_XGJJBB" (AD_CKBH00 => :AD_CKBH00,AD_TQNF00 => :AD_TQNF00,AD_TQYF00 => :AD_TQYF00,AS_TJFS00 => :AS_TJFS00,AS_XSFS00 => :AS_XSFS00,AS_SBMC00 => :AS_SBMC00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
7       16:18:22  SQL Prepare: ORACLE -  select MC0000 BMMC00,BMBH00,XM0003 YZ0000,XM0004 BYZJE0,XM0005 BYBTJE, 
 XM0008 YZCZZJ,XM0009 YZKJXM,XM0010 YZQTZJ,XM0011 BYCZZJ,
 XM0012 BYKJXM,XM0013 BYQTZJ,XM0014 LJCZZJ,XM0015 LJKJXM,
 XM0016 LJQTZJ,XM0017 JZCZZJ,XM0018 JZKJXM,XM0019 JZQTZJ,
 XM0006 LJZJ00,XM0007 JZ0000,(select BH0000 from bm_bmbm00 where bmbh00=a.bmbh00) BH0000 from BM_SBTJ00_TEMP a where id0000=21504
 order by CZRQ00,BMBH00 

8       16:18:22  SQL Execute: ORACLE -  select MC0000 BMMC00,BMBH00,XM0003 YZ0000,XM0004 BYZJE0,XM0005 BYBTJE, 
 XM0008 YZCZZJ,XM0009 YZKJXM,XM0010 YZQTZJ,XM0011 BYCZZJ,
 XM0012 BYKJXM,XM0013 BYQTZJ,XM0014 LJCZZJ,XM0015 LJKJXM,
 XM0016 LJQTZJ,XM0017 JZCZZJ,XM0018 JZKJXM,XM0019 JZQTZJ,
 XM0006 LJZJ00,XM0007 JZ0000,(select BH0000 from bm_bmbm00 where bmbh00=a.bmbh00) BH0000 from BM_SBTJ00_TEMP a where id0000=21504
 order by CZRQ00,BMBH00 

9       16:19:46  SQL Prepare: ORACLE - select BMBH00,BMMC00,BH0000,KSFLBH from bm_bmbm00 where flag00='1' order by BH0000

10      16:19:46  SQL Execute: ORACLE - select BMBH00,BMMC00,BH0000,KSFLBH from bm_bmbm00 where flag00='1' order by BH0000

11      16:29:35  Log started for: 后台维护系统
12      16:29:35  SQL Prepare: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','6',trim(PROGRAM)||'+'||'后台维护系统',SID,serial# ,'20120306','16:29:23','scott@super:8E8AC758AFD4FCDDEE5B7D0ECD1656A5' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

13      16:29:35  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','6',trim(PROGRAM)||'+'||'后台维护系统',SID,serial# ,'20120306','16:29:23','scott@super:8E8AC758AFD4FCDDEE5B7D0ECD1656A5' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

14      16:29:35  SQL Prepare: ORACLE - Commit

15      16:29:35  SQL Execute: ORACLE - Commit

16      16:29:35  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

17      16:29:35  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

18      16:29:35  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

19      16:29:35  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

20      16:29:35  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 

21      16:29:35  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 

22      16:29:35  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','6',trim(PROGRAM)||'+'||'后台维护系统',SID,serial# ,'20120306','16:29:23','sd_hospital@super:8E8AC758AFD4FCDDEE5B7D0ECD1656A5' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

23      16:29:35  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','6',trim(PROGRAM)||'+'||'后台维护系统',SID,serial# ,'20120306','16:29:23','sd_hospital@super:8E8AC758AFD4FCDDEE5B7D0ECD1656A5' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

24      16:29:35  SQL Prepare: ORACLE - Commit

25      16:29:35  SQL Execute: ORACLE - Commit

26      16:29:35  SQL Prepare: ORACLE -  delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 

27      16:29:35  SQL Execute: ORACLE -  delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 

28      16:29:35  SQL Prepare: ORACLE - Commit

29      16:29:35  SQL Execute: ORACLE - Commit

30      16:29:35  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='6'

31      16:29:35  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='6'

32      16:29:35  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 

33      16:29:35  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 

34      16:29:44  SQL Prepare: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# 
from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

35      16:29:44  SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# 
from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

36      16:29:44  SQL Prepare: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','6',trim(PROGRAM)||'+'||'后台维护系统',SID,serial# ,'20120306','16:29:32','scott@super:4FEF60119F70D5321E2D46745E90A57C' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

37      16:29:44  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','6',trim(PROGRAM)||'+'||'后台维护系统',SID,serial# ,'20120306','16:29:32','scott@super:4FEF60119F70D5321E2D46745E90A57C' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

38      16:29:44  SQL Prepare: ORACLE - Commit

39      16:29:44  SQL Execute: ORACLE - Commit

40      16:29:44  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

41      16:29:44  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

42      16:29:44  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

43      16:29:44  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

44      16:29:44  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 

45      16:29:44  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 

46      16:29:44  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','6',trim(PROGRAM)||'+'||'后台维护系统',SID,serial# ,'20120306','16:29:32','sd_hospital@super:4FEF60119F70D5321E2D46745E90A57C' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

47      16:29:44  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','6',trim(PROGRAM)||'+'||'后台维护系统',SID,serial# ,'20120306','16:29:32','sd_hospital@super:4FEF60119F70D5321E2D46745E90A57C' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

48      16:29:44  SQL Prepare: ORACLE - Commit

49      16:29:44  SQL Execute: ORACLE - Commit

50      16:29:44  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='6'

51      16:29:44  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='6'

52      16:29:44  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 

53      16:29:44  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 

54      16:29:44  SQL Prepare: ORACLE - Select SYSDATE from Dual

55      16:29:44  SQL Execute: ORACLE - Select SYSDATE from Dual

56      16:29:44  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

57      16:29:44  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

58      16:29:44  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

59      16:29:44  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

60      16:29:44  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='6'

61      16:29:44  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='6'

62      16:29:44  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

63      16:29:44  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

64      16:29:44  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

65      16:29:44  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

66      16:29:44  SQL Prepare: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('8')
 order by BH0000

67      16:29:44  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('8')
 order by BH0000

68      16:29:44  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'super'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'6' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='SUPER'))

69      16:29:44  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'super'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'6' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='SUPER'))

70      16:29:45  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=0

71      16:29:45  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=0

72      16:29:45  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

73      16:29:45  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

74      16:29:45  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

75      16:29:45  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

76      16:29:45  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

77      16:29:45  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

78      16:29:45  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

79      16:29:45  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

80      16:29:45  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'))

81      16:29:45  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'))

82      16:29:45  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2947421,0,'wlzx-3','6',nvl('38005621',' '),'',15)

83      16:29:45  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2947421,0,'wlzx-3','6',nvl('38005621',' '),'',15)

84      16:29:45  SQL Prepare: ORACLE - Commit

85      16:29:45  SQL Execute: ORACLE - Commit

86      16:29:45  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15

87      16:29:45  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15

88      16:29:45  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

89      16:29:45  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

90      16:29:45  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

91      16:29:45  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

92      16:29:45  SQL Prepare: ORACLE -  Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 

93      16:29:45  SQL Execute: ORACLE -  Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 

94      16:29:45  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120'

95      16:29:45  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120'

96      16:29:45  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y'

97      16:29:45  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y'

98      16:29:45  SQL Prepare: ORACLE -  update XT_SQIPDZ set ZT0000='1' where JQBH00=0

99      16:29:45  SQL Execute: ORACLE -  update XT_SQIPDZ set ZT0000='1' where JQBH00=0

100     16:29:45  SQL Prepare: ORACLE - Commit

101     16:29:45  SQL Execute: ORACLE - Commit

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

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

104     16:29:45  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

105     16:29:45  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

106     16:29:45  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 

107     16:29:45  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 

108     16:29:46  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

109     16:29:46  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

110     16:29:46  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='6') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',15,')> 0) and YXQ000>='20120306'

111     16:29:46  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='6') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',15,')> 0) and YXQ000>='20120306'

112     16:29:46  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

113     16:29:46  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

114     16:29:46  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

115     16:29:46  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

116     16:29:46  SQL Prepare: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX'

117     16:29:46  SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX'

118     16:29:46  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL

119     16:29:46  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL

120     16:29:46  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

121     16:29:46  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

122     16:29:46  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX'

123     16:29:46  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX'

124     16:29:46  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='6' and (( 
0= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='6'))) 

125     16:29:46  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='6' and (( 
0= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='6'))) 

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

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

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

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

130     16:29:46  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
0= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='+ '))) 

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

132     16:29:46  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
0= 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=0))))

133     16:29:46  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
0= 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=0))))

134     16:29:46  SQL Prepare: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('XT_YSXGFBKS','XT_XTXXYTJRXG','YF_SFXSGJJ','XT_SFXSGLYKFPQX')

135     16:29:46  SQL Execute: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('XT_YSXGFBKS','XT_XTXXYTJRXG','YF_SFXSGJJ','XT_SFXSGLYKFPQX')

136     16:29:46  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 0

137     16:29:46  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 0

138     16:29:49  SQL Prepare: ORACLE - Select * from XT_YGXZ00 ORDER BY DM0000

139     16:29:49  SQL Execute: ORACLE - Select * from XT_YGXZ00 ORDER BY DM0000

140     16:29:49  SQL Prepare: ORACLE - Select * from vw_bm_bmbm01 ORDER BY BH0000

141     16:29:49  SQL Execute: ORACLE - Select * from vw_bm_bmbm01 ORDER BY BH0000

142     16:29:49  SQL Prepare: ORACLE - select t1.YGBH00,t1.BMBH00,t1.ZWXM00,t1.XB0000,t1.XKH000,
       t1.PYSM00,t1.WBSM00,
       (select BMMC00 from BM_BMBM00 where t1.BMBH00=BMBH00(+)) BMMC00,
       t1.YGXZ00,
       t1.CFJB00,t1.GZDJ00,t1.MZDJ00,t1.DPDJ00,t1.SJDJ00,t1.KSSJB0,
       t1.CZBZ00,t1.DLMM00,t1.BRID00,t1.MRGHLB,
       (select LBMC00 from BM_GHLBB0 where SFYX00='Y' and t1.MRGHLB=LBBH00(+)) LBMC00,
       t1.YSLB00,
       (select YSLBMC from BM_YSLB00 where t1.YSLB00=YSLB00(+)) YSLBMC,
       t1.ssdj00,t1.ylfl00,t1.DH0000,       
       DECODE(T1.CZRQ01, NULL, '',
       substr(nvl(T1.CZRQ01, ''),1,4)||'.'||
       substr(nvl(T1.CZRQ01, ''),5,2)||'.'||
       substr(nvl(T1.CZRQ01, ''),7,2)||' '||T1.CZSJ01) CZRQSJ, T1.CZY001,
       (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=T1.CZY001) CZYXM0
from BM_YGBM00 T1
where t1.YGBH00>=1 and CZBZ00<>'2'
order by t1.XKH000, t1.BMBH00

143     16:29:49  SQL Execute: ORACLE - select t1.YGBH00,t1.BMBH00,t1.ZWXM00,t1.XB0000,t1.XKH000,
       t1.PYSM00,t1.WBSM00,
       (select BMMC00 from BM_BMBM00 where t1.BMBH00=BMBH00(+)) BMMC00,
       t1.YGXZ00,
       t1.CFJB00,t1.GZDJ00,t1.MZDJ00,t1.DPDJ00,t1.SJDJ00,t1.KSSJB0,
       t1.CZBZ00,t1.DLMM00,t1.BRID00,t1.MRGHLB,
       (select LBMC00 from BM_GHLBB0 where SFYX00='Y' and t1.MRGHLB=LBBH00(+)) LBMC00,
       t1.YSLB00,
       (select YSLBMC from BM_YSLB00 where t1.YSLB00=YSLB00(+)) YSLBMC,
       t1.ssdj00,t1.ylfl00,t1.DH0000,       
       DECODE(T1.CZRQ01, NULL, '',
       substr(nvl(T1.CZRQ01, ''),1,4)||'.'||
       substr(nvl(T1.CZRQ01, ''),5,2)||'.'||
       substr(nvl(T1.CZRQ01, ''),7,2)||' '||T1.CZSJ01) CZRQSJ, T1.CZY001,
       (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=T1.CZY001) CZYXM0
from BM_YGBM00 T1
where t1.YGBH00>=1 and CZBZ00<>'2'
order by t1.XKH000, t1.BMBH00

144     16:34:11  SQL Prepare: ORACLE - RollBack

145     16:34:11  SQL Execute: ORACLE - RollBack

146     16:34:12  SQL Prepare: ORACLE - select t1.YGBH00,t1.BMBH00,t1.ZWXM00,t1.XB0000,t1.XKH000,t1.PYSM00,t1.WBSM00,(select BMMC00 from BM_BMBM00 where t1.BMBH00=BMBH00(+)) BMMC00,t1.YGXZ00,t1.CFJB00,t1.GZDJ00,t1.MZDJ00,t1.DPDJ00,t1.SJDJ00,t1.KSSJB0,t1.CZBZ00,t1.DLMM00,t1.BRID00,t1.MRGHLB,(select LBMC00 from BM_GHLBB0 where SFYX00='Y' and t1.MRGHLB=LBBH00(+)) LBMC00,t1.YSLB00,(select YSLBMC from BM_YSLB00 where t1.YSLB00=YSLB00(+)) YSLBMC,t1.ssdj00,t1.ylfl00,t1.DH0000, DECODE(T1.CZRQ01, NULL, '', substr(nvl(T1.CZRQ01, ''),1,4)||'.'|| substr(nvl(T1.CZRQ01, ''),5,2)||'.'|| substr(nvl(T1.CZRQ01, ''),7,2)||' '||T1.CZSJ01) CZRQSJ, T1.CZY001, (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=T1.CZY001) CZYXM0 FROM BM_YGBM00 t1 WHERE t1.YGBH00>=1  and CZBZ00<>'2' order by t1.XKH000,t1.BMBH00 

147     16:34:12  SQL Execute: ORACLE - select t1.YGBH00,t1.BMBH00,t1.ZWXM00,t1.XB0000,t1.XKH000,t1.PYSM00,t1.WBSM00,(select BMMC00 from BM_BMBM00 where t1.BMBH00=BMBH00(+)) BMMC00,t1.YGXZ00,t1.CFJB00,t1.GZDJ00,t1.MZDJ00,t1.DPDJ00,t1.SJDJ00,t1.KSSJB0,t1.CZBZ00,t1.DLMM00,t1.BRID00,t1.MRGHLB,(select LBMC00 from BM_GHLBB0 where SFYX00='Y' and t1.MRGHLB=LBBH00(+)) LBMC00,t1.YSLB00,(select YSLBMC from BM_YSLB00 where t1.YSLB00=YSLB00(+)) YSLBMC,t1.ssdj00,t1.ylfl00,t1.DH0000, DECODE(T1.CZRQ01, NULL, '', substr(nvl(T1.CZRQ01, ''),1,4)||'.'|| substr(nvl(T1.CZRQ01, ''),5,2)||'.'|| substr(nvl(T1.CZRQ01, ''),7,2)||' '||T1.CZSJ01) CZRQSJ, T1.CZY001, (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=T1.CZY001) CZYXM0 FROM BM_YGBM00 t1 WHERE t1.YGBH00>=1  and CZBZ00<>'2' order by t1.XKH000,t1.BMBH00 

148     16:34:25  SQL Prepare: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=2947421

149     16:34:25  SQL Execute: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=2947421

150     16:34:25  SQL Prepare: ORACLE - Commit

151     16:34:25  SQL Execute: ORACLE - Commit

152     16:34:25  SQL Prepare: ORACLE -  update XT_SQIPDZ set ZT0000='0' where JQBH00=0

153     16:34:25  SQL Execute: ORACLE -  update XT_SQIPDZ set ZT0000='0' where JQBH00=0

154     16:34:25  SQL Prepare: ORACLE - Commit

155     16:34:25  SQL Execute: ORACLE - Commit

156     16:34:26  Log started for: Sickberth
157     16:34:32  Log started for: 临床输血管理系统
158     08:43:45  Log started for: 固定资产核算管理系统
159     08:43:48  SQL Prepare: ORACLE -  select  sysdate  N  from  dual 

160     08:43:48  SQL Execute: ORACLE -  select  sysdate  N  from  dual 

161     08:43:48  SQL Prepare: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2011 and  TQYF00 =11)

162     08:43:48  SQL Execute: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2011 and  TQYF00 =11)

163     08:43:48  SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_XGJJBB" (AD_CKBH00 => :AD_CKBH00,AD_TQNF00 => :AD_TQNF00,AD_TQYF00 => :AD_TQYF00,AS_TJFS00 => :AS_TJFS00,AS_XSFS00 => :AS_XSFS00,AS_SBMC00 => :AS_SBMC00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
164     08:43:48  SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_XGJJBB" (AD_CKBH00 => :AD_CKBH00,AD_TQNF00 => :AD_TQNF00,AD_TQYF00 => :AD_TQYF00,AS_TJFS00 => :AS_TJFS00,AS_XSFS00 => :AS_XSFS00,AS_SBMC00 => :AS_SBMC00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
165     08:43:49  SQL Prepare: ORACLE -  select MC0000 BMMC00,BMBH00,XM0003 YZ0000,XM0004 BYZJE0,XM0005 BYBTJE, 
 XM0008 YZCZZJ,XM0009 YZKJXM,XM0010 YZQTZJ,XM0011 BYCZZJ,
 XM0012 BYKJXM,XM0013 BYQTZJ,XM0014 LJCZZJ,XM0015 LJKJXM,
 XM0016 LJQTZJ,XM0017 JZCZZJ,XM0018 JZKJXM,XM0019 JZQTZJ,
 XM0006 LJZJ00,XM0007 JZ0000,(select BH0000 from bm_bmbm00 where bmbh00=a.bmbh00) BH0000 from BM_SBTJ00_TEMP a where id0000=21602
 order by CZRQ00,BMBH00 

166     08:43:49  SQL Execute: ORACLE -  select MC0000 BMMC00,BMBH00,XM0003 YZ0000,XM0004 BYZJE0,XM0005 BYBTJE, 
 XM0008 YZCZZJ,XM0009 YZKJXM,XM0010 YZQTZJ,XM0011 BYCZZJ,
 XM0012 BYKJXM,XM0013 BYQTZJ,XM0014 LJCZZJ,XM0015 LJKJXM,
 XM0016 LJQTZJ,XM0017 JZCZZJ,XM0018 JZKJXM,XM0019 JZQTZJ,
 XM0006 LJZJ00,XM0007 JZ0000,(select BH0000 from bm_bmbm00 where bmbh00=a.bmbh00) BH0000 from BM_SBTJ00_TEMP a where id0000=21602
 order by CZRQ00,BMBH00 

167     08:44:42  SQL Prepare: ORACLE -  select  sysdate  N  from  dual 

168     08:44:42  SQL Execute: ORACLE -  select  sysdate  N  from  dual 

169     08:44:42  SQL Prepare: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2011 and  TQYF00 =12)

170     08:44:42  SQL Execute: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2011 and  TQYF00 =12)

171     08:44:42  SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_XGJJBB" (AD_CKBH00 => :AD_CKBH00,AD_TQNF00 => :AD_TQNF00,AD_TQYF00 => :AD_TQYF00,AS_TJFS00 => :AS_TJFS00,AS_XSFS00 => :AS_XSFS00,AS_SBMC00 => :AS_SBMC00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
172     08:44:42  SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_XGJJBB" (AD_CKBH00 => :AD_CKBH00,AD_TQNF00 => :AD_TQNF00,AD_TQYF00 => :AD_TQYF00,AS_TJFS00 => :AS_TJFS00,AS_XSFS00 => :AS_XSFS00,AS_SBMC00 => :AS_SBMC00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
173     08:44:43  SQL Prepare: ORACLE -  select MC0000 BMMC00,BMBH00,XM0003 YZ0000,XM0004 BYZJE0,XM0005 BYBTJE, 
 XM0008 YZCZZJ,XM0009 YZKJXM,XM0010 YZQTZJ,XM0011 BYCZZJ,
 XM0012 BYKJXM,XM0013 BYQTZJ,XM0014 LJCZZJ,XM0015 LJKJXM,
 XM0016 LJQTZJ,XM0017 JZCZZJ,XM0018 JZKJXM,XM0019 JZQTZJ,
 XM0006 LJZJ00,XM0007 JZ0000,(select BH0000 from bm_bmbm00 where bmbh00=a.bmbh00) BH0000 from BM_SBTJ00_TEMP a where id0000=21603
 order by CZRQ00,BMBH00 

174     08:44:43  SQL Execute: ORACLE -  select MC0000 BMMC00,BMBH00,XM0003 YZ0000,XM0004 BYZJE0,XM0005 BYBTJE, 
 XM0008 YZCZZJ,XM0009 YZKJXM,XM0010 YZQTZJ,XM0011 BYCZZJ,
 XM0012 BYKJXM,XM0013 BYQTZJ,XM0014 LJCZZJ,XM0015 LJKJXM,
 XM0016 LJQTZJ,XM0017 JZCZZJ,XM0018 JZKJXM,XM0019 JZQTZJ,
 XM0006 LJZJ00,XM0007 JZ0000,(select BH0000 from bm_bmbm00 where bmbh00=a.bmbh00) BH0000 from BM_SBTJ00_TEMP a where id0000=21603
 order by CZRQ00,BMBH00 

175     09:01:23  SQL Prepare: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1'

176     09:01:23  SQL Execute: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1'

177     09:01:39  SQL Prepare: ORACLE - select RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000,SUM(SL0000)
 SL0000,SUM(ZJE000) ZJE000 from vw_SB_RCKJFJ
 where RCMXID in (select RCMXID from SB_RCKMX0
 where RCKID0 in ( 
select RCKID0 from SB_RCK000
 where DJLX00='1'
 and RZRQ00>='20120201'
 and RZRQ00<='20120229'
 and LXID00='1'
 and CKBH00=175
 ))
 Group by RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000 

178     09:01:39  SQL Execute: ORACLE - select RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000,SUM(SL0000)
 SL0000,SUM(ZJE000) ZJE000 from vw_SB_RCKJFJ
 where RCMXID in (select RCMXID from SB_RCKMX0
 where RCKID0 in ( 
select RCKID0 from SB_RCK000
 where DJLX00='1'
 and RZRQ00>='20120201'
 and RZRQ00<='20120229'
 and LXID00='1'
 and CKBH00=175
 ))
 Group by RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000 

179     09:01:59  SQL Prepare: ORACLE - RollBack

180     09:01:59  SQL Execute: ORACLE - RollBack

181     09:05:32  SQL Prepare: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1'

182     09:05:32  SQL Execute: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1'

183     09:05:32  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=175
 and DLXTMC='固定资产核算管理系统' and CTMC00='frmSB_RKDCX'

184     09:05:32  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=175
 and DLXTMC='固定资产核算管理系统' and CTMC00='frmSB_RKDCX'

185     09:05:32  SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.*,
decode(a.SHBZ00,'2','已审核',
'1','未审核','3','已作废') SHBZMC 
 from vw_SB_RCK000 a
 where DJLX00='1'
 and DJRQ00>='20120307'
 and DJRQ00<='20120307'
 and CKBH00=175
 order by SHBZ00,RCKID0

186     09:05:32  SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.*,
decode(a.SHBZ00,'2','已审核',
'1','未审核','3','已作废') SHBZMC 
 from vw_SB_RCK000 a
 where DJLX00='1'
 and DJRQ00>='20120307'
 and DJRQ00<='20120307'
 and CKBH00=175
 order by SHBZ00,RCKID0

187     09:05:34  SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.*,
decode(a.SHBZ00,'2','已审核',
'1','未审核','3','已作废') SHBZMC 
 from vw_SB_RCK000 a
 where DJLX00='1'
 and DJRQ00>='20120307'
 and DJRQ00<='20120307'
 and CKBH00=175
 order by SHBZ00,RCKID0

188     09:05:34  SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.*,
decode(a.SHBZ00,'2','已审核',
'1','未审核','3','已作废') SHBZMC 
 from vw_SB_RCK000 a
 where DJLX00='1'
 and DJRQ00>='20120307'
 and DJRQ00<='20120307'
 and CKBH00=175
 order by SHBZ00,RCKID0

189     09:05:39  SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.*,
decode(a.SHBZ00,'2','已审核',
'1','未审核','3','已作废') SHBZMC 
 from vw_SB_RCK000 a
 where DJLX00='1'
 and DJRQ00>='20120307'
 and DJRQ00<='20120307'
 and CKBH00=175
 order by SHBZ00,RCKID0

190     09:05:39  SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.*,
decode(a.SHBZ00,'2','已审核',
'1','未审核','3','已作废') SHBZMC 
 from vw_SB_RCK000 a
 where DJLX00='1'
 and DJRQ00>='20120307'
 and DJRQ00<='20120307'
 and CKBH00=175
 order by SHBZ00,RCKID0

191     09:05:47  SQL Prepare: ORACLE - RollBack

192     09:05:47  SQL Execute: ORACLE - RollBack

193     09:06:24  SQL Prepare: ORACLE - select RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000,SUM(SL0000)
 SL0000,SUM(ZJE000) ZJE000 from vw_SB_RCKJFJ
 where RCMXID in (select RCMXID from SB_RCKMX0
 where RCKID0 in ( 
select RCKID0 from SB_RCK000
 where DJLX00='1'
 and RZRQ00>='20120201'
 and RZRQ00<='20120229'
 and LXID00='1'
 and CKBH00=175
 ))
 Group by RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000 

194     09:06:24  SQL Execute: ORACLE - select RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000,SUM(SL0000)
 SL0000,SUM(ZJE000) ZJE000 from vw_SB_RCKJFJ
 where RCMXID in (select RCMXID from SB_RCKMX0
 where RCKID0 in ( 
select RCKID0 from SB_RCK000
 where DJLX00='1'
 and RZRQ00>='20120201'
 and RZRQ00<='20120229'
 and LXID00='1'
 and CKBH00=175
 ))
 Group by RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000 

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

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

197     09:07:07  SQL Prepare: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','665','60208' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual

198     09:07:07  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','665','60208' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual

199     09:07:07  SQL Prepare: ORACLE - Commit

200     09:07:07  SQL Execute: ORACLE - Commit

201     09:07:07  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

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

203     09:07:07  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

204     09:07:07  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

205     09:07:07  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

206     09:07:07  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

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

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

209     09:07:07  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','158','10002' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual

210     09:07:07  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','158','10002' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual

211     09:07:07  SQL Prepare: ORACLE - Commit

212     09:07:07  SQL Execute: ORACLE - Commit

213     09:07:07  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G'

214     09:07:07  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G'

215     09:07:07  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

216     09:07:07  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

217     09:07:07  SQL Prepare: ORACLE -  Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G'

218     09:07:07  SQL Execute: ORACLE -  Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G'

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

220     09:07:07  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='G'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('a','b','9','8')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 order by b.PLXH00,a.BH0000

221     09:07:10  SQL Prepare: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '169'

222     09:07:10  SQL Execute: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '169'

223     09:07:10  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

224     09:07:10  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

225     09:07:10  SQL Prepare: ORACLE -  Select '00' as XTDM00 from dual where 
'9998'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'G' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='G' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 

226     09:07:10  SQL Execute: ORACLE -  Select '00' as XTDM00 from dual where 
'9998'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'G' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='G' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 

227     09:07:10  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

228     09:07:10  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

229     09:07:10  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

230     09:07:10  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

231     09:07:10  SQL Prepare: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=2947960

232     09:07:10  SQL Execute: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=2947960

233     09:07:10  SQL Prepare: ORACLE - Commit

234     09:07:10  SQL Execute: ORACLE - Commit

235     09:07:10  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

236     09:07:10  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

237     09:07:10  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

238     09:07:10  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

239     09:07:10  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'))

240     09:07:10  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'))

241     09:07:10  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2948041,476,'wlzx-3','G',nvl('38008631',' '),'192.168.12.120#158:10002@Prj_GDZC.exe+固定资产核算管理系统',169)

242     09:07:10  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2948041,476,'wlzx-3','G',nvl('38008631',' '),'192.168.12.120#158:10002@Prj_GDZC.exe+固定资产核算管理系统',169)

243     09:07:10  SQL Prepare: ORACLE - Commit

244     09:07:10  SQL Execute: ORACLE - Commit

245     09:07:10  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 169

246     09:07:10  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 169

247     09:07:10  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

248     09:07:10  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

249     09:07:10  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

250     09:07:10  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

251     09:07:10  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120'

252     09:07:10  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120'

253     09:07:10  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

254     09:07:10  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

255     09:07:10  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
169 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

256     09:07:10  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
169 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

257     09:07:10  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20120307'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',169,' )>0 )

258     09:07:10  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20120307'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',169,' )>0 )

259     09:07:10  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

260     09:07:10  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

261     09:07:10  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

262     09:07:10  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

263     09:07:10  SQL Prepare: ORACLE -  select sysdate nowtime  from dual  

264     09:07:10  SQL Execute: ORACLE -  select sysdate nowtime  from dual  

265     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_YHCS00  where  YGBH00 = 476

266     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_YHCS00  where  YGBH00 = 476

267     09:07:10  SQL Prepare: ORACLE -  select  VALUE0  from  XT_XTCS00  where  NAME00 = 'SF_PRINTSCALE'

268     09:07:10  SQL Execute: ORACLE -  select  VALUE0  from  XT_XTCS00  where  NAME00 = 'SF_PRINTSCALE'

269     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_PageWidth'

270     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_PageWidth'

271     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_USER_ZBWidth'

272     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_USER_ZBWidth'

273     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_USER_ZBHeigh'

274     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_USER_ZBHeigh'

275     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_USER_ZBJ00'

276     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_USER_ZBJ00'

277     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_USER_YBJ00'

278     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_USER_YBJ00'

279     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_PageHeigh'

280     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_PageHeigh'

281     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SF_PageDirect'

282     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SF_PageDirect'

283     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SF_TJKSSJ'

284     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SF_TJKSSJ'

285     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SF_TJJSSJ'

286     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SF_TJJSSJ'

287     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_SlExperSBLB'

288     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_SlExperSBLB'

289     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_SBBM_SFZDSC'

290     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_SBBM_SFZDSC'

291     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_SBBM_LENGTH'

292     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_SBBM_LENGTH'

293     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_KCDWSFFK'

294     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_KCDWSFFK'

295     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_SBRKGGXHSFGG'

296     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_SBRKGGXHSFGG'

297     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_KPH000_SFZD'

298     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_KPH000_SFZD'

299     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SF_USER_PageWidth'

300     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SF_USER_PageWidth'

301     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SF_USER_PageHeigh'

302     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SF_USER_PageHeigh'

303     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_DJGSCS'

304     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_DJGSCS'

305     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_ZDY_RKDDYGSID'

306     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_ZDY_RKDDYGSID'

307     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_ZDY_CKDDYGSID'

308     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_ZDY_CKDDYGSID'

309     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'WZ_YYGXH'

310     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'WZ_YYGXH'

311     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_ZCPMZDLBQY2006'

312     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_ZCPMZDLBQY2006'

313     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_SBBM_SFZDSCLX'

314     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_SBBM_SFZDSCLX'

315     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_GZDJHDL'

316     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_GZDJHDL'

317     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_RYGSCS'

318     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_RYGSCS'

319     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_RKDQR'

320     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_RKDQR'

321     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_JXZJDJBLZ'

322     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_JXZJDJBLZ'

323     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_DJHAZCKTJ'

324     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_DJHAZCKTJ'

325     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_PDDDYSFZJYZDZD'

326     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_PDDDYSFZJYZDZD'

327     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_ZCDAXGCJBQXS'

328     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_ZCDAXGCJBQXS'

329     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_XXGJBKZKHBZJ'

330     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_XXGJBKZKHBZJ'

331     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_DAKPDKDYGS'

332     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_DAKPDKDYGS'

333     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_PDDYFJJESFTJ'

334     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_PDDYFJJESFTJ'

335     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_TJYSBFLSFACKFK'

336     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_TJYSBFLSFACKFK'

337     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_ZJJDSFZJZJ'

338     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'GDZC_ZJJDSFZJZJ'

339     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_ZCPLCKXS'

340     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_ZCPLCKXS'

341     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_CKMXHZCXSFBKTK'

342     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_CKMXHZCXSFBKTK'

343     09:07:10  SQL Prepare: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_CKBHSFKZCCBH'

344     09:07:10  SQL Execute: ORACLE -  select  *  from  XT_XTCS00  where  NAME00 = 'SB_CKBHSFKZCCBH'

345     09:07:10  SQL Prepare: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('SB_JTXGJJTJSFYBMBH','GDZC_WXPJSYZKZC','GDZC_BFQKTJZCLBTJ')

346     09:07:10  SQL Execute: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('SB_JTXGJJTJSFYBMBH','GDZC_WXPJSYZKZC','GDZC_BFQKTJZCLBTJ')

347     09:07:10  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='G' and (( 
476= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='G'))) 

348     09:07:10  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='G' and (( 
476= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='G'))) 

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

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

351     09:07:10  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 exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 

352     09:07:10  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 exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 

353     09:07:10  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

354     09:07:10  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

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

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

357     09:07:15  SQL Prepare: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1'

358     09:07:15  SQL Execute: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1'

359     09:07:18  SQL Prepare: ORACLE - select RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000,SUM(SL0000)
 SL0000,SUM(ZJE000) ZJE000 from vw_SB_RCKJFJ
 where RCMXID in (select RCMXID from SB_RCKMX0
 where RCKID0 in ( 
select RCKID0 from SB_RCK000
 where DJLX00='1'
 and RZRQ00>='20120307'
 and RZRQ00<='20120307'
 and CKBH00=169
 ))
 Group by RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000 

360     09:07:18  SQL Execute: ORACLE - select RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000,SUM(SL0000)
 SL0000,SUM(ZJE000) ZJE000 from vw_SB_RCKJFJ
 where RCMXID in (select RCMXID from SB_RCKMX0
 where RCKID0 in ( 
select RCKID0 from SB_RCK000
 where DJLX00='1'
 and RZRQ00>='20120307'
 and RZRQ00<='20120307'
 and CKBH00=169
 ))
 Group by RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000 

361     09:07:21  SQL Prepare: ORACLE - select RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000,SUM(SL0000)
 SL0000,SUM(ZJE000) ZJE000 from vw_SB_RCKJFJ
 where RCMXID in (select RCMXID from SB_RCKMX0
 where RCKID0 in ( 
select RCKID0 from SB_RCK000
 where DJLX00='1'
 and RZRQ00>='20120107'
 and RZRQ00<='20120307'
 and LXID00='1'
 and CKBH00=169
 ))
 Group by RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000 

362     09:07:21  SQL Execute: ORACLE - select RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000,SUM(SL0000)
 SL0000,SUM(ZJE000) ZJE000 from vw_SB_RCKJFJ
 where RCMXID in (select RCMXID from SB_RCKMX0
 where RCKID0 in ( 
select RCKID0 from SB_RCK000
 where DJLX00='1'
 and RZRQ00>='20120107'
 and RZRQ00<='20120307'
 and LXID00='1'
 and CKBH00=169
 ))
 Group by RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000 

363     09:07:33  SQL Prepare: ORACLE - select RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000,SUM(SL0000)
 SL0000,SUM(ZJE000) ZJE000 from vw_SB_RCKJFJ
 where RCMXID in (select RCMXID from SB_RCKMX0
 where RCKID0 in ( 
select RCKID0 from SB_RCK000
 where DJLX00='1'
 and RZRQ00>='20110107'
 and RZRQ00<='20120307'
 and LXID00='1'
 and CKBH00=169
 ))
 Group by RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000 

364     09:07:33  SQL Execute: ORACLE - select RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000,SUM(SL0000)
 SL0000,SUM(ZJE000) ZJE000 from vw_SB_RCKJFJ
 where RCMXID in (select RCMXID from SB_RCKMX0
 where RCKID0 in ( 
select RCKID0 from SB_RCK000
 where DJLX00='1'
 and RZRQ00>='20110107'
 and RZRQ00<='20120307'
 and LXID00='1'
 and CKBH00=169
 ))
 Group by RZRQ00,RCLXMC,ZWPM00,GG0000,JLDW00,DJ0000