1 08:51:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3874228 and KSBH00=498 and ZLXMID=17157 and YJDJH0=9924686 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 2 08:51:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3874228 and KSBH00=498 and ZLXMID=21651 and YJDJH0=9924686 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 3 08:51:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3874228 and KSBH00=498 and ZLXMID=21692 and YJDJH0=9924686 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 4 08:51:12 SQL Execute: ORACLE - SELECT BGXMID FROM BM_JCXMDY WHERE XTCS00 IN ('TJ_YG1ID','TJ_YG2ID','TJ_YG3ID','TJ_YG4ID','TJ_YG5ID','TJ_YG6ID') AND BGXMID IS NOT NULL 5 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294154' 6 08:51:12 SQL Data In: ORACLE - Rows affected = 1 7 08:51:12 SQL Execute: ORACLE - Commit 8 08:51:12 SQL Data In: ORACLE - Rows affected = 0 9 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294158' 10 08:51:12 SQL Data In: ORACLE - Rows affected = 1 11 08:51:12 SQL Execute: ORACLE - Commit 12 08:51:12 SQL Data In: ORACLE - Rows affected = 0 13 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294137' 14 08:51:12 SQL Data In: ORACLE - Rows affected = 1 15 08:51:12 SQL Execute: ORACLE - Commit 16 08:51:12 SQL Data In: ORACLE - Rows affected = 0 17 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294160' 18 08:51:12 SQL Data In: ORACLE - Rows affected = 1 19 08:51:12 SQL Execute: ORACLE - Commit 20 08:51:12 SQL Data In: ORACLE - Rows affected = 0 21 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294138' 22 08:51:12 SQL Data In: ORACLE - Rows affected = 1 23 08:51:12 SQL Execute: ORACLE - Commit 24 08:51:12 SQL Data In: ORACLE - Rows affected = 0 25 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294157' 26 08:51:12 SQL Data In: ORACLE - Rows affected = 1 27 08:51:12 SQL Execute: ORACLE - Commit 28 08:51:12 SQL Data In: ORACLE - Rows affected = 0 29 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294155' 30 08:51:12 SQL Data In: ORACLE - Rows affected = 1 31 08:51:12 SQL Execute: ORACLE - Commit 32 08:51:12 SQL Data In: ORACLE - Rows affected = 0 33 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294149' 34 08:51:12 SQL Data In: ORACLE - Rows affected = 1 35 08:51:12 SQL Execute: ORACLE - Commit 36 08:51:12 SQL Data In: ORACLE - Rows affected = 0 37 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294145' 38 08:51:12 SQL Data In: ORACLE - Rows affected = 1 39 08:51:12 SQL Execute: ORACLE - Commit 40 08:51:12 SQL Data In: ORACLE - Rows affected = 0 41 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294143' 42 08:51:12 SQL Data In: ORACLE - Rows affected = 1 43 08:51:12 SQL Execute: ORACLE - Commit 44 08:51:12 SQL Data In: ORACLE - Rows affected = 0 45 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294144' 46 08:51:12 SQL Data In: ORACLE - Rows affected = 1 47 08:51:12 SQL Execute: ORACLE - Commit 48 08:51:12 SQL Data In: ORACLE - Rows affected = 0 49 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294150' 50 08:51:12 SQL Data In: ORACLE - Rows affected = 1 51 08:51:12 SQL Execute: ORACLE - Commit 52 08:51:12 SQL Data In: ORACLE - Rows affected = 0 53 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294136' 54 08:51:12 SQL Data In: ORACLE - Rows affected = 1 55 08:51:12 SQL Execute: ORACLE - Commit 56 08:51:12 SQL Data In: ORACLE - Rows affected = 0 57 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294159' 58 08:51:12 SQL Data In: ORACLE - Rows affected = 1 59 08:51:12 SQL Execute: ORACLE - Commit 60 08:51:12 SQL Data In: ORACLE - Rows affected = 0 61 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294147' 62 08:51:12 SQL Data In: ORACLE - Rows affected = 1 63 08:51:12 SQL Execute: ORACLE - Commit 64 08:51:12 SQL Data In: ORACLE - Rows affected = 0 65 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294161' 66 08:51:12 SQL Data In: ORACLE - Rows affected = 1 67 08:51:12 SQL Execute: ORACLE - Commit 68 08:51:12 SQL Data In: ORACLE - Rows affected = 0 69 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294135' 70 08:51:12 SQL Data In: ORACLE - Rows affected = 1 71 08:51:12 SQL Execute: ORACLE - Commit 72 08:51:12 SQL Data In: ORACLE - Rows affected = 0 73 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294156' 74 08:51:12 SQL Data In: ORACLE - Rows affected = 1 75 08:51:12 SQL Execute: ORACLE - Commit 76 08:51:12 SQL Data In: ORACLE - Rows affected = 0 77 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294141' 78 08:51:12 SQL Data In: ORACLE - Rows affected = 1 79 08:51:12 SQL Execute: ORACLE - Commit 80 08:51:12 SQL Data In: ORACLE - Rows affected = 0 81 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294140' 82 08:51:12 SQL Data In: ORACLE - Rows affected = 1 83 08:51:12 SQL Execute: ORACLE - Commit 84 08:51:12 SQL Data In: ORACLE - Rows affected = 0 85 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294139' 86 08:51:12 SQL Data In: ORACLE - Rows affected = 1 87 08:51:12 SQL Execute: ORACLE - Commit 88 08:51:12 SQL Data In: ORACLE - Rows affected = 0 89 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294142' 90 08:51:12 SQL Data In: ORACLE - Rows affected = 1 91 08:51:12 SQL Execute: ORACLE - Commit 92 08:51:12 SQL Data In: ORACLE - Rows affected = 0 93 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294152' 94 08:51:12 SQL Data In: ORACLE - Rows affected = 1 95 08:51:12 SQL Execute: ORACLE - Commit 96 08:51:12 SQL Data In: ORACLE - Rows affected = 0 97 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294146' 98 08:51:12 SQL Data In: ORACLE - Rows affected = 1 99 08:51:12 SQL Execute: ORACLE - Commit 100 08:51:12 SQL Data In: ORACLE - Rows affected = 0 101 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294162' 102 08:51:12 SQL Data In: ORACLE - Rows affected = 1 103 08:51:12 SQL Execute: ORACLE - Commit 104 08:51:12 SQL Data In: ORACLE - Rows affected = 0 105 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294148' 106 08:51:12 SQL Data In: ORACLE - Rows affected = 1 107 08:51:12 SQL Execute: ORACLE - Commit 108 08:51:12 SQL Data In: ORACLE - Rows affected = 0 109 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294134' 110 08:51:12 SQL Data In: ORACLE - Rows affected = 1 111 08:51:12 SQL Execute: ORACLE - Commit 112 08:51:12 SQL Data In: ORACLE - Rows affected = 0 113 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294153' 114 08:51:12 SQL Data In: ORACLE - Rows affected = 1 115 08:51:12 SQL Execute: ORACLE - Commit 116 08:51:12 SQL Data In: ORACLE - Rows affected = 0 117 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294151' 118 08:51:12 SQL Data In: ORACLE - Rows affected = 1 119 08:51:12 SQL Execute: ORACLE - Commit 120 08:51:12 SQL Data In: ORACLE - Rows affected = 0 121 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294129' 122 08:51:12 SQL Data In: ORACLE - Rows affected = 1 123 08:51:12 SQL Execute: ORACLE - Commit 124 08:51:12 SQL Data In: ORACLE - Rows affected = 0 125 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294128' 126 08:51:12 SQL Data In: ORACLE - Rows affected = 1 127 08:51:12 SQL Execute: ORACLE - Commit 128 08:51:12 SQL Data In: ORACLE - Rows affected = 0 129 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294130' 130 08:51:12 SQL Data In: ORACLE - Rows affected = 1 131 08:51:12 SQL Execute: ORACLE - Commit 132 08:51:12 SQL Data In: ORACLE - Rows affected = 0 133 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294131' 134 08:51:12 SQL Data In: ORACLE - Rows affected = 1 135 08:51:12 SQL Execute: ORACLE - Commit 136 08:51:12 SQL Data In: ORACLE - Rows affected = 0 137 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294133' 138 08:51:12 SQL Data In: ORACLE - Rows affected = 1 139 08:51:12 SQL Execute: ORACLE - Commit 140 08:51:12 SQL Data In: ORACLE - Rows affected = 0 141 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294121' 142 08:51:12 SQL Data In: ORACLE - Rows affected = 1 143 08:51:12 SQL Execute: ORACLE - Commit 144 08:51:12 SQL Data In: ORACLE - Rows affected = 0 145 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294132' 146 08:51:12 SQL Data In: ORACLE - Rows affected = 1 147 08:51:12 SQL Execute: ORACLE - Commit 148 08:51:12 SQL Data In: ORACLE - Rows affected = 0 149 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294126' 150 08:51:12 SQL Data In: ORACLE - Rows affected = 1 151 08:51:12 SQL Execute: ORACLE - Commit 152 08:51:12 SQL Data In: ORACLE - Rows affected = 0 153 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294127' 154 08:51:12 SQL Data In: ORACLE - Rows affected = 1 155 08:51:12 SQL Execute: ORACLE - Commit 156 08:51:12 SQL Data In: ORACLE - Rows affected = 0 157 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294123' 158 08:51:12 SQL Data In: ORACLE - Rows affected = 1 159 08:51:12 SQL Execute: ORACLE - Commit 160 08:51:12 SQL Data In: ORACLE - Rows affected = 0 161 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294124' 162 08:51:12 SQL Data In: ORACLE - Rows affected = 1 163 08:51:12 SQL Execute: ORACLE - Commit 164 08:51:12 SQL Data In: ORACLE - Rows affected = 0 165 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294125' 166 08:51:12 SQL Data In: ORACLE - Rows affected = 1 167 08:51:12 SQL Execute: ORACLE - Commit 168 08:51:12 SQL Data In: ORACLE - Rows affected = 0 169 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294122' 170 08:51:12 SQL Data In: ORACLE - Rows affected = 1 171 08:51:12 SQL Execute: ORACLE - Commit 172 08:51:12 SQL Data In: ORACLE - Rows affected = 0 173 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294108' 174 08:51:12 SQL Data In: ORACLE - Rows affected = 1 175 08:51:12 SQL Execute: ORACLE - Commit 176 08:51:12 SQL Data In: ORACLE - Rows affected = 0 177 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294106' 178 08:51:12 SQL Data In: ORACLE - Rows affected = 1 179 08:51:12 SQL Execute: ORACLE - Commit 180 08:51:12 SQL Data In: ORACLE - Rows affected = 0 181 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294105' 182 08:51:12 SQL Data In: ORACLE - Rows affected = 1 183 08:51:12 SQL Execute: ORACLE - Commit 184 08:51:12 SQL Data In: ORACLE - Rows affected = 0 185 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294116' 186 08:51:12 SQL Data In: ORACLE - Rows affected = 1 187 08:51:12 SQL Execute: ORACLE - Commit 188 08:51:12 SQL Data In: ORACLE - Rows affected = 0 189 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294115' 190 08:51:12 SQL Data In: ORACLE - Rows affected = 1 191 08:51:12 SQL Execute: ORACLE - Commit 192 08:51:12 SQL Data In: ORACLE - Rows affected = 0 193 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294111' 194 08:51:12 SQL Data In: ORACLE - Rows affected = 1 195 08:51:12 SQL Execute: ORACLE - Commit 196 08:51:12 SQL Data In: ORACLE - Rows affected = 0 197 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294110' 198 08:51:12 SQL Data In: ORACLE - Rows affected = 1 199 08:51:12 SQL Execute: ORACLE - Commit 200 08:51:12 SQL Data In: ORACLE - Rows affected = 0 201 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294100' 202 08:51:12 SQL Data In: ORACLE - Rows affected = 1 203 08:51:12 SQL Execute: ORACLE - Commit 204 08:51:12 SQL Data In: ORACLE - Rows affected = 0 205 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294099' 206 08:51:12 SQL Data In: ORACLE - Rows affected = 1 207 08:51:12 SQL Execute: ORACLE - Commit 208 08:51:12 SQL Data In: ORACLE - Rows affected = 0 209 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294098' 210 08:51:12 SQL Data In: ORACLE - Rows affected = 1 211 08:51:12 SQL Execute: ORACLE - Commit 212 08:51:12 SQL Data In: ORACLE - Rows affected = 0 213 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294097' 214 08:51:12 SQL Data In: ORACLE - Rows affected = 1 215 08:51:12 SQL Execute: ORACLE - Commit 216 08:51:12 SQL Data In: ORACLE - Rows affected = 0 217 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294112' 218 08:51:12 SQL Data In: ORACLE - Rows affected = 1 219 08:51:12 SQL Execute: ORACLE - Commit 220 08:51:12 SQL Data In: ORACLE - Rows affected = 0 221 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294101' 222 08:51:12 SQL Data In: ORACLE - Rows affected = 1 223 08:51:12 SQL Execute: ORACLE - Commit 224 08:51:12 SQL Data In: ORACLE - Rows affected = 0 225 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294114' 226 08:51:12 SQL Data In: ORACLE - Rows affected = 1 227 08:51:12 SQL Execute: ORACLE - Commit 228 08:51:12 SQL Data In: ORACLE - Rows affected = 0 229 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294117' 230 08:51:12 SQL Data In: ORACLE - Rows affected = 1 231 08:51:12 SQL Execute: ORACLE - Commit 232 08:51:12 SQL Data In: ORACLE - Rows affected = 0 233 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294118' 234 08:51:12 SQL Data In: ORACLE - Rows affected = 1 235 08:51:12 SQL Execute: ORACLE - Commit 236 08:51:12 SQL Data In: ORACLE - Rows affected = 0 237 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294119' 238 08:51:12 SQL Data In: ORACLE - Rows affected = 1 239 08:51:12 SQL Execute: ORACLE - Commit 240 08:51:12 SQL Data In: ORACLE - Rows affected = 0 241 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='294113' 242 08:51:12 SQL Data In: ORACLE - Rows affected = 1 243 08:51:12 SQL Execute: ORACLE - Commit 244 08:51:12 SQL Data In: ORACLE - Rows affected = 0 245 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294107' 246 08:51:12 SQL Data In: ORACLE - Rows affected = 1 247 08:51:12 SQL Execute: ORACLE - Commit 248 08:51:12 SQL Data In: ORACLE - Rows affected = 0 249 08:51:12 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294102' 250 08:51:12 SQL Data In: ORACLE - Rows affected = 1 251 08:51:12 SQL Execute: ORACLE - Commit 252 08:51:13 SQL Data In: ORACLE - Rows affected = 0 253 08:51:13 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294104' 254 08:51:13 SQL Data In: ORACLE - Rows affected = 1 255 08:51:13 SQL Execute: ORACLE - Commit 256 08:51:13 SQL Data In: ORACLE - Rows affected = 0 257 08:51:13 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294120' 258 08:51:13 SQL Data In: ORACLE - Rows affected = 1 259 08:51:13 SQL Execute: ORACLE - Commit 260 08:51:13 SQL Data In: ORACLE - Rows affected = 0 261 08:51:13 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294103' 262 08:51:13 SQL Data In: ORACLE - Rows affected = 1 263 08:51:13 SQL Execute: ORACLE - Commit 264 08:51:13 SQL Data In: ORACLE - Rows affected = 0 265 08:51:13 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='N' where BGID00='294109' 266 08:51:13 SQL Data In: ORACLE - Rows affected = 1 267 08:51:13 SQL Execute: ORACLE - Commit 268 08:51:13 SQL Data In: ORACLE - Rows affected = 0 269 08:51:13 SQL Execute: ORACLE - update TJ_TJXJB0 a set CDZ000=?,JCYS00='1201',JCYSXM='严锦',JCRQ00='20130618' WHERE GHID00 = 3874228 and KSBH00 = 498 AND ZLXMID IS NULL and SFDDDY='N' 270 08:51:13 SQL Data In: ORACLE - Rows affected = 1 271 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1177A' AND KSBH00||'A' = '498A' 272 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '偏低' AND JCXMID = '204813' AND ROWNUM = 1 273 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1193A' AND KSBH00||'A' = '498A' 274 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '↑' AND JCXMID = '204807' AND ROWNUM = 1 275 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1194A' AND KSBH00||'A' = '498A' 276 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '↑' AND JCXMID = '204806' AND ROWNUM = 1 277 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1195A' AND KSBH00||'A' = '498A' 278 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '↓' AND JCXMID = '204808' AND ROWNUM = 1 279 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '621A' AND KSBH00||'A' = '498A' 280 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '281A' AND KSBH00||'A' = '498A' 281 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '151A' AND KSBH00||'A' = '498A' 282 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '阴性' AND JCXMID = '204784' AND ROWNUM = 1 283 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '146A' AND KSBH00||'A' = '498A' 284 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '阴性' AND JCXMID = '204794' AND ROWNUM = 1 285 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '153A' AND KSBH00||'A' = '498A' 286 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '154A' AND KSBH00||'A' = '498A' 287 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '阴性' AND JCXMID = '204779' AND ROWNUM = 1 288 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '147A' AND KSBH00||'A' = '498A' 289 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '阴性' AND JCXMID = '204783' AND ROWNUM = 1 290 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '148A' AND KSBH00||'A' = '498A' 291 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '+1' AND JCXMID = '204781' AND ROWNUM = 1 292 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '149A' AND KSBH00||'A' = '498A' 293 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '150A' AND KSBH00||'A' = '498A' 294 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '阴性' AND JCXMID = '204782' AND ROWNUM = 1 295 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '155A' AND KSBH00||'A' = '498A' 296 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '阴性' AND JCXMID = '204785' AND ROWNUM = 1 297 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1783A' AND KSBH00||'A' = '498A' 298 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '↓' AND JCXMID = '206120' AND ROWNUM = 1 299 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1789A' AND KSBH00||'A' = '498A' 300 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '↑' AND JCXMID = '206123' AND ROWNUM = 1 301 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1792A' AND KSBH00||'A' = '498A' 302 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '↑' AND JCXMID = '205982' AND ROWNUM = 1 303 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1795A' AND KSBH00||'A' = '498A' 304 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '↓' AND JCXMID = '206180' AND ROWNUM = 1 305 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1796A' AND KSBH00||'A' = '498A' 306 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '↓' AND JCXMID = '206181' AND ROWNUM = 1 307 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1797A' AND KSBH00||'A' = '498A' 308 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '↓' AND JCXMID = '206182' AND ROWNUM = 1 309 08:51:13 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '1798A' AND KSBH00||'A' = '498A' 310 08:51:13 SQL Execute: ORACLE - select distinct a.ICD900 from TJ_CJJGWH a,TJ_ZDJYWH b where a.icd900=b.icd900(+) and KSBH00= '498' AND JGMC00 = '↑' AND JCXMID = '206125' AND ROWNUM = 1 311 08:51:13 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3874228 312 08:51:13 SQL Data In: ORACLE - Param = 2, Name = PKSBH00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 498 313 08:51:13 SQL Execute: ORACLE - BEGIN "SP_TJ_TJJYHZ" (PGHID00 => :PGHID00,PKSBH00 => :PKSBH00); END; 314 08:51:13 SQL Execute: ORACLE - Commit 315 08:51:13 SQL Data In: ORACLE - Rows affected = 0 316 08:51:13 SQL Execute: ORACLE - SELECT C.* FROM ( select yjdjh0,yjfzh0,a.zlxmid,b.zlxmjc,b.lbbh00,xmzt00,SL0000,YJKSBH, DECODE(XMZT00,'0','已申请','1','已计价','2','已收费','3','已执行', '6','已作废','7','已退费','D','已取消') XMZTMC, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = A.ZLXMID AND ROWNUM = 1 AND BH0000 = A.YJKSBH) YYID00 from TJ_YJDJH0 a,bm_zlzd00 b where a.zlxmid=b.zlxmid and xmzt00 in('0','1','2','6','D') and (not exists (select 'y' from yj_yw0000 c where c.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and (ghid00='3874228' or ghid00='') ) C WHERE YYID00 = '220035' 317 08:51:13 SQL Execute: ORACLE - select * from TJ_TJXJB0 where GHID00='3874228' and KSBH00='498' and SFDDDY='N' 318 08:51:13 SQL Execute: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='3874228' and ksbh00='498' order by ID0000 319 08:51:13 SQL Execute: ORACLE - select * from ( select SJLX00,BGID00,XSSX00,A.ZLXMID,A.YJDJH0,A.JCXMID,XXZ000,SXZ000,XXTS00,SXTS00,CKZ000,JCRQ00,SFCSTS,XMMC00,CDZ000,DW0000,JGSM00,JCYS00,JCYSXM,B.XH0000 ZLXMXH,SFJRXJ,CDMS00,ICD900,JBMC00,A.SFDY00 from VW_TJ_TJBG00_DIS A,TJ_ZHXM00 B where A.ZLXMID=B.ZLXMID AND GHID00='3874228' and A.KSBH00='498' AND A.KSBH00=B.BH0000 UNION select 'C' SJLX00,0 BGID00,0 XSSX00,A.ZLXMID,C.YJDJH0,0 JCXMID,0 XXZ000,0 SXZ000,'' XXTS00,'' SXTS00,'' CKZ000,C.JCRQ00,'' SFCSTS,B.ZLXMJC XMMC00,'' CDZ000,'' DW0000,'' JGSM00,C.JCYS00,C.JCYSXM,A.XH0000 ZLXMXH,'N' SFJRXJ,'' CDMS00,'' ICD900,'' JBMC00,'N' SFDY00 from TJ_ZHXM00 A,BM_ZLZD00 B,VW_TJ_TJBG00_DIS C WHERE C.GHID00='3874228' and C.KSBH00='498' and A.ZLXMID=B.ZLXMID AND A.ZLXMID=C.ZLXMID and A.BH0000=C.KSBH00 and ((exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is not null) or (not exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is null)) )order by ZLXMXH,ZLXMID,YJDJH0,XSSX00