1 09:56:57 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 2 09:56:57 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 3 09:58:02 SQL Execute: ORACLE - Select SYSDATE from Dual 4 09:58:02 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') 5 09:58:02 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 6 09:58:04 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='FZYBK58273787' and ICKNBH ='FZYBK58273787' 7 09:58:04 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =121340 8 09:58:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBK58273787 9 09:58:04 SQL Execute: ORACLE - select brid00 from ic_yhxx00 where ickh00 = ? and ZT0000=1 10 09:58:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBK58273787 11 09:58:04 SQL Execute: ORACLE - select brid00 from ic_yhxx00 where ickh00 = ? and ZT0000=1 12 09:58:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBK58273787 13 09:58:04 SQL Execute: ORACLE - select brid00 from ic_yhxx00 where ickh00 = ? and ZT0000=1 14 09:58:04 SQL Execute: ORACLE - select * from ( select * from VW_SF_BRGH00 A where SFYY00 = 'N' and THRQ00 is null and BRID00 = 121340 and GHRQ00 > to_char(trunc(SysDate-1/4)-GHYXTS,'YYYYMMDD' ) and GHRQ00 >= '20221213' and GHRQ00 <= '20221213' ) order by ghh000 desc 15 09:58:04 SQL Execute: ORACLE - select ICKH00 from ic_yhxx00 where brid00 = 121340 and ZT0000 = '1' 16 09:58:04 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 17 09:58:04 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 18 09:58:04 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 19 09:58:04 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 20 09:58:05 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 21 09:58:05 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 22 09:58:05 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 23 09:58:05 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 24 09:58:05 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 25 09:58:05 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 26 09:58:06 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 27 09:58:06 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 28 09:58:06 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 29 09:58:06 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 30 09:58:06 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 31 09:58:06 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 32 09:58:06 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 33 09:58:06 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 34 09:58:06 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 35 09:58:06 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='121340' AND GHH000='959460' and ZJE000<>0 36 09:58:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 37 09:58:06 SQL Execute: ORACLE - select SF_SF_ZHYJJYEJY(?) FHJG00 from dual 38 09:58:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 39 09:58:06 SQL Execute: ORACLE - select b.GHQXBZ from sf_brxxb0 a,BM_GHLBB0 b where a.GHLB00=b.LBBH00 AND GHH000 = ? 40 09:58:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 41 09:58:06 SQL Execute: ORACLE - select a.YBID00,a.YBKH00,a.yblb00,b.sfxnh0 from bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.BRID00 = ? 42 09:58:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 43 09:58:06 SQL Execute: ORACLE - select SF_SF_ZHYJJYEJY(?) FHJG00 from dual 44 09:58:06 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 =535 and SYBZ00 = 'Y' 45 09:58:06 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='MZPY_SFKQBYJFY' 46 09:58:06 SQL Execute: ORACLE - select * from VW_BM_NEWYBJK_YBJKLX where SFYX00='1' and 1=1 order by XSXH00 47 09:58:06 SQL Execute: ORACLE - select VALUE0,SXMC00 from BM_YBSXZD where JKBM00=1 and sxbm00='bke284' and SFYX00='1' order by VALUE0 48 09:58:06 SQL Execute: ORACLE - select VALUE0,nvl(JKDZMC,SXMC00)SXMC00 from BM_YBSXZD where JKBM00=1 and sxbm00='bke284' and SFYX00='1' and JKDZBM is not null order by VALUE0 49 09:58:06 SQL Execute: ORACLE - select * from bm_brjflb where jflbid in (0,1) 50 09:58:06 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='SF_FYSFSYZDBYJ' 51 09:58:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 52 09:58:06 SQL Execute: ORACLE - select * from bm_brxxb0 where brid00 = ? 53 09:58:06 SQL Execute: ORACLE - select * from ic_ybbrlb where YBLB00 = '1' and FBBH00=3 54 09:58:06 SQL Execute: ORACLE - select * from bm_ybbrlb where YBZXLB = '1' and YBBRLB ='6' 55 09:58:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 56 09:58:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 57 09:58:06 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 58 09:58:06 SQL Execute: ORACLE - select SF_SF_NEWYBJK_OPEN(?,?,?) as FHXX00 from dual 59 09:58:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 60 09:58:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 61 09:58:06 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 62 09:58:06 SQL Execute: ORACLE - select SF_SF_FSDYLX(?,?,?) FSDYLX from dual 63 09:58:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 64 09:58:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 65 09:58:06 SQL Execute: ORACLE - select distinct a.tsbzbh bh0000,a.tsbzmc mc0000 from VW_SF_YBTZBZ A where 1=1 and a.djh000+0=0 and A.BRID00 = ? and trim(a.tsbzbh) is not null and a.GHH000= ? 66 09:58:06 SQL Execute: ORACLE - select GHID00,BRID00 from sf_brxxb0 where GHH000 = '959460' 67 09:58:06 SQL Execute: ORACLE - select * from VW_SF_YBTZBZ where ghid00=2556080 and 1=2 68 09:58:06 SQL Execute: ORACLE - select YBZXLB from ic_ybbrlb where FBBH00='3' and YBLB00 = '1' 69 09:58:06 SQL Execute: ORACLE - select BH0000||'→'||MC0000 TSBZ00,BH0000 from BM_TSBZB0 where YBZXLB = '1' and nvl(MZZYBZ,'2') in ('0','2') and nvl(ZT0000,'0') <> '1' order by lpad(trim(nvl(PXZD00,'ZZZ')),3,'0'), BH0000 70 09:58:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 71 09:58:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 72 09:58:07 SQL Execute: ORACLE - select count(1) TsbzNum from VW_SF_YBTZBZ A where 1=1 and a.djh000+0=0 and A.BRID00 = ? and trim(a.tsbzbh) is not null and a.GHH000= ? 73 09:58:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 74 09:58:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 75 09:58:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 76 09:58:07 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 77 09:58:07 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 78 09:58:07 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 959460 79 09:58:07 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 80 09:58:07 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 81 09:58:07 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 82 09:58:07 SQL Execute: ORACLE - select SF_SF_SFMRYBJS(?,?,?,?,?,?,?,?,?) FSLX00 from dual 83 09:58:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 84 09:58:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 85 09:58:07 SQL Execute: ORACLE - select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ? and cfyjbz = '0' and A.GHH000 = ? 86 09:58:07 SQL Execute: ORACLE - update YF_MZCF00 A SET SFXJJZ='0' where A.SFXJJZ='1' and A.BCCFH0 is null and A.CFZT00 = '0' and A.CFLSH0 in ('1345033 ') 87 09:58:07 SQL Data In: ORACLE - Rows affected = 0 88 09:58:07 SQL Execute: ORACLE - commit 89 09:58:07 SQL Data In: ORACLE - Rows affected = 0 90 09:58:07 SQL Execute: ORACLE - select SF_MZ_PSCFYS('959460','1345033 ') NFJJ00 from dual 91 09:58:07 SQL Execute: ORACLE - select * from VW_SF_CFMX00 where CFLSH0 in ('1345033 ') 92 09:58:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10006.000000 93 09:58:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 94 09:58:07 SQL Execute: ORACLE - select B.XMMC00 YBXMMC,A.* from VW_SF_YBSFDY A,BM_YBSFXM B where A.YBXMBH = B.XMBH00 and A.YBZXLB = B.YBZXLB and A.SFXMID =? and A.YBZXLB=? and A.SFYP00 ='Y' 95 09:58:07 SQL Execute: ORACLE - select * from YF_MZCF00 where CFLSH0 in ('1345033 ') 96 09:58:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 97 09:58:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 98 09:58:07 SQL Execute: ORACLE - select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ? and cfyjbz = '1' and A.GHH000 = ? 99 09:58:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 100 09:58:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 101 09:58:07 SQL Execute: ORACLE - select B.JFLBMC,A.* from sf_brzhxx A,BM_BRJFLB B where A.JFLBID = B.JFLBID and A.JFLBID = ? and BRID00 = ? 102 09:58:07 SQL Execute: ORACLE - select a.*,(select FBMC00 from BM_BRFBB0 where FBBH00=a.FBBH00 ) FBMC00 from bm_ybbrlb a,SF_BRXXB0 b where instr(',N,',','||to_char(a.FBBH00)||',')>0 and MZZFSX>0 and b.GHID00=2556080 and a.FBBH00=b.FBBH00 103 09:58:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 104 09:58:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 105 09:58:07 SQL Execute: ORACLE - Select (nvl(sum(HJJE00),0)-nvl(sum(ybyl19),0)) HJJE00 from sf_jzb000 where BRID00=? and JZRQ00=? and FBBH00=3 AND YBDJH0<>'0' 106 09:58:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 107 09:58:07 SQL Execute: ORACLE - select SF_SF_MSZFKQ(?)FHJG00 from dual 108 09:58:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 109 09:58:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 110 09:58:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 111 09:58:07 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 112 09:58:07 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 113 09:58:07 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 114 09:58:07 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?,?,?)SFZRZY from dual 115 09:58:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 116 09:58:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 117 09:58:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 118 09:58:07 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 119 09:58:07 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 120 09:58:07 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 121 09:58:07 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?,?,?)SFZRZY from dual 122 09:58:07 SQL Execute: ORACLE - select SF_SF_GETMZZD(2556080) ZDMC00 from dual 123 09:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 124 09:58:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 125 09:58:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2556080.000000 126 09:58:18 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 127 09:58:18 SQL Execute: ORACLE - select SF_SF_GETYWLSH0(?,?,?,?) AS FHXX00 from dual 128 09:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 129 09:58:18 SQL Execute: ORACLE - select b.SFXNH0,b.FBBH00,b.YBZXLB,b.ybmc00 from bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.brid00=? 130 09:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 131 09:58:18 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 132 09:58:18 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(121340,959460,0) YYKSBM from dual 133 09:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 134 09:58:18 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 135 09:58:18 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(121340,959460,1) YYKSBM from dual 136 09:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 137 09:58:18 SQL Execute: ORACLE - select b.SFXNH0,b.FBBH00,b.YBZXLB,b.ybmc00 from bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.brid00=? 138 09:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 139 09:58:18 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 140 09:58:18 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(121340,959460,0) YYKSBM from dual 141 09:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 142 09:58:18 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 143 09:58:18 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(121340,959460,1) YYKSBM from dual 144 09:58:18 SQL Execute: ORACLE - Select SYSDATE from Dual 145 09:58: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') 146 09:58: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 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 147 09:58:21 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='FZYBK58273787' and ICKNBH ='FZYBK58273787' 148 09:58:21 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =121340 149 09:58:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 150 09:58:21 SQL Execute: ORACLE - select tyje01 from VW_SF_BRZHXX where brid00= ? 151 09:58:21 SQL Execute: ORACLE - select * from VW_SF_YJYW00 where CXDJH0 is null and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = 121340 and YJDJH0 not in ( 0 ) and GHH000 = '959460' 152 09:58:21 SQL Execute: ORACLE - select SQ_SF_BRJFB0_DJH000.nextval DJH000 from dual 153 09:58:21 SQL Data In: ORACLE - Param = 1, Name = ad_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 154 09:58:21 SQL Data In: ORACLE - Param = 2, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6365796.000000 155 09:58:21 SQL Data In: ORACLE - Param = 3, Name = AD_JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.210000 156 09:58:21 SQL Data In: ORACLE - Param = 4, Name = ad_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 157 09:58:21 SQL Data In: ORACLE - Param = 5, Name = AS_BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 158 09:58:21 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 159 09:58:21 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 160 09:58:21 SQL Execute: ORACLE - BEGIN "SP_SF_YJCF00_QZFJE0" (ad_BRID00 => :ad_BRID00,AD_ID0000 => :AD_ID0000,AD_JE0000 => :AD_JE0000,ad_JZJE00 => :ad_JZJE00,AS_BZ0000 => :AS_BZ0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 161 09:58:21 SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1345033 162 09:58:21 SQL Data In: ORACLE - Param = 2, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9772860.000000 163 09:58:21 SQL Data In: ORACLE - Param = 3, Name = AD_SFCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 164 09:58:21 SQL Data In: ORACLE - Param = 4, Name = AS_SFQZF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 165 09:58:21 SQL Data In: ORACLE - Param = 5, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 166 09:58:21 SQL Data In: ORACLE - Param = 6, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 167 09:58:21 SQL Data In: ORACLE - Param = 7, Name = AS_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 535.000000 168 09:58:21 SQL Data In: ORACLE - Param = 8, Name = AS_ZYDJQT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 169 09:58:21 SQL Execute: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AD_SFCKBH => :AD_SFCKBH,AS_SFQZF0 => :AS_SFQZF0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_CZY000 => :AS_CZY000,AS_ZYDJQT => :AS_ZYDJQT); END; 170 09:58:21 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 171 09:58:21 SQL Data In: ORACLE - Param = 2, Name = AS_MZH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 959460 172 09:58:21 SQL Data In: ORACLE - Param = 3, Name = AD_MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2556080.000000 173 09:58:21 SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 174 09:58:21 SQL Data In: ORACLE - Param = 5, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 175 09:58:21 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 卢艇 176 09:58:21 SQL Data In: ORACLE - Param = 7, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 177 09:58:21 SQL Data In: ORACLE - Param = 8, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 535.000000 178 09:58:21 SQL Data In: ORACLE - Param = 9, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 公收费-乌 179 09:58:21 SQL Data In: ORACLE - Param = 10, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 180 09:58:21 SQL Data In: ORACLE - Param = 11, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9772860.000000 181 09:58:21 SQL Data In: ORACLE - Param = 12, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 182 09:58:21 SQL Data In: ORACLE - Param = 13, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 183 09:58:21 SQL Data In: ORACLE - Param = 14, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 184 09:58:21 SQL Data In: ORACLE - Param = 15, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 185 09:58:21 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 186 09:58:21 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 187 09:58:21 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_REG000" (AS_YBDJH0 => :AS_YBDJH0,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,AS_JFLBMC => :AS_JFLBMC,AD_BRID00 => :AD_BRID00,AS_XM0000 => :AS_XM0000,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_DJH000 => :AD_DJH000,AD_HJJE00 => :AD_HJJE00,AD_ZFJE00 => :AD_ZFJE00,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 188 09:58:21 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where brid00=121340 and ZT0000='1' 189 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9772860.000000 190 09:58:29 SQL Execute: ORACLE - select nvl(sum(hjje00),0) hjje00 from sf_brfy00 where djh000=? 191 09:58:29 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 192 09:58:29 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 193 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 535.000000 194 09:58:29 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 = ? and SYBZ00 = 'Y' 195 09:58:29 SQL Execute: ORACLE - select * from VW_BM_NEWYBJK_YBJKLX where SFYX00='1' and 1=1 order by XSXH00 196 09:58:29 SQL Execute: ORACLE - select VALUE0,SXMC00 from BM_YBSXZD where JKBM00=1 and sxbm00='bke284' and SFYX00='1' order by VALUE0 197 09:58:29 SQL Execute: ORACLE - select VALUE0,nvl(JKDZMC,SXMC00)SXMC00 from BM_YBSXZD where JKBM00=1 and sxbm00='bke284' and SFYX00='1' and JKDZBM is not null order by VALUE0 198 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 199 09:58:29 SQL Execute: ORACLE - select SF_SF_ZHYJJYEJY(?) FHJG00 from dual 200 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 201 09:58:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 202 09:58:29 SQL Execute: ORACLE - select A.*,B.JFLBMC,C.*,D.FBMC00,e.ybmc00,e.XYBJK0,nvl((select max(GHID00) from SF_BRXXB0 where BRID00=C.BRID00 and THRQ00 is null),0) GHID00 from sf_brzhxx A,BM_BRJFLB B,BM_BRXXB0 C,bm_brfbb0 D,ic_ybbrlb e where A.JFLBID = B.JFLBID and C.FBBH00 = D.FBBH00 and c.fbbh00=e.fbbh00 and c.yblb00=e.yblb00 and A.BRID00 = C.BRID00 and A.SFDJ00 <> '2' and A.BRID00 = ? and A.JFLBID = ? 203 09:58:29 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 204 09:58:29 SQL Execute: ORACLE - select SP_SF_TSBRXXTS('350104198501275430','') MSG000 from dual 205 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 206 09:58:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 207 09:58:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 208 09:58:29 SQL Execute: ORACLE - select SF_SF_FSDYLX(?,?,?) FSDYLX from dual 209 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 210 09:58:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYDBZJK 211 09:58:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 212 09:58:29 SQL Execute: ORACLE - select SF_SF_XTCS00_SFQYJK(?,?,?) FSDYLX from dual 213 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 214 09:58:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 215 09:58:29 SQL Execute: ORACLE - select * from ic_ybbrlb where YBLB00 = ? and FBBH00= ? 216 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 217 09:58:29 SQL Execute: ORACLE - select TBLBMC from VW_BM_BRXXB2 where BRID00 =? 218 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 219 09:58:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 220 09:58:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 221 09:58:29 SQL Execute: ORACLE - select max(GHID00) GHID00,max(SFZRZY)SFZRZY from SF_BRXXB0 A where 1 = 1 and A.BRID00 = ? and A.LBBH00 = ? and A.GHH000 = ? 222 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2556080.000000 223 09:58:29 SQL Execute: ORACLE - select NVL(max(A.YBGHH0),0) YBLSH0,NVL(max(A.SYGHH0),0)SYLSH0,NVL(max(A.BJGHH0),0)BJLSH0, max(C.BMMC00) GHKSMC,max(D.LBMC00) GHLBMC,max(A.GHH000) GHH000,max(C.bmbh00) GHKS00,max(a.GHRQ00)GHRQ00,max(A.YBGHHT) YBGHHT from SF_BRXXB0 A,SF_BRFY00 B,BM_BMBM00 C ,BM_GHLBB0 D where A.GHKS00 = C.BMBH00 and A.BRID00 = B.BRID00 and A.GHLB00 = D.LBBH00(+) and A.LBBH00 = B.JFLBID and B.JZDH00+0 = 0 and A.GHID00 = ? 224 09:58:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 225 09:58:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 226 09:58:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 227 09:58:29 SQL Execute: ORACLE - select SF_SF_NEWYBJK_OPEN(?,?,?) as FHXX00 from dual 228 09:58:30 SQL Execute: ORACLE - select SF_SF_GETMZZD(2556080) ZDMC00 from dual 229 09:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 230 09:58:30 SQL Execute: ORACLE - select a.fbbh00,a.brid00,b.ybzxlb from bm_brxxb0 a,ic_ybbrlb b where a.brid00 = ? and a.yblb00=b.yblb00 and a.fbbh00=b.fbbh00 231 09:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 232 09:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 233 09:58:30 SQL Execute: ORACLE - select MAX(A.GHID00)GHID00,NVL(max(A.YBGHH0),0) YBLSH0,NVL(max(A.SYGHH0),0)SYLSH0,NVL(max(A.BJGHH0),0)BJLSH0, max(C.BMMC00) GHKSMC,max(D.LBMC00) GHLBMC,max(A.GHH000) GHH000,max(C.bmbh00) GHKS00,max(a.GHRQ00)GHRQ00 from SF_BRXXB0 A,SF_BRFY00 B,BM_BMBM00 C ,BM_GHLBB0 D where A.GHKS00 = C.BMBH00 and A.BRID00 = B.BRID00 and A.GHLB00 = D.LBBH00(+) and A.LBBH00 = B.JFLBID and B.JZDH00+0 = 0 and A.GHH000=? and A.BRID00=? 234 09:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 235 09:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 236 09:58:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 237 09:58:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 238 09:58:30 SQL Execute: ORACLE - select distinct a.tsbzbh bh0000,a.tsbzmc mc0000 from VW_SF_YBTZBZ A,sf_brfy00 c where 1=1 and a.djh000=c.djh000 and c.jzdh00+0=0 and A.BRID00 = ? and trim(a.tsbzbh) is not null and c.CZRQ00>= ? and c.CZRQ00<= ? and c.MZH000=? 239 09:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 240 09:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 241 09:58:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 242 09:58:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 243 09:58:30 SQL Execute: ORACLE - select count(1) TsbzNum from VW_SF_YBTZBZ A,sf_brfy00 c where 1=1 and a.djh000=c.djh000 and c.jzdh00+0=0 and A.BRID00 = ? and trim(a.tsbzbh) is not null and c.CZRQ00>= ? and c.CZRQ00<= ? and c.MZH000=? 244 09:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 245 09:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 246 09:58:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 247 09:58:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 248 09:58:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 249 09:58:30 SQL Execute: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( D.MZH000 = ? or (D.MZH000='0' and '1'='1')) 250 09:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 251 09:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 252 09:58:30 SQL Execute: ORACLE - select sum(ZFJE00) ZFJE00,sum(JZJE00) JZJE00 FROM SF_BRFY00 WHERE BRID00=? and JZDH00+0=0 AND CXPJR0='999999' and ( MZH000 =?) 253 09:58:30 SQL Execute: ORACLE - update SF_BRFY00 SET CZRQ00='20221213' WHERE BRID00=121340 and JZDH00+0=0 AND CZRQ00='19990101' and ( MZH000 = '959460') 254 09:58:30 SQL Data In: ORACLE - Rows affected = 0 255 09:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.210000 256 09:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 257 09:58:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 258 09:58:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 259 09:58:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 260 09:58:30 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 261 09:58:30 SQL Execute: ORACLE - select 0 FPXMID,'合计' XMMC00, ? JE0000 from dual union all select C.FPXMID,C.XMMC00,sum(A.HJJE00) JE0000 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( D.MZH000 = ? or (D.MZH000='0' and '1'='1')) group by C.FPXMID, C.XMMC00 262 09:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 263 09:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 264 09:58:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 265 09:58:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 266 09:58:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 267 09:58:30 SQL Execute: ORACLE - select A.*,D.CZYXM0,D.MZH000,D.MZID00,(select CZRQ00 CXCZRQ from SF_BRFY00 where DJH000=D.CXDJH0 and BRID00=D.BRID00 and rownum=1) CXCZRQ,D.CXDJH0 from sf_fymx00 A,bm_yysfxm B,sf_brfy00 D where A.XMBH00 = B.SFXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( D.MZH000 = ? or (D.MZH000='0' and '1'='1')) 268 09:58:30 SQL Execute: ORACLE - select SF_SF_GETMZZD(2556080) ZDMC00 from dual 269 09:58:30 SQL Execute: ORACLE - select SF_SF_GETMZZD(2556080) ZDMC00 from dual 270 09:58:30 SQL Execute: ORACLE - select SF_SF_GETMZZD(2556080) ZDMC00 from dual 271 09:58:30 SQL Execute: ORACLE - select SF_SF_GETMZZD(2556080) ZDMC00 from dual 272 09:58:30 SQL Execute: ORACLE - select SF_SF_GETMZZD(2556080) ZDMC00 from dual 273 09:58:30 SQL Execute: ORACLE - select SF_SF_GETMZZD(2556080) ZDMC00 from dual 274 09:58:30 SQL Execute: ORACLE - select SF_SF_GETMZZD(2556080) ZDMC00 from dual 275 09:58:30 SQL Execute: ORACLE - select count(*) RCOUNT from BM_YYSFXM A where SFXMID in (-1,9999999997) and MZFPID<>'6' 276 09:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 277 09:58:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 278 09:58:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 279 09:58:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 280 09:58:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 281 09:58:30 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 959460 282 09:58:30 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 283 09:58:30 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 284 09:58:30 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 285 09:58:30 SQL Execute: ORACLE - select SF_SF_SFMRYBJS(?,?,?,?,?,?,?,?,?) FSLX00 from dual 286 09:58:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 287 09:58:30 SQL Execute: ORACLE - select SF_SF_MSZFKQ(?)FHJG00 from dual 288 09:58:30 SQL Execute: ORACLE - select b.MXNODE,b.JKCJMC,b.DJXS00,a.* from BM_TYJKBM a,BM_TYJKMX b where b.JKCJMC='收费' and a.JKBH00=b.JKBH00 and b.JKCJLB='0' and b.SFQY00='1' and a.SFQY00='1' and (a.QYKS00 is null or instr(','||a.QYKS00||',',',20,')>0) order by nvl(a.QYKS00,'0') desc 289 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 290 09:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 291 09:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2556080.000000 292 09:58:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 293 09:58:35 SQL Execute: ORACLE - select SF_SF_GETYWLSH0(?,?,?,?) AS FHXX00 from dual 294 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 535.000000 295 09:58:35 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 = ? and SYBZ00 = 'Y' 296 09:58:35 SQL Execute: ORACLE - select count(1) num from SF_PJSYQK where PLBH00=1 and PJXH00='25144553' and CZY000=535 297 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 298 09:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 299 09:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 300 09:58:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 301 09:58:35 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 302 09:58:35 SQL Execute: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( D.MZH000 = ? or (D.MZH000='0' and '1'='1')) 303 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 304 09:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 305 09:58:35 SQL Execute: ORACLE - select sum(ZFJE00) ZFJE00,sum(JZJE00) JZJE00 FROM SF_BRFY00 WHERE BRID00=? and JZDH00+0=0 AND CXPJR0='999999' and ( MZH000 =?) 306 09:58:35 SQL Execute: ORACLE - update SF_BRFY00 SET CZRQ00='20221213' WHERE BRID00=121340 and JZDH00+0=0 AND CZRQ00='19990101' and ( MZH000 = '959460') 307 09:58:35 SQL Data In: ORACLE - Rows affected = 0 308 09:58:35 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YF_MZCFBLTS' 309 09:58:35 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YJ_XMYXTS' 310 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 311 09:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 312 09:58:35 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') 313 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 314 09:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 315 09:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 316 09:58:35 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') 317 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 318 09:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 319 09:58:35 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 320 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 321 09:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 322 09:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 323 09:58:35 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') 324 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 325 09:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 326 09:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 327 09:58:35 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 328 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 329 09:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 330 09:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 331 09:58:35 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 and b.SFKSLY<>'Y' group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 332 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 333 09:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 334 09:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 335 09:58:35 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 336 09:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350104198501275430 337 09:58:35 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 338 09:58:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 339 09:58:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 959460 340 09:58:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 341 09:58:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 342 09:58:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 343 09:58:36 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 344 09:58:36 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?,?,?)SFZRZY from dual 345 09:58:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 346 09:58:36 SQL Execute: ORACLE - select b.SFXNH0,b.FBBH00,b.YBZXLB,b.ybmc00 from bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.brid00=? 347 09:58:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 348 09:58:36 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 349 09:58:36 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(121340,959460,0) YYKSBM from dual 350 09:58:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 351 09:58:36 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 352 09:58:36 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(121340,959460,1) YYKSBM from dual 353 09:58:36 SQL Execute: ORACLE - select SP_SF_PDBRSFYXQFJS(121340) SFQFJS from dual 354 09:58:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 355 09:58:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 356 09:58:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 357 09:58:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 959460 358 09:58:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 359 09:58:36 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 360 09:58:36 SQL Execute: ORACLE - select SF_SF_TSBZJM(?,?,?,?,?,?) FSDYLX from dual 361 09:58:36 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 362 09:58:36 SQL Data In: ORACLE - Param = 2, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 363 09:58:36 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221213 364 09:58:36 SQL Data In: ORACLE - Param = 4, Name = AS_GHH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 959460 365 09:58:36 SQL Data In: ORACLE - Param = 5, Name = AS_ICKH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 366 09:58:36 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 367 09:58:36 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 368 09:58:36 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 卢艇 369 09:58:36 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 370 09:58:36 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 371 09:58:36 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.210000 372 09:58:36 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 373 09:58:36 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 374 09:58:36 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.210000 375 09:58:36 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 376 09:58:36 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 377 09:58:36 SQL Data In: ORACLE - Param = 17, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 378 09:58:36 SQL Data In: ORACLE - Param = 18, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 379 09:58:36 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.210000 380 09:58:36 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 535.000000 381 09:58:36 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 公收费-乌 382 09:58:36 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 383 09:58:36 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 384 09:58:36 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 385 09:58:36 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 386 09:58:36 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 387 09:58:36 SQL Data In: ORACLE - Param = 27, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 388 09:58:36 SQL Data In: ORACLE - Param = 28, Name = AS_BZJSLX, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 389 09:58:36 SQL Data In: ORACLE - Param = 29, Name = as_SFDYFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 390 09:58:36 SQL Data In: ORACLE - Param = 30, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 391 09:58:36 SQL Data In: ORACLE - Param = 31, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 392 09:58:36 SQL Data In: ORACLE - Param = 32, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 393 09:58:36 SQL Data In: ORACLE - Param = 33, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 394 09:58:36 SQL Data In: ORACLE - Param = 34, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 395 09:58:36 SQL Data In: ORACLE - Param = 35, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 396 09:58:36 SQL Data In: ORACLE - Param = 36, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 397 09:58:36 SQL Data In: ORACLE - Param = 37, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 398 09:58:36 SQL Data In: ORACLE - Param = 38, Name = AD_JJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 399 09:58:36 SQL Data In: ORACLE - Param = 39, Name = AD_SYDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 400 09:58:36 SQL Data In: ORACLE - Param = 40, Name = AD_SBDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 401 09:58:36 SQL Data In: ORACLE - Param = 41, Name = AD_BJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 402 09:58:36 SQL Data In: ORACLE - Param = 42, Name = AD_GWYDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 403 09:58:36 SQL Data In: ORACLE - Param = 43, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 404 09:58:36 SQL Data In: ORACLE - Param = 44, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 405 09:58:36 SQL Data In: ORACLE - Param = 45, Name = AD_HJJE01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 406 09:58:36 SQL Data In: ORACLE - Param = 46, Name = ad_MSTID0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 407 09:58:36 SQL Data In: ORACLE - Param = 47, Name = ad_MSTYE0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 408 09:58:36 SQL Data In: ORACLE - Param = 48, Name = as_WBPJLY, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 409 09:58:36 SQL Data In: ORACLE - Param = 49, Name = as_FPDYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 410 09:58:36 SQL Data In: ORACLE - Param = 50, Name = as_YBTYPE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 411 09:58:36 SQL Data In: ORACLE - Param = 51, Name = as_INTXML, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 412 09:58:36 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_GHH000 => :AS_GHH000,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,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,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_BZJSLX => :AS_BZJSLX,as_SFDYFP => :as_SFDYFP,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_JZDH00 => :AD_JZDH00,AD_ZFDJH0 => :AD_ZFDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AD_JJDJH0 => :AD_JJDJH0,AD_SYDJH0 => :AD_SYDJH0,AD_SBDJH0 => :AD_SBDJH0,AD_BJDJH0 => :AD_BJDJH0,AD_GWYDJH => :AD_GWYDJH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AD_HJJE01 => :AD_HJJE01,ad_MSTID0 => :ad_MSTID0,ad_MSTYE0 => :ad_MSTYE0,as_WBPJLY => :as_WBPJLY,as_FPDYBZ => :as_FPDYBZ,as_YBTYPE => :as_YBTYPE,as_INTXML => :as_INTXML); END; 413 09:58:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 414 09:58:37 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00=? 415 09:58:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121340.000000 416 09:58:37 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00=? 417 09:58:37 SQL Execute: ORACLE - Commit 418 09:58:37 SQL Data In: ORACLE - Rows affected = 0 419 09:58:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 735141.000000 420 09:58:37 SQL Execute: ORACLE - select SQ_BM_JSD000_LSH000.NEXTVAL LSH000,'' as BDXX00,a.* from VW_SF_JSDDY a where a.JZDH00=? 421 09:58:37 SQL Execute: ORACLE - select * from SF_PJSYMX where xmje00<>0 and PJH000 =3525621 order by XMBH00 422 09:58:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 735141.000000 423 09:58:37 SQL Execute: ORACLE - select SQ_BM_JSD000_LSH000.NEXTVAL LSH000,'' as BDXX00,a.* from VW_SF_JSDDY a where a.JZDH00=?