1 08:42:22 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='6631489' and LBBH00='0' 2 08:42:22 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='5897529' and ZT0000='1' 3 08:42:22 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='5897529' and ZT0000='1' 4 08:42:22 SQL Execute: ORACLE - Select SYSDATE from Dual 5 08:42:22 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 6 08:42:22 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') 7 08:42:23 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0221094090972478' and ICKNBH = '0221094090972478' 8 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 9 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 10 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 11 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 12 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 13 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 14 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 15 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2450 AND A.BBID00=B.BBID00 order by a.XH0000 16 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 17 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 18 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 19 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 20 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 21 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 22 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 23 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 24 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 25 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 26 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 27 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 28 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 29 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 30 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 31 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 32 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 33 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 34 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 35 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 36 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 37 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 38 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 39 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2450 AND A.BBID00=B.BBID00 order by a.XH0000 40 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 41 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 42 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 43 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 44 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 45 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 46 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 47 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 48 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 49 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 50 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 51 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 52 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 53 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 54 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 55 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 56 08:42:23 SQL Execute: ORACLE - select YJDJH0 from YJ_YW0000 where XMZT00 in ('2','3','4') and YJDJH0 in (30674955,30674956,30674957,30674958,30674959) 57 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 58 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 59 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 60 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 61 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 62 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 63 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 64 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 65 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 66 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 67 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 68 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2450 AND A.BBID00=B.BBID00 order by a.XH0000 69 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 70 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 71 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 72 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 73 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 74 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 75 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 76 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 77 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 78 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 79 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 80 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 81 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 82 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 83 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 84 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 85 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 86 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 87 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 88 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 89 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 90 08:42:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 91 08:42:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2469 92 08:42:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 93 08:42:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 52 94 08:42:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 67 95 08:42:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 278 96 08:42:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 216 97 08:42:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 杨之怡 98 08:42:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 99 08:42:23 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 100 08:42:23 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 101 08:42:23 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 102 08:42:23 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 103 08:42:23 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 104 08:42:23 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 105 08:42:23 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 106 08:42:23 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 107 08:42:23 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 108 08:42:23 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 109 08:42:23 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 110 08:42:23 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 111 08:42:23 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 112 08:42:23 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 113 08:42:23 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 114 08:42:23 SQL Execute: ORACLE - update YJ_YW0000 set YJFZH0=?,BRID00=?,ZLXMID=?,SL0000=?,YJKSBH=?,KDYS00=?,KDKSBH=?,YSSZKS=?,LRXM00=?,JZBZ00=?,BWMC00=?,ZDID00=?,ZDMC00=?,XMZT00=?,YZCFID=?,DCBZ00=?,JCQZY0=?,MC0000=?,BH0000=?,ZSDYMC=?,TSBSMC=?,BZ0000=?,BBID00=?,BWBH00=? where YJDJH0=? 115 08:42:23 SQL Data In: ORACLE - Rows affected = 1 116 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 117 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 118 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 119 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2450 AND A.BBID00=B.BBID00 order by a.XH0000 120 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 121 08:42:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 122 08:42:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2450 123 08:42:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 124 08:42:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 52 125 08:42:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 67 126 08:42:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 278 127 08:42:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 216 128 08:42:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 杨之怡 129 08:42:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 130 08:42:23 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 131 08:42:23 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 132 08:42:23 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 133 08:42:23 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 134 08:42:23 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 135 08:42:23 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 136 08:42:23 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 137 08:42:23 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 138 08:42:23 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 139 08:42:23 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 140 08:42:23 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 141 08:42:23 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 142 08:42:23 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 143 08:42:23 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 144 08:42:23 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 145 08:42:23 SQL Execute: ORACLE - update YJ_YW0000 set YJFZH0=?,BRID00=?,ZLXMID=?,SL0000=?,YJKSBH=?,KDYS00=?,KDKSBH=?,YSSZKS=?,LRXM00=?,JZBZ00=?,BWMC00=?,ZDID00=?,ZDMC00=?,XMZT00=?,YZCFID=?,DCBZ00=?,JCQZY0=?,MC0000=?,BH0000=?,ZSDYMC=?,TSBSMC=?,BZ0000=?,BBID00=?,BWBH00=? where YJDJH0=? 146 08:42:23 SQL Data In: ORACLE - Rows affected = 1 147 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 148 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 149 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 150 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 151 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 152 08:42:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 153 08:42:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2413 154 08:42:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 155 08:42:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 52 156 08:42:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 67 157 08:42:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 278 158 08:42:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 216 159 08:42:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 杨之怡 160 08:42:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 161 08:42:23 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 162 08:42:23 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 163 08:42:23 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 164 08:42:23 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 165 08:42:23 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 166 08:42:23 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 167 08:42:23 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 168 08:42:23 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 169 08:42:23 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 170 08:42:23 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 171 08:42:23 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 172 08:42:23 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 173 08:42:23 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 174 08:42:23 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 175 08:42:23 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 176 08:42:23 SQL Execute: ORACLE - update YJ_YW0000 set YJFZH0=?,BRID00=?,ZLXMID=?,SL0000=?,YJKSBH=?,KDYS00=?,KDKSBH=?,YSSZKS=?,LRXM00=?,JZBZ00=?,BWMC00=?,ZDID00=?,ZDMC00=?,XMZT00=?,YZCFID=?,DCBZ00=?,JCQZY0=?,MC0000=?,BH0000=?,ZSDYMC=?,TSBSMC=?,BZ0000=?,BBID00=?,BWBH00=? where YJDJH0=? 177 08:42:23 SQL Data In: ORACLE - Rows affected = 1 178 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 179 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 180 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 181 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 182 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 183 08:42:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 184 08:42:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2413 185 08:42:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 186 08:42:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 52 187 08:42:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 67 188 08:42:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 278 189 08:42:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 216 190 08:42:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 杨之怡 191 08:42:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 192 08:42:23 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 193 08:42:23 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 194 08:42:23 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 195 08:42:23 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 196 08:42:23 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 197 08:42:23 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 198 08:42:23 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 199 08:42:23 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 200 08:42:23 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 201 08:42:23 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 202 08:42:23 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 203 08:42:23 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 204 08:42:23 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 205 08:42:23 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 206 08:42:23 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 207 08:42:23 SQL Execute: ORACLE - update YJ_YW0000 set YJFZH0=?,BRID00=?,ZLXMID=?,SL0000=?,YJKSBH=?,KDYS00=?,KDKSBH=?,YSSZKS=?,LRXM00=?,JZBZ00=?,BWMC00=?,ZDID00=?,ZDMC00=?,XMZT00=?,YZCFID=?,DCBZ00=?,JCQZY0=?,MC0000=?,BH0000=?,ZSDYMC=?,TSBSMC=?,BZ0000=?,BBID00=?,BWBH00=? where YJDJH0=? 208 08:42:23 SQL Data In: ORACLE - Rows affected = 1 209 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 210 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 211 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 212 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 213 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 214 08:42:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 215 08:42:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2424 216 08:42:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 217 08:42:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 52 218 08:42:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 67 219 08:42:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 278 220 08:42:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 216 221 08:42:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 杨之怡 222 08:42:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 223 08:42:23 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 224 08:42:23 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 225 08:42:23 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 226 08:42:23 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 227 08:42:23 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 228 08:42:23 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 229 08:42:23 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 230 08:42:23 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 231 08:42:23 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 232 08:42:23 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 233 08:42:23 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 234 08:42:23 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 235 08:42:23 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 236 08:42:23 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 237 08:42:23 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 238 08:42:23 SQL Execute: ORACLE - update YJ_YW0000 set YJFZH0=?,BRID00=?,ZLXMID=?,SL0000=?,YJKSBH=?,KDYS00=?,KDKSBH=?,YSSZKS=?,LRXM00=?,JZBZ00=?,BWMC00=?,ZDID00=?,ZDMC00=?,XMZT00=?,YZCFID=?,DCBZ00=?,JCQZY0=?,MC0000=?,BH0000=?,ZSDYMC=?,TSBSMC=?,BZ0000=?,BBID00=?,BWBH00=? where YJDJH0=? 239 08:42:23 SQL Data In: ORACLE - Rows affected = 1 240 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 241 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 242 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 243 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 244 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 245 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 246 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 247 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 248 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 249 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 250 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 251 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2450 AND A.BBID00=B.BBID00 order by a.XH0000 252 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 253 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 254 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 255 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 256 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 257 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 258 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 259 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 260 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 261 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 262 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 263 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 264 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 265 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 266 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 267 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 268 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 269 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 270 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 271 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 272 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 273 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 274 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 275 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2450 AND A.BBID00=B.BBID00 order by a.XH0000 276 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 277 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 278 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 279 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 280 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 281 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 282 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 283 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 284 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 285 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 286 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 287 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 288 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 289 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 290 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 291 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 292 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 293 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 294 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 295 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 296 08:42:23 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30674955.000000 297 08:42:23 SQL Data In: ORACLE - Param = 2, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 298 08:42:23 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 299 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_UPDTSBZ" (PYJDJH0 => :PYJDJH0,PBH0000 => :PBH0000,PBRID00 => :PBRID00); END; 300 08:42:23 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12576687.000000 301 08:42:23 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30674955.000000 302 08:42:23 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 303 08:42:23 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 304 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 305 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 306 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 307 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 308 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2450 AND A.BBID00=B.BBID00 order by a.XH0000 309 08:42:23 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30674956.000000 310 08:42:23 SQL Data In: ORACLE - Param = 2, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 311 08:42:23 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 312 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_UPDTSBZ" (PYJDJH0 => :PYJDJH0,PBH0000 => :PBH0000,PBRID00 => :PBRID00); END; 313 08:42:23 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12576687.000000 314 08:42:23 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30674956.000000 315 08:42:23 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 316 08:42:23 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 317 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 318 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 319 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 320 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 321 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 322 08:42:23 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30674957.000000 323 08:42:23 SQL Data In: ORACLE - Param = 2, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 324 08:42:23 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 325 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_UPDTSBZ" (PYJDJH0 => :PYJDJH0,PBH0000 => :PBH0000,PBRID00 => :PBRID00); END; 326 08:42:23 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12576687.000000 327 08:42:23 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30674957.000000 328 08:42:23 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 329 08:42:23 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 330 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 331 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 332 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 333 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 334 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 335 08:42:23 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30674958.000000 336 08:42:23 SQL Data In: ORACLE - Param = 2, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 337 08:42:23 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 338 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_UPDTSBZ" (PYJDJH0 => :PYJDJH0,PBH0000 => :PBH0000,PBRID00 => :PBRID00); END; 339 08:42:23 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12576687.000000 340 08:42:23 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30674958.000000 341 08:42:23 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 342 08:42:23 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 343 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 344 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 345 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 346 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 347 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 348 08:42:23 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30674959.000000 349 08:42:23 SQL Data In: ORACLE - Param = 2, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 350 08:42:23 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 351 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_UPDTSBZ" (PYJDJH0 => :PYJDJH0,PBH0000 => :PBH0000,PBRID00 => :PBRID00); END; 352 08:42:23 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12576687.000000 353 08:42:23 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30674959.000000 354 08:42:23 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 355 08:42:23 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 356 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 357 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 358 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 359 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 360 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 361 08:42:23 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12576687.000000 362 08:42:23 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 363 08:42:23 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 364 08:42:23 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 365 08:42:23 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 366 08:42:23 SQL Execute: ORACLE - Commit 367 08:42:23 SQL Data In: ORACLE - Rows affected = 0 368 08:42:23 SQL Execute: ORACLE - commit 369 08:42:23 SQL Data In: ORACLE - Rows affected = 0 370 08:42:23 SQL Execute: ORACLE - select a.*,b.BMMC00 as BMMC,'0' XGBZ00, decode(a.jcqzy0,null,(select jcqzysx from bm_zlzd00 where zlxmid=a.zlxmid),a.jcqzy0) JCQZYSX,c.LBBH00 ,nvl(c.JCLBID,0) JCLBID,nvl(c.SQDID0,0) SQDID0,'0' as yjmxzt,decode(nvl(a.SQID00,0),0,'未申请','已申请:'||a.SQID00) SQZT00,a.YJDJH0 YJDJH1,c.BWBH00 WHBWBH,a.BWBH00 OLDBW0,a.ZLXMJC OLDMC0 from YJ_YW0000 a,BM_BMBM00 b,bm_zlzd00 c where a.YJKSBH=b.BMBH00 and a.MZZYBZ='0' and a.zlxmid=c.zlxmid and c.lbbh00 not in ('0') and a.ZYHGHH='6631489' and a.SL0000>0 and (a.XMZT00='0' or a.XMZT00='1' or a.XMZT00='5') and not exists (select 'a' from yj_yw0000 d where d.cxdjh0=a.yjdjh0 and d.ZYHGHH='6631489') order by a.YJDJH0 371 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 372 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 373 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 374 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 375 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 376 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 377 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 378 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2450 AND A.BBID00=B.BBID00 order by a.XH0000 379 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 380 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 381 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 382 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 383 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 384 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 385 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 386 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 387 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 388 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 389 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 390 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 391 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 392 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 393 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 394 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 395 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 396 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 397 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 398 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 399 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 400 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 401 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 402 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 403 08:42:23 SQL Execute: ORACLE - select a.*,b.BMMC00 as BMMC from YJ_YW0000 a,BM_BMBM00 b,bm_zlzd00 c where a.YJKSBH=b.BMBH00 and a.zlxmid=c.zlxmid and c.lbbh00 not in ('0') and a.MZZYBZ='0' and a.ZYHGHH='6631489' and a.SL0000>0 and (a.XMZT00<>'0' and a.XMZT00<>'1' and a.XMZT00<>'5') and not exists (select 'a' from yj_yw0000 d where d.cxdjh0=a.yjdjh0 and d.ZYHGHH='6631489') order by a.YJDJH0 404 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6631489 405 08:42:23 SQL Execute: ORACLE - select THBZ00 from SF_BRXXB0 where GHH000=? and GHH000 is not null 406 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 407 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 408 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 409 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 410 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6631489 411 08:42:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6631489 412 08:42:23 SQL Execute: ORACLE - select sum(CFZJE0) from VW_YS_CFZL00 where CFBZ00='1' and GHH000=? and zt0000 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=? and MZZYBZ='0' and xmzt00 in ('0','1') 413 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5897529 414 08:42:23 SQL Execute: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=? and a.BRID00=b.BRID00 415 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674955 416 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 417 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 418 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2469 AND A.BBID00=B.BBID00 order by a.XH0000 419 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674956 420 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 421 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 422 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2450 AND A.BBID00=B.BBID00 order by a.XH0000 423 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674957 424 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 425 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 426 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 427 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674958 428 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 429 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 430 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2413 AND A.BBID00=B.BBID00 order by a.XH0000 431 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 432 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 433 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 434 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 435 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30674959 436 08:42:23 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 437 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 438 08:42:23 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=2424 AND A.BBID00=B.BBID00 order by a.XH0000 439 08:42:23 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=12576687 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc 440 08:42:23 SQL Execute: ORACLE - select a.ZDMC00 from ys_brzdxx A,BM_TYZD00 b where a.ghid00=12576687 and a.zdmc00=b.mc0000 and b.zdmc00='诊断处方天数限制' and b.BZ0000=(select min(b.BZ0000) from ys_brzdxx A,BM_TYZD00 b where a.ghid00=12576687 and a.zdmc00=b.mc0000 and b.zdmc00='诊断处方天数限制') and rownum=1 441 08:42:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 442 08:42:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 48 443 08:42:23 SQL Execute: ORACLE - select LBBH00 from vw_ys_ypkcxx where ypnm00=? and yfbmbh=? 444 08:42:29 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 = '8') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',278,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',67,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =67 AND b.JSKSBH = '278') AND (INSTR (',' || a.jsksbh || ',',',278,') > 0 or a.jsksbh is null)