1 07:58:16 Log started for: ÃÅÕïÒ½Éú¹¤×÷Õ¾·Öϵͳ 2 07:58:16 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 07:58:16 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','8','appYS_YSGZZ.exe'||'+'||'ÃÅÕïÒ½Éú¹¤×÷Õ¾·Öϵͳ','199','12126' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:CB99DFF7787F4059E70A7B68AD2C97D6' from dual 4 07:58:16 SQL Data In: ORACLE - Rows affected = 1 5 07:58:16 SQL Execute: ORACLE - Commit 6 07:58:16 SQL Data In: ORACLE - Rows affected = 0 7 07:58:16 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 07:58:16 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 9 07:58:16 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 10 07:58:16 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 07:58:16 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','8','appYS_YSGZZ.exe'||'+'||'ÃÅÕïÒ½Éú¹¤×÷Õ¾·Öϵͳ','194','5196' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:5A903F71852CD02AC8E9F0B697C1754E' from dual 12 07:58:16 SQL Data In: ORACLE - Rows affected = 1 13 07:58:16 SQL Execute: ORACLE - Commit 14 07:58:16 SQL Data In: ORACLE - Rows affected = 0 15 07:58:16 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 16 07:58:16 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 17 07:58:16 SQL Execute: ORACLE - Select SYSDATE from Dual 18 07:58:16 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 19 07:58:16 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 20 07:58:16 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 21 07:58:16 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 22 07:58:16 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 23 07:58:16 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','5','9','c') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 24 07:58:16 SQL Execute: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 25 07:58:16 SQL Execute: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') and rownum=1 26 07:58:18 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 27 07:58:18 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114 28 07:58:18 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 29 07:58:18 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 30 07:58:18 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 31 07:58:18 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 32 07:58:18 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')) 33 07:58:19 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4614604,1114,'wlzx-3','8',nvl('231333617',' '),'192.168.5.33#194:5196@appYS_YSGZZ.exe+ÃÅÕïÒ½Éú¹¤×÷Õ¾·Öϵͳ',20) 34 07:58:20 SQL Data In: ORACLE - Rows affected = 1 35 07:58:20 SQL Execute: ORACLE - Commit 36 07:58:20 SQL Data In: ORACLE - Rows affected = 0 37 07:58:20 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 38 07:58:20 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 39 07:58:20 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 40 07:58:20 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 41 07:58:20 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 42 07:58:20 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 43 07:58:20 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 44 07:58:20 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 45 07:58:21 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1114' and name00='SYSTEMSKIN' 46 07:58:21 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 47 07:58:21 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20150623' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='8') 48 07:58:21 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 49 07:58:21 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 50 07:58:21 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 51 07:58:21 SQL Execute: ORACLE - select PSID00 from BM_PS0000 where PSMC00='ƤÊÔ' and YXBZ00='1' 52 07:58:21 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 53 07:58:21 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 54 07:58:21 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YS_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS','YS_YYCXZNCXBYS','YS_JCJYJGDZ') 55 07:58:21 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='¸£½¨Ê¡³¤ÀÖÊÐÐÂÅ©ºÏ¹ÜÀíÖÐÐÄ' 56 07:58:21 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='¸Î¹¦¶ÔÓ¦µÄÕï¶Ï' AND YXBZ00='1' 57 07:58:21 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='Éö¹¦¶ÔÓ¦µÄÕï¶Ï' AND YXBZ00='1' 58 07:58:21 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='ÖÇ·½Î£»úÖµÅäÖÃ' AND YXBZ00='1' and MC0000='ˢмä¸ô' 59 07:58:21 SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 60 07:58:21 SQL Execute: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='¾ÓÃñ½¡¿µµµ°¸ÌáʾµÄÏà¹Ø²ÎÊý' AND YXBZ00='1' order by XSXH00 61 07:58:21 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 1114 62 07:58:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1114 63 07:58:21 SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?) 64 07:58:21 SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%¼±%' and SFYX00='Y' 65 07:58:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 66 07:58:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1114 67 07:58:21 SQL Execute: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 68 07:58:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 69 07:58:21 SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=? 70 07:58:21 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 71 07:58:21 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='8'))) 72 07:58:21 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||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 73 07:58:21 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='0 '))) 74 07:58:21 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 75 07:58:21 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='+ '))) 76 07:58:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1114 77 07:58:22 SQL Execute: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'δÉèÖÃ') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=? and a.YSLB00=b.YSLB00(+) 78 07:58:22 SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '¼å%' and rownum=1 79 07:58:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1114 80 07:58:22 SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=? 81 07:58:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 82 07:58:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 83 07:58:22 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 84 07:58:22 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 85 07:58:22 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 86 07:58:22 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 87 07:58:22 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 88 07:58:22 SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and GZDJ00 <=? and MZDJ00 <=? and DPDJ00 <=? and KSSDJ0<=? and ((SJDJ00 >=? and ? >'0') or SJDJ00='0') and Rownum=1 89 07:58:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1114 90 07:58:23 SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=? 91 07:58:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 92 07:58:23 SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=? 93 07:58:23 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 94 07:58:23 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 95 07:58:23 SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00 96 07:58:23 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='8' and MKDM00='8Z01' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='8' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1114)))) 97 07:58:23 SQL Execute: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='Ò½ÉúÔ¤Ô¼' and YXBZ00='1' and BZ0000 is not null order by XSXH00 98 07:58:23 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 99 07:58:23 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 100 07:58:23 SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 101 07:58:23 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 102 07:58:23 SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 103 07:58:23 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 104 07:58:23 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 105 07:58:23 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 106 07:58:23 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 107 07:58:23 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 108 07:58:23 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 109 07:58:23 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 110 07:58:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1114 111 07:58:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 112 07:58:23 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 113 07:58:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1114 114 07:58:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 115 07:58:23 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 116 07:58:23 SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 1114 117 07:58:23 SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '¼ìÑé¿Æ' 118 07:58:23 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 119 07:58:23 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 120 07:58:23 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 121 07:58:23 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 122 07:58:23 SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=1114 123 07:58:26 SQL Execute: ORACLE - Select SYSDATE from Dual 124 07:58:26 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 125 07:58:26 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 126 07:58:27 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137601097009' and ICKNBH = '0222137601097009' 127 07:58:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 128 07:58:27 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=? 129 07:58:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 130 07:58:27 SQL Execute: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=? 131 07:58:27 SQL Execute: ORACLE - select SF_YS_BRJZBSTS(2006699) GHCSTS from dual 132 07:58:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 133 07:58:27 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=1114) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 134 07:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 135 07:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 136 07:58:30 SQL Execute: ORACLE - select SF_YS_YKDWZXXMTS(?,?) TSXX00 from dual 137 07:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 138 07:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1114 139 07:58:30 SQL Execute: ORACLE - select GHLBBH,GHLBMC,GHXHS0,GHYGHS from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS') and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS') 140 07:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 141 07:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19000101 142 07:58:30 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0,a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0,a.FWMC00,a.BWMC00 from YS_BRZDXX a, XT_ICD900 b where a.ICD900=b.ICD900(+) and a.SFXYZD='1'and a.GHID00=? and exists(select 1 from SF_BRXXB0 where GHID00=a.GHID00 and GHRQ00>=?) 143 07:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 144 07:58:30 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD ,BWMC00,FWMC00 from YS_BRZDXX a where SFXYZD='0'and GHID00=? 145 07:58:30 SQL Data In: ORACLE - Param = 1, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 146 07:58:30 SQL Data In: ORACLE - Param = 2, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1114.000000 147 07:58:30 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 148 07:58:30 SQL Data In: ORACLE - Param = 4, Name = PRESULT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 149 07:58:30 SQL Data In: ORACLE - Param = 5, Name = PMSG000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 150 07:58:30 SQL Execute: ORACLE - BEGIN "SP_YS_GHXZTS" (PGHKS00 => :PGHKS00,PGHYS00 => :PGHYS00,PBRID00 => :PBRID00,PRESULT => :PRESULT,PMSG000 => :PMSG000); END; 151 07:58:30 SQL Execute: ORACLE - select sf_ys_ghxz00(20,1114,2006699) from dual 152 07:58:30 SQL Execute: ORACLE - select LBMC00,LBBH00 from VW_BM_GHLBB0 where lbbh00 in (12,13,14,15,16,17,18,19) 153 07:58:30 SQL Execute: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00 154 07:58:30 SQL Execute: ORACLE - select SFYD00,GRSFEN,BRDYFW from BM_BRXXB0 where BRID00=2006699 155 07:58:30 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select GHID00 from SF_BRXXB0 b where brid00=2006699) and rownum=1 156 07:58:30 SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1 157 07:58:30 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 158 07:58:30 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13 159 07:58:30 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 160 07:58:30 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 161 07:58:30 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 162 07:58:30 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 163 07:58:30 SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 164 07:58:30 SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 165 07:58:30 SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 166 07:58:30 SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 167 07:58:30 SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 168 07:58:30 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END; 169 07:58:30 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 170 07:58:30 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13 171 07:58:30 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 172 07:58:30 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 173 07:58:30 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 174 07:58:30 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 175 07:58:30 SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 176 07:58:30 SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 177 07:58:30 SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 178 07:58:30 SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 179 07:58:30 SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 180 07:58:30 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END; 181 07:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 182 07:58:30 SQL Execute: ORACLE - select nvl(max(GHID00),0) GHID00 from YS_BRBQB0 where GHID00 in (select GHID00 from SF_BRXXB0 b where BRID00=? ) 183 07:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 184 07:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16554936 185 07:58:30 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='0' 186 07:58:32 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 187 07:58:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 188 07:58:32 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=1114 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=10 189 07:58:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %d% 190 07:58:32 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=1114 or cjks00=20 or yxfw00='2') ) Order By PXH000,Instrb(PYSM00,'d'),PYSM00) where Rownum<=10 191 07:58:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %dg% 192 07:58:33 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=1114 or cjks00=20 or yxfw00='2') ) Order By PXH000,Instrb(PYSM00,'dg'),PYSM00) where Rownum<=10 193 07:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %dgd% 194 07:58:35 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=1114 or cjks00=20 or yxfw00='2') ) Order By PXH000,Instrb(PYSM00,'dgd'),PYSM00) where Rownum<=10 195 07:58:47 SQL Execute: ORACLE - select trim(MC0000) MC0000 from BM_TYZD00 where ZDMC00='´«È¾²¡µÇ¼Ç²»Öظ´µÄICD' and trim(MC0000) in ('E67.300') 196 07:58:47 SQL Execute: ORACLE - select 1 NUM from YS_CRBDJ0 where brid00 = '2006699' and trim(jbmc00)= 'άÉúËØD¹ý¶àÖ¢' and CZRQ00>=to_char(sysdate-365,'YYYYMMDD') 197 07:58:52 SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHH000.nextval from dual where rownum=1 198 07:58:52 SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1 199 07:58:52 SQL Execute: ORACLE - commit 200 07:58:52 SQL Data In: ORACLE - Rows affected = 0 201 07:58:52 SQL Execute: ORACLE - insert into YS_BRZDXX (ZDXXID, GHID00, GHH000,ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM,JZKS00,ZDMC00, SFYZ00, SFXYZD,ZDRQ00,ZDSJ00,FWMC00,BWMC00)Values (SQ_YS_BRZDXX_ZDXXID.nextval, 16555435,'7927811','3','E67.300','','1114','ÁÖÓÚ','20','άÉúËØD¹ý¶àÖ¢','0','1',to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'','') 202 07:58:52 SQL Data In: ORACLE - Rows affected = 1 203 07:58:52 SQL Execute: ORACLE - select SF_YS_GHZDXZ(13,1114,16555435) from dual 204 07:58:52 SQL Execute: ORACLE - insert into YS_BRBQB0 (ZS0000,GHID00,BRBQID,GHH000,JZYS00,SJYS00,JZRQSJ,CZRQ00,CZSJ00,JZYSXM,FBRQ00,BRID00)Values('',16555435,SQ_YS_BRBQB0_BRBQID.Nextval,'7927811',1114,0,to_char(sysdate,'yyyymmdd')||substr(to_char(sysdate,'hh24:mi:ss'),1,2)||substr(to_char(sysdate,'hh24:mi:ss'),4,2),to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),'ÁÖÓÚ','20150623',2006699) 205 07:58:52 SQL Data In: ORACLE - Rows affected = 1 206 07:58:52 SQL Execute: ORACLE - commit 207 07:58:52 SQL Data In: ORACLE - Rows affected = 0 208 07:58:52 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 209 07:58:52 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13 210 07:58:52 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 211 07:58:52 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 212 07:58:52 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 213 07:58:52 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 214 07:58:52 SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 215 07:58:52 SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 216 07:58:52 SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 217 07:58:52 SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 218 07:58:52 SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 219 07:58:52 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END; 220 07:58:52 SQL Execute: ORACLE - select SF_YS_XSTSBZXX(2006699) MSG000 from dual 221 07:58:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16555435 222 07:58:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = /222137/ 223 07:58:52 SQL Execute: ORACLE - select a.* from VW_YS_BYZJYPDDYZD a,YS_BRZDXX b where a.ZDICD0=trim(b.ICD900) and b.GHID00=? and exists(select 1 from XT_XTCS00 where NAME00='YS_TZDDYZJYYID' and instr(VALUE0,?)>0) 224 07:58:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 225 07:58:52 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 226 07:58:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 227 07:58:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1114 228 07:58:52 SQL Execute: ORACLE - select GHHBID from sf_ysghhb where GHKSBH=? and GHYSBH=? and PBLX00='0' and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') order by ghjssj 229 07:58:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 230 07:58:52 SQL Execute: ORACLE - select GHHBID from sf_ysghhb where GHKSBH=? and PBLX00='1' and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') order by ghjssj 231 07:58:52 SQL Execute: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00 =2006699 232 07:58:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 233 07:58:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 234 07:58:52 SQL Execute: ORACLE - Update SF_BRZHXX set TYJE00 = TYJE00+? where BRID00=? and JFLBID = 1 235 07:58:53 SQL Data In: ORACLE - Rows affected = 1 236 07:58:53 SQL Data In: ORACLE - Param = 1, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20058691 237 07:58:53 SQL Data In: ORACLE - Param = 2, Name = AS_YBGHH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 238 07:58:53 SQL Data In: ORACLE - Param = 3, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = Ö÷ÖÎҽʦ 239 07:58:53 SQL Data In: ORACLE - Param = 4, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 240 07:58:53 SQL Data In: ORACLE - Param = 5, Name = AS_SFCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 241 07:58:53 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = Ò×ÉÜäÔ 242 07:58:53 SQL Data In: ORACLE - Param = 7, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = Å® 243 07:58:53 SQL Data In: ORACLE - Param = 8, Name = AS_CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090127 244 07:58:53 SQL Data In: ORACLE - Param = 9, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = ×Ô·Ñ 245 07:58:53 SQL Data In: ORACLE - Param = 10, Name = AS_GFZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 246 07:58:53 SQL Data In: ORACLE - Param = 11, Name = AS_BRDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 247 07:58:53 SQL Data In: ORACLE - Param = 12, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 248 07:58:53 SQL Data In: ORACLE - Param = 13, Name = AD_GHY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1114.000000 249 07:58:53 SQL Data In: ORACLE - Param = 14, Name = AS_GHYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = ÁÖÓÚ 250 07:58:53 SQL Data In: ORACLE - Param = 15, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000 251 07:58:53 SQL Data In: ORACLE - Param = 16, Name = AD_GHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 252 07:58:53 SQL Data In: ORACLE - Param = 17, Name = AD_JZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1114.000000 253 07:58:53 SQL Data In: ORACLE - Param = 18, Name = AS_JZYSXM, Type = fldZSTRING, Precision = 4, Scale = 0, Data = ÁÖÓÚ 254 07:58:53 SQL Data In: ORACLE - Param = 19, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 255 07:58:53 SQL Data In: ORACLE - Param = 20, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 256 07:58:53 SQL Data In: ORACLE - Param = 21, Name = AS_FPXH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 257 07:58:53 SQL Data In: ORACLE - Param = 22, Name = AD_GHF000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 258 07:58:53 SQL Data In: ORACLE - Param = 23, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 259 07:58:53 SQL Data In: ORACLE - Param = 24, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 260 07:58:53 SQL Data In: ORACLE - Param = 25, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 261 07:58:53 SQL Data In: ORACLE - Param = 26, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 262 07:58:53 SQL Data In: ORACLE - Param = 27, Name = AS_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 263 07:58:53 SQL Data In: ORACLE - Param = 28, Name = AS_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 264 07:58:53 SQL Data In: ORACLE - Param = 29, Name = AS_GHRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 265 07:58:53 SQL Data In: ORACLE - Param = 30, Name = AS_SFYYGH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 266 07:58:53 SQL Data In: ORACLE - Param = 31, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 267 07:58:53 SQL Data In: ORACLE - Param = 32, Name = AS_SFSBLF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 268 07:58:53 SQL Data In: ORACLE - Param = 33, Name = AS_BRZY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 269 07:58:53 SQL Data In: ORACLE - Param = 34, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 270 07:58:53 SQL Data In: ORACLE - Param = 35, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = Éí·ÝÖ¤ 271 07:58:53 SQL Data In: ORACLE - Param = 36, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 272 07:58:53 SQL Data In: ORACLE - Param = 37, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 273 07:58:53 SQL Data In: ORACLE - Param = 38, Name = AS_SFNLYD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 274 07:58:53 SQL Data In: ORACLE - Param = 39, Name = AS_HZLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = ÆÕͨ 275 07:58:53 SQL Data In: ORACLE - Param = 40, Name = AS_ICKH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 276 07:58:53 SQL Data In: ORACLE - Param = 41, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 277 07:58:53 SQL Data In: ORACLE - Param = 42, Name = AD_FJJZDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 278 07:58:53 SQL Data In: ORACLE - Param = 43, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 279 07:58:53 SQL Data In: ORACLE - Param = 44, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 280 07:58:53 SQL Data In: ORACLE - Param = 45, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 281 07:58:53 SQL Data In: ORACLE - Param = 46, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 282 07:58:53 SQL Data In: ORACLE - Param = 47, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 283 07:58:53 SQL Data In: ORACLE - Param = 48, Name = AS_GHH000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 7927811 284 07:58:53 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 285 07:58:53 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 286 07:58:53 SQL Data In: ORACLE - Param = 51, Name = AS_JZSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 287 07:58:53 SQL Data In: ORACLE - Param = 52, Name = AS_ZSQGFF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 288 07:58:53 SQL Data In: ORACLE - Param = 53, Name = as_SFZJDK, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 289 07:58:53 SQL Data In: ORACLE - Param = 54, Name = as_SFZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 290 07:58:53 SQL Data In: ORACLE - Param = 55, Name = as_YGHH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 291 07:58:53 SQL Data In: ORACLE - Param = 56, Name = as_SFZRZY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 292 07:58:53 SQL Execute: ORACLE - BEGIN "SP_SF_BRGHXX" (AS_BRBLH0 => :AS_BRBLH0,AS_YBGHH0 => :AS_YBGHH0,AS_GHLBMC => :AS_GHLBMC,AD_BRID00 => :AD_BRID00,AS_SFCZ00 => :AS_SFCZ00,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_CSRQ00 => :AS_CSRQ00,AS_FBMC00 => :AS_FBMC00,AS_GFZH00 => :AS_GFZH00,AS_BRDH00 => :AS_BRDH00,AS_BRHYZK => :AS_BRHYZK,AD_GHY000 => :AD_GHY000,AS_GHYXM0 => :AS_GHYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_GHKS00 => :AD_GHKS00,AD_JZYS00 => :AD_JZYS00,AS_JZYSXM => :AS_JZYSXM,AD_GHHBID => :AD_GHHBID,AS_YJJXH0 => :AS_YJJXH0,AS_FPXH00 => :AS_FPXH00,AD_GHF000 => :AD_GHF000,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AS_ZPZH00 => :AS_ZPZH00,AS_YBID00 => :AS_YBID00,AS_YBKH00 => :AS_YBKH00,AS_GHRQ00 => :AS_GHRQ00,AS_SFYYGH => :AS_SFYYGH,AS_CZBZ00 => :AS_CZBZ00,AS_SFSBLF => :AS_SFSBLF,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_TYDWMC => :AS_TYDWMC,AS_SFNLYD => :AS_SFNLYD,AS_HZLB00 => :AS_HZLB00,AS_ICKH00 => :AS_ICKH00,AS_BRJTDZ => :AS_BRJTDZ,AD_FJJZDH => :AD_FJJZDH,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AS_GHH000 => :AS_GHH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_JZSJ00 => :AS_JZSJ00,AS_ZSQGFF => :AS_ZSQGFF,as_SFZJDK => :as_SFZJDK,as_SFZZ00 => :as_SFZZ00,as_YGHH00 => :as_YGHH00,as_SFZRZY => :as_SFZRZY); END; 293 07:58:55 SQL Execute: ORACLE - update SF_HZBR00 set HZZT00='1',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='7927811' and HZZT00 in ('0','2','4') 294 07:58:55 SQL Data In: ORACLE - Rows affected = 1 295 07:58:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7927811 296 07:58:55 SQL Execute: ORACLE - select ghid00,LBBH00,ZDFF00,ZLFA00 from SF_BRXXB0 where ghh000=? 297 07:58:55 SQL Execute: ORACLE - update YS_BRZDXX set GHID00=16555436 WHERE GHID00=16555435 298 07:58:55 SQL Data In: ORACLE - Rows affected = 1 299 07:58:55 SQL Execute: ORACLE - update YS_BRBQB0 set GHID00=16555436 WHERE GHID00=16555435 300 07:58:55 SQL Data In: ORACLE - Rows affected = 1 301 07:58:55 SQL Execute: ORACLE - update YS_CRBDJ0 set MZID00=16555436 WHERE MZID00=16555435 and BRID00=2006699 302 07:58:55 SQL Data In: ORACLE - Rows affected = 0 303 07:58:55 SQL Execute: ORACLE - update YS_CRBDJ0 set MZID00=16555436 WHERE BRID00=2006699 and CZY000=1114 and CZRQ00=to_char(sysdate,'YYYYMMDD') and MZID00+0<16555436 and not exists (select 1 from SF_BRXXB0 where GHID00=YS_CRBDJ0.MZID00) 304 07:58:55 SQL Data In: ORACLE - Rows affected = 0 305 07:58:55 SQL Execute: ORACLE - COMMIT 306 07:58:55 SQL Data In: ORACLE - Rows affected = 0 307 07:58:55 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 308 07:58:55 SQL Data In: ORACLE - Param = 2, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16555436 309 07:58:55 SQL Data In: ORACLE - Param = 3, Name = PMZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 310 07:58:55 SQL Data In: ORACLE - Param = 4, Name = PSFYF00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 311 07:58:55 SQL Data In: ORACLE - Param = 5, Name = PSFBR00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 312 07:58:55 SQL Data In: ORACLE - Param = 6, Name = PSFGG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 313 07:58:55 SQL Data In: ORACLE - Param = 7, Name = PSFSG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 314 07:58:55 SQL Data In: ORACLE - Param = 8, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1114 315 07:58:55 SQL Data In: ORACLE - Param = 9, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 316 07:58:55 SQL Execute: ORACLE - BEGIN "SP_YS_SAVEBSL" (PBRID00 => :PBRID00,PGHID00 => :PGHID00,PMZBZ00 => :PMZBZ00,PSFYF00 => :PSFYF00,PSFBR00 => :PSFBR00,PSFGG00 => :PSFGG00,PSFSG00 => :PSFSG00,PCZY000 => :PCZY000,PERRMSG => :PERRMSG); END; 317 07:58:55 SQL Execute: ORACLE - COMMIT 318 07:58:55 SQL Data In: ORACLE - Rows affected = 0 319 07:58:55 SQL Execute: ORACLE - Update sf_brxxb0 set THBZ00='2' where GHH000='7927811' 320 07:58:55 SQL Data In: ORACLE - Rows affected = 1 321 07:58:55 SQL Execute: ORACLE - commit 322 07:58:55 SQL Data In: ORACLE - Rows affected = 0 323 07:58:55 SQL Execute: ORACLE - commit 324 07:58:55 SQL Data In: ORACLE - Rows affected = 0 325 07:58:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 326 07:58:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19000101 327 07:58:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16555436 328 07:58:55 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC ,a.FWMC00,a.BWMC00 from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? and (exists(select 1 from SF_BRXXB0 where GHID00=a.GHID00 and GHRQ00>=?) or a.GHID00=?) order by zzdbz0 329 07:58:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 330 07:58:55 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC ,BWMC00,FWMC00 from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 331 07:58:55 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00,YYLBID,to_date(decode(nvl(YYKBRQ,' '),' ',to_char(sysdate,'YYYYMMDD'),YYKBRQ),'YYYYMMDD') YYKBRQ from SF_BRXXB0 where GHID00=16555436 332 07:58:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 333 07:58:55 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 334 07:58:55 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=2006699)and GHID00<16555436 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=2006699)and GHID00>16555436 and rownum=1 335 07:58:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7927811 336 07:58:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7927811 337 07:58:55 SQL Execute: ORACLE - select sum(CFZJE0) from VW_YS_CFZL00 where CFBZ00='1' and GHH000=? and zt0000 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=? and MZZYBZ='0' and xmzt00 in ('0','1') 338 07:58:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 339 07:58:55 SQL Execute: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=? and a.BRID00=b.BRID00 340 07:58:55 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 341 07:58:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16555436 342 07:58:55 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 343 07:58:57 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='7927811' and LBBH00='0' 344 07:58:57 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='2006699' and ZT0000='1' 345 07:58:57 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='2006699' and ZT0000='1' 346 07:58:57 SQL Execute: ORACLE - Select SYSDATE from Dual 347 07:58:57 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 348 07:58:57 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 349 07:58:57 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137601097009' and ICKNBH = '0222137601097009' 350 07:58:57 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='7927811' and SFXYZD='1' and ZDXXID not in (-1,5994276) 351 07:58:57 SQL Data In: ORACLE - Rows affected = 0 352 07:58:57 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = 'E67.300',ZDMSMC = '',ZDMC00 = 'άÉúËØD¹ý¶àÖ¢',SFYZ00 = '0',JZYS00 = 1114,JZYSXM = 'ÁÖÓÚ', FWMC00 = '',BWMC00 = ''where ZDXXID = 5994276 353 07:58:57 SQL Data In: ORACLE - Rows affected = 1 354 07:58:57 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='7927811' and SFXYZD='0' and ZDXXID not in (-1) 355 07:58:57 SQL Data In: ORACLE - Rows affected = 0 356 07:58:57 SQL Execute: ORACLE - update YS_BRBQB0 set ZS0000 ='',SZ0000 ='',ST0000 ='',MX0000 ='',TW0000 ='',XTCS00 ='',HXCS00 ='',SZY000 ='',SSY000 ='',SFHC00 ='0',BS0000 =?,TGJC00 =?,SYSJC0 =?,ZDCLNR =?,FBRQ00 ='20150623'Where GHH000='7927811' 357 07:58:57 SQL Data In: ORACLE - Rows affected = 1 358 07:58:57 SQL Execute: ORACLE - update SF_BRXXB0 set SFLG00='N' where GHID00=16555436 359 07:58:57 SQL Data In: ORACLE - Rows affected = 1 360 07:58:57 SQL Execute: ORACLE - update SF_BRXXB0 set SFZRZY='N' where GHID00=16555436 361 07:58:57 SQL Data In: ORACLE - Rows affected = 1 362 07:58:57 SQL Execute: ORACLE - Commit 363 07:58:57 SQL Data In: ORACLE - Rows affected = 0 364 07:58:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16555436 365 07:58:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19000101 366 07:58:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16555436 367 07:58:57 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC ,a.FWMC00,a.BWMC00 from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? and (exists(select 1 from SF_BRXXB0 where GHID00=a.GHID00 and GHRQ00>=?) or a.GHID00=?) order by zzdbz0 368 07:58:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16555436 369 07:58:57 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC ,BWMC00,FWMC00 from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 370 07:58:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 371 07:58:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19000101 372 07:58:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16555436 373 07:58:58 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC ,a.FWMC00,a.BWMC00 from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? and (exists(select 1 from SF_BRXXB0 where GHID00=a.GHID00 and GHRQ00>=?) or a.GHID00=?) order by zzdbz0 374 07:58:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 375 07:58:58 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC ,BWMC00,FWMC00 from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 376 07:58:58 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00,YYLBID,to_date(decode(nvl(YYKBRQ,' '),' ',to_char(sysdate,'YYYYMMDD'),YYKBRQ),'YYYYMMDD') YYKBRQ from SF_BRXXB0 where GHID00=16555436 377 07:58:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 378 07:58:58 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 379 07:58:58 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=2006699)and GHID00<16555436 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=2006699)and GHID00>16555436 and rownum=1 380 07:58:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7927811 381 07:58:59 SQL Execute: ORACLE - select a.*,(select YPDLBH from YF_MZCF00 where CFLSH0=a.CFLSH0) YPDLBH from ys_cfxxb0 a where cflsh0=(select max(cflsh0) from YS_CFXXB0 where GHH000=? and CFXZ00<>'0') 382 07:59:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = Ö÷ÖÎҽʦ 383 07:59:01 SQL Execute: ORACLE - select ghqxbz from bm_ghlbb0 where lbmc00=? 384 07:59:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7927811 385 07:59:01 SQL Execute: ORACLE - select HBQX00 from SF_BRXXB0 where GHH000=? 386 07:59:01 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 387 07:59:01 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 388 07:59:01 SQL Data In: ORACLE - Param = 3, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1114.000000 389 07:59:01 SQL Data In: ORACLE - Param = 4, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 390 07:59:01 SQL Data In: ORACLE - Param = 5, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 391 07:59:01 SQL Execute: ORACLE - BEGIN "SP_YS_KJCFSTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_YSGZH0 => :V_YSGZH0,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE); END; 392 07:59:01 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 393 07:59:01 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 394 07:59:01 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 395 07:59:01 SQL Data In: ORACLE - Param = 4, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 396 07:59:01 SQL Data In: ORACLE - Param = 5, Name = V_ZYCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 397 07:59:01 SQL Data In: ORACLE - Param = 6, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1114.000000 398 07:59:01 SQL Execute: ORACLE - BEGIN "SP_YS_XZCFTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE,V_ZYCFBZ => :V_ZYCFBZ,V_YSGZH0 => :V_YSGZH0); END; 399 07:59:14 SQL Execute: ORACLE - Rollback 400 07:59:14 SQL Data In: ORACLE - Rows affected = 0 401 07:59:19 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 402 07:59:19 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','8','appYS_YSGZZ.exe'||'+'||'ÃÅÕïÒ½Éú¹¤×÷Õ¾·Öϵͳ','194','5198' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:DA0EAE149D09996EA79567577DAFEB94' from dual 403 07:59:19 SQL Data In: ORACLE - Rows affected = 1 404 07:59:19 SQL Execute: ORACLE - Commit 405 07:59:19 SQL Data In: ORACLE - Rows affected = 0 406 07:59:19 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 407 07:59:19 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 408 07:59:19 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 409 07:59:19 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 410 07:59:19 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','8','appYS_YSGZZ.exe'||'+'||'ÃÅÕïÒ½Éú¹¤×÷Õ¾·Öϵͳ','199','12274' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:226DB686F958F2AD9E7D6DB4118BE8BB' from dual 411 07:59:19 SQL Data In: ORACLE - Rows affected = 1 412 07:59:19 SQL Execute: ORACLE - Commit 413 07:59:19 SQL Data In: ORACLE - Rows affected = 0 414 07:59:19 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 415 07:59:19 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 416 07:59:28 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 417 07:59:28 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 418 07:59:32 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 419 07:59:32 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='0806' and CZBZ00 in ('1') 420 07:59:32 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 421 07:59:32 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','5','9','c') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806')) order by b.PLXH00,a.BH0000 422 07:59:33 SQL Execute: ORACLE - select GHKSBH,GHJSSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806') and rownum=1 423 07:59:33 SQL Execute: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '37' 424 07:59:33 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 425 07:59:33 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where '0806'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806') 426 07:59:33 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=444 427 07:59:33 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 428 07:59:33 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4614604 429 07:59:33 SQL Data In: ORACLE - Rows affected = 1 430 07:59:33 SQL Execute: ORACLE - Commit 431 07:59:33 SQL Data In: ORACLE - Rows affected = 0 432 07:59:33 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 433 07:59:33 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 434 07:59:33 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')) 435 07:59:34 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4614605,444,'wlzx-3','8',nvl('231333620',' '),'',37) 436 07:59:34 SQL Data In: ORACLE - Rows affected = 1 437 07:59:34 SQL Execute: ORACLE - Commit 438 07:59:34 SQL Data In: ORACLE - Rows affected = 0 439 07:59:34 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 37 440 07:59:34 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 441 07:59:34 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 442 07:59:34 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 443 07:59:34 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 444 07:59:34 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 37 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,149,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 445 07:59:34 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20150623' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',37,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='8') 446 07:59:34 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 447 07:59:34 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 448 07:59:34 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 444 449 07:59:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 450 07:59:34 SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?) 451 07:59:34 SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%¼±%' and SFYX00='Y' 452 07:59:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 453 07:59:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 454 07:59:34 SQL Execute: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 455 07:59:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 456 07:59:34 SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=? 457 07:59:34 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 444= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=444 and XTDM00='8'))) 458 07:59:34 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||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 459 07:59:34 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((444= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=444 and XTDM00='0 '))) 460 07:59:34 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 461 07:59:34 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 444= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=444 and XTDM00='+ '))) 462 07:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 463 07:59:35 SQL Execute: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'δÉèÖÃ') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=? and a.YSLB00=b.YSLB00(+) 464 07:59:35 SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '¼å%' and rownum=1 465 07:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 466 07:59:35 SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=? 467 07:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 468 07:59:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 469 07:59:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 470 07:59:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 471 07:59:35 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 472 07:59:35 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 473 07:59:35 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 474 07:59:35 SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and GZDJ00 <=? and MZDJ00 <=? and DPDJ00 <=? and KSSDJ0<=? and ((SJDJ00 >=? and ? >'0') or SJDJ00='0') and Rownum=1 475 07:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 476 07:59:35 SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=? 477 07:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 478 07:59:35 SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=? 479 07:59:35 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 480 07:59:35 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 481 07:59:35 SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00 482 07:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 483 07:59:35 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 484 07:59:35 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='8' and MKDM00='8Z01' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='8' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=444)))) 485 07:59:35 SQL Execute: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='Ò½ÉúÔ¤Ô¼' and YXBZ00='1' and BZ0000 is not null order by XSXH00 486 07:59:35 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 487 07:59:35 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 488 07:59:35 SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 489 07:59:35 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 490 07:59:35 SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 491 07:59:35 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 492 07:59:35 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 493 07:59:35 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 494 07:59:35 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 495 07:59:35 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 496 07:59:35 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 497 07:59:35 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 498 07:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 499 07:59:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 500 07:59:35 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 501 07:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 502 07:59:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 503 07:59:35 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 504 07:59:35 SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 444 505 07:59:35 SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '¼ìÑé¿Æ' 506 07:59:35 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 507 07:59:35 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 508 07:59:35 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 509 07:59:35 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 510 07:59:35 SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=444 511 07:59:40 SQL Execute: ORACLE - Select SYSDATE from Dual 512 07:59:40 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 513 07:59:40 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 514 07:59:40 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137601097009' and ICKNBH = '0222137601097009' 515 07:59:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 516 07:59:40 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=? 517 07:59:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 518 07:59:40 SQL Execute: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=? 519 07:59:40 SQL Execute: ORACLE - select SF_YS_BRJZBSTS(2006699) GHCSTS from dual 520 07:59:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 521 07:59:40 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=444) or (a.JZYS00=0) ) or (a.GHKS00=37 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 522 07:59:40 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='7927811' and LBBH00='0' 523 07:59:40 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='2006699' and ZT0000='1' 524 07:59:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16555436 525 07:59:42 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = /222137/ 526 07:59:42 SQL Execute: ORACLE - select a.* from VW_YS_BYZJYPDDYZD a,YS_BRZDXX b where a.ZDICD0=trim(b.ICD900) and b.GHID00=? and exists(select 1 from XT_XTCS00 where NAME00='YS_TZDDYZJYYID' and instr(VALUE0,?)>0) 527 07:59:42 SQL Execute: ORACLE - update SF_HZBR00 set HZZT00='1',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='7927811' and HZZT00 in ('0','2','4') 528 07:59:42 SQL Data In: ORACLE - Rows affected = 0 529 07:59:42 SQL Execute: ORACLE - commit 530 07:59:42 SQL Data In: ORACLE - Rows affected = 0 531 07:59:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 532 07:59:42 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19000101 533 07:59:42 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16555436 534 07:59:42 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC ,a.FWMC00,a.BWMC00 from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? and (exists(select 1 from SF_BRXXB0 where GHID00=a.GHID00 and GHRQ00>=?) or a.GHID00=?) order by zzdbz0 535 07:59:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 536 07:59:42 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC ,BWMC00,FWMC00 from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 537 07:59:42 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00,YYLBID,to_date(decode(nvl(YYKBRQ,' '),' ',to_char(sysdate,'YYYYMMDD'),YYKBRQ),'YYYYMMDD') YYKBRQ from SF_BRXXB0 where GHID00=16555436 538 07:59:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 539 07:59:42 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 540 07:59:42 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=2006699)and GHID00<16555436 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=2006699)and GHID00>16555436 and rownum=1 541 07:59:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7927811 542 07:59:42 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7927811 543 07:59:42 SQL Execute: ORACLE - select sum(CFZJE0) from VW_YS_CFZL00 where CFBZ00='1' and GHH000=? and zt0000 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=? and MZZYBZ='0' and xmzt00 in ('0','1') 544 07:59:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2006699 545 07:59:42 SQL Execute: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=? and a.BRID00=b.BRID00 546 07:59:42 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 547 07:59:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7927811 548 07:59:44 SQL Execute: ORACLE - select a.*,(select YPDLBH from YF_MZCF00 where CFLSH0=a.CFLSH0) YPDLBH from ys_cfxxb0 a where cflsh0=(select max(cflsh0) from YS_CFXXB0 where GHH000=? and CFXZ00<>'0') 549 07:59:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = Ö÷ÖÎҽʦ 550 07:59:46 SQL Execute: ORACLE - select ghqxbz from bm_ghlbb0 where lbmc00=? 551 07:59:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7927811 552 07:59:46 SQL Execute: ORACLE - select HBQX00 from SF_BRXXB0 where GHH000=? 553 07:59:46 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 554 07:59:46 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 555 07:59:46 SQL Data In: ORACLE - Param = 3, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 444.000000 556 07:59:46 SQL Data In: ORACLE - Param = 4, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 557 07:59:46 SQL Data In: ORACLE - Param = 5, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 558 07:59:46 SQL Execute: ORACLE - BEGIN "SP_YS_KJCFSTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_YSGZH0 => :V_YSGZH0,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE); END; 559 07:59:46 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 560 07:59:46 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 561 07:59:46 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 562 07:59:46 SQL Data In: ORACLE - Param = 4, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 563 07:59:46 SQL Data In: ORACLE - Param = 5, Name = V_ZYCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 564 07:59:46 SQL Data In: ORACLE - Param = 6, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 444.000000 565 07:59:46 SQL Execute: ORACLE - BEGIN "SP_YS_XZCFTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE,V_ZYCFBZ => :V_ZYCFBZ,V_YSGZH0 => :V_YSGZH0); END; 566 07:59:46 SQL Data In: ORACLE - Param = 2, Name = p_LSH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = MZYF_MZCFH 567 07:59:46 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 568 07:59:46 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (p_LSH => :p_LSH); END; 569 07:59:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7954763 570 07:59:46 SQL Execute: ORACLE - select a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00,(select LBBH00 from BM_YD0000 where YPNM00=a.YPNM00) YPLBBH from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0=? and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00 571 07:59:46 SQL Execute: ORACLE - select YFID00,YPYFMC from BM_YPYF00 572 07:59:46 SQL Execute: ORACLE - select pcid00,pcmc00,ZQDW00 "LCDW" from VW_bm_pc0000 573 07:59:46 SQL Execute: ORACLE - select PSID00,PSMC00 from BM_PS0000 where YXBZ00='1' 574 07:59:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7954763 575 07:59:46 SQL Execute: ORACLE - select * from YS_CFXXB0 where CFLSH0=? 576 07:59:46 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 577 07:59:46 SQL Execute: ORACLE - select YPLBBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=37 and YFBMBH=70 578 07:59:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %d% 579 07:59:59 SQL Execute: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,YPMC02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,YPSPMC,ypmclb,F2J000,MRYYZF,NBLBMC,NBZFBL,ZQCS00,YPXZ00,YPSYSM,Colour from VW_YS_YBDMYPSR A where (PYSM00 Like ?) and( YFBMBH =70 and YBZXLB='@' and YBBRLB='0' and FBBH00=3 and CFJB00<=2 and GZDJ00<='1' and MZDJ00<='1' and DPDJ00<='1' and ((SJDJ00>= '1' and '1'>'0') or SJDJ00='0') and KSSDJ0<='2' ) Order By Instrb(PYSM00,'d'),PYSM00) where Rownum<=300 580 08:00:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 581 08:00:02 SQL Execute: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,YPMC02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,YPSPMC,ypmclb,F2J000,MRYYZF,NBLBMC,NBZFBL,ZQCS00,YPXZ00,YPSYSM,Colour from VW_YS_YBDMYPSR A where (PYSM00 Like ?) and( YFBMBH =70 and YBZXLB='@' and YBBRLB='0' and FBBH00=3 and CFJB00<=2 and GZDJ00<='1' and MZDJ00<='1' and DPDJ00<='1' and ((SJDJ00>= '1' and '1'>'0') or SJDJ00='0') and KSSDJ0<='2' ) Order By PYSM00) where Rownum<=300 582 08:00:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %a% 583 08:00:04 SQL Execute: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,YPMC02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,YPSPMC,ypmclb,F2J000,MRYYZF,NBLBMC,NBZFBL,ZQCS00,YPXZ00,YPSYSM,Colour from VW_YS_YBDMYPSR A where (PYSM00 Like ?) and( YFBMBH =70 and YBZXLB='@' and YBBRLB='0' and FBBH00=3 and CFJB00<=2 and GZDJ00<='1' and MZDJ00<='1' and DPDJ00<='1' and ((SJDJ00>= '1' and '1'>'0') or SJDJ00='0') and KSSDJ0<='2' ) Order By Instrb(PYSM00,'a'),PYSM00) where Rownum<=300 584 08:00:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %ap% 585 08:00:05 SQL Execute: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,YPMC02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,YPSPMC,ypmclb,F2J000,MRYYZF,NBLBMC,NBZFBL,ZQCS00,YPXZ00,YPSYSM,Colour from VW_YS_YBDMYPSR A where (PYSM00 Like ?) and( YFBMBH =70 and YBZXLB='@' and YBBRLB='0' and FBBH00=3 and CFJB00<=2 and GZDJ00<='1' and MZDJ00<='1' and DPDJ00<='1' and ((SJDJ00>= '1' and '1'>'0') or SJDJ00='0') and KSSDJ0<='2' ) Order By Instrb(PYSM00,'ap'),PYSM00) where Rownum<=300 586 08:00:07 SQL Execute: ORACLE - select SF_YS_GETBRLSYPYYL(477,2006699) VTS000 from dual 587 08:00:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 477 588 08:00:07 SQL Execute: ORACLE - SELECT NDJCTS FROM BM_YD0000 WHERE YPNM00=? 589 08:00:07 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 590 08:00:07 SQL Data In: ORACLE - Param = 2, Name = P_YPNM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477.000000 591 08:00:07 SQL Data In: ORACLE - Param = 3, Name = P_MCSL00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 592 08:00:07 SQL Data In: ORACLE - Param = 4, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 593 08:00:07 SQL Execute: ORACLE - BEGIN :Result := "SF_YS_GETCLY" (P_YPNM00 => :P_YPNM00,P_MCSL00 => :P_MCSL00,P_BRID00 => :P_BRID00); END; 594 08:00:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 595 08:00:21 SQL Execute: ORACLE - Select * from (select BZMC00,BZID00,BZBH00,PYSM00,WBSM00 from BM_DMZD00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=300 596 08:00:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 597 08:00:50 SQL Execute: ORACLE - Select * from (select PCMC00,PCID00,PYSM00,WBSM00,SM0000,ZQCD00,ZQDW00,ZQCS00,BH0000 from VW_BM_PC0000 where (PYSM00 Like ?) and( (MZZYBZ='0' or MZZYBZ='1') ) Order By Order0,PYSM00) where Rownum<=300 598 08:00:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %q% 599 08:00:52 SQL Execute: ORACLE - Select * from (select PCMC00,PCID00,PYSM00,WBSM00,SM0000,ZQCD00,ZQDW00,ZQCS00,BH0000 from VW_BM_PC0000 where (PYSM00 Like ?) and( (MZZYBZ='0' or MZZYBZ='1') ) Order By Order0,Instrb(PYSM00,'q'),PYSM00) where Rownum<=300 600 08:00:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %q1% 601 08:00:54 SQL Execute: ORACLE - Select * from (select PCMC00,PCID00,PYSM00,WBSM00,SM0000,ZQCD00,ZQDW00,ZQCS00,BH0000 from VW_BM_PC0000 where (PYSM00 Like ?) and( (MZZYBZ='0' or MZZYBZ='1') ) Order By Order0,Instrb(PYSM00,'q1'),PYSM00) where Rownum<=300 602 08:00:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %q12% 603 08:00:54 SQL Execute: ORACLE - Select * from (select PCMC00,PCID00,PYSM00,WBSM00,SM0000,ZQCD00,ZQDW00,ZQCS00,BH0000 from VW_BM_PC0000 where (PYSM00 Like ?) and( (MZZYBZ='0' or MZZYBZ='1') ) Order By Order0,Instrb(PYSM00,'q12'),PYSM00) where Rownum<=300 604 08:01:08 SQL Data In: ORACLE - Param = 2, Name = p_ypnm00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 477 605 08:01:08 SQL Data In: ORACLE - Param = 3, Name = p_mcsl00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 606 08:01:08 SQL Data In: ORACLE - Param = 4, Name = p_z2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 607 08:01:08 SQL Data In: ORACLE - Param = 5, Name = p_pcid00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 61 608 08:01:08 SQL Data In: ORACLE - Param = 6, Name = p_zqs000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 609 08:01:08 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 610 08:01:08 SQL Data In: ORACLE - Param = 7, Name = p_brid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2006699.000000 611 08:01:08 SQL Data In: ORACLE - Param = 8, Name = p_sftsbz, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 612 08:01:08 SQL Data In: ORACLE - Param = 9, Name = p_f2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 613 08:01:08 SQL Data In: ORACLE - Param = 10, Name = p_ghid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16555436.000000 614 08:01:08 SQL Execute: ORACLE - BEGIN :Result := "SF_YS_LYLJS0" (p_ypnm00 => :p_ypnm00,p_mcsl00 => :p_mcsl00,p_z2j000 => :p_z2j000,p_pcid00 => :p_pcid00,p_zqs000 => :p_zqs000,p_brid00 => :p_brid00,p_sftsbz => :p_sftsbz,p_f2j000 => :p_f2j000,p_ghid00 => :p_ghid00); END; 615 08:01:18 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='7927811' and LBBH00='0' 616 08:01:18 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='2006699' and ZT0000='1' 617 08:01:18 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='2006699' and ZT0000='1' 618 08:01:18 SQL Execute: ORACLE - Select SYSDATE from Dual 619 08:01:18 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 620 08:01:18 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 621 08:01:18 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137601097009' and ICKNBH = '0222137601097009' 622 08:01:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 477 623 08:01:18 SQL Execute: ORACLE - select ZDXL00 FROM BM_YD0000 WHERE YPNM00=? 624 08:01:18 SQL Execute: ORACLE - select * from VW_YS_YBDMYPSR where YFBMBH=70 and YPNM00=477 and SJKCSL>0 625 08:01:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 477 626 08:01:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 627 08:01:18 SQL Execute: ORACLE - select LBBH00 from vw_ys_ypkcxx where ypnm00=? and yfbmbh=? 628 08:01:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477.000000 629 08:01:18 SQL Execute: ORACLE - SELECT NDJCTS FROM BM_YD0000 WHERE YPNM00=? 630 08:01:18 SQL Execute: ORACLE - select b.YPMC00,b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00 from BM_YD0000 b where YPNM00=477 631 08:01:18 SQL Execute: ORACLE - Delete from ys_cfmx00 where cflsh0='7954763' and cfid00 not in (-1) 632 08:01:18 SQL Data In: ORACLE - Rows affected = 0 633 08:01:18 SQL Execute: ORACLE - insert into YS_CFMX00 (CFID00, CFLSH0, YPNM00, YPMC00, YPGG00, LSDJ00, YFID00, PCID00,CSL000, JLDW00, YYSJ00, YYSJDW, YYZF00 , ZB0000, PSLBID, SFZBY0,YPZSL0, CFDW00, ZHL000, ZQCS00, ZFBL00, YBLB00, THBZ00,ZXCS00,TSYS00,CQLY00,F2J000,ZFFSBZ)Values (SQ_YS_CFMX00_CFID00.NEXTVAL, '7954763','477','°¢Æ¬Æ¬','50mg*10Ƭ*2°å','0.4875','001','61','50','mg','1','*12Ð','','','','N','1','Ƭ','50','1','1','7','0','1','','','1','N') 634 08:01:18 SQL Data In: ORACLE - Rows affected = 0 635 08:01:18 SQL Execute: ORACLE - Rollback 636 08:01:18 SQL Data In: ORACLE - Rows affected = 0 637 08:01:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 638 08:01:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 639 08:01:34 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 640 08:01:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 641 08:01:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 642 08:01:34 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 643 08:03:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 644 08:03:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 645 08:03:34 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 646 08:03:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 647 08:03:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 648 08:03:34 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=?