1 17:24:46 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 2 17:24:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 3 17:24:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 4 17:24:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 5 17:24:53 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000022467 6 17:24:53 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 7 17:24:53 SQL Execute: ORACLE - select A.*,D.CZYXM0 from zy_fymx00 A,bm_yysfxm B,bm_fpxm00 C,zy_brfy00 D where A.XMBH00 = B.SFXMID and B.ZYFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = ? and D.JFLBID = ? and D.ZYID00 = ? and (D.ZYH000= ? or D.ZYH000 = '0' ) and B.ZYFPID = ? order by D.CZRQ00 desc 8 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 9 17:24:54 SQL Execute: ORACLE - select SF_ZY_SFQYDBZJK(?)SFQYBZ FROM dual 10 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 11 17:24:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 12 17:24:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 13 17:24:54 SQL Execute: ORACLE - select SF_ZY_DBZJE00(?,?,?) DBZJE0 FROM dual 14 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 15 17:24:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 16 17:24:54 SQL Execute: ORACLE - select SF_ZY_GetYYKSBM(?,?)YYKSBM from dual 17 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 18 17:24:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 19 17:24:54 SQL Execute: ORACLE - select SF_ZY_GetYYKSBM(?,?)YYKSBM from dual 20 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 21 17:24:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 福建省两费中心 22 17:24:54 SQL Execute: ORACLE - select SF_ZY_FSDYLX(?,?) FHLX00 from dual 23 17:24:54 SQL Execute: ORACLE - select FBBH00 from ZY_BRXXB0 where ZYID00=51457307 24 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1648.000000 25 17:24:54 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 3 and PJSYR0 = ? and SYBZ00 = 'Y' 26 17:24:54 SQL Execute: ORACLE - select SF_ZY_SFXYYBSP(51457307) from dual 27 17:24:54 SQL Execute: ORACLE - select XMMC00,SL0000,HJJE00, nvl((select count(*) from YK_YBMLSP where ZYID00=d.ZYID00 and SFXMID=d.XMBH00 and ZFRQ00='20991231' and JSSYRQ>=to_char(sysdate,'YYYYMMDD')),0) SPBZ00 from ( select b.ZYID00,a.XMBH00,a.XMMC00,sum(XMSL00) SL0000,sum(a.HJJE00) HJJE00 from ZY_FYMX00 a,ZY_BRFY00 b,BM_YYSFXM c where b.ZYID00=51457307 and a.DJH000=b.DJH000 and a.XMBH00=c.SFXMID and c.JSXM00='2' and b.JZDH00=0 and a.XMDJ00>=1000 group by b.ZYID00,a.XMBH00,a.XMMC00 ) d 28 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 29 17:24:54 SQL Execute: ORACLE - select * from bm_brxxb0 where brid00=? and yblb00='3' and ybbrlb='4' 30 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 31 17:24:54 SQL Execute: ORACLE - select * from bq_brzdxx where zdlb00='3' and zyid00= ? 32 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 33 17:24:54 SQL Execute: ORACLE - select count(*) NUM from zy_brxxb0 where ZYID00=? and BRZT00 = '3' 34 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 35 17:24:54 SQL Execute: ORACLE - select count(*) NUM from yf_zycf00 where BCCFH0 is null and ZYID00=? and CFZT00 = '0' 36 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 37 17:24:54 SQL Execute: ORACLE - select count(*) NUM from yf_zycf00 where ZYID00=? and CFZT00='1' and SFKSLY='N' 38 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 39 17:24:54 SQL Execute: ORACLE - select count(*) NUM from VW_ZY_YJYW00 where cxdjh0 is null and ZYID00=? and ZJE000<>0 40 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 41 17:24:54 SQL Execute: ORACLE - select count(*) NUM from YF_YZYPSQ where ZYID00 =? and QLZT00='0' and CXBZ00 = 'Z' 42 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 43 17:24:54 SQL Execute: ORACLE - select sum(hjje00) NUM from zy_brfy00 where ZYID00=? 44 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 45 17:24:54 SQL Execute: ORACLE - select count(*) NUM from ZY_BRZHXX where BRID00 =? and SFDJ00 <> '2' and JFLBID <> 0 46 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 出院结算 47 17:24:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 48 17:24:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 49 17:24:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000022467 50 17:24:54 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20010709 51 17:24:54 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 52 17:24:54 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 53 17:24:54 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部 54 17:24:54 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 55 17:24:54 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 56 17:24:54 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 57 17:24:54 SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 58 17:24:54 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28812.940000 59 17:24:54 SQL Execute: ORACLE - select SF_ZY_CHECK_CYJSDATA(?,?,?,?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 60 17:24:54 SQL Execute: ORACLE - select SF_ZY_BRRYLBXX('2','51457307') RYLB00 from dual 61 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000022467 62 17:24:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 63 17:24:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 64 17:24:54 SQL Execute: ORACLE - select SF_ZY_ZRZYFY(?,?,?)FHXX00 from dual 65 17:24:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350102192911220459 66 17:24:54 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 67 17:24:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 68 17:24:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 69 17:24:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 70 17:24:55 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 71 17:24:55 SQL Execute: ORACLE - select SF_ZY_GETYWLSH0(?,?,?,?) AS FHXX00 from dual 72 17:24:55 SQL Execute: ORACLE - select YBZXLB,SFXNH0 from ic_ybbrlb where YBLB00 = '3' 73 17:24:55 SQL Execute: ORACLE - select trim(BH0000)||'→'||MC0000 TSBZ00 from BM_TSBZB0 where TSBZFL<>'2' and YBZXLB = '3' and nvl(MZZYBZ,'2') in ('1','2') and nvl(ZT0000,'0') <> '1' 74 17:24:56 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 75 17:24:56 SQL Execute: ORACLE - select b.SFXNH0 from zy_brxxb0 a,ic_ybbrlb b where a.yblb00=b.yblb00 and a.fbbh00=b.fbbh00 and a.zyid00=51457307 76 17:24:56 SQL Execute: ORACLE - select to_date(case when SJCYRQ is null or SJCYRQ='' or SJCYRQ='20991231' then nvl(CYRQ00,to_char(sysdate,'yyyymmdd')) else SJCYRQ end,'yyyymmdd') - to_date(nvl(SJRYRQ,RYRQ00),'yyyymmdd')+1 PTBCTS from ZY_BRXXB0 where ZYID00='51457307' 77 17:24:56 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 78 17:24:56 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 79 17:24:56 SQL Data In: ORACLE - Param = 3, Name = PZYH000, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 000022467 80 17:24:56 SQL Data In: ORACLE - Param = 4, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 81 17:24:56 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1648.000000 82 17:24:56 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈静霆 83 17:24:56 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 673.000000 84 17:24:56 SQL Data In: ORACLE - Param = 8, Name = PCZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 85 17:24:56 SQL Data In: ORACLE - Param = 9, Name = PFYCFLX, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 8 86 17:24:56 SQL Data In: ORACLE - Param = 10, Name = PTYPE00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 出院结算 87 17:24:56 SQL Data In: ORACLE - Param = 11, Name = PQTCS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 88 17:24:56 SQL Data In: ORACLE - Param = 12, Name = PHJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28812.940000 89 17:24:56 SQL Data In: ORACLE - Param = 13, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 90 17:24:56 SQL Data In: ORACLE - Param = 14, Name = PZXZT00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 91 17:24:56 SQL Data In: ORACLE - Param = 15, Name = PZFHJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 92 17:24:56 SQL Data In: ORACLE - Param = 16, Name = PYBHJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 93 17:24:56 SQL Data In: ORACLE - Param = 17, Name = PFKLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 94 17:24:56 SQL Data In: ORACLE - Param = 18, Name = PNDJSXX, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 95 17:24:56 SQL Data In: ORACLE - Param = 19, Name = POUTSTR, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 96 17:24:56 SQL Data In: ORACLE - Param = 20, Name = PERCODE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 97 17:24:56 SQL Data In: ORACLE - Param = 21, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 98 17:24:56 SQL Execute: ORACLE - BEGIN "SP_ZY_FYJS00_FYCFJS" (PBRID00 => :PBRID00,PZYID00 => :PZYID00,PZYH000 => :PZYH000,PJZDH00 => :PJZDH00,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PCZLX00 => :PCZLX00,PFYCFLX => :PFYCFLX,PTYPE00 => :PTYPE00,PQTCS00 => :PQTCS00,PHJJE00 => :PHJJE00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PZFHJJE => :PZFHJJE,PYBHJJE => :PYBHJJE,PFKLSH0 => :PFKLSH0,PNDJSXX => :PNDJSXX,POUTSTR => :POUTSTR,PERCODE => :PERCODE,PERRMSG => :PERRMSG); END; 99 17:24:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 100 17:24:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000022467 101 17:24:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 102 17:24:56 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 103 17:24:56 SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0)HJJE00, nvl(sum(NVL(ZFJE00,0)),0)ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0)GFJE00,min(djh000) qsdjh0,max(djh000) zzdjh0 from zy_brfy00 where JZDH00+0 = 0 and JFLBID = ? and zyh000= ? and ZYID00 = ? and BRID00 = ? 104 17:24:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 105 17:24:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 106 17:24:56 SQL Execute: ORACLE - select * from zy_brzhxx where 1 = 1 and JFLBID = ? and BRID00 = ? 107 17:24:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 108 17:24:56 SQL Execute: ORACLE - select * from ZY_BRJFB0 A where A.JZDH00+0 = 0 and JFLBID = 2 and A.BRID00 =? and A.JFBZ00 <> '2' 109 17:24:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 110 17:24:57 SQL Execute: ORACLE - select A.*, B.PJXH00 from ZY_BRJFB0 A, ZY_PJSYQK B where A.PJH000 = B.PJH000 and B.PLBH00 in (4,8) and A.JZDH00+0 = 0 and JFLBID = 2 and A.BRID00 =? and A.JFBZ00 <> '2' 111 17:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 112 17:24:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 113 17:24:58 SQL Execute: ORACLE - select count(*) ZJL,nvl(sum(decode(sign(B.HJJE00),-1,1,0)),0) CXJL from zy_brxxb0 A,ZY_JZB000 B where A.BRID00=B.BRID00 and A.ZYID00=B.ZYID00 AND A.BRID00=? AND A.ZYID00=? and ((b.yexm00 is null) or (b.yexm00='全部') or (b.yexm00='母亲') ) 114 17:24:58 SQL Data In: ORACLE - Param = 1, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 115 17:24:58 SQL Data In: ORACLE - Param = 2, Name = AS_QSRQ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 116 17:24:58 SQL Data In: ORACLE - Param = 3, Name = AS_ZZRQ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 117 17:24:58 SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 福建省两费中心 118 17:24:58 SQL Data In: ORACLE - Param = 5, Name = AS_CLJKGC, Type = fldZSTRING, Precision = 19, Scale = 0, Data = SP_ZY_ZYSF00_YBJK01 119 17:24:58 SQL Data In: ORACLE - Param = 6, Name = AD_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部 120 17:24:58 SQL Data In: ORACLE - Param = 7, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 121 17:24:58 SQL Data In: ORACLE - Param = 8, Name = AD_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44622520.000000 122 17:24:58 SQL Data In: ORACLE - Param = 9, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44880146.000000 123 17:24:58 SQL Data In: ORACLE - Param = 10, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 124 17:24:58 SQL Data In: ORACLE - Param = 11, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 125 17:24:58 SQL Execute: ORACLE - BEGIN "SP_ZY_WSPYPTS" (AD_JZDH00 => :AD_JZDH00,AS_QSRQ00 => :AS_QSRQ00,AS_ZZRQ00 => :AS_ZZRQ00,AS_YBMC00 => :AS_YBMC00,AS_CLJKGC => :AS_CLJKGC,AD_YEXM00 => :AD_YEXM00,AD_ZYID00 => :AD_ZYID00,AD_QSDJH0 => :AD_QSDJH0,AD_ZZDJH0 => :AD_ZZDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 126 17:24:58 SQL Data In: ORACLE - Param = 1, Name = AD_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44622520.000000 127 17:24:58 SQL Data In: ORACLE - Param = 2, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44880146.000000 128 17:24:58 SQL Data In: ORACLE - Param = 3, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 129 17:24:58 SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 福建省两费中心 130 17:24:58 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 131 17:24:58 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 132 17:24:58 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 133 17:24:58 SQL Data In: ORACLE - Param = 8, Name = ad_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部 134 17:24:58 SQL Data In: ORACLE - Param = 9, Name = ad_DBZBM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 135 17:24:58 SQL Data In: ORACLE - Param = 10, Name = ad_DDLSH0, Type = fldZSTRING, Precision = 26, Scale = 0, Data = FYCF2022121517245751457307 136 17:24:58 SQL Data In: ORACLE - Param = 11, Name = as_SFXYB0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 137 17:24:58 SQL Data In: ORACLE - Param = 12, Name = as_FKJSLX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 138 17:24:58 SQL Data In: ORACLE - Param = 13, Name = ad_FKJZDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 139 17:24:58 SQL Data In: ORACLE - Param = 14, Name = as_FKLSH0, Type = fldZSTRING, Precision = 26, Scale = 0, Data = FYCF2022121517245751457307 140 17:24:58 SQL Data In: ORACLE - Param = 15, Name = ad_FKJZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 141 17:24:58 SQL Data In: ORACLE - Param = 16, Name = as_INTXML, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 142 17:24:58 SQL Data In: ORACLE - Param = 17, Name = as_YBTYPE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 143 17:24:58 SQL Execute: ORACLE - BEGIN "SP_ZY_ZYSF00_YBJK01" (AD_QSDJH0 => :AD_QSDJH0,AD_ZZDJH0 => :AD_ZZDJH0,AD_JZDH00 => :AD_JZDH00,AS_YBMC00 => :AS_YBMC00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,ad_YEXM00 => :ad_YEXM00,ad_DBZBM0 => :ad_DBZBM0,ad_DDLSH0 => :ad_DDLSH0,as_SFXYB0 => :as_SFXYB0,as_FKJSLX => :as_FKJSLX,ad_FKJZDH => :ad_FKJZDH,as_FKLSH0 => :as_FKLSH0,ad_FKJZJE => :ad_FKJZJE,as_INTXML => :as_INTXML,as_YBTYPE => :as_YBTYPE); END; 144 17:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 145 17:24:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 146 17:24:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 147 17:24:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 148 17:24:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 149 17:24:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 150 17:24:58 SQL Execute: ORACLE - select SF_ZY_BQBM00_DBZBM0(?,?,?,?,?,?)FHXX00 from dual 151 17:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2766475.000000 152 17:24:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51457307.000000 153 17:24:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 154 17:24:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 155 17:24:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 156 17:24:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 157 17:24:58 SQL Execute: ORACLE - select SF_ZY_BQBM00_DBZBM0(?,?,?,?,?,?)FHXX00 from dual 158 17:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5676073.000000 159 17:24:58 SQL Execute: ORACLE - select COUNT(*) NUM, NVL(SUM(XMJE00),0) AMOUNT from BM_ZYCFMX_TEMP00 where ID0000 = ? 160 17:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5676073.000000 161 17:24:58 SQL Execute: ORACLE - select * from BM_ZYCF00_TEMP00 where ID0000 = ? and BZ0000 = 'Y' 162 17:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5676073.000000 163 17:24:58 SQL Execute: ORACLE - select * from BM_ZYCF00_TEMP00 where ID0000 = ? and BZ0000 = 'N' 164 17:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5676073.000000 165 17:24:58 SQL Execute: ORACLE - select * from BM_ZYCFMX_TEMP00 where ID0000 = ? 166 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 167 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 168 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 169 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 170 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 171 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 172 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 173 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 174 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 175 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 176 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 177 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 178 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 179 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 180 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 181 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 182 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 183 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 184 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 185 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 186 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 187 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 188 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 189 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 190 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 191 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 192 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 193 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 194 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 195 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 196 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 197 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 198 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 199 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 200 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 201 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 202 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 203 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 204 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 205 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 206 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 207 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 208 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 209 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 210 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 211 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 212 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 213 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 214 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 215 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 216 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 217 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 218 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 219 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 220 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 221 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 222 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 223 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 224 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 225 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 226 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 227 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 228 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 229 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 230 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 231 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 232 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 233 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 234 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 235 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 236 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 237 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 238 17:24:58 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 239 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 240 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 241 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 242 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 243 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 244 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 245 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 246 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 247 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 248 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 249 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 250 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 251 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 252 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 253 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 254 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 255 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 256 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 257 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 258 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 259 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 260 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 261 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 262 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 263 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 264 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 265 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 266 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 267 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 268 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 269 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 270 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 271 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 272 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 273 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 274 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 275 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 276 17:24:59 SQL Execute: ORACLE - Select * from ZY_XMFSDY where MRFS00='1' order by PXXH00 277 17:25:06 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 278 17:25:16 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 279 17:25:26 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 280 17:25:36 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 281 17:25:46 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 282 17:25:56 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 283 17:26:06 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 284 17:26:12 SQL Execute: ORACLE - RollBack 285 17:26:12 SQL Data In: ORACLE - Rows affected = 0 286 17:26:16 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 287 17:26:26 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null) 288 17:26:36 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673') AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null)