1 11:13:28 Log started for: 住院医生工作站系统 2 11:13:28 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 11:13:28 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 11:13:28 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','101','23439' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:743CF2A78AB67D5AF453292DE5A53532' from dual 5 11:13:28 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','101','23439' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:743CF2A78AB67D5AF453292DE5A53532' from dual 6 11:13:28 SQL Data In: ORACLE - Rows affected = 1 7 11:13:28 SQL Prepare: ORACLE - Commit 8 11:13:28 SQL Execute: ORACLE - Commit 9 11:13:28 SQL Data In: ORACLE - Rows affected = 0 10 11:13:28 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 11:13:28 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 12 11:13:28 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 13 11:13:28 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 14 11:13:28 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 15 11:13:28 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 16 11:13:28 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 17 11:13:28 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 18 11:13:28 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','138','15888' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:0A1AF7CE587A5DD7280165C0BA14BFED' from dual 19 11:13:28 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','138','15888' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:0A1AF7CE587A5DD7280165C0BA14BFED' from dual 20 11:13:28 SQL Data In: ORACLE - Rows affected = 1 21 11:13:28 SQL Prepare: ORACLE - Commit 22 11:13:28 SQL Execute: ORACLE - Commit 23 11:13:28 SQL Data In: ORACLE - Rows affected = 0 24 11:13:28 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 25 11:13:28 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 26 11:13:28 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 27 11:13:28 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 28 11:13:28 SQL Prepare: ORACLE - Select SYSDATE from Dual 29 11:13:28 SQL Execute: ORACLE - Select SYSDATE from Dual 30 11:13:28 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 11:13:28 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 32 11:13:28 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 33 11:13:28 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 34 11:13:28 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z' 35 11:13:28 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z' 36 11:13:28 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 11:13:28 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 11:13:28 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 39 11:13:28 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 40 11:13:28 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)='343')) 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)='343')) order by b.PLXH00,a.BH0000 41 11:13:28 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)='343')) 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)='343')) order by b.PLXH00,a.BH0000 42 11:13:29 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '343'='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)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 43 11:13:29 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '343'='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)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 44 11:13:29 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 45 11:13:29 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 46 11:13:29 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 11:13:29 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 48 11:13:29 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 11:13:29 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 11:13:29 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 11:13:29 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 52 11:13:29 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 11:13:29 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 54 11:13:29 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')) 55 11:13:29 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')) 56 11:13:30 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4287532,1143,'wlzx-y','Z',nvl('228669492',' '),'192.168.5.22#138:15888@ZY_YS.exe+住院医生工作站系统',20) 57 11:13:30 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4287532,1143,'wlzx-y','Z',nvl('228669492',' '),'192.168.5.22#138:15888@ZY_YS.exe+住院医生工作站系统',20) 58 11:13:30 SQL Data In: ORACLE - Rows affected = 1 59 11:13:30 SQL Prepare: ORACLE - Commit 60 11:13:30 SQL Execute: ORACLE - Commit 61 11:13:30 SQL Data In: ORACLE - Rows affected = 0 62 11:13:30 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 63 11:13:30 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 64 11:13:30 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 65 11:13:30 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 66 11:13:30 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 67 11:13:30 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 68 11:13:30 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 69 11:13:30 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 70 11:13:30 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 71 11:13:30 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 72 11:13:30 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 73 11:13:30 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 74 11:13:30 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 75 11:13:30 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 76 11:13:30 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'Z'||',')>0 77 11:13:30 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'Z'||',')>0 78 11:13:32 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 79 11:13:32 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 80 11:13:32 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 81 11:13:32 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 82 11:13:32 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140915' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='Z') 83 11:13:32 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140915' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='Z') 84 11:13:32 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 85 11:13:32 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 86 11:13:32 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 87 11:13:32 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 88 11:13:32 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 89 11:13:32 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 90 11:13:32 SQL Prepare: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 91 11:13:32 SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 92 11:13:32 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','138','15888' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ADO:' from dual 93 11:13:32 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','138','15888' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ADO:' from dual 94 11:13:32 SQL Data In: ORACLE - Rows affected = 1 95 11:13:32 SQL Prepare: ORACLE - Commit 96 11:13:32 SQL Execute: ORACLE - Commit 97 11:13:32 SQL Data In: ORACLE - Rows affected = 0 98 11:13:32 SQL Prepare: ORACLE - SELECT to_char(sid,'0000') FROM V$SESSION where userenv('sessionid')=audsid 99 11:13:32 SQL Execute: ORACLE - SELECT to_char(sid,'0000') FROM V$SESSION where userenv('sessionid')=audsid 100 11:13:32 SQL Prepare: ORACLE - begin package_zhcx.set_var('0138'); END; 101 11:13:32 SQL Execute: ORACLE - begin package_zhcx.set_var('0138'); END; 102 11:13:32 SQL Data In: ORACLE - Rows affected = 0 103 11:13:32 SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 104 11:13:32 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 105 11:13:32 SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a 106 11:13:32 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a 107 11:13:32 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='Z' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='Z'))) 108 11:13:32 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='Z' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='Z'))) 109 11:13:32 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 110 11:13:32 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 111 11:13:32 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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 112 11:13:32 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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 113 11:13:32 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 114 11:13:32 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 115 11:13:32 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 116 11:13:32 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 117 11:13:32 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID' 118 11:13:32 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID' 119 11:13:32 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%' 120 11:13:32 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%' 121 11:13:32 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') 122 11:13:32 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') 123 11:13:32 SQL Prepare: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 124 11:13:32 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 125 11:13:32 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 1143 126 11:13:32 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 1143 127 11:13:32 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 128 11:13:32 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 129 11:13:33 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF') 130 11:13:33 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF') 131 11:13:33 SQL Prepare: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=1143 132 11:13:33 SQL Execute: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=1143 133 11:13:33 SQL Prepare: ORACLE - select * from bm_yslb00 where yslb00='3' 134 11:13:33 SQL Execute: ORACLE - select * from bm_yslb00 where yslb00='3' 135 11:13:33 SQL Prepare: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 136 11:13:33 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 137 11:13:36 SQL Prepare: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=:1 and a.YSLB00=b.YSLB00(+) 138 11:13:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1143 139 11:13:36 SQL Execute: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=? and a.YSLB00=b.YSLB00(+) 140 11:13:36 SQL Prepare: ORACLE - select * from VW_BQ_YZLB00 141 11:13:36 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 142 11:13:36 SQL Prepare: ORACLE - SELECT A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,a.CJYSXM FROM VW_ZS_YJBLXX A WHERE (DQKS00=:1 or DQBQ00=:2) ORDER BY RYCWH0 143 11:13:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 144 11:13:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 145 11:13:36 SQL Execute: ORACLE - SELECT A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,a.CJYSXM FROM VW_ZS_YJBLXX A WHERE (DQKS00=? or DQBQ00=?) ORDER BY RYCWH0 146 11:13:44 SQL Prepare: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ') 147 11:13:44 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ') 148 11:13:44 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='Z' and (MKDM00='Z95' or MKDM00='Z95') and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='Z' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1143)))) 149 11:13:44 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='Z' and (MKDM00='Z95' or MKDM00='Z95') and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='Z' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1143)))) 150 11:13:44 SQL Prepare: ORACLE - select 1 from BM_YGBM00 where YGBH00=1143 and YGXZ00 like '%5%' 151 11:13:44 SQL Execute: ORACLE - select 1 from BM_YGBM00 where YGBH00=1143 and YGXZ00 like '%5%' 152 11:13:46 SQL Prepare: ORACLE - SELECT A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,a.CJYSXM FROM VW_ZS_YJBLXX A WHERE (DQKS00=:1 or DQBQ00=:2) ORDER BY RYCWH0 153 11:13:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 154 11:13:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 155 11:13:46 SQL Execute: ORACLE - SELECT A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,a.CJYSXM FROM VW_ZS_YJBLXX A WHERE (DQKS00=? or DQBQ00=?) ORDER BY RYCWH0 156 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1029729 157 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1029729 158 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 159 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3837739 160 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1029729 161 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 162 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027479 163 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027479 164 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 165 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3835941 166 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1027479 167 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 168 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1028820 169 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1028820 170 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 171 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3836980 172 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1028820 173 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 174 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023219 175 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023219 176 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 177 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3831613 178 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1023219 179 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 180 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1024667 181 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1024667 182 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 183 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3832621 184 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1024667 185 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 186 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025767 187 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025767 188 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 189 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3833711 190 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1025767 191 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 192 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025067 193 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025067 194 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 195 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3833111 196 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1025067 197 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 198 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1029069 199 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1029069 200 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 201 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3837173 202 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1029069 203 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 204 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1028217 205 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1028217 206 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 207 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3836488 208 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1028217 209 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 210 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1026368 211 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1026368 212 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 213 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3835115 214 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1026368 215 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 216 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023021 217 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023021 218 11:13:54 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 219 11:13:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3831349 220 11:13:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1023021 221 11:13:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 222 11:13:54 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1030117 223 11:13:54 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1030117 224 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 225 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3838040 226 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1030117 227 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 228 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=991212 229 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=991212 230 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 231 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3795808 232 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 991212 233 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 234 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025572 235 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025572 236 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 237 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3833588 238 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1025572 239 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 240 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023924 241 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023924 242 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 243 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3831988 244 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1023924 245 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 246 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1026567 247 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1026567 248 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 249 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3835272 250 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1026567 251 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 252 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027917 253 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027917 254 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 255 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3836275 256 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1027917 257 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 258 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025122 259 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025122 260 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 261 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3833161 262 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1025122 263 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 264 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1030230 265 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1030230 266 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 267 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3838258 268 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1030230 269 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 270 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1026419 271 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1026419 272 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 273 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3835169 274 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1026419 275 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 276 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1018817 277 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1018817 278 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 279 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3827508 280 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1018817 281 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 282 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1028119 283 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1028119 284 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 285 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3836443 286 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1028119 287 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 288 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027769 289 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027769 290 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 291 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3836168 292 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1027769 293 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 294 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027571 295 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027571 296 11:13:55 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 297 11:13:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3836003 298 11:13:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1027571 299 11:13:55 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 300 11:13:55 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027368 301 11:13:55 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027368 302 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 303 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3835826 304 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1027368 305 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 306 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027867 307 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1027867 308 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 309 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3836238 310 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1027867 311 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 312 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1021319 313 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1021319 314 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 315 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3830148 316 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1021319 317 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 318 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1019976 319 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1019976 320 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 321 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3828785 322 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1019976 323 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 324 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023818 325 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023818 326 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 327 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3831883 328 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1023818 329 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 330 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1029318 331 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1029318 332 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 333 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3837430 334 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1029318 335 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 336 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1030018 337 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1030018 338 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 339 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3837993 340 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1030018 341 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 342 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1021267 343 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1021267 344 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 345 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3830108 346 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1021267 347 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 348 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1030168 349 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1030168 350 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 351 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3838173 352 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1030168 353 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 354 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025669 355 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025669 356 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 357 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3833667 358 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1025669 359 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 360 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023934 361 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023934 362 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 363 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3832017 364 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1023934 365 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 366 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1009215 367 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1009215 368 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 369 11:13:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3818355 370 11:13:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1009215 371 11:13:56 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 372 11:13:56 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1030518 373 11:13:56 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1030518 374 11:13:56 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 375 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3838665 376 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1030518 377 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 378 11:13:57 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1021823 379 11:13:57 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1021823 380 11:13:57 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 381 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3830497 382 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1021823 383 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 384 11:13:57 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1029417 385 11:13:57 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1029417 386 11:13:57 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 387 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3837505 388 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1029417 389 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 390 11:13:57 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023417 391 11:13:57 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023417 392 11:13:57 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 393 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3831705 394 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1023417 395 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 396 11:13:57 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1029267 397 11:13:57 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1029267 398 11:13:57 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 399 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3837369 400 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1029267 401 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 402 11:13:57 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025818 403 11:13:57 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025818 404 11:13:57 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 405 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3833749 406 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1025818 407 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 408 11:13:57 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025717 409 11:13:57 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1025717 410 11:13:57 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 411 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3833690 412 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1025717 413 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 414 11:13:57 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1026820 415 11:13:57 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1026820 416 11:13:57 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 417 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3835498 418 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1026820 419 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 420 11:13:57 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023932 421 11:13:57 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1023932 422 11:13:57 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 423 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3832013 424 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1023932 425 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 426 11:13:57 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1013169 427 11:13:57 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1013169 428 11:13:57 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 429 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3821651 430 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1013169 431 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 432 11:13:57 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1021775 433 11:13:57 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=1021775 434 11:13:57 SQL Prepare: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=:1 and GHID00=:2 and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 435 11:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3830453 436 11:13:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1021775 437 11:13:57 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 438 11:14:01 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 1029729 439 11:14:01 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 1029729 440 11:14:01 SQL Prepare: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 1029729 and (YZZT00 in ('7','0','1','2','5','9','7') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID 441 11:14:01 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 1029729 and (YZZT00 in ('7','0','1','2','5','9','7') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID 442 11:14:01 SQL Prepare: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=1029729 and ZDLB00='2' 443 11:14:01 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=1029729 and ZDLB00='2' 444 11:14:04 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 445 11:14:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 446 11:14:04 SQL Execute: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=? and rownum=1 447 11:14:04 SQL Prepare: ORACLE - select BBMC00,BBID00 from BM_BBZD00 448 11:14:04 SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00 449 11:14:04 SQL Prepare: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 450 11:14:04 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 451 11:14:04 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=nvl('1143','0') and BMBH00=12345 and DLXTMC='检验结果查询' and CTMC00='FormQuery' 452 11:14:04 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=nvl('1143','0') and BMBH00=12345 and DLXTMC='检验结果查询' and CTMC00='FormQuery' 453 11:14:04 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 454 11:14:04 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 455 11:14:04 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ') 456 11:14:04 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ') 457 11:14:04 SQL Prepare: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 458 11:14:04 SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 459 11:14:04 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 460 11:14:04 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 461 11:14:04 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 462 11:14:04 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 463 11:14:04 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 464 11:14:04 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 465 11:14:04 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 466 11:14:04 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 467 11:14:04 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 468 11:14:04 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 469 11:14:04 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 470 11:14:04 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 471 11:14:04 SQL Prepare: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='59' 472 11:14:04 SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='59' 473 11:14:04 SQL Prepare: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 474 11:14:04 SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 475 11:14:04 SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='59' 476 11:14:04 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='59' 477 11:14:04 SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='59' 478 11:14:04 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='59' 479 11:14:04 SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='59' 480 11:14:04 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='59' 481 11:14:04 SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='59' 482 11:14:04 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='59' 483 11:14:04 SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='59' 484 11:14:04 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='59' 485 11:14:04 SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='59' 486 11:14:04 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='59' 487 11:14:04 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='1143' 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,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00, decode(A.JGZT00,'6','Y','N') dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140908' and '20140915' and A.ZYHGHH = '295918' and ( ( A.SQKS00+0 = '59' or A.SQBQ00+0 = '59') ) union select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00, decode(A.JGZT00,'6','Y','N') dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140908' and '20140915' and A.ZYHGHH = '295918' and ( ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE zyid00=A.ZYGHID and (DQBQ00 = '59' or DQKS00='59')))) ) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 488 11:14:04 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='1143' 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,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00, decode(A.JGZT00,'6','Y','N') dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140908' and '20140915' and A.ZYHGHH = '295918' and ( ( A.SQKS00+0 = '59' or A.SQBQ00+0 = '59') ) union select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00, decode(A.JGZT00,'6','Y','N') dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140908' and '20140915' and A.ZYHGHH = '295918' and ( ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE zyid00=A.ZYGHID and (DQBQ00 = '59' or DQKS00='59')))) ) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 489 11:14:05 SQL Prepare: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='FB' 490 11:14:05 SQL Execute: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='FB' 491 11:14:05 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='FB0010' and pyrq00='20140914' and rownum=1 492 11:14:05 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='FB0010' and pyrq00='20140914' and rownum=1 493 11:14:05 SQL Prepare: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'FB0010' and PYRQ00 = '20140914' 494 11:14:05 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'FB0010' and PYRQ00 = '20140914' 495 11:14:05 SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16358,16359) 496 11:14:05 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16358,16359) 497 11:14:05 SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='FB0010' and pyrq00='20140914' ORDER BY DYSX00 498 11:14:05 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='FB0010' and pyrq00='20140914' ORDER BY DYSX00 499 11:17:57 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 500 11:17:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 501 11:17:57 SQL Execute: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=? and rownum=1 502 11:17:57 SQL Prepare: ORACLE - select BBMC00,BBID00 from BM_BBZD00 503 11:17:57 SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00 504 11:17:57 SQL Prepare: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 505 11:17:57 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 506 11:17:57 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=nvl('1143','0') and BMBH00=12345 and DLXTMC='检验结果查询' and CTMC00='FormQuery' 507 11:17:57 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=nvl('1143','0') and BMBH00=12345 and DLXTMC='检验结果查询' and CTMC00='FormQuery' 508 11:17:57 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 509 11:17:57 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 510 11:17:57 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ') 511 11:17:57 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ') 512 11:17:57 SQL Prepare: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 513 11:17:57 SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 514 11:17:57 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 515 11:17:57 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 516 11:17:57 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 517 11:17:57 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 518 11:17:57 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 519 11:17:57 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 520 11:17:57 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 521 11:17:57 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 522 11:17:57 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 523 11:17:57 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 524 11:17:57 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 525 11:17:57 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 526 11:17:57 SQL Prepare: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='59' 527 11:17:57 SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='59' 528 11:17:57 SQL Prepare: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 529 11:17:57 SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 530 11:17:57 SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='59' 531 11:17:57 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='59' 532 11:17:57 SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='59' 533 11:17:57 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='59' 534 11:17:57 SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='59' 535 11:17:57 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='59' 536 11:17:57 SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='59' 537 11:17:57 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='59' 538 11:17:57 SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='59' 539 11:17:57 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='59' 540 11:17:57 SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='59' 541 11:17:57 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='59' 542 11:17:57 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='1143' 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,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00, decode(A.JGZT00,'6','Y','N') dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140908' and '20140915' and A.ZYHGHH = '295918' and ( ( A.SQKS00+0 = '59' or A.SQBQ00+0 = '59') ) union select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00, decode(A.JGZT00,'6','Y','N') dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140908' and '20140915' and A.ZYHGHH = '295918' and ( ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE zyid00=A.ZYGHID and (DQBQ00 = '59' or DQKS00='59')))) ) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 543 11:17:57 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='1143' 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,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00, decode(A.JGZT00,'6','Y','N') dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140908' and '20140915' and A.ZYHGHH = '295918' and ( ( A.SQKS00+0 = '59' or A.SQBQ00+0 = '59') ) union select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00, decode(A.JGZT00,'6','Y','N') dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140908' and '20140915' and A.ZYHGHH = '295918' and ( ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE zyid00=A.ZYGHID and (DQBQ00 = '59' or DQKS00='59')))) ) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 544 11:17:57 SQL Prepare: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='FB' 545 11:17:57 SQL Execute: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='FB' 546 11:17:57 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='FB0010' and pyrq00='20140914' and rownum=1 547 11:17:57 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='FB0010' and pyrq00='20140914' and rownum=1 548 11:17:57 SQL Prepare: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'FB0010' and PYRQ00 = '20140914' 549 11:17:57 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'FB0010' and PYRQ00 = '20140914' 550 11:17:57 SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16358,16359) 551 11:17:57 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16358,16359) 552 11:17:57 SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='FB0010' and pyrq00='20140914' ORDER BY DYSX00 553 11:17:57 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='FB0010' and pyrq00='20140914' ORDER BY DYSX00