1       10:56:31  Log started for: 住院医生工作站系统
2       10:56:31  SQL Prepare: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','956','435' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual

3       10:56:31  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','956','435' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual

4       10:56:31  SQL Data In: ORACLE - Rows affected = 1
5       10:56:31  SQL Prepare: ORACLE - Commit

6       10:56:31  SQL Execute: ORACLE - Commit

7       10:56:31  SQL Data In: ORACLE - Rows affected = 0
8       10:56:31  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

9       10:56:31  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

10      10:56:31  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

11      10:56:31  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

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

13      10:56:31  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

14      10:56:31  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

15      10:56:31  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

16      10:56:31  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','670','37822' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual

17      10:56:31  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','670','37822' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual

18      10:56:31  SQL Data In: ORACLE - Rows affected = 1
19      10:56:31  SQL Prepare: ORACLE - Commit

20      10:56:31  SQL Execute: ORACLE - Commit

21      10:56:31  SQL Data In: ORACLE - Rows affected = 0
22      10:56:31  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z'

23      10:56:31  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z'

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

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

26      10:56:31  SQL Prepare: ORACLE - Select SYSDATE from Dual

27      10:56:31  SQL Execute: ORACLE - Select SYSDATE from Dual

28      10:56:31  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

29      10:56:31  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

30      10:56:31  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

31      10:56:31  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

32      10:56:31  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z'

33      10:56:31  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z'

34      10:56:31  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

35      10:56:31  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

36      10:56:31  SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

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

38      10:56:31  SQL Prepare: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='Z'
 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 ('0',',','1',',','8')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='Z'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 order by b.PLXH00,a.BH0000

39      10:56:31  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='Z'
 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 ('0',',','1',',','8')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='Z'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 order by b.PLXH00,a.BH0000

40      10:56:34  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'9998'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'Z' 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='Z' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 

41      10:56:34  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'9998'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'Z' 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='Z' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 

42      10:56:35  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

43      10:56:35  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

44      10:56:35  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

45      10:56:35  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

46      10:56:35  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

47      10:56:35  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

48      10:56:35  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

49      10:56:35  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

50      10:56:35  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

51      10:56:35  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

52      10:56:35  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'))

53      10:56:35  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'))

54      10:56:35  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3150398,476,'wlzx-3','Z',nvl('38961356',' '),'192.168.12.120#670:37822@ZY_YS.exe+住院医生工作站系统',22)

55      10:56:35  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3150398,476,'wlzx-3','Z',nvl('38961356',' '),'192.168.12.120#670:37822@ZY_YS.exe+住院医生工作站系统',22)

56      10:56:35  SQL Data In: ORACLE - Rows affected = 1
57      10:56:35  SQL Prepare: ORACLE - Commit

58      10:56:35  SQL Execute: ORACLE - Commit

59      10:56:35  SQL Data In: ORACLE - Rows affected = 0
60      10:56:35  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 22

61      10:56:35  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 22

62      10:56:35  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

63      10:56:35  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

64      10:56:35  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

65      10:56:35  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

66      10:56:35  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120'

67      10:56:35  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120'

68      10:56:35  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

69      10:56:35  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

70      10:56:35  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
22 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

71      10:56:35  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
22 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

72      10:56:35  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

73      10:56:35  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

74      10:56:35  SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'Z'||',')>0 

75      10:56:35  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'Z'||',')>0 

76      10:56:36  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN'

77      10:56:36  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN'

78      10:56:36  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

79      10:56:36  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

80      10:56:36  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='Z') and YXQ000>='20120808'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',22,' )>0 )

81      10:56:36  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='Z') and YXQ000>='20120808'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',22,' )>0 )

82      10:56:36  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

83      10:56:36  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

84      10:56:36  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

85      10:56:36  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

86      10:56:36  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

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

88      10:56:36  SQL Prepare: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

89      10:56:36  SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

90      10:56:36  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','670','37822' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ADO:' from dual

91      10:56:36  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','670','37822' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ADO:' from dual

92      10:56:36  SQL Data In: ORACLE - Rows affected = 1
93      10:56:36  SQL Prepare: ORACLE - Commit

94      10:56:36  SQL Execute: ORACLE - Commit

95      10:56:36  SQL Data In: ORACLE - Rows affected = 0
96      10:56:37  SQL Prepare: ORACLE - SELECT to_char(sid,'0000')  FROM V$SESSION where userenv('sessionid')=audsid 

97      10:56:37  SQL Execute: ORACLE - SELECT to_char(sid,'0000')  FROM V$SESSION where userenv('sessionid')=audsid 

98      10:56:37  SQL Prepare: ORACLE - begin 
 package_zhcx.set_var('0670'); 
 END;

99      10:56:37  SQL Execute: ORACLE - begin 
 package_zhcx.set_var('0670'); 
 END;

100     10:56:37  SQL Data In: ORACLE - Rows affected = 0
101     10:56:37  SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a

102     10:56:37  SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a

103     10:56:37  SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a

104     10:56:37  SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a

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

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

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

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

109     10:56:37  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 '))) 

110     10:56:37  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 '))) 

111     10:56:37  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

112     10:56:37  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

113     10:56:37  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='+ '))) 

114     10:56:37  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='+ '))) 

115     10:56:37  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID'

116     10:56:37  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID'

117     10:56:37  SQL Prepare: ORACLE - select Trigger_Name from all_triggers
 where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%'

118     10:56:37  SQL Execute: ORACLE - select Trigger_Name from all_triggers
 where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%'

119     10:56:37  SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%'  or name00 in ('zs_RunMode','XT_QDXXZHYE','ZS_YAPSSSFKYSC','BQ_NT5','BQ_RQDCDZ','ZS_YZDYGS','ZS_YZSFTD','ZS_BRQFSFYXLYZ','ZS_SSTHSFXG','ZS_FYYZSFSRZDHBQZY','BQ_SZYS_RYZDSFXS','ZS_MBSFTZ','ZS_SFXSBB','ZS_BLGSSFTZ','ZS_SFSYPASSXT','ZS_SFHISSJDR','ZS_YZDYLRSJ','SS_SFYFSZT','ZS_JYXMSRTZXX','ZS_BASYSGSRJBMC','ZS_YZWHJMXSBAH','ZS_CFJBKSSJB','ZS_FYYZXZJYXM','ZS_YZZJQRCDZ','ZS_SFGBADO','ZS_XZYSCZBLQX','ZS_CGBJJESFTS','ZS_YZYXBCYPBM','ZS_FTZYBCYPJJSH','ZS_SFZYYH','ZS_BRLLSFXSGDH','YS_ZFBRZFBLYBLB','ZS_BASYJBXXZDYID','ZS_BASYZDXXZDYID','ZS_BASYSSXXZDYID','ZS_YZWHSFZHJYXM','ZS_MZFFSFBT','ZS_SSSXSQDCSYZ','BQ_ZDLBSFXZXG','ZS_CFMBYYCLBZSFTS','ZS_ZYYZSFXYDJTS','ZS_BASYZJSSXX','ZS_SFSYXMLMSBL','ZS_XYZCYSFYXTZ','BQ_SFYXJC','ZS_ZYBASYJBXXZDYID','SFXSGRQKHSSSC','ZS_SFDYYZYSHS','ZS_SFXZBYS','ZS_ZYBASSQTXXZDYID','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','ZS_RYZDSFSGSR','BQ_LRCZPSYCSPSDZ','BQ_HZYZXMST','ZS_YBSFXSWQZFYPBL','ZS_SFSYDTYYSCXT','XT_SFSYTYTYYSCXT','ZS_YZLRSFYXPZTZ','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB','ZS_SSSGLR','ZS_JKXXDZ_NEW','ZS_DKBLSFYCLC','ZS_BASYDYSFSYFR3SMDY','ZS_ZYBLDYSFMRMYDY','ZS_PACSTWBGWZ','ZS_PACSTXLLWZ','ZS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','SS_SQZDSFZDY','SS_ZXSWFYSSXM','SS_SSSQSFXSCW','ZS_RYZDWCRBZDSYQTXBGK','ZS_BASYSFTJBASSH','ZS_ZYBLA4DYHS','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_AUTOSHOWYJYZ','ZS_SFKZYSRYWYP','ZS_YSWHYPBMQZ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_SFKYLRSRCS','BQ_TZYZSFXYHD','ZS_WXZBXYZSFTG','ZS_CQYZZJSSFTXYPSL','ZS_YZGLJMSJEXSFS','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','ZY_RQDGSCS','ZY_RQDSFABRFYDY','ZS_SFZDGXLJ','ZS_YZWHJMSFXSYBWFSJE','ZS_YZCLLBSFSYZDY','ZS_CZWTZYZSFKCJ','ZS_WCCJSFSHRYY','ZS_SFYXXGXM','ZS_YTZLDZSFKYCX','ZS_YZWHJMMRYZLB','ZS_SFTSMRCYBR','ZS_SJWDSFKCJ','ZS_CJZDTZLJYZ','ZS_WLJBRZBSRZLXMID','ZS_YBBRFYTSJE','ZS_NBBRFYTSJE','ZS_KJXCYLSYZSZLSFBYXBJ','ZS_KJXCYLSYZSSFSYTSXZ','ZS_CRBDJSFQZSR','ZS_BAQHJGTS','ZS_SFKYYJSYKSSYP','ZS_ZYBAJKSFZNCSYSHBA','ZS_SFSYYZYTZGN')

120     10:56:37  SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%'  or name00 in ('zs_RunMode','XT_QDXXZHYE','ZS_YAPSSSFKYSC','BQ_NT5','BQ_RQDCDZ','ZS_YZDYGS','ZS_YZSFTD','ZS_BRQFSFYXLYZ','ZS_SSTHSFXG','ZS_FYYZSFSRZDHBQZY','BQ_SZYS_RYZDSFXS','ZS_MBSFTZ','ZS_SFXSBB','ZS_BLGSSFTZ','ZS_SFSYPASSXT','ZS_SFHISSJDR','ZS_YZDYLRSJ','SS_SFYFSZT','ZS_JYXMSRTZXX','ZS_BASYSGSRJBMC','ZS_YZWHJMXSBAH','ZS_CFJBKSSJB','ZS_FYYZXZJYXM','ZS_YZZJQRCDZ','ZS_SFGBADO','ZS_XZYSCZBLQX','ZS_CGBJJESFTS','ZS_YZYXBCYPBM','ZS_FTZYBCYPJJSH','ZS_SFZYYH','ZS_BRLLSFXSGDH','YS_ZFBRZFBLYBLB','ZS_BASYJBXXZDYID','ZS_BASYZDXXZDYID','ZS_BASYSSXXZDYID','ZS_YZWHSFZHJYXM','ZS_MZFFSFBT','ZS_SSSXSQDCSYZ','BQ_ZDLBSFXZXG','ZS_CFMBYYCLBZSFTS','ZS_ZYYZSFXYDJTS','ZS_BASYZJSSXX','ZS_SFSYXMLMSBL','ZS_XYZCYSFYXTZ','BQ_SFYXJC','ZS_ZYBASYJBXXZDYID','SFXSGRQKHSSSC','ZS_SFDYYZYSHS','ZS_SFXZBYS','ZS_ZYBASSQTXXZDYID','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','ZS_RYZDSFSGSR','BQ_LRCZPSYCSPSDZ','BQ_HZYZXMST','ZS_YBSFXSWQZFYPBL','ZS_SFSYDTYYSCXT','XT_SFSYTYTYYSCXT','ZS_YZLRSFYXPZTZ','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB','ZS_SSSGLR','ZS_JKXXDZ_NEW','ZS_DKBLSFYCLC','ZS_BASYDYSFSYFR3SMDY','ZS_ZYBLDYSFMRMYDY','ZS_PACSTWBGWZ','ZS_PACSTXLLWZ','ZS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','SS_SQZDSFZDY','SS_ZXSWFYSSXM','SS_SSSQSFXSCW','ZS_RYZDWCRBZDSYQTXBGK','ZS_BASYSFTJBASSH','ZS_ZYBLA4DYHS','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_AUTOSHOWYJYZ','ZS_SFKZYSRYWYP','ZS_YSWHYPBMQZ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_SFKYLRSRCS','BQ_TZYZSFXYHD','ZS_WXZBXYZSFTG','ZS_CQYZZJSSFTXYPSL','ZS_YZGLJMSJEXSFS','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','ZY_RQDGSCS','ZY_RQDSFABRFYDY','ZS_SFZDGXLJ','ZS_YZWHJMSFXSYBWFSJE','ZS_YZCLLBSFSYZDY','ZS_CZWTZYZSFKCJ','ZS_WCCJSFSHRYY','ZS_SFYXXGXM','ZS_YTZLDZSFKYCX','ZS_YZWHJMMRYZLB','ZS_SFTSMRCYBR','ZS_SJWDSFKCJ','ZS_CJZDTZLJYZ','ZS_WLJBRZBSRZLXMID','ZS_YBBRFYTSJE','ZS_NBBRFYTSJE','ZS_KJXCYLSYZSZLSFBYXBJ','ZS_KJXCYLSYZSSFSYTSXZ','ZS_CRBDJSFQZSR','ZS_BAQHJGTS','ZS_SFKYYJSYKSSYP','ZS_ZYBAJKSFZNCSYSHBA','ZS_SFSYYZYTZGN')

121     10:56:38  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 476

122     10:56:38  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 476

123     10:56:38  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%'

124     10:56:38  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%'

125     10:56:38  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF')

126     10:56:38  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF')

127     10:56:38  SQL Prepare: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=476

128     10:56:38  SQL Execute: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=476

129     10:56:38  SQL Prepare: ORACLE - select * from bm_yslb00 where yslb00='3'

130     10:56:38  SQL Execute: ORACLE - select * from bm_yslb00 where yslb00='3'

131     10:56:38  SQL Prepare: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 

132     10:56:38  SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 

133     10:56:48  SQL Prepare: ORACLE -  SELECT DISTINCT A.BRID00,A.ZYID00,A.ZYH000,A.MRN000,A.RYCWH0,A.XM0000,A.XB0000,TO_DATE(A.RYRQ00,'YYYY.MM.DD') RYRQ00,A.RYSJ00,
        TO_DATE(A.CYRQ00,'YYYY.MM.DD') CYRQ00,A.CYSJ00,A.RZKS00,B.BMMC00 RZKSMC, C.ZDMC00
 FROM ZY_BRXXB0 A,BM_BMBM00 B, BQ_BRZDXX C
 WHERE A.RZKS00=B.BMBH00 AND A.ZYID00=C.ZYID00(+) 
 AND ROWNUM<=100 ORDER BY A.ZYH000 

134     10:56:48  SQL Execute: ORACLE -  SELECT DISTINCT A.BRID00,A.ZYID00,A.ZYH000,A.MRN000,A.RYCWH0,A.XM0000,A.XB0000,TO_DATE(A.RYRQ00,'YYYY.MM.DD') RYRQ00,A.RYSJ00,
        TO_DATE(A.CYRQ00,'YYYY.MM.DD') CYRQ00,A.CYSJ00,A.RZKS00,B.BMMC00 RZKSMC, C.ZDMC00
 FROM ZY_BRXXB0 A,BM_BMBM00 B, BQ_BRZDXX C
 WHERE A.RZKS00=B.BMBH00 AND A.ZYID00=C.ZYID00(+) 
 AND ROWNUM<=100 ORDER BY A.ZYH000 

135     10:56:49  SQL Prepare: ORACLE - SELECT BLXMID,BLXMMC,FZDYMC FROM VW_ZS_BLZC00 ORDER BY XSXH00

136     10:56:49  SQL Execute: ORACLE - SELECT BLXMID,BLXMMC,FZDYMC FROM VW_ZS_BLZC00 ORDER BY XSXH00

137     10:56:49  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=1
 ORDER BY XH0000

138     10:56:49  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=1
 ORDER BY XH0000

139     10:56:49  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=2
 ORDER BY XH0000

140     10:56:49  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=2
 ORDER BY XH0000

141     10:56:49  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=3
 ORDER BY XH0000

142     10:56:49  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=3
 ORDER BY XH0000

143     10:56:49  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=4
 ORDER BY XH0000

144     10:56:49  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=4
 ORDER BY XH0000

145     10:56:49  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=5
 ORDER BY XH0000

146     10:56:49  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=5
 ORDER BY XH0000

147     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=6
 ORDER BY XH0000

148     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=6
 ORDER BY XH0000

149     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=7
 ORDER BY XH0000

150     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=7
 ORDER BY XH0000

151     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=8
 ORDER BY XH0000

152     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=8
 ORDER BY XH0000

153     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=9
 ORDER BY XH0000

154     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=9
 ORDER BY XH0000

155     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=10
 ORDER BY XH0000

156     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=10
 ORDER BY XH0000

157     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=11
 ORDER BY XH0000

158     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=11
 ORDER BY XH0000

159     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=12
 ORDER BY XH0000

160     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=12
 ORDER BY XH0000

161     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=13
 ORDER BY XH0000

162     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=13
 ORDER BY XH0000

163     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=14
 ORDER BY XH0000

164     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=14
 ORDER BY XH0000

165     10:56:50  SQL Prepare: ORACLE - SELECT BLXMID,BLXMMC,FZDYMC FROM VW_ZS_BLZC00 ORDER BY XSXH00

166     10:56:50  SQL Execute: ORACLE - SELECT BLXMID,BLXMMC,FZDYMC FROM VW_ZS_BLZC00 ORDER BY XSXH00

167     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=1
 ORDER BY XH0000

168     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=1
 ORDER BY XH0000

169     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=2
 ORDER BY XH0000

170     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=2
 ORDER BY XH0000

171     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=3
 ORDER BY XH0000

172     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=3
 ORDER BY XH0000

173     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=4
 ORDER BY XH0000

174     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=4
 ORDER BY XH0000

175     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=5
 ORDER BY XH0000

176     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=5
 ORDER BY XH0000

177     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=6
 ORDER BY XH0000

178     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=6
 ORDER BY XH0000

179     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=7
 ORDER BY XH0000

180     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=7
 ORDER BY XH0000

181     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=8
 ORDER BY XH0000

182     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=8
 ORDER BY XH0000

183     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=9
 ORDER BY XH0000

184     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=9
 ORDER BY XH0000

185     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=10
 ORDER BY XH0000

186     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=10
 ORDER BY XH0000

187     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=11
 ORDER BY XH0000

188     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=11
 ORDER BY XH0000

189     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=12
 ORDER BY XH0000

190     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=12
 ORDER BY XH0000

191     10:56:50  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=13
 ORDER BY XH0000

192     10:56:50  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=13
 ORDER BY XH0000

193     10:56:51  SQL Prepare: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=14
 ORDER BY XH0000

194     10:56:51  SQL Execute: ORACLE -  SELECT BLXMID,XH0000,WJMC00,CJYSMC,WJMC00||'-'||CJYSMC XSMC00
 FROM VW_ZS_BLJL00
 WHERE LSH000=286776 AND BLXMID=14
 ORDER BY XH0000

195     10:57:09  SQL Prepare: ORACLE - select  * from bm_bmbm00 where BMXZ00='9' and CZBZ00<>'2' and FLAG00='1'

196     10:57:09  SQL Execute: ORACLE - select  * from bm_bmbm00 where BMXZ00='9' and CZBZ00<>'2' and FLAG00='1'

197     10:57:09  SQL Prepare: ORACLE - select bqh000 from bm_bqks00 a,bm_ygbm00 b where a.ksh000=b.bmbh00 and ygbh00=476

198     10:57:09  SQL Execute: ORACLE - select bqh000 from bm_bqks00 a,bm_ygbm00 b where a.ksh000=b.bmbh00 and ygbh00=476

199     10:57:09  SQL Prepare: ORACLE - SELECT COUNT(ZYID00) FROM ZY_BRXXB0
       WHERE BRZT00 IN ('20','22','23') AND DQBQ00=:1
UNION ALL
SELECT COUNT (DISTINCT ZYID00) FROM BQ_BRLDXX
       WHERE QSZT00='新入' AND BQH000=:2 AND QSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT (ZYID00) FROM ZY_BRXXB0
       WHERE BRZT00>='3' AND DQBQ00=:3 and CYDJRQ=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT(ZYID00) FROM ZY_BRXXB0
       WHERE BRZT00='3' AND DQBQ00=:4 and CYDJRQ=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT (DISTINCT ZYID00) FROM BQ_BRLDXX
       WHERE QSZT00='转入' AND BQH000=:5 AND QSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT (DISTINCT ZYID00) FROM BQ_BRLDXX
       WHERE JSZT00='转出' AND BQH000=:6 AND JSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')


 

200     10:57:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000
201     10:57:09  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000
202     10:57:09  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000
203     10:57:09  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000
204     10:57:09  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000
205     10:57:09  SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000
206     10:57:09  SQL Execute: ORACLE - SELECT COUNT(ZYID00) FROM ZY_BRXXB0
       WHERE BRZT00 IN ('20','22','23') AND DQBQ00=?
UNION ALL
SELECT COUNT (DISTINCT ZYID00) FROM BQ_BRLDXX
       WHERE QSZT00='新入' AND BQH000=? AND QSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT (ZYID00) FROM ZY_BRXXB0
       WHERE BRZT00>='3' AND DQBQ00=? and CYDJRQ=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT(ZYID00) FROM ZY_BRXXB0
       WHERE BRZT00='3' AND DQBQ00=? and CYDJRQ=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT (DISTINCT ZYID00) FROM BQ_BRLDXX
       WHERE QSZT00='转入' AND BQH000=? AND QSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT (DISTINCT ZYID00) FROM BQ_BRLDXX
       WHERE JSZT00='转出' AND BQH000=? AND JSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')


 

207     10:57:09  SQL Prepare: ORACLE - SELECT 
C.CH0000,ZYH000,XM0000,XB0000,JBMC00"RYZD00",
ZZYSXM,FBMC00,ZLXMJC,
SF_BQ_CSRQTONL(CSRQ00)"NL0000",
TO_CHAR(TO_DATE(RYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"RYRQ00",
KYJE00,ZYE000,
BRZT00,Z.ZYID00,C.CWZT00,Z.BRID00,
decode(HLJBID,null,-1,hljbid-100)"hljbid",YBMC00,B.YBLB00,BJJE00,b.MRN000,B.BRZJBH,B.BRZJLX,B.BRLXXM,B.BRLXDH,B.YBID00,
Z.FBBH00,Y.SFXNH0,0 as BRFY00,0 as YZBL00,0 as ZFYPBL,round(sysdate-to_date(Z.RYRQ00,'YYYYMMDD')) ZYTS00
FROM ZY_BRXXB0 Z,BM_CWK000 C,BM_BRFBB0 F,VW_BQ_ZYBRJE J,
BM_ZLZD00 L,XT_ICD900 I,BM_BRXXB0 B,IC_YBBRLB Y
WHERE Z.DQBQ00=:1 AND C.CWZT00 IN ('1','2') AND C.BQH000=:2 AND C.ZYID00 IS NOT NULL
AND C.ZYID00=Z.ZYID00 AND Z.FBBH00=F.FBBH00 AND C.ZYID00=J.ZYID00
AND Z.HLJBID=L.ZLXMID(+)AND rpad(trim(ryzd00),10)=I.ICD900(+) AND Z.BRID00=B.BRID00
AND B.YBLB00=Y.YBLB00
UNION ALL
SELECT CH0000,'','','','','','',
'','','',0,0,'',0,CWZT00,0,0,'','',0,'','','','','','',0,'',0,0,0,0
FROM BM_CWK000
WHERE BQH000=:3 AND CWZT00 IN ('0','3')
ORDER BY CH0000





208     10:57:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000
209     10:57:09  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000
210     10:57:09  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000
211     10:57:09  SQL Execute: ORACLE - SELECT 
C.CH0000,ZYH000,XM0000,XB0000,JBMC00"RYZD00",
ZZYSXM,FBMC00,ZLXMJC,
SF_BQ_CSRQTONL(CSRQ00)"NL0000",
TO_CHAR(TO_DATE(RYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"RYRQ00",
KYJE00,ZYE000,
BRZT00,Z.ZYID00,C.CWZT00,Z.BRID00,
decode(HLJBID,null,-1,hljbid-100)"hljbid",YBMC00,B.YBLB00,BJJE00,b.MRN000,B.BRZJBH,B.BRZJLX,B.BRLXXM,B.BRLXDH,B.YBID00,
Z.FBBH00,Y.SFXNH0,0 as BRFY00,0 as YZBL00,0 as ZFYPBL,round(sysdate-to_date(Z.RYRQ00,'YYYYMMDD')) ZYTS00
FROM ZY_BRXXB0 Z,BM_CWK000 C,BM_BRFBB0 F,VW_BQ_ZYBRJE J,
BM_ZLZD00 L,XT_ICD900 I,BM_BRXXB0 B,IC_YBBRLB Y
WHERE Z.DQBQ00=? AND C.CWZT00 IN ('1','2') AND C.BQH000=? AND C.ZYID00 IS NOT NULL
AND C.ZYID00=Z.ZYID00 AND Z.FBBH00=F.FBBH00 AND C.ZYID00=J.ZYID00
AND Z.HLJBID=L.ZLXMID(+)AND rpad(trim(ryzd00),10)=I.ICD900(+) AND Z.BRID00=B.BRID00
AND B.YBLB00=Y.YBLB00
UNION ALL
SELECT CH0000,'','','','','','',
'','','',0,0,'',0,CWZT00,0,0,'','',0,'','','','','','',0,'',0,0,0,0
FROM BM_CWK000
WHERE BQH000=? AND CWZT00 IN ('0','3')
ORDER BY CH0000





212     10:57:09  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

213     10:57:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464461.000000
214     10:57:09  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

215     10:57:09  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

216     10:57:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464633.000000
217     10:57:09  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

218     10:57:09  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

219     10:57:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464472.000000
220     10:57:09  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

221     10:57:09  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

222     10:57:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464049.000000
223     10:57:09  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

224     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

225     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464043.000000
226     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

227     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

228     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464066.000000
229     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

230     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

231     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464179.000000
232     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

233     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

234     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464192.000000
235     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

236     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

237     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464013.000000
238     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

239     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

240     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464258.000000
241     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

242     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

243     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464636.000000
244     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

245     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

246     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464260.000000
247     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

248     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

249     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464160.000000
250     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

251     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

252     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464042.000000
253     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

254     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

255     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464261.000000
256     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

257     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

258     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464206.000000
259     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

260     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

261     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464163.000000
262     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

263     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

264     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463950.000000
265     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

266     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

267     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464070.000000
268     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

269     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

270     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463985.000000
271     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

272     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

273     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464024.000000
274     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

275     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

276     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464307.000000
277     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

278     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

279     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464507.000000
280     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

281     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

282     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464757.000000
283     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

284     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

285     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464181.000000
286     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

287     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

288     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464361.000000
289     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

290     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

291     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464626.000000
292     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

293     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

294     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464474.000000
295     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

296     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

297     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464514.000000
298     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

299     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

300     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464715.000000
301     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

302     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

303     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464560.000000
304     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

305     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

306     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464631.000000
307     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

308     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

309     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464632.000000
310     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

311     10:57:10  SQL Prepare: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=:1) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

312     10:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464044.000000
313     10:57:10  SQL Execute: ORACLE - select (select nvl(sum(HJJE00),0) from  ZY_BRFY00  where  ZYID00=?) as BRFY00 
,0 as YZBL00 
,0 as ZFYPBL 
 from  dual

314     10:57:20  SQL Prepare: ORACLE -  SELECT DISTINCT A.BRID00,A.ZYID00,A.ZYH000,A.MRN000,A.RYCWH0,A.XM0000,A.XB0000,TO_DATE(A.RYRQ00,'YYYY.MM.DD') RYRQ00,A.RYSJ00,
        TO_DATE(A.CYRQ00,'YYYY.MM.DD') CYRQ00,A.CYSJ00,A.RZKS00,B.BMMC00 RZKSMC, C.ZDMC00
 FROM ZY_BRXXB0 A,BM_BMBM00 B, BQ_BRZDXX C
 WHERE A.RZKS00=B.BMBH00 AND A.ZYID00=C.ZYID00(+) 
 AND ROWNUM<=100 ORDER BY A.ZYH000 

315     10:57:20  SQL Execute: ORACLE -  SELECT DISTINCT A.BRID00,A.ZYID00,A.ZYH000,A.MRN000,A.RYCWH0,A.XM0000,A.XB0000,TO_DATE(A.RYRQ00,'YYYY.MM.DD') RYRQ00,A.RYSJ00,
        TO_DATE(A.CYRQ00,'YYYY.MM.DD') CYRQ00,A.CYSJ00,A.RZKS00,B.BMMC00 RZKSMC, C.ZDMC00
 FROM ZY_BRXXB0 A,BM_BMBM00 B, BQ_BRZDXX C
 WHERE A.RZKS00=B.BMBH00 AND A.ZYID00=C.ZYID00(+) 
 AND ROWNUM<=100 ORDER BY A.ZYH000