1 11:04:08 Log started for: 后台维护系统 2 11:04:08 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 11:04:08 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','6',trim(PROGRAM)||'+'||'后台维护系统',SID,serial# ,'20140114','11:04:08','scott@super:4FEF60119F70D5321E2D46745E90A57C' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 11:04:08 SQL Data In: ORACLE - Rows affected = 1 5 11:04:08 SQL Execute: ORACLE - Commit 6 11:04:08 SQL Data In: ORACLE - Rows affected = 0 7 11:04:08 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 11:04:08 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 9 11:04:08 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 10 11:04:08 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','6',trim(PROGRAM)||'+'||'后台维护系统',SID,serial# ,'20140114','11:04:08','sd_Hospital@super:4FEF60119F70D5321E2D46745E90A57C' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 11 11:04:08 SQL Data In: ORACLE - Rows affected = 1 12 11:04:08 SQL Execute: ORACLE - Commit 13 11:04:08 SQL Data In: ORACLE - Rows affected = 0 14 11:04:08 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='6' 15 11:04:08 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 16 11:04:08 SQL Execute: ORACLE - Select SYSDATE from Dual 17 11:04:08 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 18 11:04:08 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 19 11:04:08 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='6' 20 11:04:08 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 21 11:04:08 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 22 11:04:08 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('8') order by BH0000 23 11:04:08 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'super'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '6' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='SUPER')) 24 11:04:08 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=0 25 11:04:08 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 26 11:04:08 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 27 11:04:08 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 28 11:04:08 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 29 11:04:08 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')) 30 11:04:08 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3442350,0,'BZ1UQZZXW8GF5WB','6',nvl('95174168',' '),'',15) 31 11:04:08 SQL Data In: ORACLE - Rows affected = 1 32 11:04:08 SQL Execute: ORACLE - Commit 33 11:04:08 SQL Data In: ORACLE - Rows affected = 0 34 11:04:08 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15 35 11:04:08 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 36 11:04:08 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 37 11:04:08 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 38 11:04:08 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.194' 39 11:04:08 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 40 11:04:08 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 41 11:04:08 SQL Data In: ORACLE - Rows affected = 0 42 11:04:08 SQL Execute: ORACLE - Commit 43 11:04:08 SQL Data In: ORACLE - Rows affected = 0 44 11:04:08 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 45 11:04:08 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 46 11:04:08 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 47 11:04:09 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 48 11:04:09 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='6') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',15,')> 0) and YXQ000>='20140114' 49 11:04:09 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 50 11:04:09 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 51 11:04:09 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 52 11:04:09 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 53 11:04:09 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 54 11:04:09 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 55 11:04:09 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='6' and (( 0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='6'))) 56 11:04:09 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0' ORDER BY B.F_TEMPTYPE,A.MKDM00 57 11:04:09 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='0 '))) 58 11:04:09 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='+ '))) 59 11:04:09 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 60 11:04:09 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('XT_YSXGFBKS','XT_XTXXYTJRXG','YF_SFXSGJJ','XT_SFXSGLYKFPQX') 61 11:04:09 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 0 62 11:05:17 SQL Execute: ORACLE - Select * from XT_YGXZ00 ORDER BY DM0000 63 11:05:17 SQL Execute: ORACLE - Select * from vw_bm_bmbm01 ORDER BY BH0000 64 11:05:17 SQL Execute: ORACLE - select t1.YGBH00,t1.BMBH00,t1.ZWXM00,t1.XB0000,t1.XKH000, t1.PYSM00,t1.WBSM00, (select BMMC00 from BM_BMBM00 where t1.BMBH00=BMBH00(+)) BMMC00, t1.YGXZ00, t1.CFJB00,t1.GZDJ00,t1.MZDJ00,t1.DPDJ00,t1.SJDJ00,t1.KSSJB0, t1.CZBZ00,t1.DLMM00,t1.BRID00,t1.MRGHLB, (select LBMC00 from BM_GHLBB0 where SFYX00='Y' and t1.MRGHLB=LBBH00(+)) LBMC00, t1.YSLB00, (select YSLBMC from BM_YSLB00 where t1.YSLB00=YSLB00(+)) YSLBMC, t1.ssdj00,t1.ylfl00,t1.DH0000, DECODE(T1.CZRQ01, NULL, '', substr(nvl(T1.CZRQ01, ''),1,4)||'.'|| substr(nvl(T1.CZRQ01, ''),5,2)||'.'|| substr(nvl(T1.CZRQ01, ''),7,2)||' '||T1.CZSJ01) CZRQSJ, T1.CZY001, (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=T1.CZY001) CZYXM0 from BM_YGBM00 T1 where t1.YGBH00>=1 and CZBZ00<>'2' order by t1.XKH000, t1.BMBH00 65 11:14:04 SQL Execute: ORACLE - select t1.YGBH00,t1.BMBH00,t1.ZWXM00,t1.XB0000,t1.XKH000,t1.PYSM00,t1.WBSM00,(select BMMC00 from BM_BMBM00 where t1.BMBH00=BMBH00(+)) BMMC00,t1.YGXZ00,t1.CFJB00,t1.GZDJ00,t1.MZDJ00,t1.DPDJ00,t1.SJDJ00,t1.KSSJB0,t1.CZBZ00,t1.DLMM00,t1.BRID00,t1.MRGHLB,(select LBMC00 from BM_GHLBB0 where SFYX00='Y' and t1.MRGHLB=LBBH00(+)) LBMC00,t1.YSLB00,(select YSLBMC from BM_YSLB00 where t1.YSLB00=YSLB00(+)) YSLBMC,t1.ssdj00,t1.ylfl00,t1.DH0000, DECODE(T1.CZRQ01, NULL, '', substr(nvl(T1.CZRQ01, ''),1,4)||'.'|| substr(nvl(T1.CZRQ01, ''),5,2)||'.'|| substr(nvl(T1.CZRQ01, ''),7,2)||' '||T1.CZSJ01) CZRQSJ, T1.CZY001, (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=T1.CZY001) CZYXM0 FROM BM_YGBM00 t1 WHERE t1.YGBH00>=1 and CZBZ00<>'2' order by t1.XKH000,t1.BMBH00 66 15:18:01 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=3442350 67 15:18:01 SQL Data In: ORACLE - Rows affected = 1 68 15:18:01 SQL Execute: ORACLE - Commit 69 15:18:01 SQL Data In: ORACLE - Rows affected = 0 70 15:18:01 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 71 15:18:01 SQL Data In: ORACLE - Rows affected = 0 72 15:18:01 SQL Execute: ORACLE - Commit 73 15:18:01 SQL Data In: ORACLE - Rows affected = 0 74 15:18:51 Log started for: 库存物资管理子系统 75 15:18:51 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','K','prjSB_KCWZ.exe'||'+'||'库存物资管理子系统','514','28781' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 76 15:18:51 SQL Data In: ORACLE - Rows affected = 1 77 15:18:51 SQL Execute: ORACLE - Commit 78 15:18:51 SQL Data In: ORACLE - Rows affected = 0 79 15:18:51 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 80 15:18:51 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 81 15:18:51 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 82 15:18:51 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 83 15:18:51 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','K','prjSB_KCWZ.exe'||'+'||'库存物资管理子系统','556','41062' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 84 15:18:51 SQL Data In: ORACLE - Rows affected = 1 85 15:18:51 SQL Execute: ORACLE - Commit 86 15:18:51 SQL Data In: ORACLE - Rows affected = 0 87 15:18:51 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='K' 88 15:18:51 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 89 15:18:51 SQL Execute: ORACLE - Select SYSDATE from Dual 90 15:18:51 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 91 15:18:51 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 92 15:18:51 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 93 15:18:51 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 94 15:18:51 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 95 15:18:51 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='K' 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 ('c','0','1','5','2','9','a','8','4','b') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 96 15:18:54 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'K' 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='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 97 15:18:54 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 98 15:18:54 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 99 15:18:54 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 100 15:18:54 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 101 15:18:54 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 102 15:18:54 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')) 103 15:18:54 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3945970,476,'BZ1UQZZXW8GF5WB','K',nvl('226943090',' '),'192.168.8.194#556:41062@prjSB_KCWZ.exe+库存物资管理子系统',208) 104 15:18:54 SQL Data In: ORACLE - Rows affected = 1 105 15:18:54 SQL Execute: ORACLE - Commit 106 15:18:54 SQL Data In: ORACLE - Rows affected = 0 107 15:18:54 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 208 108 15:18:54 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 109 15:18:54 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 110 15:18:54 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.194' 111 15:18:54 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 112 15:18:54 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 208 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 113 15:18:54 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 114 15:18:54 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'K'||',')>0 115 15:18:56 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 116 15:18:56 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 117 15:18:56 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140114' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',208,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='K') 118 15:18:56 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 119 15:18:56 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 120 15:18:56 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=208 121 15:18:56 SQL Execute: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 122 15:18:56 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 123 15:18:56 SQL Execute: ORACLE - delete SD_SB.WZ_TEMP00 124 15:18:56 SQL Data In: ORACLE - Rows affected = 0 125 15:18:56 SQL Execute: ORACLE - Commit 126 15:18:56 SQL Data In: ORACLE - Rows affected = 0 127 15:18:56 SQL Execute: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 128 15:18:56 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 129 15:18:56 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='K' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='K'))) 130 15:18:56 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'K$%' and A.XTDM00='K' and trim(A.MKDM00)='K$'||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 131 15:18:56 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 '))) 132 15:18:56 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 133 15:18:56 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='+ '))) 134 15:18:58 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKQR' 135 15:18:58 SQL Execute: ORACLE - SELECT DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00 FROM WZ_RCK000 a,VW_WZ_CJBM00 b WHERE a.SHBMBH=b.BMID00 AND a.KFBMBH=208 AND RCKLB0='2' AND ZTBZ00='1' and (RCKLX0<>'27' and rcklx0<>'36') ORDER BY b.BMBH00 136 15:19:07 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 137 15:19:10 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKQR' 138 15:19:10 SQL Execute: ORACLE - SELECT DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00 FROM WZ_RCK000 a,VW_WZ_CJBM00 b WHERE a.SHBMBH=b.BMID00 AND a.KFBMBH=208 AND RCKLB0='2' AND ZTBZ00='1' and (RCKLX0<>'27' and rcklx0<>'36') ORDER BY b.BMBH00 139 15:19:13 SQL Execute: ORACLE - SELECT DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00 FROM WZ_RCK000 a,VW_WZ_CJBM00 b WHERE a.SHBMBH=b.BMID00 AND a.KFBMBH=208 AND RCKLB0='2' AND ZTBZ00='1' and (RCKLX0<>'27' and rcklx0<>'36') ORDER BY b.BMBH00 140 15:19:23 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 141 15:19:23 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','K','prjSB_KCWZ.exe'||'+'||'库存物资管理子系统','176','10306' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 142 15:19:23 SQL Data In: ORACLE - Rows affected = 1 143 15:19:23 SQL Execute: ORACLE - Commit 144 15:19:23 SQL Data In: ORACLE - Rows affected = 0 145 15:19:23 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 146 15:19:23 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 147 15:19:23 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 148 15:19:23 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 149 15:19:23 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','K','prjSB_KCWZ.exe'||'+'||'库存物资管理子系统','216','38223' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 150 15:19:23 SQL Data In: ORACLE - Rows affected = 1 151 15:19:23 SQL Execute: ORACLE - Commit 152 15:19:23 SQL Data In: ORACLE - Rows affected = 0 153 15:19:23 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='K' 154 15:19:23 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 155 15:19:23 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 156 15:19:23 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='K' 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 ('c','0','1','5','2','9','a','8','4','b') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 157 15:19:29 SQL Execute: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '208' 158 15:19:29 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 159 15:19:29 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'K' 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='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 160 15:19:29 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 161 15:19:29 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 162 15:19:29 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=3945970 163 15:19:29 SQL Data In: ORACLE - Rows affected = 1 164 15:19:29 SQL Execute: ORACLE - Commit 165 15:19:29 SQL Data In: ORACLE - Rows affected = 0 166 15:19:29 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 167 15:19:29 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 168 15:19: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')) 169 15:19:30 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3945971,476,'BZ1UQZZXW8GF5WB','K',nvl('226943099',' '),'192.168.8.194#216:38223@prjSB_KCWZ.exe+库存物资管理子系统',208) 170 15:19:30 SQL Data In: ORACLE - Rows affected = 1 171 15:19:30 SQL Execute: ORACLE - Commit 172 15:19:30 SQL Data In: ORACLE - Rows affected = 0 173 15:19:30 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 208 174 15:19:30 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 175 15:19:30 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 176 15:19:30 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.194' 177 15:19:30 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 178 15:19:30 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 208 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 179 15:19:30 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140114' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',208,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='K') 180 15:19:30 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 181 15:19:30 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 182 15:19:30 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=208 183 15:19:30 SQL Execute: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 184 15:19:30 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 185 15:19:30 SQL Execute: ORACLE - delete SD_SB.WZ_TEMP00 186 15:19:30 SQL Data In: ORACLE - Rows affected = 0 187 15:19:30 SQL Execute: ORACLE - Commit 188 15:19:30 SQL Data In: ORACLE - Rows affected = 0 189 15:19:30 SQL Execute: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 190 15:19:30 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 191 15:19:30 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='K' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='K'))) 192 15:19:30 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'K$%' and A.XTDM00='K' and trim(A.MKDM00)='K$'||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 193 15:19:30 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 '))) 194 15:19:30 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 195 15:19:30 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='+ '))) 196 15:19:33 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKQR' 197 15:19:33 SQL Execute: ORACLE - SELECT DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00 FROM WZ_RCK000 a,VW_WZ_CJBM00 b WHERE a.SHBMBH=b.BMID00 AND a.KFBMBH=208 AND RCKLB0='2' AND ZTBZ00='1' and (RCKLX0<>'27' and rcklx0<>'36') ORDER BY b.BMBH00 198 15:19:37 SQL Execute: ORACLE - SELECT DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00 FROM WZ_RCK000 a,VW_WZ_CJBM00 b WHERE a.SHBMBH=b.BMID00 AND a.KFBMBH=208 AND RCKLB0='2' AND ZTBZ00='1' and (RCKLX0<>'27' and rcklx0<>'36') ORDER BY b.BMBH00 199 15:19:39 SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH 200 15:19:39 SQL Execute: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '2' and RCKBBH<>'36' AND SFYX00 = 'Y' 201 15:19:39 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKCX' 202 15:19:39 SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKCX' and DBGRIN='DBGridEh1' order by LS0000 203 15:19:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140114 204 15:19:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140114 205 15:19:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 206 15:19:39 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 207 15:19:39 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 208 15:19:39 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 209 15:19:39 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2',decode(b.CXBZ00,'Z','已确认','已冲销'),'3','已审核','4','已作废','5','已更正') as ZTBZMC,a.RCKBMC,a.QRRQ00,a.RCKDH0,a.SHBMMC,b.FPH000,c.WZDMBM,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.WZDW00,b.CRKSL0,b.MJPH00,b.PZWH00,b.CGJ000,b.PH0000,b.YXQ000,b.CKPFJ0,b.ZJE000,b.JCS000,b.WZSXMC,a.RCKID0,c.PYSM00,c.WBSM00,b.CXBZ00,b.BZ0000,a.CGYGXM ,b.XZZD01,b.XZZD02,b.XZZD03,b.XZZD04 ,(select QRRXM0 from vw_wz_qld000 where rckid0=a.rckid0) QLQRR0,b.MJRQ00,b.LSJE00,B.LSJ000 ,SHYGXM,QRYGXM,RKYGXM,a.SHRQ00 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b ,BM_WZDM00 c where a.RCKID0=b.RCKID0 and b.WZDMID=c.WZDMID and a.QRRQ00 >=? and a.QRRQ00 <=? and a.KFBMBH = ? and (rcklx0<>'27' and rcklx0<>'36') and a.RCKLB0 = '2' and c.WZDMBM||'' like ? ||'%' and ((A.rcklx0 =? ) OR (? = '-1')) and b.BZSL00<>0 order by a.RCKDH0 desc,b.RCKMXH 210 15:19:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140114 211 15:19:40 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140114 212 15:19:40 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 213 15:19:40 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 214 15:19:40 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 215 15:19:40 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 216 15:19:40 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2',decode(b.CXBZ00,'Z','已确认','已冲销'),'3','已审核','4','已作废','5','已更正') as ZTBZMC,a.RCKBMC,a.QRRQ00,a.RCKDH0,a.SHBMMC,b.FPH000,c.WZDMBM,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.WZDW00,b.CRKSL0,b.MJPH00,b.PZWH00,b.CGJ000,b.PH0000,b.YXQ000,b.CKPFJ0,b.ZJE000,b.JCS000,b.WZSXMC,a.RCKID0,c.PYSM00,c.WBSM00,b.CXBZ00,b.BZ0000,a.CGYGXM ,b.XZZD01,b.XZZD02,b.XZZD03,b.XZZD04 ,(select QRRXM0 from vw_wz_qld000 where rckid0=a.rckid0) QLQRR0,b.MJRQ00,b.LSJE00,B.LSJ000 ,SHYGXM,QRYGXM,RKYGXM,a.SHRQ00 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b ,BM_WZDM00 c where a.RCKID0=b.RCKID0 and b.WZDMID=c.WZDMID and a.QRRQ00 >=? and a.QRRQ00 <=? and a.KFBMBH = ? and (rcklx0<>'27' and rcklx0<>'36') and a.RCKLB0 = '2' and c.WZDMBM||'' like ? ||'%' and ((A.rcklx0 =? ) OR (? = '-1')) and b.BZSL00<>0 order by a.RCKDH0 desc,b.RCKMXH 217 15:19:48 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=3945971 218 15:19:48 SQL Data In: ORACLE - Rows affected = 1 219 15:19:48 SQL Execute: ORACLE - Commit 220 15:19:48 SQL Data In: ORACLE - Rows affected = 0 221 15:19:48 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 222 15:19:48 SQL Data In: ORACLE - Rows affected = 0 223 15:19:48 SQL Execute: ORACLE - Commit 224 15:19:48 SQL Data In: ORACLE - Rows affected = 0 225 15:20:06 Log started for: 检验信息系统 226 15:20:06 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 227 15:20:06 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','27','8959' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 228 15:20:06 SQL Data In: ORACLE - Rows affected = 1 229 15:20:06 SQL Execute: ORACLE - Commit 230 15:20:06 SQL Data In: ORACLE - Rows affected = 0 231 15:20:06 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 232 15:20:06 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 233 15:20:06 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 234 15:20:06 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 235 15:20:06 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','115','28471' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 236 15:20:06 SQL Data In: ORACLE - Rows affected = 1 237 15:20:06 SQL Execute: ORACLE - Commit 238 15:20:06 SQL Data In: ORACLE - Rows affected = 0 239 15:20:06 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 240 15:20:06 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 241 15:20:06 SQL Execute: ORACLE - Select SYSDATE from Dual 242 15:20:06 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 243 15:20:06 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 244 15:20:06 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 245 15:20:06 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 246 15:20:06 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 247 15:20:06 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' 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','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 248 15:21:14 Log started for: 住院医生工作站系统 249 15:21:14 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','176','13742' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 250 15:21:14 SQL Data In: ORACLE - Rows affected = 1 251 15:21:14 SQL Execute: ORACLE - Commit 252 15:21:14 SQL Data In: ORACLE - Rows affected = 0 253 15:21:14 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 254 15:21:14 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 255 15:21:14 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 256 15:21:14 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 257 15:21:14 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','27','11060' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 258 15:21:14 SQL Data In: ORACLE - Rows affected = 1 259 15:21:14 SQL Execute: ORACLE - Commit 260 15:21:14 SQL Data In: ORACLE - Rows affected = 0 261 15:21:14 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 262 15:21:14 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 263 15:21:14 SQL Execute: ORACLE - Select SYSDATE from Dual 264 15:21:14 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 265 15:21:14 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 266 15:21:14 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z' 267 15:21:14 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 268 15:21:14 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 269 15:21:14 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 270 15:21:17 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') 271 15:21:17 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 272 15:21:17 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 273 15:21:17 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 274 15:21:17 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 275 15:21:17 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 276 15:21:17 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')) 277 15:21:17 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3945975,476,'BZ1UQZZXW8GF5WB','Z',nvl('226943137',' '),'192.168.8.194#27:11060@ZY_YS.exe+住院医生工作站系统',22) 278 15:21:18 SQL Data In: ORACLE - Rows affected = 1 279 15:21:18 SQL Execute: ORACLE - Commit 280 15:21:18 SQL Data In: ORACLE - Rows affected = 0 281 15:21:18 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 22 282 15:21:18 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 283 15:21:18 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 284 15:21:18 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.194' 285 15:21:18 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 286 15:21:18 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 22 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 287 15:21:18 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 288 15:21:18 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'Z'||',')>0 289 15:21:19 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 290 15:21:19 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 291 15:21:19 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140114' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',22,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='Z') 292 15:21:19 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 293 15:21:19 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 294 15:21:19 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 295 15:21:19 SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 296 15:21:19 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.194','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','27','11060' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ADO:' from dual 297 15:21:19 SQL Data In: ORACLE - Rows affected = 1 298 15:21:19 SQL Execute: ORACLE - Commit 299 15:21:19 SQL Data In: ORACLE - Rows affected = 0 300 15:21:21 SQL Execute: ORACLE - SELECT to_char(sid,'0000') FROM V$SESSION where userenv('sessionid')=audsid 301 15:21:21 SQL Execute: ORACLE - begin package_zhcx.set_var('0027'); END; 302 15:21:21 SQL Data In: ORACLE - Rows affected = 0 303 15:21:21 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 304 15:21:21 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a 305 15:21:21 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'))) 306 15:21:21 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 307 15:21:21 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 '))) 308 15:21:21 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 309 15:21:21 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='+ '))) 310 15:21:21 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID' 311 15:21:21 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%' 312 15:21:21 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') 313 15:21:21 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 314 15:21:21 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 476 315 15:21:21 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 316 15:21:21 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF') 317 15:21:21 SQL Execute: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=476 318 15:21:21 SQL Execute: ORACLE - select * from bm_yslb00 where yslb00='3' 319 15:21:21 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 320 15:21:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 476 321 15:21:29 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(+) 322 15:21:29 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 323 15:21:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 324 15:21:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 325 15:21:29 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 326 15:21:35 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ') 327 15:21:35 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=476)))) 328 15:21:35 SQL Execute: ORACLE - select 1 from BM_YGBM00 where YGBH00=476 and YGXZ00 like '%5%' 329 15:21:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 330 15:21:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 331 15:21:37 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 332 15:21:43 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951096 333 15:21:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668916 334 15:21:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951096 335 15:21:43 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 336 15:21:43 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951383 337 15:21:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3671369 338 15:21:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951383 339 15:21:43 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 340 15:21:43 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=950928 341 15:21:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3667614 342 15:21:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950928 343 15:21:43 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 344 15:21:43 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=942163 345 15:21:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3653393 346 15:21:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 942163 347 15:21:43 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 348 15:21:43 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951171 349 15:21:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3669628 350 15:21:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951171 351 15:21:43 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 352 15:21:43 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951057 353 15:21:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668693 354 15:21:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951057 355 15:21:43 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 356 15:21:43 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951032 357 15:21:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668467 358 15:21:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951032 359 15:21:43 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 360 15:21:43 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=950737 361 15:21:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3666274 362 15:21:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950737 363 15:21:43 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 364 15:21:43 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951306 365 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3670781 366 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951306 367 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 368 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951335 369 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3670952 370 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951335 371 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 372 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951075 373 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668777 374 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951075 375 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 376 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951402 377 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3671569 378 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951402 379 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 380 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951241 381 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3670269 382 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951241 383 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 384 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=950916 385 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3667537 386 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950916 387 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 388 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951078 389 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668793 390 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951078 391 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 392 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951021 393 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668352 394 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951021 395 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 396 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=945864 397 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3657800 398 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 945864 399 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 400 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951025 401 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668395 402 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951025 403 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 404 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951415 405 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3671782 406 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951415 407 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 408 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951390 409 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3671458 410 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951390 411 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 412 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951481 413 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3672268 414 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951481 415 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 416 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=950777 417 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3666544 418 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950777 419 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 420 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=950899 421 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3667482 422 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950899 423 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 424 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=949274 425 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3662084 426 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 949274 427 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 428 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=949250 429 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3661873 430 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 949250 431 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 432 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951084 433 15:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668802 434 15:21:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951084 435 15:21:44 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 436 15:21:44 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951197 437 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3669988 438 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951197 439 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 440 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=949843 441 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3664088 442 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 949843 443 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 444 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=927607 445 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3592315 446 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 927607 447 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 448 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951477 449 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3672210 450 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951477 451 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 452 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951327 453 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3670919 454 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951327 455 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 456 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=949115 457 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3661369 458 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 949115 459 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 460 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951400 461 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3671514 462 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951400 463 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 464 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=949987 465 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3664898 466 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 949987 467 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 468 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951193 469 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3669845 470 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951193 471 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 472 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951022 473 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668357 474 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951022 475 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 476 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=946258 477 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3658325 478 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 946258 479 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 480 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951049 481 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668602 482 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951049 483 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 484 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=950838 485 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3666974 486 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950838 487 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 488 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=950914 489 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3667530 490 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950914 491 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 492 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951224 493 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3670126 494 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951224 495 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 496 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951079 497 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668794 498 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951079 499 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 500 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951218 501 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3670106 502 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951218 503 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 504 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=950902 505 15:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3667490 506 15:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950902 507 15:21:45 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 508 15:21:45 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951040 509 15:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3668525 510 15:21:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951040 511 15:21:46 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 512 15:21:46 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951201 513 15:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3670022 514 15:21:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951201 515 15:21:46 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 516 15:21:46 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=951442 517 15:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3671902 518 15:21:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 951442 519 15:21:46 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 520 15:21:46 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=842959 521 15:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3424974 522 15:21:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 842959 523 15:21:46 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 524 15:21:46 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=950023 525 15:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3665123 526 15:21:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950023 527 15:21:46 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 528 15:21:47 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 951032 529 15:21:47 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951032 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 530 15:21:47 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=951032 and ZDLB00='2' 531 15:21:59 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 532 15:21:59 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=4 and ZYGHID=951032 and MZZYBZ='1' 533 15:22:10 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951032 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 534 15:22:11 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 950737 535 15:22:11 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 950737 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 536 15:22:11 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=950737 and ZDLB00='2' 537 15:22:13 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 538 15:22:13 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=4 and ZYGHID=950737 and MZZYBZ='1' 539 15:24:09 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 951481 540 15:24:09 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951481 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 541 15:24:09 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=951481 and ZDLB00='2' 542 15:24:13 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 543 15:24:13 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=4 and ZYGHID=951481 and MZZYBZ='1' 544 15:24:15 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 951022 545 15:24:15 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951022 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 546 15:24:15 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=951022 and ZDLB00='2' 547 15:24:17 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 548 15:24:17 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=4 and ZYGHID=951022 and MZZYBZ='1' 549 15:24:32 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 951477 550 15:24:32 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951477 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 551 15:24:33 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=951477 and ZDLB00='2' 552 15:24:34 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 553 15:24:34 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=4 and ZYGHID=951477 and MZZYBZ='1' 554 15:25:37 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 555 15:25:37 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=4 and ZYGHID=951477 and MZZYBZ='1' 556 15:25:39 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 951197 557 15:25:39 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951197 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 558 15:25:39 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=951197 and ZDLB00='2' 559 15:25:42 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 560 15:25:42 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=4 and ZYGHID=951197 and MZZYBZ='1' 561 15:25:43 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 951078 562 15:25:43 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951078 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 563 15:25:43 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=951078 and ZDLB00='2' 564 15:25:44 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 565 15:25:44 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=3 and ZYGHID=951078 and MZZYBZ='1' 566 15:25:45 SQL Execute: ORACLE - select * from BM_JCLB00 where SFJK00='1' 567 15:25:45 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where XKH000='9998' 568 15:25:45 SQL Execute: ORACLE - select BMBH00,BMXZ00 from BM_BMBM00 where JKBH01='22' 569 15:25:45 SQL Execute: ORACLE - select KSH000 from BM_BQKS00 where BQH000 in (select BQH000 from BM_BQKS00 where KSH000=22) 570 15:25:47 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 951390 571 15:25:47 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951390 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 572 15:25:47 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=951390 and ZDLB00='2' 573 15:25:50 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 574 15:25:50 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=4 and ZYGHID=951390 and MZZYBZ='1' 575 15:30:18 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 951078 576 15:30:18 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951078 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 577 15:30:18 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=951078 and ZDLB00='2' 578 15:30:21 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 579 15:30:21 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=4 and ZYGHID=951078 and MZZYBZ='1' 580 15:30:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 581 15:30:27 SQL Execute: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=? and rownum=1 582 15:30:27 SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00 583 15:30:27 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 584 15:30:27 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 585 15:30:27 SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 586 15:30:27 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 587 15:30:27 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 588 15:30:27 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 589 15:30:27 SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='61' 590 15:30:27 SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 591 15:30:27 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='61' 592 15:30:27 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='61' 593 15:30:27 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='61' 594 15:30:27 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='61' 595 15:30:27 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='61' 596 15:30:27 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='61' 597 15:30:27 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, decode(A.JGZT00,'6','Y','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 '20140107' and '20140114' and A.ZYHGHH = '278095' and (A.SQKS00+0 = '61' or A.SQBQ00+0 = '61')) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 598 15:30:27 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='LX0042' and pyrq00='20140112' and rownum=1 599 15:30:28 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'LX0042' and PYRQ00 = '20140112' 600 15:30:28 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,22593) 601 15:30:28 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='LX0042' and pyrq00='20140112' ORDER BY DYSX00 602 15:30: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, decode(A.JGZT00,'6','Y','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 '20140101' and '20140114' and A.ZYHGHH = '278095' and (A.SQKS00+0 = '61' or A.SQBQ00+0 = '61')) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 603 15:30: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='LX0042' and pyrq00='20140112' and rownum=1 604 15:30:39 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'LX0042' and PYRQ00 = '20140112' 605 15:30:39 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,22593) 606 15:30:39 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='LX0042' and pyrq00='20140112' ORDER BY DYSX00 607 15:30:47 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 951415 608 15:30:47 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951415 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 609 15:30:47 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=951415 and ZDLB00='2' 610 15:30:48 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 949274 611 15:30:48 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 949274 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 612 15:30:48 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=949274 and ZDLB00='2' 613 15:30:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 614 15:30:52 SQL Execute: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=? and rownum=1 615 15:30:52 SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00 616 15:30:52 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 617 15:30:52 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 618 15:30:52 SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 619 15:30:52 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 620 15:30:52 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 621 15:30:52 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 622 15:30:52 SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='61' 623 15:30:52 SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 624 15:30:52 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='61' 625 15:30:52 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='61' 626 15:30:52 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='61' 627 15:30:52 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='61' 628 15:30:52 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='61' 629 15:30:52 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='61' 630 15:30:52 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, decode(A.JGZT00,'6','Y','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 '20140107' and '20140114' and A.ZYHGHH = '277215' and (A.SQKS00+0 = '61' or A.SQBQ00+0 = '61')) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 631 15:30:52 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='' and pyrq00='' and rownum=1 632 15:30:52 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = '' and PYRQ00 = '' 633 15:30:52 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1) 634 15:30:52 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='' and pyrq00='' ORDER BY DYSX00 635 15:30:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 636 15:30:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 637 15:30:52 SQL Execute: ORACLE - SELECT distinct PYRQ00,YBH000,XJID00,XJYWMC,ZWMC00,XJJG00,BBBZ00,JGZT00,XJMS00 FROM VW_JY_XJJG00 WHERE YBH000=? AND PYRQ00=? 638 15:30:55 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 949843 639 15:30:55 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 949843 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 640 15:30:55 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=949843 and ZDLB00='2' 641 15:30:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 642 15:30:58 SQL Execute: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=? and rownum=1 643 15:31:01 SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00 644 15:31:01 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 645 15:31:01 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 646 15:31:01 SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 647 15:31:01 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 648 15:31:01 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 649 15:31:01 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 650 15:31:01 SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='61' 651 15:31:01 SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 652 15:31:01 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='61' 653 15:31:01 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='61' 654 15:31:01 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='61' 655 15:31:01 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='61' 656 15:31:01 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='61' 657 15:31:01 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='61' 658 15:31:01 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, decode(A.JGZT00,'6','Y','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 '20140107' and '20140114' and A.ZYHGHH = '277486' and (A.SQKS00+0 = '61' or A.SQBQ00+0 = '61')) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 659 15:31:01 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='FB0003' and pyrq00='20140108' and rownum=1 660 15:31:01 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'FB0003' and PYRQ00 = '20140108' 661 15:31:01 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16358) 662 15:31:01 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='FB0003' and pyrq00='20140108' ORDER BY DYSX00 663 15:31:12 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, decode(A.JGZT00,'6','Y','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 '20131205' and '20140114' and A.ZYHGHH = '277486' and (A.SQKS00+0 = '61' or A.SQBQ00+0 = '61')) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 664 15:31:12 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='FB0003' and pyrq00='20140108' and rownum=1 665 15:31:12 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'FB0003' and PYRQ00 = '20140108' 666 15:31:12 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16358) 667 15:31:12 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='FB0003' and pyrq00='20140108' ORDER BY DYSX00 668 15:31:13 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='LX0017' and pyrq00='20140102' and rownum=1 669 15:31:13 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'LX0017' and PYRQ00 = '20140102' 670 15:31:13 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,22593) 671 15:31:13 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='LX0017' and pyrq00='20140102' ORDER BY DYSX00 672 15:31:19 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, decode(A.JGZT00,'6','Y','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 '20140107' and '20140114' and A.ZYHGHH = '277486' and (A.SQKS00+0 = '61' or A.SQBQ00+0 = '61')) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 673 15:31:19 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='FB0003' and pyrq00='20140108' and rownum=1 674 15:31:19 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'FB0003' and PYRQ00 = '20140108' 675 15:31:19 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16358) 676 15:31:19 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='FB0003' and pyrq00='20140108' ORDER BY DYSX00 677 15:32:59 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 951402 678 15:32:59 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 951402 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 679 15:32:59 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=951402 and ZDLB00='2' 680 15:33:01 SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=22 681 15:33:01 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00=4 and ZYGHID=951402 and MZZYBZ='1' 682 15:33:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 683 15:33:05 SQL Execute: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=? and rownum=1 684 15:33:05 SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00 685 15:33:05 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 686 15:33:05 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 687 15:33:05 SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 688 15:33:05 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 689 15:33:05 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 690 15:33:05 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 691 15:33:05 SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='61' 692 15:33:05 SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 693 15:33:05 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='61' 694 15:33:05 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='61' 695 15:33:05 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='61' 696 15:33:05 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='61' 697 15:33:05 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='61' 698 15:33:05 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='61' 699 15:33:05 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, decode(A.JGZT00,'6','Y','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 '20140107' and '20140114' and A.ZYHGHH = '278411' and (A.SQKS00+0 = '61' or A.SQBQ00+0 = '61')) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 700 15:33:06 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='AC0011' and pyrq00='20140114' and rownum=1 701 15:33:06 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AC0011' and PYRQ00 = '20140114' 702 15:33:06 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,17183,17173,17170) 703 15:33:06 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='AC0011' and pyrq00='20140114' ORDER BY DYSX00