1 10:26:25 Log started for: Sickberth 2 10:26:25 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 10:26:25 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.0.222','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20120518','10:26:27','scott@2029:0229F2EB8386D6735C11EE682604B12F' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 10:26:25 SQL Data In: ORACLE - Rows affected = 1 5 10:26:25 SQL Execute: ORACLE - Commit 6 10:26:25 SQL Data In: ORACLE - Rows affected = 0 7 10:26:25 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 10:26:25 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222147' 9 10:26:25 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='2029' and CZBZ00 in ('1') 10 10:26:25 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.0.222','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20120518','10:26:27','sd_hospital@2029:1CA24368F014C47C5A3A3A399F2BDEC9' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 11 10:26:25 SQL Data In: ORACLE - Rows affected = 1 12 10:26:25 SQL Execute: ORACLE - Commit 13 10:26:25 SQL Data In: ORACLE - Rows affected = 0 14 10:26:25 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 15 10:26:25 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2029' and CZBZ00 in ('1') 16 10:26:25 SQL Execute: ORACLE - Select SYSDATE from Dual 17 10:26:25 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 18 10:26:25 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 19 10:26:25 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 20 10:26:25 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 21 10:26:25 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 22 10:26:25 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='2029')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='2029')) order by b.PLXH00,a.BH0000 23 10:26:25 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '2029'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='2029')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='2029') 24 10:26:25 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=282 25 10:26:25 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 26 10:26:25 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 27 10:26:25 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 28 10:26:25 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 29 10:26:25 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 10:26:25 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2143075,282,'20120331-1308','9',nvl('218984',' '),'192.168.0.2-192.168.0.222#78:847@SickBerth.exe+病区护理系统',56) 31 10:26:25 SQL Data In: ORACLE - Rows affected = 1 32 10:26:25 SQL Execute: ORACLE - Commit 33 10:26:25 SQL Data In: ORACLE - Rows affected = 0 34 10:26:25 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 56 35 10:26:25 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222147' 36 10:26:25 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 37 10:26:25 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.222' 38 10:26:25 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 39 10:26:25 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 56 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 40 10:26:25 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222147') 41 10:26:25 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 42 10:26:27 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='282' and name00='SYSTEMSKIN' 43 10:26:27 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 44 10:26:27 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='9') and YXQ000>='20120518' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',56,' )>0 ) 45 10:26:27 SQL Execute: ORACLE - select distinct a.CZYKS0,b.BMMC00 from vw_bm_SystemMessage a,BM_BMBM00 b where a.CZYKS0=b.BMBH00 and (XTDM00='-1' or XTDM00='9') and (JSKSBH is null or instr( ','||JSKSBH||',' , ',56,' )>0 ) 46 10:26:27 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='消息系统字体颜色配置' 47 10:26:27 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 = 'XTXXSFJXPX' 48 10:26:27 SQL Execute: ORACLE - select * from vw_bm_SystemMessage where (XTDM00='-1' or XTDM00='9') and YXQ000>='20120518' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',56,' )>0 ) order by XH0000 49 10:26:29 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 50 10:26:29 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 51 10:26:30 SQL Execute: ORACLE - select sysdate from dual 52 10:26:30 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='9' and (( 282= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=282 and XTDM00='9'))) 53 10:26:30 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||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 54 10:26: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 ((282= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=282 and XTDM00='0 '))) 55 10:26:30 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 56 10:26:30 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 282= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=282 and XTDM00='+ '))) 57 10:26:30 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 58 10:26:30 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 59 10:26:30 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 60 10:26:30 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 61 10:26:30 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 62 10:26:30 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_XZSSSQSFYXKBQ','BQ_KFWYYSFAPCDY','BQ_ZQCYJH') 63 10:26:30 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_HLJLDSFSYFR3DY','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_SFSYXXCSGN','BQ_CWXMSFTSBLSQNJWF','BQ_DYCKDSFQDYJZY','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_YZCXSJSFMRYT','BQ_TSYPYZDY_ZDY','BQ_SFSYPASSXT','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_SERVERDIRCP','YJ_JSXMSFXZ','BQ_YZZXDDYSFQB','BQ_CQYZZJSSFTXYPSL') 64 10:26:30 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet') and YGBH00 = 282 65 10:26:30 SQL Execute: ORACLE - select sysdate nowtime from dual 66 10:26:30 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 67 10:26:30 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 68 10:26:30 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 69 10:26:30 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 70 10:26:30 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=282 71 10:26:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 72 10:26:30 SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00,DQLJID,YJJZE0,YBZFJE, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000 order by b.cwxh00,RYCWH0 73 10:26:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 74 10:26:31 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 75 10:26:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 76 10:26:32 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 77 10:26:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 78 10:26:33 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 79 10:26:33 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19750425) AS NL FROM DUAL 80 10:26:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 81 10:26:33 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 82 10:26:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 83 10:26:33 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 84 10:26:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 85 10:26:34 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 86 10:26:35 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 87 10:26:35 SQL Execute: ORACLE - Select To_date('2012.05.1800:00:00','YYYY.MM.DDHH24:MI:SS') from dual 88 10:26:35 SQL Execute: ORACLE - select yflbid,yflbmc from BQ_YFLB00 89 10:26:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 90 10:26:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 0:0:0:0 91 10:26:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 92 10:26:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 93 10:26:35 SQL Data In: ORACLE - Param = 5, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 94 10:26:35 SQL Data In: ORACLE - Param = 6, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 95 10:26:35 SQL Execute: ORACLE - SELECT DISTINCT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YZZXJL_XYZX W WHERE DQBQ00=? and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.QSRQ00<=TO_CHAR((?),'YYYYMMDD') UNION SELECT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YJYZ00_WTZ W WHERE DQBQ00=? and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.YZLB00<>1 AND (W.CJKS00 is null or W.CJKS00=?) AND ( (YZZT00='1' AND (?)>=QSRQSJ) OR(YZZT00='2' AND (?)>TQRQSJ ) ) ORDER BY RYCWH0 96 10:26:35 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 97 10:26:35 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 018189 98 10:26:35 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 99 10:26:35 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 100 10:26:35 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 101 10:26:35 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 102 10:26:35 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 103 10:26:35 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 104 10:26:35 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 105 10:26:35 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 106 10:26:35 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 107 10:26:35 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 108 10:26:35 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 109 10:26:35 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 110 10:26:35 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 111 10:26:35 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 112 10:26:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 113 10:26:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 0:0:0:0 114 10:26:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 115 10:26:35 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=? AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((?),'YYYYMMDD') AND ZYID00=? ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托') order by tqrqsj,clbz00,lbmc00,yzid00 116 10:26:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 117 10:26:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 118 10:26:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 119 10:26:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 120 10:26:35 SQL Execute: ORACLE - SELECT DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,a.PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID,nvl((select sum(jjje00)*a.mcsl00*decode(a.ts0000,null,1,0,1,a.ts0000)*c.zqcs00 from bq_yjyzjj where yzmxid=a.yzmxid),0) JE0000 FROM VW_BQ_YJYZ00_WTZ a,bm_pc0000 c WHERE ZYID00=? AND YZLB00<>1 and ( (YZZT00='1' AND (?)-QSRQSJ>=0) OR(YZZT00='2' AND (?)-TQRQSJ>0) ) and (CJKS00 is null or CJKS00=?) and decode(a.pcid00,0,1,a.pcid00)=c.pcid00 order by tqrqsj,clbz00,lbmc00,yzmxid 121 10:26:35 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 122 10:26:35 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 018189 123 10:26:35 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 124 10:26:35 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 125 10:26:35 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 126 10:26:35 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 127 10:26:35 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 128 10:26:35 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 129 10:26:35 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 130 10:26:35 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 131 10:26:35 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 132 10:26:35 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 133 10:26:35 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 134 10:26:35 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 135 10:26:35 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 136 10:26:35 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 137 10:26:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 138 10:26:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 0:0:0:0 139 10:26:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 140 10:26:35 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=? AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((?),'YYYYMMDD') AND ZYID00=? ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托') order by tqrqsj,clbz00,lbmc00,yzid00 141 10:26:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 142 10:26:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 143 10:26:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 144 10:26:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 145 10:26:35 SQL Execute: ORACLE - SELECT DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,a.PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID,nvl((select sum(jjje00)*a.mcsl00*decode(a.ts0000,null,1,0,1,a.ts0000)*c.zqcs00 from bq_yjyzjj where yzmxid=a.yzmxid),0) JE0000 FROM VW_BQ_YJYZ00_WTZ a,bm_pc0000 c WHERE ZYID00=? AND YZLB00<>1 and ( (YZZT00='1' AND (?)-QSRQSJ>=0) OR(YZZT00='2' AND (?)-TQRQSJ>0) ) and (CJKS00 is null or CJKS00=?) and decode(a.pcid00,0,1,a.pcid00)=c.pcid00 order by tqrqsj,clbz00,lbmc00,yzmxid 146 10:26:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 147 10:26:35 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 148 10:26:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 149 10:26:36 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 150 10:26:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 151 10:26:37 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 152 10:26:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 153 10:26:38 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 154 10:26:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 155 10:26:39 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 156 10:26:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 157 10:26:40 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 158 10:26:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 159 10:26:41 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 160 10:26:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 161 10:26:42 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 162 10:26:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 163 10:26:43 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 164 10:26:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 165 10:26:44 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 166 10:26:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 167 10:26:45 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 168 10:26:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 169 10:26:46 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 170 10:26:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 171 10:26:47 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 172 10:26:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 173 10:26:48 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 174 10:26:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 175 10:26:49 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 176 10:26:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 177 10:26:50 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 178 10:26:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 179 10:26:51 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 180 10:26:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 181 10:26:52 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 182 10:26:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 183 10:26:53 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 184 10:26:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 185 10:26:54 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 186 10:26:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 187 10:26:55 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 188 10:26:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 189 10:26:56 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 190 10:26:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 191 10:26:57 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 192 10:26:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 193 10:26:58 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 194 10:26:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 195 10:26:59 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 196 10:27:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 197 10:27:00 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 198 10:27:01 SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 282.000000 199 10:27:01 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 200 10:27:01 SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 201 10:27:01 SQL Data In: ORACLE - Param = 4, Name = PCLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 202 10:27:01 SQL Data In: ORACLE - Param = 5, Name = PYFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 203 10:27:01 SQL Data In: ORACLE - Param = 6, Name = PYPLBBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 204 10:27:01 SQL Data In: ORACLE - Param = 7, Name = PZXRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/18/2012 0:0:0:0 205 10:27:01 SQL Execute: ORACLE - BEGIN "SP_BQ_YPYZZX" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PYFLBID => :PYFLBID,PYPLBBH => :PYPLBBH,PZXRQ00 => :PZXRQ00); END; 206 10:27:01 SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 282.000000 207 10:27:01 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 208 10:27:01 SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 209 10:27:01 SQL Data In: ORACLE - Param = 4, Name = PCLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 210 10:27:01 SQL Data In: ORACLE - Param = 5, Name = PLBBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 211 10:27:01 SQL Data In: ORACLE - Param = 6, Name = PZXRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/18/2012 0:0:0:0 212 10:27:01 SQL Data In: ORACLE - Param = 7, Name = PBCTQID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 213 10:27:01 SQL Data In: ORACLE - Param = 8, Name = PCJKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 214 10:27:01 SQL Execute: ORACLE - BEGIN "SP_BQ_YJYZZX_NOHL" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PLBBH00 => :PLBBH00,PZXRQ00 => :PZXRQ00,PBCTQID => :PBCTQID,PCJKS00 => :PCJKS00); END; 215 10:27:02 SQL Error: ORACLE - ORA-20002: ORA-20020: ORA-20001: 数据没有找到！*ORA-01403: 未找到任何数据 ORA-01403: 未找到任何数据 ORA-06512: 在 "SD_HOSPITAL.TR_WZ_ZY_FYMX00_INS", line 134 ORA ORA-06512: 在 "SD_HOSPITAL.SP_BQ_YJYZZX_NOHL", line 162 ORA-06512: 在 line 1 216 10:27:02 SQL Error: ORACLE - Unmapped SQL Error Code: 20002 217 10:27:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 218 10:27:02 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 219 10:27:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 220 10:27:02 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 221 10:27:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 222 10:27:03 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 223 10:27:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 224 10:27:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 0:0:0:0 225 10:27:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 226 10:27:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 227 10:27:04 SQL Data In: ORACLE - Param = 5, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 228 10:27:04 SQL Data In: ORACLE - Param = 6, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 229 10:27:04 SQL Execute: ORACLE - SELECT DISTINCT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YZZXJL_XYZX W WHERE DQBQ00=? and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.QSRQ00<=TO_CHAR((?),'YYYYMMDD') UNION SELECT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YJYZ00_WTZ W WHERE DQBQ00=? and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.YZLB00<>1 AND (W.CJKS00 is null or W.CJKS00=?) AND ( (YZZT00='1' AND (?)>=QSRQSJ) OR(YZZT00='2' AND (?)>TQRQSJ ) ) ORDER BY RYCWH0 230 10:27:04 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 231 10:27:04 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 018189 232 10:27:04 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 233 10:27:04 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 234 10:27:04 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 235 10:27:04 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 236 10:27:04 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 237 10:27:04 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 238 10:27:04 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 239 10:27:04 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 240 10:27:04 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 241 10:27:04 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 242 10:27:04 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 243 10:27:04 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 244 10:27:04 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 245 10:27:04 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 246 10:27:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 247 10:27:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 0:0:0:0 248 10:27:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 249 10:27:04 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=? AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((?),'YYYYMMDD') AND ZYID00=? ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托') order by tqrqsj,clbz00,lbmc00,yzid00 250 10:27:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 251 10:27:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 252 10:27:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 253 10:27:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 254 10:27:04 SQL Execute: ORACLE - SELECT DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,a.PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID,nvl((select sum(jjje00)*a.mcsl00*decode(a.ts0000,null,1,0,1,a.ts0000)*c.zqcs00 from bq_yjyzjj where yzmxid=a.yzmxid),0) JE0000 FROM VW_BQ_YJYZ00_WTZ a,bm_pc0000 c WHERE ZYID00=? AND YZLB00<>1 and ( (YZZT00='1' AND (?)-QSRQSJ>=0) OR(YZZT00='2' AND (?)-TQRQSJ>0) ) and (CJKS00 is null or CJKS00=?) and decode(a.pcid00,0,1,a.pcid00)=c.pcid00 order by tqrqsj,clbz00,lbmc00,yzmxid 255 10:27:04 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 256 10:27:04 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 018189 257 10:27:04 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 258 10:27:04 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 259 10:27:04 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 260 10:27:04 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 261 10:27:04 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 262 10:27:04 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 263 10:27:04 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 264 10:27:04 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 265 10:27:04 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 266 10:27:04 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 267 10:27:04 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 268 10:27:04 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 269 10:27:04 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 270 10:27:04 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 271 10:27:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 272 10:27:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 0:0:0:0 273 10:27:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 274 10:27:04 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=? AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((?),'YYYYMMDD') AND ZYID00=? ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托') order by tqrqsj,clbz00,lbmc00,yzid00 275 10:27:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 390118.000000 276 10:27:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 277 10:27:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 23:0:0:0 278 10:27:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 279 10:27:04 SQL Execute: ORACLE - SELECT DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,a.PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID,nvl((select sum(jjje00)*a.mcsl00*decode(a.ts0000,null,1,0,1,a.ts0000)*c.zqcs00 from bq_yjyzjj where yzmxid=a.yzmxid),0) JE0000 FROM VW_BQ_YJYZ00_WTZ a,bm_pc0000 c WHERE ZYID00=? AND YZLB00<>1 and ( (YZZT00='1' AND (?)-QSRQSJ>=0) OR(YZZT00='2' AND (?)-TQRQSJ>0) ) and (CJKS00 is null or CJKS00=?) and decode(a.pcid00,0,1,a.pcid00)=c.pcid00 order by tqrqsj,clbz00,lbmc00,yzmxid 280 10:27:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 281 10:27:04 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 282 10:27:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 283 10:27:05 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 284 10:27:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 285 10:27:06 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 286 10:27:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 287 10:27:07 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 288 10:27:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 289 10:27:08 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 290 10:27:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 291 10:27:09 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 292 10:27:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 293 10:27:10 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 294 10:27:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 295 10:27:11 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 296 10:27:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 297 10:27:12 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 298 10:27:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 299 10:27:13 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 300 10:27:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 301 10:27:14 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 302 10:27:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 303 10:27:15 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 304 10:27:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 305 10:27:16 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 306 10:27:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 307 10:27:17 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 308 10:27:18 Log started for: Yjsystem 309 10:27:22 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '7' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999') 310 10:27:22 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=369 311 10:27:22 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 312 10:27:22 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 313 10:27:22 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 314 10:27:22 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 315 10:27:22 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')) 316 10:27:22 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2143076,369,'20120331-1308','7',nvl('218986',' '),'192.168.0.2-192.168.0.222#98:9214@YJsystem.exe+医技管理系统',34) 317 10:27:22 SQL Data In: ORACLE - Rows affected = 1 318 10:27:22 SQL Execute: ORACLE - Commit 319 10:27:22 SQL Data In: ORACLE - Rows affected = 0 320 10:27:22 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 34 321 10:27:22 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222147' 322 10:27:22 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 323 10:27:22 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.222' 324 10:27:22 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 325 10:27:22 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 34 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 326 10:27:22 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222147') 327 10:27:22 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 328 10:27:24 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='369' and name00='SYSTEMSKIN' 329 10:27:24 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 330 10:27:24 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='7') and YXQ000>='20120518' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',34,' )>0 ) 331 10:27:24 SQL Execute: ORACLE - select distinct a.CZYKS0,b.BMMC00 from vw_bm_SystemMessage a,BM_BMBM00 b where a.CZYKS0=b.BMBH00 and (XTDM00='-1' or XTDM00='7') and (JSKSBH is null or instr( ','||JSKSBH||',' , ',34,' )>0 ) 332 10:27:24 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='消息系统字体颜色配置' 333 10:27:24 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 = 'XTXXSFJXPX' 334 10:27:24 SQL Execute: ORACLE - select * from vw_bm_SystemMessage where (XTDM00='-1' or XTDM00='7') and YXQ000>='20120518' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',34,' )>0 ) order by XH0000 335 10:27:28 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 336 10:27:28 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 337 10:27:28 SQL Execute: ORACLE - select sysdate from dual 338 10:27:28 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='7' and (( 369= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=369 and XTDM00='7'))) 339 10:27:29 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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 340 10:27:29 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 ((369= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=369 and XTDM00='0 '))) 341 10:27:29 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 342 10:27:29 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 369= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=369 and XTDM00='+ '))) 343 10:27:29 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 344 10:27:29 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY') and YGBH00 = 369 345 10:27:29 SQL Execute: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YF_YYGXH','YJ_YXCXTS','YJ_YXCXTS2','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_SYKSFZDDY','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YF_MZCFTDHS','YJ_XMZJYSWSSKS','YJ_XSKDYGS','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','YJ_SYHDSFDY','YJ_ZJLZDYDY','YJ_XMWHCKSFKYZXXM','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY','YJ_XMAPSFAKSCX','YJ_XMAPDYZDYID','YJ_XMSQKSYSSFMRWK','YJ_SYGCDZDYDY','YJ_CFFWFXWHXZ','YJ_TXMDYSFFY','YJ_YJCXD_ZDY','XT_ZYXTGBDW','YF_MZCFSFDYXXYF','YF_CFSFDYTYM','YF_CFTDGSSFZJZD','YF_MZCFJYDJGHS','YF_MZCFSFDYYS','YF_MZCFTDDDHS','YF_CFTDSFDYFB','YF_ZYJYF_SFDM','YF_SFDYCFT','YJ_SFQYMZYDSY') 346 10:27:29 SQL Execute: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 347 10:27:29 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=369 and name00='YJ_QSBRLB' 348 10:27:29 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 349 10:27:33 SQL Execute: ORACLE - select * from bm_jyzyzb order by zyzbid 350 10:27:33 SQL Execute: ORACLE - Select distinct zlxmbh,zlxmjc from BM_ZLZD00 where lbbz00='0' and zlxmbh Like 'Z%' order by zlxmbh 351 10:27:33 SQL Execute: ORACLE - SELECT * FROM bm_bbzd00 352 10:27:33 SQL Execute: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,DLBQZX,DLKSZX,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,zhxmbz,jkbh01,a.jytzbh,jclbid,a.SQDID0,a.SFCSSX from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like '%' and Zlxmid>=100 order by zlxmbh 353 10:27:33 SQL Execute: ORACLE - SELECT * FROM BM_BMBM00 WHERE flag00='1' and czbz00 in ('0','1') and bmxz00 in ('0','1','5') order by bmmc00 354 10:27:33 SQL Execute: ORACLE - select * from BM_JCLB00 order by JCLBID 355 10:27:33 SQL Execute: ORACLE - SELECT * FROM YS_SQDGS0 WHERE SYBZ00='Y' order by SQDID0 356 10:28:28 SQL Execute: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,a.zhxmbz,a.jkbh01,a.jytzbh, lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,dlkszx,dlbqzx,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,jclbid, A.SQDID0,a.SFCSSX from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like '%' and Zlxmid>=100 order by zlxmbh 357 10:28:39 SQL Execute: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,DLBQZX,DLKSZX,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,zhxmbz,jkbh01,a.jytzbh,jclbid,a.SQDID0,a.SFCSSX from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like 'Z005001%' and Zlxmid>=100 order by zlxmbh 358 10:28:42 SQL Execute: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,DLBQZX,DLKSZX,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,zhxmbz,jkbh01,a.jytzbh,jclbid,a.SQDID0,a.SFCSSX from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like 'Z005002%' and Zlxmid>=100 order by zlxmbh 359 10:28:54 SQL Execute: ORACLE - Select zlxmjc,zlxmbh,lbbz00,zlxmid from VW_BM_YXZLZD WHERE LENGTH(ZLXMBH)<=10 order by zlxmbh 360 10:29:04 SQL Execute: ORACLE - Select gxid00,a.zlxmid,a.sfxmid,xmmc00,gdbz00,BQSFBZ,a.bz0000,FJFYBZ,sfcs00,mxxmid,NVL(a.TCJE00,C.SFJE00) TCJE00, c.SFJE00,A.GJBM00,a.TYBZ00,a.SFLB00,a.mzzybz from XT_ZLSFGX a,VW_BM_YXZLZD B,BM_YYSFXM C where a.zlxmid=b.zlxmid and a.sfxmid=c.sfxmid and zlxmbh='Z005002003' order by xmmc00 361 10:29:04 SQL Execute: ORACLE - select distinct a.mxxmid,b.zlxmjc from xt_zlsfgx a,bm_zlzd00 b where a.zlxmid=5283 and a.mxxmid=b.zlxmid 362 10:29:06 SQL Execute: ORACLE - Select gxid00,a.zlxmid,a.sfxmid,xmmc00,gdbz00,BQSFBZ,a.bz0000,FJFYBZ,sfcs00,mxxmid,NVL(a.TCJE00,C.SFJE00) TCJE00, c.SFJE00,A.GJBM00,a.TYBZ00,a.SFLB00,a.mzzybz from XT_ZLSFGX a,VW_BM_YXZLZD B,BM_YYSFXM C where a.zlxmid=b.zlxmid and a.sfxmid=c.sfxmid and zlxmbh='Z005002004' order by xmmc00 363 10:29:06 SQL Execute: ORACLE - select distinct a.mxxmid,b.zlxmjc from xt_zlsfgx a,bm_zlzd00 b where a.zlxmid=5284 and a.mxxmid=b.zlxmid 364 10:32:18 Log started for: Sickberth 365 10:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 366 10:32:18 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 367 10:32:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 368 10:32:19 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 369 10:32:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 370 10:32:20 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 371 10:32:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 372 10:32:21 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 373 10:32:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 374 10:32:22 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 375 10:32:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 376 10:32:23 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 377 10:32:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 378 10:32:24 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 379 10:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 380 10:32:26 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 381 10:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 382 10:32:26 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 383 10:32:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 384 10:32:27 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 385 10:32:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 386 10:32:28 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 387 10:32:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 388 10:32:29 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 389 10:32:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 390 10:32:30 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 391 10:32:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 392 10:32:31 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 393 10:32:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 394 10:32:32 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 395 10:32:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 396 10:32:33 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 397 10:32:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 398 10:32:34 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 399 10:32:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 400 10:32:35 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 401 10:32:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 402 10:32:36 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 403 10:32:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 404 10:32:37 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 405 10:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 406 10:32:38 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 407 10:32:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 408 10:32:39 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 409 10:32:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 410 10:32:40 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 411 10:32:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 412 10:32:41 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 413 10:32:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 414 10:32:42 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 415 10:32:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 416 10:32:43 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 417 10:32:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 418 10:32:44 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 419 10:32:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 420 10:32:45 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 421 10:32:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 422 10:32:46 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 423 10:32:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 424 10:32:47 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 425 10:32:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 426 10:32:48 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 427 10:32:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 428 10:32:49 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 429 10:32:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 430 10:32:50 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 431 10:32:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 432 10:32:51 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 433 10:32:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 434 10:32:52 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 435 10:32:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 436 10:32:53 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 437 10:32:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 438 10:32:54 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 439 10:32:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 440 10:32:55 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 441 10:32:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 442 10:32:56 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 443 10:32:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 444 10:32:57 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 445 10:32:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 446 10:32:58 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 447 10:32:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 448 10:32:59 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 449 10:33:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 450 10:33:00 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 451 10:33:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 452 10:33:01 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 453 10:33:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 454 10:33:02 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 455 10:33:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 456 10:33:03 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 457 10:33:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 458 10:33:04 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 459 10:33:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 460 10:33:05 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 461 10:33:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 462 10:33:06 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 463 10:33:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 464 10:33:07 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 465 10:33:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 466 10:33:08 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 467 10:33:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 468 10:33:09 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 469 10:33:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 470 10:33:10 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 471 10:33:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 472 10:33:11 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 473 10:33:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 474 10:33:12 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 475 10:33:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 476 10:33:13 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 477 10:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 478 10:33:14 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 479 10:33:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 480 10:33:15 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 481 10:33:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 482 10:33:16 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 483 10:33:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 484 10:33:17 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 485 10:33:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 486 10:33:18 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 487 10:33:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 488 10:33:19 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 489 10:33:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 490 10:33:20 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 491 10:33:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 492 10:33:21 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 493 10:33:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 494 10:33:22 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 495 10:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 496 10:33:23 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 497 10:33:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 498 10:33:24 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 499 10:33:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 500 10:33:25 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 501 10:33:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 502 10:33:26 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 503 10:33:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 504 10:33:27 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 505 10:33:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 506 10:33:28 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 507 10:33:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 508 10:33:29 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 509 10:33:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 510 10:33:30 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 511 10:33:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 512 10:33:31 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 513 10:33:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 514 10:33:32 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 515 10:33:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 516 10:33:33 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 517 10:33:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 518 10:33:34 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 519 10:33:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 520 10:33:35 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 521 10:33:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 522 10:33:36 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 523 10:33:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 524 10:33:37 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 525 10:33:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 526 10:33:38 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 527 10:33:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 528 10:33:39 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 529 10:33:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 530 10:33:40 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 531 10:33:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 532 10:33:41 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 533 10:33:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 534 10:33:42 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1 535 10:33:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 536 10:33:43 SQL Execute: ORACLE - select b.ZYID00 from ZY_BRJFB0 a,ZY_BRXXB0 b where JFRQ00=to_char(sysdate,'YYYYMMDD') and a.brid00=b.brid00 and b.dqbq00+0=? and b.brzt00 like '2%' and Floor((to_date(to_char(sysdate,'hh24:mi:ss'),'hh24:mi:ss')-to_date(JFSJ00,'hh24:mi:ss'))*24*60*60)<=1