1 08:41:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057 2 08:41:36 SQL Execute: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'δÉèÖÃ') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=? and a.YSLB00=b.YSLB00(+) 3 08:41:36 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 4 08:41:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 487.000000 5 08:41:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 487.000000 6 08:41:36 SQL Execute: ORACLE - SELECT A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,a.CJYSXM FROM VW_ZS_YJBLXX A WHERE (DQKS00=? or DQBQ00=?) ORDER BY RYCWH0 7 08:41:37 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ') 8 08:41:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 487.000000 9 08:41:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 487.000000 10 08:41:37 SQL Execute: ORACLE - SELECT A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,a.CJYSXM FROM VW_ZS_YJBLXX A WHERE (DQKS00=? or DQBQ00=?) ORDER BY RYCWH0 11 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=616127 12 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 318789 13 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 616127 14 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 15 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=614577 16 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 318233 17 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 614577 18 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 19 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=630177 20 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 273621 21 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 630177 22 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 23 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=582877 24 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 258053 25 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 582877 26 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 27 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=583777 28 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 258051 29 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 583777 30 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 31 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=582827 32 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 318506 33 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 582827 34 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 35 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=585627 36 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 626186 37 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 585627 38 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 39 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=607527 40 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 299987 41 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 607527 42 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 43 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=597127 44 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 258024 45 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 597127 46 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 47 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=583677 48 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 319754 49 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 583677 50 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 51 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=583827 52 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 258270 53 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 583827 54 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 55 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=582579 56 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 318333 57 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 582579 58 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 59 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=583577 60 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 284964 61 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 583577 62 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 63 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=582677 64 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 319323 65 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 582677 66 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 67 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=625327 68 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3060688 69 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 625327 70 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 71 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=616177 72 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 281824 73 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 616177 74 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 75 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=624227 76 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2374286 77 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 624227 78 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 79 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=600227 80 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 265536 81 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 600227 82 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 83 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=585027 84 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2053086 85 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 585027 86 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 87 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=630178 88 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 319497 89 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 630178 90 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 91 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=624777 92 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3414187 93 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 624777 94 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 95 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=582578 96 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1057486 97 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 582578 98 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 99 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=628327 100 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3551187 101 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 628327 102 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 103 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=582777 104 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 257667 105 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 582777 106 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 107 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=585927 108 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1030686 109 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 585927 110 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 111 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=614027 112 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 947686 113 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 614027 114 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 115 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=614377 116 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1399086 117 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 614377 118 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 119 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=579527 120 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1614586 121 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 579527 122 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 123 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=628127 124 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3510388 125 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 628127 126 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 127 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=628077 128 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 306229 129 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 628077 130 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 131 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=624477 132 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 337661 133 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 624477 134 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 135 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=613777 136 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 333564 137 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 613777 138 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 139 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=624427 140 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3365086 141 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 624427 142 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 143 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=629977 144 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2437687 145 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 629977 146 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 147 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=625127 148 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 276726 149 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 625127 150 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 151 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=612327 152 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 442986 153 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 612327 154 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 155 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=607827 156 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3221786 157 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 607827 158 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 159 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=627827 160 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 355555 161 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 627827 162 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 163 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=608377 164 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 258544 165 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 608377 166 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 167 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=610327 168 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 319778 169 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 610327 170 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 171 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=616277 172 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 780586 173 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 616277 174 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 175 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=629427 176 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3552588 177 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 629427 178 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 179 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=591827 180 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3167086 181 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 591827 182 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 183 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=628677 184 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1601086 185 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 628677 186 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 187 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=614427 188 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2755587 189 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 614427 190 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 191 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=623227 192 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3533086 193 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 623227 194 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 195 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=629727 196 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 262552 197 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 629727 198 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 199 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=625027 200 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3424286 201 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 625027 202 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 203 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=616527 204 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3382886 205 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 616527 206 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 207 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=624527 208 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3538296 209 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 624527 210 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 211 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=623677 212 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127786 213 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 623677 214 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 215 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=627527 216 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 291711 217 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 627527 218 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 219 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=615377 220 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 354683 221 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 615377 222 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 223 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=620778 224 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3462286 225 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 620778 226 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 227 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=626527 228 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3544086 229 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 626527 230 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 231 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=622277 232 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1983686 233 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 622277 234 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 235 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=628877 236 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3552387 237 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 628877 238 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 239 08:41:38 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=628427 240 08:41:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3549486 241 08:41:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 628427 242 08:41:38 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='1' 243 08:41:38 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='Z' and (MKDM00='Z95' or MKDM00='Z95') and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='Z' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1057)))) 244 08:41:38 SQL Execute: ORACLE - select 1 from BM_YGBM00 where YGBH00=1057 and YGXZ00 like '%5%' 245 08:41:39 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 585627 246 08:41:39 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 585627 and (YZZT00 in ('7','0','1','2','5','9','7') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID 247 08:41:39 SQL Execute: ORACLE - select ZDMC00,ZDM000 from VW_BQ_BRZDXX where ZYID00=585627 and ZDLB00='2' 248 08:41:39 SQL Execute: ORACLE - select LJID00,ZRZCID from LJ_ZRZC00 a where ZYID00=585627 and nvl(JSRQ00,' ')=' ' 249 08:41:40 SQL Execute: ORACLE - select a.ID0000,a.ZDMC00 from BQ_BRZDXX a,XT_ICD900 b where a.zyid00=585627 and a.ZDLB00='2' and a.ZDM000=b.ICD900 and b.SFCRB0='1' and not exists (select 1 from CR_CRBDJ0 where ZYID00=a.ZYID00 and CZRQ00>to_char(sysdate-365,'YYYYMMDD') and (JBMC00=a.ZDMC00 OR DJID00=a.CRDJID)) 250 08:41:40 SQL Execute: ORACLE - select a.ID0000,a.ZDMC00 from BQ_BRZDXX a,XT_ICD900 b where a.zyid00=585627 and a.ZDLB00='2' and a.ZDM000=b.ICD900 and b.SFCRB0='1' and not exists (select 1 from CR_CRBDJ0 where ZYID00=a.ZYID00 and CZRQ00>to_char(sysdate-365,'YYYYMMDD') and (JBMC00=a.ZDMC00 OR DJID00=a.CRDJID)) 251 08:41:40 SQL Execute: ORACLE - select YPLBBH,YFBMBH from XT_YPFWFX where SLBMBH =481 and MRBZ00 = 'Y' 252 08:41:40 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 585627 253 08:41:40 SQL Execute: ORACLE - select NAME00,to_char(sysdate,'YYYY.MM.DD')TODAY,to_char(sysdate,'HH24:MI') NOWTIME,VALUE0 from XT_XTCS00 where NAME00 in ('BQ_FYYZMRQYSJ','BQ_PTYZMRQYSJ','ZS_YZ_DQSJWYZQYSJ') order by NAME00 254 08:41:41 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 255 08:41:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 256 08:41:41 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,ZFBL00,BZ0000,NBLBMC,NBZFBL,LBBH00,YPSYSM,COLOUR from VW_BQ_YBYP00 where (PYSM00 Like ?) and( YBZXLB = '3' and YBBRLB = '3' and (((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=481 and YPLBBH='0')) )and LBBH00 = '0') or ((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=481 and YPLBBH='1'))) and LBBH00 = '1')) and ( (exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00 and BZ0000='ºôÎü²¡Çø')) or (not exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00)) ) ) Order By PYSM00) where Rownum<=9999 257 08:41:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %s% 258 08:41:42 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,ZFBL00,BZ0000,NBLBMC,NBZFBL,LBBH00,YPSYSM,COLOUR from VW_BQ_YBYP00 where (PYSM00 Like ?) and( YBZXLB = '3' and YBBRLB = '3' and (((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=481 and YPLBBH='0')) )and LBBH00 = '0') or ((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=481 and YPLBBH='1'))) and LBBH00 = '1')) and ( (exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00 and BZ0000='ºôÎü²¡Çø')) or (not exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00)) ) ) Order By Instrb(PYSM00,'s'),PYSM00) where Rownum<=9999 259 08:41:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %sn% 260 08:41:42 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,ZFBL00,BZ0000,NBLBMC,NBZFBL,LBBH00,YPSYSM,COLOUR from VW_BQ_YBYP00 where (PYSM00 Like ?) and( YBZXLB = '3' and YBBRLB = '3' and (((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=481 and YPLBBH='0')) )and LBBH00 = '0') or ((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=481 and YPLBBH='1'))) and LBBH00 = '1')) and ( (exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00 and BZ0000='ºôÎü²¡Çø')) or (not exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00)) ) ) Order By Instrb(PYSM00,'sn'),PYSM00) where Rownum<=9999 261 08:41:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %sns% 262 08:41:42 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,ZFBL00,BZ0000,NBLBMC,NBZFBL,LBBH00,YPSYSM,COLOUR from VW_BQ_YBYP00 where (PYSM00 Like ?) and( YBZXLB = '3' and YBBRLB = '3' and (((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=481 and YPLBBH='0')) )and LBBH00 = '0') or ((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=481 and YPLBBH='1'))) and LBBH00 = '1')) and ( (exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00 and BZ0000='ºôÎü²¡Çø')) or (not exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00)) ) ) Order By Instrb(PYSM00,'sns'),PYSM00) where Rownum<=9999 263 08:41:43 SQL Execute: ORACLE - select * from VW_BQ_YFYPSC where YPNM00 = 3009 and (((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=481 and YPLBBH='0')) ) and LBBH00 = '0') or ((YFBMBH = 497 or (BQKDYF='Y' and YFBMBH IN (select YFBMBH from XT_YPFWFX where SLBMBH=481 and YPLBBH='1'))) and LBBH00 = '1'))