1 15:57:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 2 15:57:57 SQL Execute: ORACLE - select YBDJH0,ZYYBJK,BXLB00 from BM_YBJS00 where BRID00=? and czrq00=to_char(sysdate,'YYYYMMDD') and MZZYBZ='0' AND CZBZ00='1' and JSZT00='1' 3 15:57:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2484.000000 4 15:57:57 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 = ? and SYBZ00 = 'Y' 5 15:57:57 SQL Execute: ORACLE - select ICKLB0 from ic_yhxx00 where ickh00= 'PTYBPT10310024105' 6 15:57:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 7 15:57:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 8 15:57:57 SQL Execute: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in (select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0 and b.brid00= ?) and d.srrq00>=to_char(sysdate-?,'YYYYMMDD') 9 15:57:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 10 15:57:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 11 15:57:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 12 15:57:57 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND d.brid00=? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 13 15:57:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 14 15:57:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 15 15:57:57 SQL Execute: ORACLE - select a.SRRQ00,D.LBMC00,A.GHH000,F.GHRQ00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1 and a.ghh000=f.ghh000 and B.BRID00= ? and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0 and A.srrq00>=to_char(sysdate-?,'YYYYMMDD') and A.YPDLBH=D.LBBH00 16 15:57:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 17 15:57:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 18 15:57:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 19 15:57:57 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and d.ghh000=f.ghh000 and d.brid00= ? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00> 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 20 15:57:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 21 15:57:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 22 15:57:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 23 15:57:57 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00=? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 24 15:57:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 25 15:57:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 26 15:57:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 27 15:57:57 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= ? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 28 15:57:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 29 15:57:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 30 15:57:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 31 15:57:57 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 from YJ_YW0000 D,bm_bmbm00 e,SF_BRXXB0 F WHERE 1=1 and D.ZYHGHH=F.GHH000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0 and D.brid00= ? and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 32 15:57:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1911163 33 15:57:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 22, Scale = 0, Data = 医保病人以自费建卡登记 34 15:57:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 35 15:57:57 SQL Execute: ORACLE - select count(0) num from BM_TYZD00 where BH0000=? and ZDMC00=? and YXBZ00=? 36 15:57:58 SQL Execute: ORACLE - Select SYSDATE from Dual 37 15:57:58 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 38 15:57:58 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') 39 15:57:58 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBPT10310024105' and ICKNBH = 'PTYBPT10310024105' 40 15:57:58 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDDHH24:MI:SS') OraSysDate FROM DUAL 41 15:57:58 SQL Execute: ORACLE - Select SQ_SF_JZB000_JZDH00.NextVal Val from Dual 42 15:57:58 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14753153 43 15:57:58 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 44 15:57:58 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 609356.000000 45 15:57:58 SQL Data In: ORACLE - Param = 4, Name = PYBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 46 15:57:58 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2484.000000 47 15:57:58 SQL Data In: ORACLE - Param = 6, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 539.000000 48 15:57:58 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 49 15:57:58 SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 50 15:57:58 SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 51 15:57:58 SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 52 15:57:58 SQL Execute: ORACLE - BEGIN "SP_SF_FYJS00_JZDH00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PYBDJH0 => :PYBDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 53 15:57:58 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 54 15:57:58 SQL Data In: ORACLE - Param = 2, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 609356.000000 55 15:57:58 SQL Data In: ORACLE - Param = 3, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180710 56 15:57:58 SQL Data In: ORACLE - Param = 4, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20181109 57 15:57:58 SQL Data In: ORACLE - Param = 5, Name = AS_ICKH00, Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT10310024105 58 15:57:58 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 59 15:57:58 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 60 15:57:58 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 蔡颢恒 61 15:57:58 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 62 15:57:58 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 63 15:57:58 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.410000 64 15:57:58 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 65 15:57:58 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 66 15:57:58 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.410000 67 15:57:58 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 68 15:57:58 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 69 15:57:58 SQL Data In: ORACLE - Param = 17, Name = AS_YBJZRQ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 70 15:57:58 SQL Data In: ORACLE - Param = 18, Name = AS_YBJZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 71 15:57:58 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.410000 72 15:57:58 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2484.000000 73 15:57:58 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员 74 15:57:58 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 539.000000 75 15:57:58 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 76 15:57:58 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 77 15:57:58 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 78 15:57:58 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 79 15:57:58 SQL Data In: ORACLE - Param = 27, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 80 15:57:58 SQL Data In: ORACLE - Param = 28, Name = AS_SFDYFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 81 15:57:58 SQL Data In: ORACLE - Param = 29, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 82 15:57:58 SQL Data In: ORACLE - Param = 30, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 83 15:57:58 SQL Data In: ORACLE - Param = 31, Name = as_SFSCJS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 84 15:57:58 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AD_JZDH00 => :AD_JZDH00,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_BRFB00 => :AD_BRFB00,AD_BRZJE0 => :AD_BRZJE0,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AD_HJJE00 => :AD_HJJE00,AD_JMJE00 => :AD_JMJE00,AS_ZPZH00 => :AS_ZPZH00,AS_YBJZRQ => :AS_YBJZRQ,AS_YBJZSJ => :AS_YBJZSJ,AD_ZFJE00 => :AD_ZFJE00,AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_JZYKS0 => :AD_JZYKS0,AS_JMYY00 => :AS_JMYY00,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_SFYB00 => :AS_SFYB00,AS_TSBZBH => :AS_TSBZBH,AS_SFDYFP => :AS_SFDYFP,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_SFSCJS => :as_SFSCJS); END; 85 15:57:59 SQL Execute: ORACLE - commit 86 15:57:59 SQL Data In: ORACLE - Rows affected = 0 87 15:57:59 SQL Execute: ORACLE - update IC_YHXX00 set ICKH00='offline#20181109#PT10310024105',ICKNBH='offline#20181109#PT10310024105' where ICKH00='PTYBPT10310024105' and rownum=1 88 15:57:59 SQL Data In: ORACLE - Rows affected = 1 89 15:57:59 SQL Execute: ORACLE - insert into IC_YHXX00(ICKH00,ICKMM0,YGBH00,KLDH00,ICKLB0,ICKSX0,ZT0000,SFDM00,ICKJE0,ICKNBH,KMH000) select 'PTYBPT10310024105' ICKH00,ICKMM0,YGBH00,KLDH00,'0' ICKLB0,ICKSX0,'0' ZT0000,SFDM00,ICKJE0,'PTYBPT10310024105' ICKNBH,KMH000 from IC_YHXX00 where ICKH00='offline#20181109#PT10310024105' 90 15:57:59 SQL Data In: ORACLE - Rows affected = 1 91 15:57:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 92 15:57:59 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=? 93 15:57:59 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 94 15:57:59 SQL Data In: ORACLE - Param = 2, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 95 15:57:59 SQL Data In: ORACLE - Param = 3, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 清账退卡 96 15:57:59 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 97 15:57:59 SQL Data In: ORACLE - Param = 5, Name = PJYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 98 15:57:59 SQL Data In: ORACLE - Param = 6, Name = PQTCS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 99 15:57:59 SQL Data In: ORACLE - Param = 7, Name = PCXLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 100 15:57:59 SQL Data In: ORACLE - Param = 8, Name = PTKJLS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 101 15:57:59 SQL Data In: ORACLE - Param = 9, Name = PTKJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 102 15:57:59 SQL Data In: ORACLE - Param = 10, Name = PERRSTR, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 103 15:57:59 SQL Data In: ORACLE - Param = 11, Name = PXTCS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = R 104 15:57:59 SQL Execute: ORACLE - BEGIN "SP_SF_PAY_TKDATA" (PBRID00 => :PBRID00,PZFFS00 => :PZFFS00,PZFFSMC => :PZFFSMC,PMZZYBZ => :PMZZYBZ,PJYJE00 => :PJYJE00,PQTCS00 => :PQTCS00,PCXLSH0 => :PCXLSH0,PTKJLS0 => :PTKJLS0,PTKJE00 => :PTKJE00,PERRSTR => :PERRSTR,PXTCS00 => :PXTCS00); END; 105 15:57:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 20181109155800 106 15:57:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 107 15:57:59 SQL Execute: ORACLE - select ZFFS00,ZFFSMC,sum(TKJE00)TKJE00 from PAY_YJJ_MXCX where CXLSH0=? and BRID00=? group by ZFFS00,ZFFSMC order by ZFFS00 desc 108 15:58:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 20181109155800 109 15:58:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 110 15:58:05 SQL Execute: ORACLE - select CXLSH0,BRID00,ZFFS00,ZFFSMC,DDLSH0,JYLSH0,YKTSH0,TKDDH0,DJH000,TKJE00,STATE from PAY_YJJ_MXCX where CXLSH0=? and BRID00=? order by ZFFS00 desc,DJH000 desc 111 15:58:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 112 15:58:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 门诊结算清账退卡 113 15:58:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 114 15:58:05 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 115 15:58:05 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 116 15:58:05 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 117 15:58:05 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 118 15:58:05 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 119 15:58:05 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = R 120 15:58:05 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 121 15:58:05 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 122 15:58:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 123 15:58:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 门诊结算清账退卡 124 15:58:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 125 15:58:05 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 126 15:58:05 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 127 15:58:05 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 128 15:58:05 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 129 15:58:05 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 130 15:58:05 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = R 131 15:58:05 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 132 15:58:05 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 133 15:58:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 134 15:58:05 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=? 135 15:58:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2484.000000 136 15:58:05 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 7 and PJSYR0 = ? and SYBZ00 = 'Y' 137 15:58:05 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1911163.000000 138 15:58:05 SQL Data In: ORACLE - Param = 2, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2484.000000 139 15:58:05 SQL Data In: ORACLE - Param = 3, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员 140 15:58:05 SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 141 15:58:05 SQL Data In: ORACLE - Param = 5, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -50.590000 142 15:58:05 SQL Data In: ORACLE - Param = 6, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 143 15:58:05 SQL Data In: ORACLE - Param = 7, Name = AD_BJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 144 15:58:05 SQL Data In: ORACLE - Param = 8, Name = AD_TYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 145 15:58:05 SQL Data In: ORACLE - Param = 9, Name = AD_YXQFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 146 15:58:05 SQL Data In: ORACLE - Param = 10, Name = AS_ZFFSMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 147 15:58:05 SQL Data In: ORACLE - Param = 11, Name = AS_ZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 148 15:58:05 SQL Data In: ORACLE - Param = 12, Name = AS_ZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 149 15:58:05 SQL Data In: ORACLE - Param = 13, Name = AS_ZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 150 15:58:05 SQL Data In: ORACLE - Param = 14, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 151 15:58:05 SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 152 15:58:05 SQL Data In: ORACLE - Param = 16, Name = AS_KTZZBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 153 15:58:05 SQL Data In: ORACLE - Param = 17, Name = AD_PJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 154 15:58:05 SQL Data In: ORACLE - Param = 18, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 155 15:58:05 SQL Data In: ORACLE - Param = 19, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 156 15:58:05 SQL Data In: ORACLE - Param = 20, Name = AS_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 157 15:58:05 SQL Data In: ORACLE - Param = 21, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 158 15:58:05 SQL Data In: ORACLE - Param = 22, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 539.000000 159 15:58:05 SQL Execute: ORACLE - BEGIN "SP_SF_BRZHXX" (AD_BRID00 => :AD_BRID00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_JFLBMC => :AS_JFLBMC,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_BJJE00 => :AD_BJJE00,AD_TYJE00 => :AD_TYJE00,AD_YXQFJE => :AD_YXQFJE,AS_ZFFSMC => :AS_ZFFSMC,AS_ZPH000 => :AS_ZPH000,AS_ZPKHYH => :AS_ZPKHYH,AS_ZPDWMC => :AS_ZPDWMC,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_KTZZBZ => :AS_KTZZBZ,AD_PJH000 => :AD_PJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_COMMIT => :AS_COMMIT,AS_ZPZH00 => :AS_ZPZH00,AD_CZYKS0 => :AD_CZYKS0); END; 160 15:58:07 SQL Execute: ORACLE - select BRZJBH,brid00 from BM_BRXXB0 where BRBLH0='*1165290' and BRZJLX='身份证' 161 15:58:07 SQL Execute: ORACLE - SELECT a.*,decode('N','Y','补打:','N',' ') SFBD00 FROM VW_SF_BRJFXX a where a.DJH000=15578033 162 15:58:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 163 15:58:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 164 15:58:08 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 165 15:58:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 166 15:58:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 167 15:58:08 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 168 15:58:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 169 15:58:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 170 15:58:08 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 171 15:58:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 172 15:58:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 173 15:58:08 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 174 15:58:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 175 15:58:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 176 15:58:08 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 177 15:58:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 178 15:58:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 179 15:58:08 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 180 15:58:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 181 15:58:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 182 15:58:08 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 183 15:58:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 184 15:58:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 185 15:58:08 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 186 15:58:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 187 15:58:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 188 15:58:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 189 15:58:08 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 190 15:58:08 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 191 15:58:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 192 15:58:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 193 15:58:08 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 194 15:58:29 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 195 15:58:29 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1911163 196 15:58:29 SQL Data In: ORACLE - Param = 3, Name = PICKH00, Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT10310024105 197 15:58:29 SQL Data In: ORACLE - Param = 4, Name = PYGBH00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484 198 15:58:29 SQL Data In: ORACLE - Param = 5, Name = PKL0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 199 15:58:29 SQL Data In: ORACLE - Param = 6, Name = POLDICK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 200 15:58:29 SQL Data In: ORACLE - Param = 7, Name = PSKBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 201 15:58:29 SQL Data In: ORACLE - Param = 8, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484 202 15:58:29 SQL Data In: ORACLE - Param = 9, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 539 203 15:58:29 SQL Data In: ORACLE - Param = 10, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 204 15:58:29 SQL Data In: ORACLE - Param = 11, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 205 15:58:29 SQL Data In: ORACLE - Param = 12, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 206 15:58:29 SQL Data In: ORACLE - Param = 13, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 207 15:58:29 SQL Data In: ORACLE - Param = 14, Name = Pyybr00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 208 15:58:29 SQL Data In: ORACLE - Param = 15, Name = Psfsqyj, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 209 15:58:29 SQL Data In: ORACLE - Param = 16, Name = Psfybhk, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 210 15:58:29 SQL Execute: ORACLE - BEGIN "SP_SF_BRZHXX_ICKF00" (POPFLAG => :POPFLAG,PBRID00 => :PBRID00,PICKH00 => :PICKH00,PYGBH00 => :PYGBH00,PKL0000 => :PKL0000,POLDICK => :POLDICK,PSKBZ00 => :PSKBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,Pyybr00 => :Pyybr00,Psfsqyj => :Psfsqyj,Psfybhk => :Psfybhk); END; 211 15:58:29 SQL Execute: ORACLE - commit 212 15:58:29 SQL Data In: ORACLE - Rows affected = 0 213 15:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2484.000000 214 15:58:29 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 = ? and SYBZ00 = 'Y' 215 15:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2484.000000 216 15:58:29 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 = ? and SYBZ00 = 'Y' 217 15:58:35 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 218 15:58:35 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='4' 219 15:58:35 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 220 15:58:35 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 221 15:58:36 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,2484,'管理员','192.168.4.183','F4-4D-30-B3-68-31','4','ACT_MZSF_MZKCZ0','266068') 222 15:58:36 SQL Data In: ORACLE - Rows affected = 1 223 15:58:36 SQL Execute: ORACLE - Commit 224 15:58:36 SQL Data In: ORACLE - Rows affected = 0 225 15:58:37 SQL Execute: ORACLE - Select SYSDATE from Dual 226 15:58:37 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 227 15:58:37 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') 228 15:58:37 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBPT10310024105' and ICKNBH = 'PTYBPT10310024105' 229 15:58:37 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 where ICKH00 = 'PTYBPT10310024105' 230 15:58:37 SQL Execute: ORACLE - select a.* from VW_IC_YHXXB0 a where 1 = 1 and ICKH00 = 'PTYBPT10310024105' 231 15:58:37 SQL Execute: ORACLE - select * from VW_SF_ICYWLS where ICKNBH = '' order by YWID00 desc 232 15:58:40 SQL Execute: ORACLE - Select SYSDATE from Dual 233 15:58:40 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 234 15:58: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') 235 15:58:40 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBPT10310024105' and ICKNBH = 'PTYBPT10310024105' 236 15:58:40 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 where ICKH00 = 'PTYBPT10310024105' 237 15:58:40 SQL Execute: ORACLE - select a.* from VW_IC_YHXXB0 a where 1 = 1 and ICKH00 = 'PTYBPT10310024105' 238 15:58:40 SQL Execute: ORACLE - select * from VW_SF_ICYWLS where ICKNBH = '' order by YWID00 desc 239 15:58:41 SQL Execute: ORACLE - Select SYSDATE from Dual 240 15:58:41 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 241 15:58:41 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') 242 15:58:41 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBPT10310024105' and ICKNBH = 'PTYBPT10310024105' 243 15:58:41 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 where ICKH00 = 'PTYBPT10310024105' 244 15:58:41 SQL Execute: ORACLE - select a.* from VW_IC_YHXXB0 a where 1 = 1 and ICKH00 = 'PTYBPT10310024105' 245 15:58:41 SQL Execute: ORACLE - select * from VW_SF_ICYWLS where ICKNBH = '' order by YWID00 desc 246 15:58:45 SQL Execute: ORACLE - Select SYSDATE from Dual 247 15:58:45 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 248 15:58:45 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') 249 15:58:45 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBPT10310024105' and ICKNBH = 'PTYBPT10310024105' 250 15:58:45 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 where ICKH00 = 'PTYBPT10310024105' 251 15:58:45 SQL Execute: ORACLE - select a.* from VW_IC_YHXXB0 a where 1 = 1 and ICKH00 = 'PTYBPT10310024105' 252 15:58:45 SQL Execute: ORACLE - select * from VW_SF_ICYWLS where ICKNBH = '' order by YWID00 desc