1 08:18:54 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 2 08:18:58 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='25' 3 08:18:59 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') 4 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852589,'18525881') 5 08:18:59 SQL Data In: ORACLE - Rows affected = 1 6 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852589,'18525882') 7 08:18:59 SQL Data In: ORACLE - Rows affected = 1 8 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852590,'18525881') 9 08:18:59 SQL Data In: ORACLE - Rows affected = 1 10 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852590,'18525882') 11 08:18:59 SQL Data In: ORACLE - Rows affected = 1 12 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1851306,'18513051') 13 08:18:59 SQL Data In: ORACLE - Rows affected = 1 14 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1851307,'18513051') 15 08:18:59 SQL Data In: ORACLE - Rows affected = 1 16 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855255,'18552541') 17 08:18:59 SQL Data In: ORACLE - Rows affected = 1 18 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855256,'18552541') 19 08:18:59 SQL Data In: ORACLE - Rows affected = 1 20 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855258,'18552571') 21 08:18:59 SQL Data In: ORACLE - Rows affected = 1 22 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855259,'18552571') 23 08:18:59 SQL Data In: ORACLE - Rows affected = 1 24 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855261,'18552601') 25 08:18:59 SQL Data In: ORACLE - Rows affected = 1 26 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855262,'18552601') 27 08:18:59 SQL Data In: ORACLE - Rows affected = 1 28 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855263,'18552601') 29 08:18:59 SQL Data In: ORACLE - Rows affected = 1 30 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855264,'18552601') 31 08:18:59 SQL Data In: ORACLE - Rows affected = 1 32 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1853320,'18533191') 33 08:18:59 SQL Data In: ORACLE - Rows affected = 1 34 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1853321,'18533191') 35 08:18:59 SQL Data In: ORACLE - Rows affected = 1 36 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1853323,'18533221') 37 08:18:59 SQL Data In: ORACLE - Rows affected = 1 38 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1853324,'18533221') 39 08:18:59 SQL Data In: ORACLE - Rows affected = 1 40 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1846577,'18465761') 41 08:18:59 SQL Data In: ORACLE - Rows affected = 1 42 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1846578,'18465761') 43 08:18:59 SQL Data In: ORACLE - Rows affected = 1 44 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854070,'18540691') 45 08:18:59 SQL Data In: ORACLE - Rows affected = 1 46 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854071,'18540691') 47 08:18:59 SQL Data In: ORACLE - Rows affected = 1 48 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854132,'18541311') 49 08:18:59 SQL Data In: ORACLE - Rows affected = 1 50 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854133,'18541311') 51 08:18:59 SQL Data In: ORACLE - Rows affected = 1 52 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854135,'18541341') 53 08:18:59 SQL Data In: ORACLE - Rows affected = 1 54 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854136,'18541341') 55 08:18:59 SQL Data In: ORACLE - Rows affected = 1 56 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854138,'18541371') 57 08:18:59 SQL Data In: ORACLE - Rows affected = 1 58 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854139,'18541371') 59 08:18:59 SQL Data In: ORACLE - Rows affected = 1 60 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854140,'18541371') 61 08:18:59 SQL Data In: ORACLE - Rows affected = 1 62 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1848975,'18489741') 63 08:18:59 SQL Data In: ORACLE - Rows affected = 1 64 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1848976,'18489741') 65 08:18:59 SQL Data In: ORACLE - Rows affected = 1 66 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1848404,'18484031') 67 08:18:59 SQL Data In: ORACLE - Rows affected = 1 68 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1848405,'18484031') 69 08:18:59 SQL Data In: ORACLE - Rows affected = 1 70 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1848406,'18484031') 71 08:18:59 SQL Data In: ORACLE - Rows affected = 1 72 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1848407,'18484031') 73 08:18:59 SQL Data In: ORACLE - Rows affected = 1 74 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1848408,'18484031') 75 08:18:59 SQL Data In: ORACLE - Rows affected = 1 76 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1849947,'18499461') 77 08:18:59 SQL Data In: ORACLE - Rows affected = 1 78 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1849948,'18499461') 79 08:18:59 SQL Data In: ORACLE - Rows affected = 1 80 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852889,'18528881') 81 08:18:59 SQL Data In: ORACLE - Rows affected = 1 82 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852890,'18528881') 83 08:18:59 SQL Data In: ORACLE - Rows affected = 1 84 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852892,'18528911') 85 08:18:59 SQL Data In: ORACLE - Rows affected = 1 86 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852893,'18528911') 87 08:18:59 SQL Data In: ORACLE - Rows affected = 1 88 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852895,'18528941') 89 08:18:59 SQL Data In: ORACLE - Rows affected = 1 90 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852896,'18528941') 91 08:18:59 SQL Data In: ORACLE - Rows affected = 1 92 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852897,'18528941') 93 08:18:59 SQL Data In: ORACLE - Rows affected = 1 94 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855115,'18551141') 95 08:18:59 SQL Data In: ORACLE - Rows affected = 1 96 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855116,'18551141') 97 08:18:59 SQL Data In: ORACLE - Rows affected = 1 98 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1851522,'18515211') 99 08:18:59 SQL Data In: ORACLE - Rows affected = 1 100 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1851523,'18515211') 101 08:18:59 SQL Data In: ORACLE - Rows affected = 1 102 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852769,'18527681') 103 08:18:59 SQL Data In: ORACLE - Rows affected = 1 104 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852770,'18527681') 105 08:18:59 SQL Data In: ORACLE - Rows affected = 1 106 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855284,'18552831') 107 08:18:59 SQL Data In: ORACLE - Rows affected = 1 108 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855285,'18552831') 109 08:18:59 SQL Data In: ORACLE - Rows affected = 1 110 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855286,'18552831') 111 08:18:59 SQL Data In: ORACLE - Rows affected = 1 112 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855287,'18552831') 113 08:18:59 SQL Data In: ORACLE - Rows affected = 1 114 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1851254,'18512531') 115 08:18:59 SQL Data In: ORACLE - Rows affected = 1 116 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1851255,'18512531') 117 08:18:59 SQL Data In: ORACLE - Rows affected = 1 118 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855071,'18550701') 119 08:18:59 SQL Data In: ORACLE - Rows affected = 1 120 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855072,'18550701') 121 08:18:59 SQL Data In: ORACLE - Rows affected = 1 122 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855097,'18550961') 123 08:18:59 SQL Data In: ORACLE - Rows affected = 1 124 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852946,'18529451') 125 08:18:59 SQL Data In: ORACLE - Rows affected = 1 126 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852947,'18529451') 127 08:18:59 SQL Data In: ORACLE - Rows affected = 1 128 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852948,'18529451') 129 08:18:59 SQL Data In: ORACLE - Rows affected = 1 130 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1852949,'18529451') 131 08:18:59 SQL Data In: ORACLE - Rows affected = 1 132 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1853247,'18532461') 133 08:18:59 SQL Data In: ORACLE - Rows affected = 1 134 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1853248,'18532461') 135 08:18:59 SQL Data In: ORACLE - Rows affected = 1 136 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856112,'18561111') 137 08:18:59 SQL Data In: ORACLE - Rows affected = 1 138 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856113,'18561111') 139 08:18:59 SQL Data In: ORACLE - Rows affected = 1 140 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856114,'18561111') 141 08:18:59 SQL Data In: ORACLE - Rows affected = 1 142 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855326,'18553251') 143 08:18:59 SQL Data In: ORACLE - Rows affected = 1 144 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855327,'18553251') 145 08:18:59 SQL Data In: ORACLE - Rows affected = 1 146 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854388,'18543871') 147 08:18:59 SQL Data In: ORACLE - Rows affected = 1 148 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854389,'18543871') 149 08:18:59 SQL Data In: ORACLE - Rows affected = 1 150 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854391,'18543901') 151 08:18:59 SQL Data In: ORACLE - Rows affected = 1 152 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1854392,'18543901') 153 08:18:59 SQL Data In: ORACLE - Rows affected = 1 154 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855353,'18553511') 155 08:18:59 SQL Data In: ORACLE - Rows affected = 1 156 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855352,'18553511') 157 08:18:59 SQL Data In: ORACLE - Rows affected = 1 158 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856738,'18567371') 159 08:18:59 SQL Data In: ORACLE - Rows affected = 1 160 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856739,'18567371') 161 08:18:59 SQL Data In: ORACLE - Rows affected = 1 162 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856740,'18567371') 163 08:18:59 SQL Data In: ORACLE - Rows affected = 1 164 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856741,'18567371') 165 08:18:59 SQL Data In: ORACLE - Rows affected = 1 166 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856670,'18566691') 167 08:18:59 SQL Data In: ORACLE - Rows affected = 1 168 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856671,'18566691') 169 08:18:59 SQL Data In: ORACLE - Rows affected = 1 170 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856673,'18566721') 171 08:18:59 SQL Data In: ORACLE - Rows affected = 1 172 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856674,'18566721') 173 08:18:59 SQL Data In: ORACLE - Rows affected = 1 174 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856675,'18566721') 175 08:18:59 SQL Data In: ORACLE - Rows affected = 1 176 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1856676,'18566721') 177 08:18:59 SQL Data In: ORACLE - Rows affected = 1 178 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855243,'18552421') 179 08:18:59 SQL Data In: ORACLE - Rows affected = 1 180 08:18:59 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (1855244,'18552421') 181 08:18:59 SQL Data In: ORACLE - Rows affected = 1 182 08:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 183 08:18:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 184 08:18:59 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 185 08:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 186 08:18:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 187 08:18:59 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 188 08:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 189 08:18:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 190 08:18:59 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 191 08:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 192 08:18:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 193 08:18:59 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 194 08:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 195 08:18:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 196 08:18:59 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 197 08:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 198 08:18:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 199 08:18:59 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 200 08:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 201 08:18:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 202 08:18:59 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 203 08:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 204 08:18:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 205 08:18:59 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 206 08:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 207 08:18:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 208 08:18:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 209 08:18:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 210 08:18:59 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 211 08:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 212 08:18:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 213 08:18:59 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 214 08:19:00 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,SF_BQ_CSRQTONL(csrq00) as nl0000,YYRQ00,CLBZ00 from VW_BQ_JRSYYZ a where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') order by CH0000 215 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=98451 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 216 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=99255 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 217 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=99254 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 218 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=99104 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 219 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=99016 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 220 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=99006 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 221 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=97888 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 222 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=98899 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 223 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=99000 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 224 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=98605 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 225 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=99009 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 226 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=98499 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 227 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=99013 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 228 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=99098 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 229 08:19:00 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=819 and zyid00 in (98451,97101,99255,99254,99104,99016,99006,97888,98899,99000,98605,97364,99009,98499,98599,99013,99098,98352) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=98352 and BQH000=819 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID