Hi, I need a help on PL/SQL I have A table EN and few columns and its values are as below SQL> select distinct(cpstpn),concno from en ORDER BY CPSTPN; CPSTPN CONCNO counnt(concno) ---------- ---------- --------------- 0 0 1234 0 2 1578 0 4 1238 0 5 800 0 7 567 1 2 1234 1 4 1587 3 0 1489 3 1 1287 select cpstpn,concno,enum,lctype,synthetic from en where cpstpn=0 and concno=0 and abbrnac=10 order by enum asc; CPSTPN CONCNO ENUM LCTYPE SYNTHETIC ---------- ---------- ---------- -------- -------------------------- 0 0 0 MK3MCI 00POOLE1000MK3MCI20000000 0 0 1 MK3STSP 0 0 2 MK3STSP 0 0 3 MK3STSP 00POOLE100MK3STSP45571400 0 0 4 MK3STSP 0 0 5 MK3STSP 0 0 6 MK3STSP 0 0 7 MK3STSP 00POOLE100MK3STSP19969600 0 0 8 MK3STSP 0 0 9 MK3STSP 00POOLE100MK3STSP45549500 0 0 10 MK3STSP CPSTPN CONCNO ENUM LCTYPE SYNTHETIC ---------- ---------- ---------- -------- -------------------------- 0 0 11 MK3STSP 0 0 12 MK3STSP 0 0 13 MK3STSP 00POOLE100MK3STSP45476100 0 0 14 MK3STSP 0 0 15 MK3STSP 0 0 16 MK3MCI 0 0 17 MK3STSP 00POOLE100MK3STSP19852600 0 0 18 MK3STSP My query 1 cpstpn has many Concno 1 concno has upto 2048 ENUM There is one more Column Name Recstat if the recstat column is 0 consider it is free else not free Conside 1 cpstpn has 4 concno 1 concno has 1500 enum Toatl of Enum on 1 cpstpn=4*1500=6000Enum I want to pick up 24 enum's such that it goes as below 1) FIND A CPSTPN,CONCNO by listing cpstpn having least free device and again in that concno having least free devices Ex: consder cpstpn1 has concno 1 and 2 and count of free device(recstat=0) is 510 cpstpn concno free_count 1 0 210 1 1 300 --------------------- total: 1 510 consder cpstpn 2 has concno 1 and 2 and count of free device(recstat=0) is 710 cpstpn concno count(concno) 2 1 250 2 2 460 --------------------- total: 1 710 My final list should look like this that is in the order of concno having least free equipment (Need the query for the below output) cpstpn concno count(concno) 1 0 210 2 1 250 1 1 310 2 2 460 so that i can pick the cpstpn=1 and concno=0 in case i find the a single concentrator having free equipments greater than requested ENUM(i.e in this case 24) all the concno has free equipments greater than 24 ******************************************************************************************************* select count(*) froom en where cpstn=1 and concno=0 gives me 780 records(which include recstat=0 and recstat!=0) 780/64=12.18 i need to split the 780 into rows of 64 if there are remaining records that needs to go to next element(LCT column is imginary and hwo i wnat to split the rows into block of 64) like below CPSTPN CONCNO ENUM LCTYPE SYNTHETIC LCT ---------- ---------- ---------- -------- ------------------------------------------ 0 0 0 MK3MCI 00POOLE1000MK3MCI20000000 1 0 0 1 MK3STSP 1 . . . . . . 0 0 63 MK3STSP 00POOLE100MK3STSP45571400 2 . . . . . . 0 0 127 MK3STSP 2 0 0 128 MK3STSP 3 0 0 129 MK3STSP 3 Again in this i need to find the count of free devices(synnthrtic field is not null) in each LCT LCT FREE COUNT ------------------------ 1 20 2 30 3 1 SO i wnat to now to dstribute the input 24 Equipments in the above free count rows in round robin fashion (free count rows is nothing but row having snthetic field as null) i.e as below CPSTPN CONCNO ENUM LCTYPE SYNTHETIC LCT ------------------------------------------------------------------------------------- 0 0 2 MK3MCI 1 0 0 65 MK3STSP 2 0 0 128 MK3STSP 3 my 24 enum will be as below 2 65 128 . if the count of free devices becomes zero during picking of enum from skip & go to next lct ******************************************************************************************** in case i dint find a single concno having enough free equiments as requested i need to pick the enum across concentrators(as min imu as possible) under single cpstpn having free quipments greater than >= my request requested enum=24 and free counts in conco is as below cpstpn concno count(concno) ---------------------------- 1 0 8 1 1 3 2 1 13 2 2 6 2 3 4 i need to pick up cpstpn 2 and conco=1 and alaccote= 13 enum as explained up then i need to pick up cpstpn 2 and conco=2 and alaccote= 6 enum as explained up then i need to pick up cpstpn 2 and conco=2 and alaccote= 3 enum as explained up so that input request of 24 ENUM is satisfied ccondition: while picking the cpstpn here i will have to ensue that i pick the cpstpn having least free devices first > my input request always first Also when two or three jobs comes @ once for 24(or any num) as request there should not be any collision My intention Here is to Distrinute the ENUM across LCT's in round Robin Fashion on A single COncno or more concno I hope this helps now The Data is huge I had tried to put of One CPSTPN,CONCNO CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 0 00POOLE1000MK3MCI20000000 1 0 0 1 1 0 0 2 1 0 0 3 00POOLE100MK3STSP45571400 1 0 0 4 1 0 0 5 1 0 0 6 1 0 0 7 00POOLE100MK3STSP19969600 1 0 0 8 1 0 0 9 00POOLE100MK3STSP45549500 1 0 0 10 1 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 11 1 0 0 12 1 0 0 13 00POOLE100MK3STSP45476100 1 0 0 14 1 0 0 15 1 0 0 16 1 0 0 17 00POOLE100MK3STSP19852600 1 0 0 18 1 0 0 19 1 0 0 20 1 0 0 21 00POOLE100MK3STSP45467000 1 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 22 1 0 0 23 00POOLE100MK3STSP45539400 1 0 0 24 1 0 0 25 00POOLE100MK3STSP45578900 1 0 0 26 1 0 0 27 1 0 0 28 1 0 0 29 00POOLE100MK3STSP45471800 1 0 0 30 1 0 0 31 1 0 0 32 00POOLE1000MK3MCI45585900 1 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 33 1 0 0 34 1 0 0 35 1 0 0 36 00POOLE100MK3STSP45566000 1 0 0 37 00POOLE100MK3STSP19954500 1 0 0 38 1 0 0 39 1 0 0 40 1 0 0 41 00POOLE100MK3STSP45539800 1 0 0 42 00POOLE100MK3STSP19979900 1 0 0 43 00POOLE100MK3STSP45588200 1 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 44 1 0 0 45 1 0 0 46 00POOLE100MK3STSP19866100 1 0 0 47 1 0 0 48 1 0 0 49 00POOLE100MK3STSP45570500 1 0 0 50 1 0 0 51 1 0 0 52 1 0 0 53 1 0 0 54 1 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 55 00POOLE100MK3STSP45567100 1 0 0 56 1 0 0 57 1 0 0 58 00POOLE100MK3STSP45563800 1 0 0 59 1 0 0 60 1 0 0 61 1 0 0 62 1 0 0 63 1 0 0 64 00POOLE1000MK3MCI45474300 2 0 0 65 2 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 66 00POOLE100MK3STSP45489700 2 0 0 67 00POOLE100MK3STSP19939100 2 0 0 68 00POOLE100MK3STSP19910900 2 0 0 69 2 0 0 70 00POOLE100MK3STSP45521600 2 0 0 71 00POOLE100MK3STSP19993300 2 0 0 72 2 0 0 73 00POOLE100MK3STSP19936300 2 0 0 74 00POOLE100MK3STSP45516900 2 0 0 75 00POOLE100MK3STSP45472000 2 0 0 76 00POOLE100MK3STSP45521600 2 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 77 2 0 0 78 00POOLE100MK3STSP45498500 2 0 0 79 2 0 0 80 00POOLE1000MK3MCI45439700 2 0 0 81 2 0 0 82 00POOLE100MK3STSP19848100 2 0 0 83 2 0 0 84 00POOLE100MK3STSP45585500 2 0 0 85 00POOLE100MK3STSP19930500 2 0 0 86 00POOLE100MK3STSP19902000 2 0 0 87 00POOLE100MK3STSP45497300 2 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 88 00POOLE100MK3STSP45518300 2 0 0 89 2 0 0 90 00POOLE100MK3STSP45489700 2 0 0 91 2 0 0 92 2 0 0 93 2 0 0 94 2 0 0 95 2 0 0 96 2 0 0 97 2 0 0 98 00POOLE100MK3STSP19896000 2 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 99 00POOLE100MK3STSP19867700 2 0 0 100 00POOLE100MK3STSP45507000 2 0 0 101 2 0 0 102 00POOLE100MK3STSP45591500 2 0 0 103 00POOLE100MK3STSP45551900 2 0 0 104 00POOLE100MK3STSP45582600 2 0 0 105 2 0 0 106 2 0 0 107 2 0 0 108 00POOLE100MK3STSP19949600 2 0 0 109 00POOLE100MK3STSP45541400 2 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 110 2 0 0 111 00POOLE100MK3STSP45530700 2 0 0 112 00POOLE1000MK3MCI45487600 2 0 0 113 00POOLE100MK3STSP19975300 2 0 0 114 2 0 0 115 00POOLE100MK3STSP45542900 2 0 0 116 2 0 0 117 00POOLE100MK3STSP19861400 2 0 0 118 2 0 0 119 2 0 0 120 2 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 121 00POOLE100MK3STSP45585300 2 0 0 122 00POOLE100MK3STSP45497300 2 0 0 123 2 0 0 124 2 0 0 125 2 0 0 126 00POOLE100MK3STSP45443300 2 0 0 127 2 0 0 128 00POOLE1000MK3MCI19992400 3 0 0 129 3 0 0 130 3 0 0 131 00POOLE100MK3STSP45484400 3 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 132 3 0 0 133 3 0 0 134 00POOLE100MK3STSP45576200 3 0 0 135 00POOLE100MK3STSP45591500 3 0 0 136 3 0 0 137 00POOLE100MK3STSP45467300 3 0 0 138 00POOLE100MK3STSP45500900 3 0 0 139 00POOLE100MK3STSP19905900 3 0 0 140 3 0 0 141 00POOLE100MK3STSP45501400 3 0 0 142 3 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 143 00POOLE100MK3STSP45508900 3 0 0 144 00POOLE1000MK3MCI45470000 3 0 0 145 00POOLE100MK3STSP45521000 3 0 0 146 3 0 0 147 00POOLE100MK3STSP45562300 3 0 0 148 3 0 0 149 3 0 0 150 00POOLE100MK3STSP45481900 3 0 0 151 00POOLE100MK3STSP19899800 3 0 0 152 00POOLE100MK3STSP19871500 3 0 0 153 3 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 154 3 0 0 155 00POOLE100MK3STSP45533000 3 0 0 156 3 0 0 157 00POOLE100MK3STSP19896800 3 0 0 158 3 0 0 159 00POOLE100MK3STSP45548900 3 0 0 160 3 0 0 161 00POOLE100MK3STSP45554800 3 0 0 162 3 0 0 163 3 0 0 164 00POOLE100MK3STSP45529500 3 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 165 00POOLE100MK3STSP45471900 3 0 0 166 00POOLE100MK3STSP45591500 3 0 0 167 00POOLE100MK3STSP45478500 3 0 0 168 3 0 0 169 3 0 0 170 3 0 0 171 3 0 0 172 00POOLE100MK3STSP45451500 3 0 0 173 3 0 0 174 00POOLE100MK3STSP45535000 3 0 0 175 3 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 176 00POOLE1000MK3MCI45495700 3 0 0 177 3 0 0 178 3 0 0 179 00POOLE100MK3STSP45500900 3 0 0 180 3 0 0 181 3 0 0 182 00POOLE100MK3STSP19856400 3 0 0 183 00POOLE100MK3STSP19995600 3 0 0 184 3 0 0 185 3 0 0 186 00POOLE100MK3STSP19910200 3 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 187 00POOLE100MK3STSP19881600 3 0 0 188 00POOLE100MK3STSP45585400 3 0 0 189 00POOLE100MK3STSP45530200 3 0 0 190 3 0 0 191 3 0 0 192 4 0 0 193 4 0 0 194 4 0 0 195 00POOLE100MK3STSP45495300 4 0 0 196 00POOLE100MK3STSP45570100 4 0 0 197 4 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 198 4 0 0 199 4 0 0 200 00POOLE100MK3STSP45547800 4 0 0 201 4 0 0 202 00POOLE100MK3STSP45537600 4 0 0 203 00POOLE100MK3STSP45500900 4 0 0 204 00POOLE100MK3STSP45537400 4 0 0 205 00POOLE100MK3STSP19875600 4 0 0 206 4 0 0 207 4 0 0 208 4 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 209 4 0 0 210 4 0 0 211 4 0 0 212 4 0 0 213 00POOLE100MK3STSP26769000 4 0 0 214 00POOLE100MK3STSP45566300 4 0 0 215 00POOLE100MK3STSP45577700 4 0 0 216 4 0 0 217 4 0 0 218 4 0 0 219 4 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 220 00POOLE100MK3STSP45467200 4 0 0 221 00POOLE100MK3STSP45576100 4 0 0 222 4 0 0 223 4 0 0 224 00POOLE1000MK3MCI19989400 4 0 0 225 4 0 0 226 00POOLE100MK3STSP19949100 4 0 0 227 4 0 0 228 00POOLE100MK3STSP45549000 4 0 0 229 4 0 0 230 00POOLE100MK3STSP19835400 4 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 231 4 0 0 232 00POOLE100MK3STSP19946100 4 0 0 233 4 0 0 234 00POOLE100MK3STSP19889000 4 0 0 235 4 0 0 236 4 0 0 237 4 0 0 238 4 0 0 239 4 0 0 240 00POOLE1000MK3MCI19992600 4 0 0 241 4 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 242 00POOLE100MK3STSP19996900 4 0 0 243 00POOLE100MK3STSP45527800 4 0 0 244 00POOLE100MK3STSP19939700 4 0 0 245 4 0 0 246 4 0 0 247 4 0 0 248 00POOLE100MK3STSP19993900 4 0 0 249 00POOLE100MK3STSP45547000 4 0 0 250 4 0 0 251 00POOLE100MK3STSP45542500 4 0 0 252 4 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 253 00POOLE100MK3STSP45489500 4 0 0 254 4 0 0 255 4 0 0 256 00POOLE1000MK3MCI45560900 5 0 0 257 00POOLE100MK3STSP45539800 5 0 0 258 5 0 0 259 5 0 0 260 5 0 0 261 5 0 0 262 5 0 0 263 5 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 264 00POOLE100MK3STSP45552500 5 0 0 265 00POOLE100MK3STSP19845700 5 0 0 266 5 0 0 267 5 0 0 268 00POOLE100MK3STSP45567200 5 0 0 269 5 0 0 270 5 0 0 271 5 0 0 272 00POOLE1000MK3MCI45461700 5 0 0 273 00POOLE100MK3STSP45500500 5 0 0 274 5 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 275 5 0 0 276 5 0 0 277 00POOLE100MK3STSP19839600 5 0 0 278 5 0 0 279 00POOLE100MK3STSP19950400 5 0 0 280 00POOLE100MK3STSP45498500 5 0 0 281 5 0 0 282 00POOLE100MK3STSP19865000 5 0 0 283 00POOLE100MK3STSP45539300 5 0 0 284 00POOLE100MK3STSP45486800 5 0 0 285 00PO010MK3STSP19947400 5 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 286 5 0 0 287 00POOLE100MK3STSP45568600 5 0 0 288 5 0 0 289 00POOLE100MK3STSP45500500 5 0 0 290 5 0 0 291 00POOLE100MK3STSP19944400 5 0 0 292 5 0 0 293 00POOLE100MK3STSP45509100 5 0 0 294 00POOLE100MK3STSP19859200 5 0 0 295 5 0 0 296 00POOLE100MK3STSP45530100 5 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 297 5 0 0 298 00POOLE100MK3STSP45455100 5 0 0 299 00POOLE100MK3STSP45530000 5 0 0 300 5 0 0 301 00POOLE100MK3STSP45478100 5 0 0 302 00POOLE100MK3STSP19969300 5 0 0 303 00POOLE100MK3STSP19940800 5 0 0 304 00POOLE1000MK3MCI45491000 5 0 0 305 00POOLE100MK3STSP19884000 5 0 0 306 00POOLE100MK3STSP45512700 5 0 0 307 5 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 308 5 0 0 309 5 0 0 310 00POOLE100MK3STSP45467300 5 0 0 311 00POOLE100MK3STSP45576800 5 0 0 312 5 0 0 313 5 0 0 314 00POOLE100MK3STSP45499100 5 0 0 315 5 0 0 316 00POOLE100MK3STSP19906800 5 0 0 317 00POOLE100MK3STSP45439700 5 0 0 318 00POOLE100MK3STSP45480500 5 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 319 5 0 0 320 00POOLE1000MK3MCI45559300 6 0 0 321 6 0 0 322 00POOLE100MK3STSP19903900 6 0 0 323 00POOLE100MK3STSP45485200 6 0 0 324 6 0 0 325 6 0 0 326 00POOLE100MK3STSP45547000 6 0 0 327 00POOLE100MK3STSP19929300 6 0 0 328 00POOLE100MK3STSP45567900 6 0 0 329 6 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 330 6 0 0 331 6 0 0 332 6 0 0 333 00POOLE100MK3STSP45584700 6 0 0 334 00POOLE100MK3STSP45576200 6 0 0 335 00POOLE100MK3STSP19869600 6 0 0 336 6 0 0 337 00POOLE100MK3STSP19980100 6 0 0 338 6 0 0 339 6 0 0 340 6 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 341 00POOLE100MK3STSP45563900 6 0 0 342 6 0 0 343 6 0 0 344 00POOLE100MK3STSP45549000 6 0 0 345 00POOLE100MK3STSP45567100 6 0 0 346 6 0 0 347 6 0 0 348 00POOLE100MK3STSP45500900 6 0 0 349 6 0 0 350 00POOLE100MK3STSP45485200 6 0 0 351 6 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 352 6 0 0 353 6 0 0 354 6 0 0 355 6 0 0 356 6 0 0 357 00POOLE100MK3STSP45570600 6 0 0 358 6 0 0 359 6 0 0 360 6 0 0 361 00POOLE100MK3STSP19968000 6 0 0 362 00POOLE100MK3STSP45500900 6 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 363 6 0 0 364 6 0 0 365 6 0 0 366 6 0 0 367 00POOLE100MK3STSP19965000 6 0 0 368 6 0 0 369 00POOLE100MK3STSP45585200 6 0 0 370 00POOLE100MK3STSP19879800 6 0 0 371 6 0 0 372 6 0 0 373 6 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 374 6 0 0 375 6 0 0 376 00POOLE100MK3STSP45480200 6 0 0 377 6 0 0 378 6 0 0 379 6 0 0 380 6 0 0 381 6 0 0 382 6 0 0 383 6 0 0 384 7 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 385 7 0 0 386 7 0 0 387 7 0 0 388 7 0 0 389 00POOLE100MK3STSP45594400 7 0 0 390 00POOLE100MK3STSP19981700 7 0 0 391 7 0 0 392 7 0 0 393 7 0 0 394 7 0 0 395 7 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 396 7 0 0 397 7 0 0 398 7 0 0 399 7 0 0 400 00POOLE1000MK3MCI45512400 7 0 0 401 7 0 0 402 00POOLE100MK3STSP45500500 7 0 0 403 00POOLE100MK3STSP19949800 7 0 0 404 00POOLE100MK3STSP45577100 7 0 0 405 7 0 0 406 00POOLE100MK3STSP45552600 7 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 407 7 0 0 408 7 0 0 409 7 0 0 410 00POOLE100MK3STSP45485200 7 0 0 411 00POOLE100MK3STSP19889900 7 0 0 412 00POOLE100MK3STSP19861600 7 0 0 413 7 0 0 414 00POOLE100MK3STSP19972200 7 0 0 415 00POOLE100MK3STSP19943700 7 0 0 416 00POOLE1000MK3MCI19994500 7 0 0 417 7 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 418 00POOLE100MK3STSP45453800 7 0 0 419 00POOLE100MK3STSP45584900 7 0 0 420 7 0 0 421 7 0 0 422 00POOLE100MK3STSP45544600 7 0 0 423 7 0 0 424 7 0 0 425 7 0 0 426 00POOLE100MK3STSP19965800 7 0 0 427 00POOLE100MK3STSP45467000 7 0 0 428 00POOLE100MK3STSP19908900 7 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 429 7 0 0 430 7 0 0 431 7 0 0 432 7 0 0 433 00POOLE100MK3STSP45542900 7 0 0 434 00POOLE100MK3STSP45534500 7 0 0 435 00POOLE100MK3STSP19877800 7 0 0 436 00POOLE100MK3STSP19849100 7 0 0 437 00POOLE100MK3STSP45560800 7 0 0 438 00POOLE100MK3STSP45570800 7 0 0 439 00POOLE100MK3STSP19931500 7 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 440 7 0 0 441 7 0 0 442 7 0 0 443 00POOLE100MK3STSP19985500 7 0 0 444 7 0 0 445 00POOLE100MK3STSP45564600 7 0 0 446 7 0 0 447 7 0 0 448 00POOLE1000MK3MCI19989800 8 0 0 449 00POOLE100MK3STSP45541700 8 0 0 450 00POOLE100MK3STSP19954000 8 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 451 00POOLE100MK3STSP45461800 8 0 0 452 8 0 0 453 8 0 0 454 8 0 0 455 8 0 0 456 8 0 0 457 8 0 0 458 00POOLE100MK3STSP45496700 8 0 0 459 00POOLE100MK3STSP45527500 8 0 0 460 8 0 0 461 8 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 462 00POOLE100MK3STSP45474900 8 0 0 463 8 0 0 464 00POOLE1000MK3MCI45521600 8 0 0 465 00POOLE100MK3STSP45567100 8 0 0 466 8 0 0 467 8 0 0 468 00POOLE100MK3STSP19945000 8 0 0 469 00POOLE100MK3STSP45570000 8 0 0 470 8 0 0 471 8 0 0 472 8 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 473 8 0 0 474 8 0 0 475 8 0 0 476 8 0 0 477 8 0 0 478 8 0 0 479 8 0 0 480 00POOLE1000MK3MCI45576200 8 0 0 481 8 0 0 482 8 0 0 483 8 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 484 8 0 0 485 00POOLE100MK3STSP07041000 8 0 0 486 8 0 0 487 00POOLE100MK3STSP45500500 8 0 0 488 8 0 0 489 00POOLE100MK3STSP45520500 8 0 0 490 8 0 0 491 8 0 0 492 00POOLE100MK3STSP45500900 8 0 0 493 00POOLE100MK3STSP45443300 8 0 0 494 8 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 495 8 0 0 496 00POOLE1000MK3MCI45584000 8 0 0 497 8 0 0 498 8 0 0 499 8 0 0 500 8 0 0 501 8 0 0 502 00POOLE100MK3STSP19986800 8 0 0 503 00POOLE100MK3STSP45576900 8 0 0 504 8 0 0 505 8 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 506 8 0 0 507 8 0 0 508 8 0 0 509 8 0 0 510 8 0 0 511 8 0 0 512 00POOLE1000MK3MCI45475700 9 0 0 513 9 0 0 514 9 0 0 515 00POOLE100MK3STSP19952300 9 0 0 516 00POOLE100MK3STSP45527800 9 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 517 00POOLE100MK3STSP45518900 9 0 0 518 9 0 0 519 9 0 0 520 9 0 0 521 00POOLE100MK3STSP45530300 9 0 0 522 9 0 0 523 9 0 0 524 9 0 0 525 9 0 0 526 9 0 0 527 9 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 528 00POOLE1000MK3MCI19994700 9 0 0 529 9 0 0 530 00POOLE100MK3STSP45530700 9 0 0 531 9 0 0 532 00POOLE100MK3STSP19971500 9 0 0 533 9 0 0 534 9 0 0 535 9 0 0 536 00POOLE100MK3STSP19857600 9 0 0 537 9 0 0 538 9 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 539 9 0 0 540 9 0 0 541 00POOLE100MK3STSP19883100 9 0 0 542 00POOLE100MK3STSP45567100 9 0 0 543 00POOLE100MK3STSP19994100 9 0 0 544 00POOLE1000MK3MCI45559300 9 0 0 545 9 0 0 546 9 0 0 547 00POOLE100MK3STSP45472000 9 0 0 548 9 0 0 549 9 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 550 00POOLE100MK3STSP45552500 9 0 0 551 00POOLE100MK3STSP45500900 9 0 0 552 00POOLE100MK3STSP45437200 9 0 0 553 9 0 0 554 9 0 0 555 9 0 0 556 9 0 0 557 00POOLE100MK3STSP45529900 9 0 0 558 9 0 0 559 9 0 0 560 9 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 561 9 0 0 562 9 0 0 563 9 0 0 564 00POOLE100MK3STSP45592600 9 0 0 565 9 0 0 566 9 0 0 567 9 0 0 568 9 0 0 569 00POOLE100MK3STSP19925300 9 0 0 570 9 0 0 571 9 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 572 9 0 0 573 9 0 0 574 00POOLE100MK3STSP45455100 9 0 0 575 9 0 0 576 00POOLE1000MK3MCI19993200 10 0 0 577 00POOLE100MK3STSP45485200 10 0 0 578 10 0 0 579 10 0 0 580 00POOLE100MK3STSP19947600 10 0 0 581 00POOLE100MK3STSP45585500 10 0 0 582 10 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 583 00POOLE100MK3STSP45547400 10 0 0 584 10 0 0 585 00POOLE100MK3STSP19973100 10 0 0 586 00POOLE100MK3STSP45547000 10 0 0 587 00POOLE100MK3STSP45480200 10 0 0 588 00POOLE100MK3STSP45592600 10 0 0 589 10 0 0 590 00POOLE100MK3STSP19998700 10 0 0 591 10 0 0 592 10 0 0 593 00POOLE100MK3STSP45487300 10 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 594 10 0 0 595 00POOLE100MK3STSP45549000 10 0 0 596 10 0 0 597 00POOLE100MK3STSP45564900 10 0 0 598 00POOLE100MK3STSP19938400 10 0 0 599 00POOLE100MK3STSP45529300 10 0 0 600 10 0 0 601 10 0 0 602 00POOLE100MK3STSP45539800 10 0 0 603 00POOLE100MK3STSP45439700 10 0 0 604 00POOLE100MK3STSP45558300 10 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 605 10 0 0 606 00POOLE100MK3STSP45541900 10 0 0 607 10 0 0 608 00POOLE1000MK3MCI19999500 10 0 0 609 10 0 0 610 10 0 0 611 10 0 0 612 10 0 0 613 10 0 0 614 10 0 0 615 00POOLE100MK3STSP19960900 10 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 616 10 0 0 617 10 0 0 618 10 0 0 619 10 0 0 620 10 0 0 621 10 0 0 622 00POOLE100MK3STSP19929500 10 0 0 623 00POOLE100MK3STSP45469800 10 0 0 624 10 0 0 625 10 0 0 626 00POOLE100MK3STSP45585300 10 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 627 00POOLE100MK3STSP19954900 10 0 0 628 10 0 0 629 10 0 0 630 10 0 0 631 00POOLE100MK3STSP45560800 10 0 0 632 00POOLE100MK3STSP19980300 10 0 0 633 00POOLE100MK3STSP32113800 10 0 0 634 10 0 0 635 00POOLE100MK3STSP45568800 10 0 0 636 10 0 0 637 00POOLE100MK3STSP45467900 10 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 638 10 0 0 639 10 0 0 640 00POOLE1000MK3MCI45539100 11 0 0 641 00POOLE100MK3STSP45489700 11 0 0 642 11 0 0 643 11 0 0 644 00POOLE100MK3STSP19974400 11 0 0 645 11 0 0 646 00POOLE100MK3STSP45573300 11 0 0 647 00POOLE100MK3STSP45534200 11 0 0 648 00POOLE100MK3STSP19860500 11 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 649 11 0 0 650 11 0 0 651 11 0 0 652 11 0 0 653 11 0 0 654 11 0 0 655 11 0 0 656 11 0 0 657 11 0 0 658 11 0 0 659 11 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 660 11 0 0 661 00POOLE100MK3STSP19993700 11 0 0 662 11 0 0 663 11 0 0 664 11 0 0 665 11 0 0 666 11 0 0 667 11 0 0 668 11 0 0 669 11 0 0 670 11 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 671 00POOLE100MK3STSP19877000 11 0 0 672 11 0 0 673 00POOLE100MK3STSP45518400 11 0 0 674 11 0 0 675 00POOLE100MK3STSP45473300 11 0 0 676 11 0 0 677 00POOLE100MK3STSP45476100 11 0 0 678 00POOLE100MK3STSP45512700 11 0 0 679 11 0 0 680 11 0 0 681 11 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 682 11 0 0 683 11 0 0 684 11 0 0 685 00POOLE100MK3STSP45517100 11 0 0 686 00POOLE100MK3STSP45570800 11 0 0 687 00POOLE100MK3STSP45530100 11 0 0 688 00POOLE1000MK3MCI19993400 11 0 0 689 00POOLE100MK3STSP19868100 11 0 0 690 00POOLE100MK3STSP19839400 11 0 0 691 00POOLE100MK3STSP45539800 11 0 0 692 00POOLE100MK3STSP45459700 11 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 693 11 0 0 694 11 0 0 695 00POOLE100MK3STSP45530000 11 0 0 696 00POOLE100MK3STSP19836400 11 0 0 697 11 0 0 698 11 0 0 699 11 0 0 700 11 0 0 701 11 0 0 702 11 0 0 703 11 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 704 12 0 0 705 00POOLE100MK3STSP45525900 12 0 0 706 12 0 0 707 00POOLE100MK3STSP19861800 12 0 0 708 00AF010MK3STSP45411200 12 0 0 709 12 0 0 710 12 0 0 711 12 0 0 712 12 0 0 713 00POOLE100MK3STSP45516900 12 0 0 714 00POOLE100MK3STSP19997800 12 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 715 12 0 0 716 12 0 0 717 12 0 0 718 12 0 0 719 12 0 0 720 12 0 0 721 12 0 0 722 12 0 0 723 12 0 0 724 12 0 0 725 00POOLE100MK3STSP45453200 12 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 726 12 0 0 727 12 0 0 728 12 0 0 729 12 0 0 730 12 0 0 731 00POOLE100MK3STSP45576200 12 0 0 732 12 0 0 733 00POOLE100MK3STSP45548900 12 0 0 734 12 0 0 735 12 0 0 736 00POOLE1000MK3MCI45512800 12 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 737 00POOLE100MK3STSP19846300 12 0 0 738 12 0 0 739 12 0 0 740 12 0 0 741 12 0 0 742 00POOLE100MK3STSP45453400 12 0 0 743 12 0 0 744 00POOLE100MK3STSP11304000 12 0 0 745 00POOLE100MK3STSP19954200 12 0 0 746 00POOLE100MK3STSP45560700 12 0 0 747 12 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 748 12 0 0 749 12 0 0 750 12 0 0 751 00POOLE100MK3STSP45457900 12 0 0 752 12 0 0 753 00POOLE100MK3STSP45574400 12 0 0 754 12 0 0 755 00POOLE100MK3STSP45469800 12 0 0 756 00POOLE100MK3STSP45591600 12 0 0 757 12 0 0 758 00POOLE100MK3STSP45576200 12 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 759 12 0 0 760 12 0 0 761 12 0 0 762 12 0 0 763 00POOLE100MK3STSP45588900 12 0 0 764 12 0 0 765 12 0 0 766 12 0 0 767 12 0 0 768 00POOLE1000MK3MCI45514800 13 0 0 769 13 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 770 00POOLE100MK3STSP19913700 13 0 0 771 13 0 0 772 00POOLE100MK3STSP45526500 13 0 0 773 00POOLE100MK3STSP19996000 13 0 0 774 13 0 0 775 13 0 0 776 13 0 0 777 00POOLE100MK3STSP19882000 13 0 0 778 13 0 0 779 13 0 0 780 13 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 781 00POOLE100MK3STSP45591500 13 0 0 782 13 0 0 783 13 0 0 784 00POOLE1000MK3MCI19990400 13 0 0 785 13 0 0 786 13 0 0 787 13 0 0 788 00POOLE100MK3STSP45546700 13 0 0 789 13 0 0 790 13 0 0 791 13 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 792 00POOLE100MK3STSP19958700 13 0 0 793 00POOLE100MK3STSP45594400 13 0 0 794 13 0 0 795 00POOLE100MK3STSP45594400 13 0 0 796 00POOLE100MK3STSP45570500 13 0 0 797 00POOLE100MK3STSP19984200 13 0 0 798 13 0 0 799 13 0 0 800 00POOLE1000MK3MCI19993600 13 0 0 801 13 0 0 802 13 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 803 00POOLE100MK3STSP19984000 13 0 0 804 13 0 0 805 13 0 0 806 00POOLE100MK3STSP19898500 13 0 0 807 13 0 0 808 13 0 0 809 13 0 0 810 00POOLE100MK3STSP19952500 13 0 0 811 00POOLE100MK3STSP45481900 13 0 0 812 13 0 0 813 13 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 814 13 0 0 815 13 0 0 816 13 0 0 817 13 0 0 818 13 0 0 819 00POOLE100MK3STSP45542900 13 0 0 820 13 0 0 821 00POOLE100MK3STSP19975000 13 0 0 822 13 0 0 823 13 0 0 824 13 CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- ---------- 0 0 825 00POOLE100MK3STSP45574300 13 0 0 826 13 0 0 827 13 0 0 828 13 0 0 829 00POOLE100MK3STSP45530700 13 0 0 830 13 0 0 831 00POOLE100MK3STSP19857800 13 832 rows selected. LCT FREE_COUNT ---------- ---------- 1 18 2 32 3 30 4 24 5 30 6 21 7 26 8 16 9 18 10 28 11 20 LCT FREE_COUNT ---------- ---------- 12 18 13 20