1 10:54:52 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '8') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',474,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '474') AND (INSTR (',' || a.jsksbh || ',',',474,') > 0 or a.jsksbh is null) 2 10:54:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 3 10:54:54 SQL Execute: ORACLE - select count(*) vcount from bm_ckbm00 where bmbh00=? and PBLX00='1' and flag00='4' 4 10:54:54 SQL Execute: ORACLE - Rollback 5 10:54:54 SQL Data In: ORACLE - Rows affected = 0 6 10:54:54 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2516903 7 10:54:54 SQL Data In: ORACLE - Rows affected = 1 8 10:54:54 SQL Execute: ORACLE - Commit 9 10:54:54 SQL Data In: ORACLE - Rows affected = 0 10 10:54:54 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 11 10:54:54 SQL Data In: ORACLE - Rows affected = 0 12 10:54:54 SQL Execute: ORACLE - Commit 13 10:54:54 SQL Data In: ORACLE - Rows affected = 0 14 10:54:55 Log started for: 后台维护系统 15 10:55:04 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '6')) or XXXZ00='0') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',464,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '464') AND (INSTR (',' || a.jsksbh || ',',',464,') > 0 or a.jsksbh is null) 16 10:55:05 Log started for: 住院医生工作站系统 17 10:55:05 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.200','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','263','60458' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@star:4B67AB0B69AB4AAF48374F89F31CC5BF' from dual 18 10:55:05 SQL Data In: ORACLE - Rows affected = 1 19 10:55:05 SQL Execute: ORACLE - Commit 20 10:55:05 SQL Data In: ORACLE - Rows affected = 0 21 10:55:05 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 22 10:55:06 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='220035' 23 10:55:06 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='STAR' and CZBZ00 in ('1') 24 10:55:06 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 25 10:55:06 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.200','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','443','53608' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@star:8A7076285B052F6C6F07D1A1A6735051' from dual 26 10:55:06 SQL Data In: ORACLE - Rows affected = 1 27 10:55:06 SQL Execute: ORACLE - Commit 28 10:55:06 SQL Data In: ORACLE - Rows affected = 0 29 10:55:06 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 30 10:55:06 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='STAR' and CZBZ00 in ('1') 31 10:55:06 SQL Execute: ORACLE - Select SYSDATE from Dual 32 10:55:06 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 33 10:55:06 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0)=upper('sd_Hospital') and ROWNUM = 1 34 10:55:06 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z' 35 10:55:06 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 36 10:55: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 37 10:55: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') and KLDH00 = 'YB-SBK' 38 10:55:06 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)='STAR')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0') 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)='STAR')) order by b.PLXH00,a.BH0000 39 10:55:14 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'star'='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)='STAR')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='STAR') 40 10:55:14 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1913 41 10:55:14 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 42 10:55:14 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 43 10:55:14 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 44 10:55:14 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 45 10:55:14 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')) 46 10:55:17 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2516908,1913,'lnyy-e2991db1d3','Z',nvl('17483573',' '),'192.168.10.200#443:53608@ZY_YS.exe+住院医生工作站系统',661) 47 10:55:17 SQL Data In: ORACLE - Rows affected = 1 48 10:55:17 SQL Execute: ORACLE - Commit 49 10:55:17 SQL Data In: ORACLE - Rows affected = 0 50 10:55:17 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 661 51 10:55:17 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '220035' 52 10:55:17 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 53 10:55:17 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.10.200' 54 10:55:17 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 55 10:55:17 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 661 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 56 10:55:17 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('220035') 57 10:55:17 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where (nvl(a.YYID00,'0')='220035' or trim(nvl(a.YYID00,'0'))='0') AND (a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'Z'||',')>0 ) 58 10:55:19 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1913' and name00='SYSTEMSKIN' 59 10:55:19 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 60 10:55:19 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20160812' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',661,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='Z') 61 10:55:19 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 62 10:55:19 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 63 10:55:19 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 64 10:55:19 SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 65 10:55:19 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.200','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','443','53608' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ADO:' from dual 66 10:55:19 SQL Data In: ORACLE - Rows affected = 1 67 10:55:19 SQL Execute: ORACLE - Commit 68 10:55:19 SQL Data In: ORACLE - Rows affected = 0 69 10:55:19 SQL Execute: ORACLE - SELECT to_char(sid,'0000') FROM V$SESSION where userenv('sessionid')=audsid 70 10:55:19 SQL Execute: ORACLE - begin package_zhcx.set_var('0443'); END; 71 10:55:19 SQL Data In: ORACLE - Rows affected = 0 72 10:55:19 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 73 10:55:19 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a 74 10:55:19 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='Z' and (( 1913= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1913 and XTDM00='Z'))) 75 10:55:19 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 76 10:55:19 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 ((1913= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1913 and XTDM00='0 '))) 77 10:55:19 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 78 10:55:19 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1913= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1913 and XTDM00='+ '))) 79 10:55:19 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID' 80 10:55:19 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%' 81 10:55:19 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','CR_AZBFKPrintID') 82 10:55:19 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 1913 83 10:55:19 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 84 10:55:19 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF') 85 10:55:19 SQL Execute: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=1913 86 10:55:19 SQL Execute: ORACLE - select * from bm_yslb00 where yslb00='4' 87 10:55:19 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 88 10:55:19 SQL Execute: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='合理用药' AND YXBZ00='1' order by XSXH00 89 10:55:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 90 10:55:22 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(+) 91 10:55:22 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 where LB0000<>'2' 92 10:55:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 661.000000 93 10:55:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 661.000000 94 10:55:22 SQL Execute: ORACLE - SELECT distinct A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,CJRQ00 FROM VW_ZS_DLKSBRXX A WHERE 1=1 and (DQKS00=? or DQBQ00=?) and exists (select 1 from ZS_BLXX00 where ZYID00=A.ZYID00 ) ORDER BY RYCWH0 95 10:55:23 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ') 96 10:55:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 661.000000 97 10:55:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 661.000000 98 10:55:23 SQL Execute: ORACLE - SELECT distinct A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,CJRQ00 FROM VW_ZS_DLKSBRXX A WHERE 1=1 and (DQKS00=? or DQBQ00=?) and exists (select 1 from ZS_BLXX00 where ZYID00=A.ZYID00 ) ORDER BY RYCWH0 99 10:55:24 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771960 100 10:55:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 257856 101 10:55:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771960 102 10:55:24 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 103 10:55:24 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771778 104 10:55:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3442887 105 10:55:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771778 106 10:55:24 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 107 10:55:24 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771606 108 10:55:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4149465 109 10:55:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771606 110 10:55:24 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 111 10:55:24 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771780 112 10:55:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 295640 113 10:55:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771780 114 10:55:24 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 115 10:55:24 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772074 116 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 267785 117 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772074 118 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 119 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772017 120 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4151648 121 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772017 122 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 123 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771804 124 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 319491 125 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771804 126 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 127 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771631 128 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 258579 129 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771631 130 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 131 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771625 132 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 258578 133 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771625 134 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 135 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771626 136 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 276732 137 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771626 138 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 139 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772080 140 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 302712 141 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772080 142 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 143 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771618 144 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4173635 145 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771618 146 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 147 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771801 148 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 273273 149 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771801 150 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 151 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771983 152 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4162922 153 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771983 154 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 155 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=770818 156 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 371711 157 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 770818 158 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 159 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771829 160 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 258227 161 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771829 162 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 163 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772000 164 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 257877 165 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772000 166 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 167 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771601 168 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 265536 169 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771601 170 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 171 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771910 172 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 319774 173 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771910 174 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 175 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771867 176 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4144668 177 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771867 178 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 179 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772015 180 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3299686 181 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772015 182 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 183 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772039 184 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4153949 185 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772039 186 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 187 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772057 188 10:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4184542 189 10:55:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772057 190 10:55:25 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 191 10:55:25 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771950 192 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4182436 193 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771950 194 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 195 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771904 196 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4183101 197 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771904 198 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 199 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772049 200 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4149020 201 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772049 202 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 203 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771732 204 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 277103 205 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771732 206 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 207 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771809 208 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 271129 209 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771809 210 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 211 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771177 212 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 258016 213 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771177 214 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 215 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=770948 216 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4161803 217 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 770948 218 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 219 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=770947 220 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 334261 221 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 770947 222 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 223 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771985 224 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 288824 225 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771985 226 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 227 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771791 228 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 257850 229 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771791 230 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 231 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772006 232 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4151107 233 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772006 234 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 235 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771933 236 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2366587 237 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771933 238 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 239 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772132 240 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3771686 241 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772132 242 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 243 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772103 244 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4167055 245 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772103 246 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 247 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771959 248 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 301401 249 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771959 250 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 251 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772092 252 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 343657 253 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772092 254 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 255 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771965 256 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4179282 257 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771965 258 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 259 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772077 260 10:55:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4181448 261 10:55:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772077 262 10:55:26 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 263 10:55:26 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771808 264 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 995287 265 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771808 266 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 267 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772066 268 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4184561 269 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772066 270 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 271 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772105 272 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4184643 273 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772105 274 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 275 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771838 276 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4183913 277 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771838 278 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 279 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771982 280 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 315584 281 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771982 282 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 283 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772115 284 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4142522 285 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772115 286 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 287 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771930 288 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4165262 289 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771930 290 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 291 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=770825 292 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 258491 293 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 770825 294 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 295 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772082 296 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4162837 297 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772082 298 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 299 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771800 300 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 319761 301 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771800 302 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 303 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772021 304 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 357447 305 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772021 306 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 307 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771909 308 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 319780 309 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771909 310 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 311 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771535 312 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 299928 313 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771535 314 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 315 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771961 316 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 773387 317 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771961 318 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 319 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=772100 320 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3184987 321 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772100 322 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 323 10:55:27 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=771935 324 10:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 290800 325 10:55:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 771935 326 10:55:27 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 327 10:55:27 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=1913)))) 328 10:55:27 SQL Execute: ORACLE - select 1 from BM_YGBM00 where YGBH00=1913 and YGXZ00 like '%5%' 329 10:55:28 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 771780 330 10:55:28 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 771780 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 331 10:55:29 SQL Execute: ORACLE - select SF_ZS_GETYZTSXX(771780) TSXX00 from dual 332 10:55:29 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=771780 and ZDLB00='2' 333 10:55:29 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,SLBMBH from VW_ZS_YFBMBH where SLBMBH= 483 order by PXXH00 334 10:55:29 SQL Execute: ORACLE - select LJID00,ZRZCID from LJ_ZRZC00 a where ZYID00=771780 and nvl(JSRQ00,' ')=' ' 335 10:55:29 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'Z') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',661,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '661') AND (INSTR (',' || a.jsksbh || ',',',661,') > 0 or a.jsksbh is null) 336 10:55:29 SQL Execute: ORACLE - select count(*) cou from BQ_BRZDXX a where ZDLB00='2' and ZYID00=771780 337 10:55:29 SQL Execute: ORACLE - select YPLBBH,YFBMBH from XT_YPFWFX where SLBMBH =483 and MRBZ00 = 'Y' 338 10:55:29 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 771780 339 10:55:29 SQL Execute: ORACLE - select NAME00,to_char(sysdate,'YYYY.MM.DD')TODAY,to_char(sysdate,'HH24:MI') NOWTIME,VALUE0 from XT_XTCS00 where NAME00 in ('BQ_FYYZMRQYSJ','BQ_PTYZMRQYSJ','ZS_YZ_DQSJWYZQYSJ') order by NAME00 340 10:55:30 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 341 10:55:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 342 10:55:30 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,ZFBL00,BZ0000,NBLBMC,NBZFBL,LBBH00,YPXZ00,YPSYSM,COLOUR from VW_BQ_YBYP00 where (PYSM00 Like ?) and( YBZXLB = '3' and YBBRLB = '7' and (((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=483 and YPLBBH='0')) )and LBBH00 = '0') or ((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=483 and YPLBBH='1'))) and LBBH00 = '1')) and ( (exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00 and BZ0000='消化病区')) or (not exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00)) ) ) Order By PYSM00) where Rownum<=35 343 10:55:32 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 771780 344 10:55:32 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 771780 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 345 10:55:32 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 772074 346 10:55:32 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 772074 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 347 10:55:32 SQL Execute: ORACLE - select SF_ZS_GETYZTSXX(772074) TSXX00 from dual 348 10:55:32 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=772074 and ZDLB00='2' 349 10:55:32 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,SLBMBH from VW_ZS_YFBMBH where SLBMBH= 483 order by PXXH00 350 10:55:32 SQL Execute: ORACLE - select LJID00,ZRZCID from LJ_ZRZC00 a where ZYID00=772074 and nvl(JSRQ00,' ')=' ' 351 10:55:32 SQL Execute: ORACLE - select RCID00,BRZXJD from LJ_JDZXQK where ZYID00=772074 and ZRZCID=874 and ZXJSRQ>='20160812' and DQJDBZ='1' order by ZXKSRQ 352 10:55:32 SQL Execute: ORACLE - select RCID00,BRZXJD from LJ_JDZXQK where ZYID00=772074 and ZRZCID=874 and DQJDBZ='1' order by ZXKSRQ Desc 353 10:55:32 SQL Execute: ORACLE - select nvl(max(ZXJSRQ),to_char(sysdate+1,'YYYYMMDD')) from LJ_ZRZC00 a,LJ_JDZXQK b where a.ZRZCID=b.ZRZCID and nvl(a.JSRQ00,' ')=' ' and a.ZYID00= 772074 354 10:55:34 SQL Execute: ORACLE - select ZRZCID,LJID00 from LJ_ZRZC00 where JSRQ00 is null and ZYID00=772074 355 10:55:34 SQL Execute: ORACLE - select SF_ZS_LJ_CHECKNEXTJD(772074,874,52) ZDZXJD from dual 356 10:55:34 SQL Data In: ORACLE - Param = 1, Name = AD_ZRZCID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 874.000000 357 10:55:34 SQL Data In: ORACLE - Param = 2, Name = AS_AUTOBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 358 10:55:34 SQL Data In: ORACLE - Param = 3, Name = AS_TZYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 359 10:55:34 SQL Data In: ORACLE - Param = 4, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 360 10:55:34 SQL Data In: ORACLE - Param = 5, Name = as_DQJDMC, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 361 10:55:34 SQL Execute: ORACLE - BEGIN "SP_ZS_LJ_SETLJDQJD" (AD_ZRZCID => :AD_ZRZCID,AS_AUTOBZ => :AS_AUTOBZ,AS_TZYY00 => :AS_TZYY00,AD_CZY000 => :AD_CZY000,as_DQJDMC => :as_DQJDMC); END; 362 10:55:34 SQL Execute: ORACLE - commit 363 10:55:34 SQL Data In: ORACLE - Rows affected = 0 364 10:55:34 SQL Execute: ORACLE - select LJID00,ZRZCID from LJ_ZRZC00 a where ZYID00=772074 and nvl(JSRQ00,' ')=' ' 365 10:55:34 SQL Execute: ORACLE - select RCID00,BRZXJD from LJ_JDZXQK where ZYID00=772074 and ZRZCID=874 and ZXJSRQ>='20160812' and DQJDBZ='1' order by ZXKSRQ 366 10:55:34 SQL Execute: ORACLE - select RCID00,BRZXJD from LJ_JDZXQK where ZYID00=772074 and ZRZCID=874 and DQJDBZ='1' order by ZXKSRQ Desc 367 10:55:35 SQL Execute: ORACLE - select count(*) cou from BQ_BRZDXX a where ZDLB00='2' and ZYID00=772074 368 10:55:35 SQL Execute: ORACLE - select YPLBBH,YFBMBH from XT_YPFWFX where SLBMBH =483 and MRBZ00 = 'Y' 369 10:55:35 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 772074 370 10:55:35 SQL Execute: ORACLE - select NAME00,to_char(sysdate,'YYYY.MM.DD')TODAY,to_char(sysdate,'HH24:MI') NOWTIME,VALUE0 from XT_XTCS00 where NAME00 in ('BQ_FYYZMRQYSJ','BQ_PTYZMRQYSJ','ZS_YZ_DQSJWYZQYSJ') order by NAME00 371 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 372 10:55:37 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,ZFBL00,BZ0000,NBLBMC,NBZFBL,LBBH00,YPXZ00,YPSYSM,COLOUR from VW_BQ_YBYP00 where (PYSM00 Like ?) and( YBZXLB = '1' and YBBRLB = '3' and (((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=483 and YPLBBH='0')) )and LBBH00 = '0') or ((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=483 and YPLBBH='1'))) and LBBH00 = '1')) and ( (exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00 and BZ0000='消化病区')) or (not exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00)) ) ) Order By PYSM00) where Rownum<=35 373 10:55:39 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'Z') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',661,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '661') AND (INSTR (',' || a.jsksbh || ',',',661,') > 0 or a.jsksbh is null) 374 10:55:40 SQL Execute: ORACLE - select * from VW_BQ_YFYPSC where YPNM00 = 3554 and (((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=483 and YPLBBH='0')) ) and LBBH00 = '0') or ((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=483 and YPLBBH='1'))) and LBBH00 = '1')) 375 10:55:40 SQL Execute: ORACLE - select HZBZ00 from BQ_YFLB00 where YFLBID=2 376 10:55:40 SQL Execute: ORACLE - select NDJCTS from BM_YD0000 where YPNM00=3554 377 10:55:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 378 10:55:41 SQL Execute: ORACLE - Select * from (select PCMC00,SM0000,PCID00,ZQCS00,ZQCD00,ZQDW00,CLBZ00 from VW_BM_PC0000 where (PYSM00 Like ?) and( (CLBZ00='0' or CLBZ00='2') ) Order By order0,PYSM00) where Rownum<=35 379 10:55:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 380 10:55:43 SQL Execute: ORACLE - Select * from (select YFSMMC,WBSM00,PYSM00 from BM_YPYFSM where (PYSM00 Like ?) Order By PYSM00) where Rownum<=35 381 10:55:45 SQL Execute: ORACLE - select count(*) cou from BQ_BRZDXX a where ZDLB00='2' and ZYID00=772074 382 10:55:45 SQL Execute: ORACLE - select to_char(sysdate,'YYYY.MM.DD') date2 from DUAL 383 10:55:45 SQL Execute: ORACLE - select count(*) COU from VW_BM_PC0000 where (CLBZ00='0' or CLBZ00='2') and PCID00=2 384 10:55:45 SQL Execute: ORACLE - select SF_ZS_CHECKYZYRKC(3554,497,483,1) from dual 385 10:55:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772074 386 10:55:45 SQL Execute: ORACLE - select count(*) count from bm_yd0000 where ypnm00 in (select distinct b.ypnm00 from bq_ypyz00 a,bq_ypyzmx b where a.yzid00=b.yzid00 and a.zyid00=? and YZZT00<>'4') and kssjb0>0 387 10:55:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 267785 388 10:55:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772074 389 10:55:45 SQL Execute: ORACLE - select DECODE(JLFL00,'3','Y'||DM0000,DM0000) DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00 in ('1','2','3') and SFYX00='Y' 390 10:55:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772074 391 10:55:45 SQL Execute: ORACLE - select trim(ZDM000) ICD900,ZDMC00,ZDLB00 from bq_brzdxx a where a.zyid00=? 392 10:55:45 SQL Execute: ORACLE - select SF_YS_getJYJGStr(772074) JYXML0 from dual 393 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17286018 394 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17286020 395 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17286022 396 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17286025 397 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17286028 398 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17286031 399 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17281638 400 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17281640 401 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17281642 402 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17281644 403 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17286005 404 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17286008 405 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17286010 406 10:55:45 SQL Execute: ORACLE - SELECT a.YZID00,decode(A.CLBZ00,'0','长嘱','临嘱') CLBZ00,B.YPNM00,B.YPMC00,B.MCSL00, B.JLDW00, to_char(to_date(QYrq00,'YYYY-MM-DD')+decode(a.srcs00,0,1,0),'YYYY-MM-DD')||' '||QYSJ00 QYRQ00, to_char(to_date(TZRQ00,'YYYY-MM-DD'),'YYYY-MM-DD')||' '||TZSJ00 TZRQ00, to_char(sysdate,'YYYY-MM-DD') JSRQ00, A.PCID00,A.PCMC00,A.YPYFMC ,A.YFID00, (select ROUND(24*ZQCS00/(ZQCD00*HSZQCD)) CS0000 FROM BM_PC0000 WHERE PCID00=A.PCID00 and rownum=1) CS0000,B.YZMXID,B.PSMC00,b.YPGG00,b.LYL000,a.YYZF00,b.Z2J000,b.ZYFYDW, (select c.LSDJ00/(d.K2J000*d.NSBL00)*b.Z2J000 from YF_YPKCXX c,BM_YD0000 d where d.YPNM00=b.YPNM00 and c.YPNM00=d.YPNM00 and c.SJKCSL>0 and ZTBZ00='0' and rownum=1 ) LSDJ00 FROM VW_BQ_YPYZXG A, BQ_YPYZMX B WHERE A.YZID00=B.YZID00 AND B.YZID00=17286013 407 10:55:46 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 408 10:55:46 SQL Data In: ORACLE - Param = 2, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 409 10:55:46 SQL Data In: ORACLE - Param = 3, Name = P_ZYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 772074 410 10:55:46 SQL Data In: ORACLE - Param = 4, Name = P_YEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 411 10:55:46 SQL Data In: ORACLE - Param = 5, Name = P_YPLBBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 412 10:55:46 SQL Data In: ORACLE - Param = 6, Name = P_DMBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 413 10:55:46 SQL Data In: ORACLE - Param = 7, Name = P_CLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 414 10:55:46 SQL Data In: ORACLE - Param = 8, Name = P_PXSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:55:41 415 10:55:46 SQL Data In: ORACLE - Param = 9, Name = P_KZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 416 10:55:46 SQL Data In: ORACLE - Param = 10, Name = P_LRRXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 易联众ss 417 10:55:46 SQL Data In: ORACLE - Param = 11, Name = P_QYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160812 418 10:55:46 SQL Data In: ORACLE - Param = 12, Name = P_QYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:55:00 419 10:55:46 SQL Data In: ORACLE - Param = 13, Name = P_ZQS000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 420 10:55:46 SQL Data In: ORACLE - Param = 14, Name = P_ZQCYTS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 421 10:55:46 SQL Data In: ORACLE - Param = 15, Name = P_JYCS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 422 10:55:46 SQL Data In: ORACLE - Param = 16, Name = P_PCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 423 10:55:46 SQL Data In: ORACLE - Param = 17, Name = P_YFID00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 005 424 10:55:46 SQL Data In: ORACLE - Param = 18, Name = P_YYZF00, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 10~15 d/分钟 425 10:55:46 SQL Data In: ORACLE - Param = 19, Name = P_BZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 426 10:55:46 SQL Data In: ORACLE - Param = 20, Name = P_BZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 427 10:55:46 SQL Data In: ORACLE - Param = 21, Name = p_TSYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 428 10:55:46 SQL Data In: ORACLE - Param = 22, Name = P_SRCS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 429 10:55:46 SQL Data In: ORACLE - Param = 23, Name = p_DYCJSL, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 430 10:55:46 SQL Data In: ORACLE - Param = 24, Name = p_DYCJQL, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 431 10:55:46 SQL Data In: ORACLE - Param = 25, Name = p_DECJSL, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 432 10:55:46 SQL Data In: ORACLE - Param = 26, Name = p_DECJQL, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 433 10:55:46 SQL Data In: ORACLE - Param = 27, Name = p_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 434 10:55:46 SQL Execute: ORACLE - BEGIN "SP_ZS_YPYZ00" (P_MODE00 => :P_MODE00,P_YZID00 => :P_YZID00,P_ZYID00 => :P_ZYID00,P_YEXM00 => :P_YEXM00,P_YPLBBH => :P_YPLBBH,P_DMBZ00 => :P_DMBZ00,P_CLBZ00 => :P_CLBZ00,P_PXSJ00 => :P_PXSJ00,P_KZYS00 => :P_KZYS00,P_LRRXM0 => :P_LRRXM0,P_QYRQ00 => :P_QYRQ00,P_QYSJ00 => :P_QYSJ00,P_ZQS000 => :P_ZQS000,P_ZQCYTS => :P_ZQCYTS,P_JYCS00 => :P_JYCS00,P_PCID00 => :P_PCID00,P_YFID00 => :P_YFID00,P_YYZF00 => :P_YYZF00,P_BZID00 => :P_BZID00,P_BZ0000 => :P_BZ0000,p_TSYS00 => :p_TSYS00,P_SRCS00 => :P_SRCS00,p_DYCJSL => :p_DYCJSL,p_DYCJQL => :p_DYCJQL,p_DECJSL => :p_DECJSL,p_DECJQL => :p_DECJQL,p_YFBMBH => :p_YFBMBH); END; 435 10:55:46 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 436 10:55:46 SQL Data In: ORACLE - Param = 2, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17287323.000000 437 10:55:46 SQL Data In: ORACLE - Param = 3, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 438 10:55:46 SQL Data In: ORACLE - Param = 4, Name = P_YPNM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3554.000000 439 10:55:46 SQL Data In: ORACLE - Param = 5, Name = P_YPMC00, Type = fldZSTRING, Precision = 27, Scale = 0, Data = 0.9%氯化钠注射液(玻璃.丁基) 440 10:55:46 SQL Data In: ORACLE - Param = 6, Name = P_SFDZGG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 441 10:55:46 SQL Data In: ORACLE - Param = 7, Name = P_PSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 442 10:55:46 SQL Data In: ORACLE - Param = 8, Name = P_MCSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 500.000000 443 10:55:46 SQL Data In: ORACLE - Param = 9, Name = P_LYL000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 444 10:55:46 SQL Data In: ORACLE - Param = 10, Name = P_XMYFMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 445 10:55:46 SQL Data In: ORACLE - Param = 11, Name = P_TQFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 446 10:55:46 SQL Data In: ORACLE - Param = 12, Name = P_YZCLLB, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 正常 447 10:55:46 SQL Data In: ORACLE - Param = 13, Name = P_BZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 448 10:55:46 SQL Data In: ORACLE - Param = 14, Name = P_ZQCYTS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 449 10:55:46 SQL Data In: ORACLE - Param = 15, Name = P_PCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 450 10:55:46 SQL Data In: ORACLE - Param = 16, Name = P_YPLBBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 451 10:55:46 SQL Data In: ORACLE - Param = 17, Name = P_CLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 452 10:55:46 SQL Data In: ORACLE - Param = 18, Name = P_ZQS000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 453 10:55:46 SQL Data In: ORACLE - Param = 19, Name = P_LJID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 52.000000 454 10:55:46 SQL Data In: ORACLE - Param = 20, Name = P_RCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 455 10:55:46 SQL Data In: ORACLE - Param = 21, Name = P_ZXJDID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 456 10:55:46 SQL Data In: ORACLE - Param = 22, Name = p_YJYYLB, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 457 10:55:46 SQL Data In: ORACLE - Param = 23, Name = p_YJYYLY, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 458 10:55:46 SQL Data In: ORACLE - Param = 24, Name = p_KSSYF0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 459 10:55:46 SQL Data In: ORACLE - Param = 25, Name = p_QKLX00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 460 10:55:46 SQL Data In: ORACLE - Param = 26, Name = p_SSDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 461 10:55:46 SQL Data In: ORACLE - Param = 27, Name = P_ZFFSBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 462 10:55:46 SQL Execute: ORACLE - BEGIN "SP_BQ_YPYZMX" (P_MODE00 => :P_MODE00,P_YZID00 => :P_YZID00,P_YZMXID => :P_YZMXID,P_YPNM00 => :P_YPNM00,P_YPMC00 => :P_YPMC00,P_SFDZGG => :P_SFDZGG,P_PSID00 => :P_PSID00,P_MCSL00 => :P_MCSL00,P_LYL000 => :P_LYL000,P_XMYFMC => :P_XMYFMC,P_TQFS00 => :P_TQFS00,P_YZCLLB => :P_YZCLLB,P_BZ0000 => :P_BZ0000,P_ZQCYTS => :P_ZQCYTS,P_PCID00 => :P_PCID00,P_YPLBBH => :P_YPLBBH,P_CLBZ00 => :P_CLBZ00,P_ZQS000 => :P_ZQS000,P_LJID00 => :P_LJID00,P_RCID00 => :P_RCID00,P_ZXJDID => :P_ZXJDID,p_YJYYLB => :p_YJYYLB,p_YJYYLY => :p_YJYYLY,p_KSSYF0 => :p_KSSYF0,p_QKLX00 => :p_QKLX00,p_SSDH00 => :p_SSDH00,P_ZFFSBZ => :P_ZFFSBZ); END; 463 10:55:46 SQL Error: ORACLE - ORA-20004: ORA-20002: ORA-01403: 未找到任何数据！* ORA-06512: 在 "SD_HOSPITAL.TR_BQ_YPYZMX_FORCP", line 232 ORA-04088: 触发器 'SD_HOSPITAL.TR_BQ_YPYZMX_FORCP' 执行过程中出错!* ORA-06512: 在 "SD_HOSPITAL.SP_BQ_YPYZMX", line 289 ORA-06512: 在 line 1 464 10:55:46 SQL Error: ORACLE - Unmapped SQL Error Code: 20004 465 10:55:46 SQL Execute: ORACLE - RollBack 466 10:55:46 SQL Data In: ORACLE - Rows affected = 0 467 10:55:49 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'Z') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',661,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '661') AND (INSTR (',' || a.jsksbh || ',',',661,') > 0 or a.jsksbh is null) 468 10:55:59 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'Z') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',661,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '661') AND (INSTR (',' || a.jsksbh || ',',',661,') > 0 or a.jsksbh is null) 469 10:56:09 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'Z') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',661,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '661') AND (INSTR (',' || a.jsksbh || ',',',661,') > 0 or a.jsksbh is null) 470 10:56:19 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'Z') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',661,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '661') AND (INSTR (',' || a.jsksbh || ',',',661,') > 0 or a.jsksbh is null)