1       11:22:50  Log started for: 检验信息系统
2       11:22:50  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

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

4       11:22:50  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','93','15135' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:DA0EAE149D09996EA79567577DAFEB94' from dual

5       11:22:50  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','93','15135' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:DA0EAE149D09996EA79567577DAFEB94' from dual

6       11:22:50  SQL Data In: ORACLE - Rows affected = 1
7       11:22:50  SQL Prepare: ORACLE - Commit

8       11:22:50  SQL Execute: ORACLE - Commit

9       11:22:50  SQL Data In: ORACLE - Rows affected = 0
10      11:22:50  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

11      11:22:50  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

12      11:22:50  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

13      11:22:50  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

14      11:22:50  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

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

16      11:22:50  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

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

18      11:22:50  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','642','2863' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:24BA3F35E39A8920B80658FAF0E9A863' from dual

19      11:22:50  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','642','2863' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:24BA3F35E39A8920B80658FAF0E9A863' from dual

20      11:22:50  SQL Data In: ORACLE - Rows affected = 1
21      11:22:50  SQL Prepare: ORACLE - Commit

22      11:22:50  SQL Execute: ORACLE - Commit

23      11:22:50  SQL Data In: ORACLE - Rows affected = 0
24      11:22:50  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J'

25      11:22:50  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J'

26      11:22:50  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

27      11:22:50  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

28      11:23:25  Log started for: 住院医生工作站系统
29      11:23:25  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.8.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','199','9015' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual

30      11:23:25  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.8.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','199','9015' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual

31      11:23:25  SQL Data In: ORACLE - Rows affected = 1
32      11:23:25  SQL Prepare: ORACLE - Commit

33      11:23:25  SQL Execute: ORACLE - Commit

34      11:23:25  SQL Data In: ORACLE - Rows affected = 0
35      11:23:25  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

36      11:23:25  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

37      11:23:25  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

38      11:23:25  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

39      11:23:25  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

40      11:23:25  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

41      11:23:25  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

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

43      11:23:25  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.8.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','568','5018' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual

44      11:23:25  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.8.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','568','5018' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual

45      11:23:25  SQL Data In: ORACLE - Rows affected = 1
46      11:23:25  SQL Prepare: ORACLE - Commit

47      11:23:25  SQL Execute: ORACLE - Commit

48      11:23:25  SQL Data In: ORACLE - Rows affected = 0
49      11:23:25  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z'

50      11:23:25  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z'

51      11:23:25  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

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

53      11:23:25  SQL Prepare: ORACLE - Select SYSDATE from Dual

54      11:23:25  SQL Execute: ORACLE - Select SYSDATE from Dual

55      11:23:25  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

56      11:23:25  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

57      11:23:25  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

58      11:23:25  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

59      11:23:25  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z'

60      11:23:25  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z'

61      11:23:25  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

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

63      11:23:25  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

64      11:23:25  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

65      11:23:25  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

66      11:23:25  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

67      11:23:28  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') 

68      11:23:28  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') 

69      11:23:28  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

70      11:23:28  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

71      11:23:28  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

72      11:23:28  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

73      11:23:28  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

74      11:23:28  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

75      11:23:28  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

76      11:23:28  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

77      11:23:28  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

78      11:23:28  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

79      11:23:28  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'))

80      11:23:28  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'))

81      11:23:30  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(4248878,476,'wlzx-8','Z',nvl('228450438',' '),'192.168.8.220#568:5018@ZY_YS.exe+住院医生工作站系统',21)

82      11:23:30  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(4248878,476,'wlzx-8','Z',nvl('228450438',' '),'192.168.8.220#568:5018@ZY_YS.exe+住院医生工作站系统',21)

83      11:23:30  SQL Data In: ORACLE - Rows affected = 1
84      11:23:30  SQL Prepare: ORACLE - Commit

85      11:23:30  SQL Execute: ORACLE - Commit

86      11:23:30  SQL Data In: ORACLE - Rows affected = 0
87      11:23:30  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 21

88      11:23:30  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 21

89      11:23:30  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

90      11:23:30  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

91      11:23:30  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

92      11:23:30  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

93      11:23:30  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.220'

94      11:23:30  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.220'

95      11:23:30  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

96      11:23:30  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

97      11:23:30  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
21 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

98      11:23:30  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
21 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

99      11:23:30  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

100     11:23:30  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

101     11:23:30  SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'Z'||',')>0 

102     11:23:30  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'Z'||',')>0 

103     11:23:31  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN'

104     11:23:31  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN'

105     11:23:31  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

106     11:23:31  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

107     11:23:31  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20140819'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',21,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='Z')

108     11:23:31  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20140819'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',21,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='Z')

109     11:23:31  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

110     11:23:31  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

111     11:23:31  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

112     11:23:31  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

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

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

115     11:23:31  SQL Prepare: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

116     11:23:31  SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

117     11:23:31  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.8.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','568','5018' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ADO:' from dual

118     11:23:31  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.8.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','568','5018' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ADO:' from dual

119     11:23:31  SQL Data In: ORACLE - Rows affected = 1
120     11:23:31  SQL Prepare: ORACLE - Commit

121     11:23:31  SQL Execute: ORACLE - Commit

122     11:23:31  SQL Data In: ORACLE - Rows affected = 0
123     11:23:33  SQL Prepare: ORACLE - SELECT to_char(sid,'0000')  FROM V$SESSION where userenv('sessionid')=audsid 

124     11:23:33  SQL Execute: ORACLE - SELECT to_char(sid,'0000')  FROM V$SESSION where userenv('sessionid')=audsid 

125     11:23:33  SQL Prepare: ORACLE - begin 
 package_zhcx.set_var('0568'); 
 END;

126     11:23:33  SQL Execute: ORACLE - begin 
 package_zhcx.set_var('0568'); 
 END;

127     11:23:33  SQL Data In: ORACLE - Rows affected = 0
128     11:23:33  SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a

129     11:23:33  SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a

130     11:23:33  SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a

131     11:23:33  SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a

132     11:23:33  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'))) 

133     11:23:33  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'))) 

134     11:23:34  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

135     11:23:34  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

136     11:23:34  SQL Prepare: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 

137     11:23:34  SQL Execute: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 

138     11:23:34  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

139     11:23:34  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

140     11:23:34  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='+ '))) 

141     11:23:34  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='+ '))) 

142     11:23:34  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID'

143     11:23:34  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID'

144     11:23:34  SQL Prepare: ORACLE - select Trigger_Name from all_triggers
 where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%'

145     11:23:34  SQL Execute: ORACLE - select Trigger_Name from all_triggers
 where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%'

146     11:23:34  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','YS_MBWHSFXZDYF')

147     11:23:34  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','YS_MBWHSFXZDYF')

148     11:23:34  SQL Prepare: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心'

149     11:23:34  SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心'

150     11:23:34  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 476

151     11:23:34  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 476

152     11:23:34  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%'

153     11:23:34  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%'

154     11:23:34  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF')

155     11:23:34  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF')

156     11:23:34  SQL Prepare: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=476

157     11:23:34  SQL Execute: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=476

158     11:23:34  SQL Prepare: ORACLE - select * from bm_yslb00 where yslb00='3'

159     11:23:34  SQL Execute: ORACLE - select * from bm_yslb00 where yslb00='3'

160     11:23:34  SQL Prepare: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 

161     11:23:34  SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 

162     11:23:37  SQL Prepare: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=:1 and rownum=1

163     11:23:37  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000
164     11:23:37  SQL Execute: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=? and rownum=1

165     11:23:39  SQL Prepare: ORACLE - select BBMC00,BBID00 from BM_BBZD00

166     11:23:39  SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00

167     11:23:39  SQL Prepare: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD
 where YXBZ00='Y'

168     11:23:39  SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD
 where YXBZ00='Y'

169     11:23:39  SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

170     11:23:39  SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

171     11:23:39  SQL Prepare: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW')

172     11:23:39  SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW')

173     11:23:39  SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 

174     11:23:39  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 

175     11:23:39  SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 

176     11:23:39  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 

177     11:23:39  SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 

178     11:23:39  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 

179     11:23:39  SQL Prepare: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='60'

180     11:23:39  SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='60'

181     11:23:39  SQL Prepare: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT'

182     11:23:39  SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT'

183     11:23:39  SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='60'

184     11:23:39  SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='60'

185     11:23:39  SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='60'

186     11:23:39  SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='60'

187     11:23:39  SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='60'

188     11:23:39  SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='60'

189     11:23:39  SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='60'

190     11:23:39  SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='60'

191     11:23:39  SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='60'

192     11:23:39  SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='60'

193     11:23:39  SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='60'

194     11:23:39  SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='60'

195     11:23:39  SQL Prepare: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='476' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from (select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,a.CBGRQ0 from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') 
 and A.PYRQ00 between '20140819' and '20140819' and (A.SQKS00+0 = '60' or A.SQBQ00+0 = '60')) t1 )
 order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc

196     11:23:39  SQL Execute: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='476' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from (select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,a.CBGRQ0 from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') 
 and A.PYRQ00 between '20140819' and '20140819' and (A.SQKS00+0 = '60' or A.SQBQ00+0 = '60')) t1 )
 order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc

197     11:23:39  SQL Prepare: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='AC0020' and pyrq00='20140819' and rownum=1

198     11:23:39  SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='AC0020' and pyrq00='20140819' and rownum=1

199     11:23:39  SQL Prepare: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AC0020' and PYRQ00 = '20140819'

200     11:23:39  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AC0020' and PYRQ00 = '20140819'

201     11:23:39  SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,17170,17173)

202     11:23:39  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,17170,17173)

203     11:23:39  SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='AC0020' and pyrq00='20140819'
 ORDER BY DYSX00

204     11:23:39  SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='AC0020' and pyrq00='20140819'
 ORDER BY DYSX00

205     11:23:42  SQL Prepare: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='LX0033' and pyrq00='20140819' and rownum=1

206     11:23:42  SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='LX0033' and pyrq00='20140819' and rownum=1

207     11:23:42  SQL Prepare: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'LX0033' and PYRQ00 = '20140819'

208     11:23:42  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'LX0033' and PYRQ00 = '20140819'

209     11:23:42  SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,22590,16983)

210     11:23:42  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,22590,16983)

211     11:23:42  SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='LX0033' and pyrq00='20140819'
 ORDER BY DYSX00

212     11:23:42  SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='LX0033' and pyrq00='20140819'
 ORDER BY DYSX00

213     11:23:46  SQL Prepare: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='AC0020' and pyrq00='20140819' and rownum=1

214     11:23:46  SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='AC0020' and pyrq00='20140819' and rownum=1

215     11:23:46  SQL Prepare: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AC0020' and PYRQ00 = '20140819'

216     11:23:46  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AC0020' and PYRQ00 = '20140819'

217     11:23:46  SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,17170,17173)

218     11:23:46  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,17170,17173)

219     11:23:46  SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='AC0020' and pyrq00='20140819'
 ORDER BY DYSX00

220     11:23:46  SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='AC0020' and pyrq00='20140819'
 ORDER BY DYSX00