Solved

Oracle IN clause

Posted on 2007-03-20
9
23,608 Views
Last Modified: 2013-12-07
Using Oracle 9i, what is the most efficient way of executing the following SELECT and UPDATE statements?

select c.claim_id, c.account_structure_id
from s_dis_claim c
where c.claim_id in (
524903,524905,524912,524913,524916,524923,524924,524929,524935,524940,
524946,524947,524951,524956,524969,524972,524977,524978,524980,524981,
524982,524986,524987,524990,524993,524997,525001,525003,525010,525011,
525015,525016,525028,525037,525040,525045,525059,525061,525066,525067,
525079,525081,525085,525089,525094,525097,525100,525105,525116,525121,
525136,525139,525149,525153,525154,525163,525166,525169,525172,525179,
525180,525181,525187,525194,525198,525199,525204,525206,525217,525218,
525220,525227,525231,525232,525237,525239,525240,525241,525244,525251,
525256,525261,525271,525272,525274,525277,525280,525282,525285,525288,
525289,525293,525294,525295,525299,525301,525303,525311,525312,525315,
525319,525322,525323,525328,525344,525349,525351,525355,525358,525362,
525365,525371,525373,525379,525383,525384,525389,525396,525398,525400,
525402,525412,525415,525416,525422,525424,525425,525431,525433,525435,
525436,525437,525440,525441,525447,525450,525458,525464,525467,525470,
525486,525496,525497,525504,525511,525512,525514,525523,525524,525526,
525527,525532,525538,525540,525543,525544,525545,525546,525548,525550,
525553,525556,525560,525561,525565,525566,525572,525575,525576,525578,
525580,525581,525583,525586,525592,525595,525598,525601,525612,525623,
525624,525632,525637,525640,525643,525645,525648,525649,525652,525657,
525675,525687,525688,525693,525697,525705,525707,525713,525716,525718,
525719,525723,525726,525733,525734,525741,525750,525771,525780,525783,
525800,525801,525802,525803,525808,525814,525817,525819,525829,525831,
525839,525842,525845,525848,525853,525855,525857,525858,525870,525872,
525888,525896,525898,525904,525909,525911,525924,525928,525931,525932,
525933,525936,525938,525939,525945,525950,525952,525957,525959,525965,
525973,525982,525984,525985,525986,525988,525995,526012,526020,526021,
526026,526027,526028,526030,526041,526042,526045,526046,526047,526051,
526056,526065,526066,526068,526076,526087,526088,526090,526093,526097,
526104,526105,526107,526111,526120,526126,526131,526132,526133,526139,
526143,526147,526150,526151,526153,526154,526156,526157,526159,526161,
526167,526172,526185,526186,526190,526195,526198,526203,526205,526206,
526208,526214,526215,526216,526217,526222,526224,526225,526226,526228,
526230,526231,526240,526246,526249,526253,526271,526280,526281,526288,
526289,526301,526313,526322,526324,526328,526338,526345,526362,526371,
526373,526393,526394,526401,526409,526412,526415,526418,526422,526424,
526431,526436,526446,526448,526456,526462,526464,526473,526478,526482,
526489,526493,526495,526496,526497,526498,526499,526509,526515,526516,
526524,526529,526530,526532,526533,526538,526541,526542,526543,526545,
523446,523816,523845,523851,523872,523887,523890,523899,523907,523911,
523921,523942,523960,523969,523977,523981,523989,524021,524022,524025,
524026,524033,524039,524047,524049,524065,524066,524112,524127,524131,
524134,524150,524154,524161,524171,524175,524180,524192,524193,524194,
524195,524200,524203,524211,524222,524236,524239,524256,524257,524258,
524264,524267,524271,524280,524282,524288,524290,524295,524299,524300,
524312,524321,524336,524347,524462,524828,524871,524677,524743,524754,
524286,523963,524059,524146,524230,524398,524431,524509,524640,524667,
524202,524255,524333,524483,524846,573566,523447,523813,523821,523823,
523827,523829,523830,523854,523859,523861,523863,523864,523875,523882,
523893,523895,523897,523898,523913,523915,523917,523926,523927,523934,
523939,523943,523945,523948,523953,523961,523962,523965,523967,523973,
523975,523985,523990,523992,524005,524012,524024,524030,524032,524037,
524042,524044,524052,524057,524062,524068,524072,524079,524081,524093,
524096,524098,524108,524109,524115,524120,524126,524128,524132,524137,
524142,524143,524145,524148,524149,524153,524155,524157,524158,524160,
524162,524163,524164,524168,524169,524172,524174,524177,524178,524179,
524184,524185,524187,524188,524189,524191,524198,524199,524201,524204,
524205,524207,524208,524209,524210,524213,524214,524216,524217,524220,
524223,524226,524227,524229,524232,524233,524238,524246,524248,524249,
524251,524252,524253,524254,524262,524269,524275,524276,524279,524284,
524285,524292,524294,524304,524306,524308,524310,524313,524315,524318,
524320,524323,524327,524332,524343,524411,524425,524428,524444,524447,
524501,524514,524528,524652,524658,524676,524703,524705,524759,524849,
524851,572648,572660,572879,523978,523996,524028,524058,524245,524260,
524322,524325,524339,524359,524374,524399,524408,524418,524536,524610,
524612,524649,524734,524738,524811,524812,523976,524064,524123,524165,
524206,524228,524237,524084,524439,524642,524757,524878,572539,572556,
572592,572604,572638,572837,572849,572856,572866,572875,524353,524419,
524502,524556,524755,523444,523450,523451,523455,523458,523460,523468,
523471,523481,523484,523488,523491,523492,523507,523516,523517,523520,
523521,523529,523532,523540,523542,523548,523554,523555,523559,523563,
523566,523575,523576,523577,523591,523593,523602,523603,523607,523608,
523609,523610,523617,523622,523633,523634,523644,523648,523649,523654,
523659,523662,523663,523664,523667,523669,523670,523675,523678,523682,
523683,523685,523687,523692,523698,523703,523704,523706,523709,523710,
523712,523713,523716,523717,523718,523720,523723,523726,523727,523729,
523731,523739,523740,523742,523752,523753,523755,523757,523758,523764,
523766,523768,523769,523770,523773,523774,523779,523781,523782,523784,
523785,523786,523790,523791,523793,523796,523799,523800,523801,523802,
523803,523805,523806,523807,523808,523809,523811,523814,523818,523819,
523820,523822,523824,523825,523828,523831,523832,523834,523837,523838,
523839,523841,523844,523846,523847,523848,523849,523852,523857,523860,
523862,523865,523866,523867,523869,523873,523874,523876,523878,523879,
523880,523883,523884,523885,523888,523889,523891,523892,523894,523901,
523902,523903,523904,523905,523906,523908,523918,523920,523923,523925,
523932,523935,523936,523937,523940,523941,523946,523947,523949,523950,
523951,523957,523959,523974,523979,523982,523984,523995,523998,523999,
524001,524010,524011,524023,524036,524046,524054,524078,524083,524085,
524086,524097,524124,524125,524218,524265,524273,524296,524393,524437,
524459,524473,524493,524525,524580,524630,524675,524750,524786,524848,
524872,571982,572805,572844,572868,572873,573603,573976,524212,524240,
524241,524242,524243,524281,524316,524328,524381,524382,524416,524489,
524490,524741,524772,524857,572741,524122,524247,524605,524781,524795,
524682,572304,572499,524955,525032,525174,525182,525214,525247,525286,
525397,525409,525516,525541,525542,525554,525563,525613,525641,525660,
525759,525769,525770,525852,525935,525960,525966,525976,525977,525989,
526011,526058,526067,526106,526236,526239,526255,526260,526350,526398,
526400,526428,526443,526453,525210,525304,525348,525361,525520,525642,
525720,525745,525746,525753,525761,525762,525797,525813,525816,525822,
525856,525868,525981,526003,526114,526165,526180,526212,526296,526310,
526339,526360,526396,526514,526537,524917,524963,525078,525112,525141,
525145,525186,525245,525343,525366,525369,525370,525414,525428,525429,
525446,525528,525534,525605,525631,525677,525681,525686,525715,525727,
525728,525782,525789,525790,525792,525840,525877,525878,525889,525934,
525948,526040,526044,526077,526080,526099,526102,526103,526144,526209,
526219,526259,526269,526319,526349,526357,526358,526365,526388,526389,
526408,526411,526416,526425,526437,526449,526454,526470,526481,526490,
526512,572751,572826,572861,572583,572814,572852,572855,572874,574317,
572644,572679,572870,572478,572872,573587,524899,524900,524901,524906,
524907,524908,524909,524911,524914,524918,524919,524920,524921,524922,
524925,524926,524927,524928,524930,524931,524933,524934,524938,524939,
524942,524948,524950,524952,524953,524957,524958,524959,524960,524962,
524965,524967,524973,524974,524975,524979,524984,524985,524988,524992,
524995,524998,525000,525005,525006,525013,525014,525022,525024,525025,
525026,525027,525033,525036,525038,525039,525041,525044,525046,525047,
525048,525049,525050,525051,525052,525053,525054,525058,525060,525062,
525065,525068,525069,525070,525073,525074,525075,525076,525077,525088,
525092,525093,525095,525096,525098,525101,525102,525103,525104,525106,
525107,525108,525109,525110,525113,525114,525119,525120,525124,525126,
525127,525128,525129,525130,525131,525132,525133,525138,525142,525144,
525146,525147,525148,525151,525152,525156,525158,525159,525160,525164,
525165,525168,525173,525175,525178,525185,525189,525190,525191,525192,
525195,525200,525209,525211,525212,525216,525224,525229,525235,525242,
525243,525248,525249,525250,525252,525253,525254,525255,525258,525259,
525263,525264,525265,525268,525269,525270,525273,525275,525281,525287,
525290,525292,525297,525298,525302,525305,525309,525310,525313,525314,
525317,525318,525320,525324,525327,525331,525334,525336,525337,525338,
525339,525347,525350,525353,525354,525357,525359,525360,525363,525364,
525368,525372,525374,525375,525377,525378,525380,525381,525388,525390,
525391,525394,525399,525404,525405,525407,525408,525410,525411,525413,
525417,525418,525419,525421,525423,525427,525434,525438,525442,525443,
525445,525452,525453,525454,525457,525459,525460,525462,525463,525465,
525466,525468,525471,525472,525473,525474,525475,525476,525477,525479,
525482,525483,525484,525485,525487,525488,525489,525490,525493,525498,
525499,525506,525507,525508,525517,525519,525521,525529,525530,525533,
525535,525537,525547,525551,525552,525555,525567,525570,525571,525573,
525574,525579,525585,525588,525593,525597,525602,525606,525607,525608,
525609,525611,525614,525615,525616,525618,525620,525625,525627,525629,
525633,525634,525638,525644,525646,525647,525650,525655,525659,525661,
525662,525671,525672,525673,525674,525676,525680,525682,525683,525684,
525691,525692,525696,525698,525699,525701,525704,525711,525714,525724,
525725,525730,525732,525736,525737,525738,525739,525743,525748,525749,
525751,525756,525757,525760,525763,525767,525773,525774,525777,525778,
525779,525781,525787,525788,525793,525796,525798,525799,525805,525806,
525811,525812,525815,525818,525821,525827,525830,525833,525835,525837,
525841,525843,525849,525850,525851,525854,525859,525861,525862,525863,
525864,525865,525866,525867,525869,525871,525873,525874,525875,525876,
525880,525881,525882,525883,525885,525887,525890,525895,525899,525900,
525902,525905,525907,525915,525919,525921,525922,525923,525927,525929,
525937,525941,525943,525951,525954,525962,525967,525968,525970,525971,
525975,525979,525983,525987,525990,525992,525993,525994,525996,526001,
526004,526007,526008,526009,526017,526019,526022,526023,526025,526031,
526035,526036,526038,526043,526048,526049,526052,526055,526059,526061,
526062,526063,526069,526070,526072,526081,526082,526085,526086,526089,
526091,526092,526094,526095,526096,526100,526101,526108,526109,526110,
526117,526118,526121,526127,526128,526129,526134,526140,526141,526142,
526145,526149,526152,526158,526160,526164,526168,526170,526173,526174,
526175,526176,526177,526178,526179,526181,526182,526184,526187,526188,
526192,526193,526194,526196,526199,526200,526201,526204,526207,526220,
526221,526227,526229,526232,526233,526235,526237,526238,526242,526245,
526247,526248,526250,526251,526258,526261,526262,526263,526264,526270,
526272,526274,526275,526276,526278,526279,526283,526284,526285,526292,
526294,526297,526298,526299,526302,526303,526304,526307,526308,526316,
526317,526320,526321,526323,526329,526330,526331,526334,526336,526342,
526343,526347,526348,526351,526352,526353,526354,526355,526363,526364,
526366,526367,526368,526369,526375,526376,526380,526382,526385,526386,
526387,526391,526392,526397,526399,526404,526405,526406,526414,526417,
526420,526421,526423,526427,526432,526433,526435,526438,526440,526441,
526442,526444,526445,526450,526452,526455,526457,526458,526460,526461,
526463,526465,526467,526468,526472,526474,526477,526479,526480,526483,
526484,526485,526487,526492,526494,526503,526505,526506,526507,526508,
526511,526513,526518,526519,526521,526522,526523,526525,526526,526527,
526528,526531,526534,526535,526536,526546,572828,524101,524166,524244,
524685,612279,612388  
);

update s_dis_claim c
set c.account_structure_id = (case
when c.claim_id = 524903 then 187
when c.claim_id = 524905 then 187
when c.claim_id = 524912 then 187
when c.claim_id = 524913 then 187
when c.claim_id = 524916 then 187
when c.claim_id = 524923 then 187
when c.claim_id = 524924 then 187
when c.claim_id = 524929 then 187
when c.claim_id = 524935 then 187
when c.claim_id = 524940 then 187
when c.claim_id = 524946 then 187
when c.claim_id = 524947 then 187
when c.claim_id = 524951 then 187
when c.claim_id = 524956 then 187
when c.claim_id = 524969 then 187
when c.claim_id = 524972 then 187
when c.claim_id = 524977 then 187
when c.claim_id = 524978 then 187
when c.claim_id = 524980 then 187
when c.claim_id = 524981 then 187
when c.claim_id = 524982 then 187
when c.claim_id = 524986 then 187
when c.claim_id = 524987 then 187
when c.claim_id = 524990 then 187
when c.claim_id = 524993 then 187
when c.claim_id = 524997 then 187
when c.claim_id = 525001 then 187
when c.claim_id = 525003 then 187
when c.claim_id = 525010 then 187
when c.claim_id = 525011 then 187
when c.claim_id = 525015 then 187
when c.claim_id = 525016 then 187
when c.claim_id = 525028 then 187
when c.claim_id = 525037 then 187
when c.claim_id = 525040 then 187
when c.claim_id = 525045 then 187
when c.claim_id = 525059 then 187
when c.claim_id = 525061 then 187
when c.claim_id = 525066 then 187
when c.claim_id = 525067 then 187
when c.claim_id = 525079 then 187
when c.claim_id = 525081 then 187
when c.claim_id = 525085 then 187
when c.claim_id = 525089 then 187
when c.claim_id = 525094 then 187
when c.claim_id = 525097 then 187
when c.claim_id = 525100 then 187
when c.claim_id = 525105 then 187
when c.claim_id = 525116 then 187
when c.claim_id = 525121 then 187
when c.claim_id = 525136 then 187
when c.claim_id = 525139 then 187
when c.claim_id = 525149 then 187
when c.claim_id = 525153 then 187
when c.claim_id = 525154 then 187
when c.claim_id = 525163 then 187
when c.claim_id = 525166 then 187
when c.claim_id = 525169 then 187
when c.claim_id = 525172 then 187
when c.claim_id = 525179 then 187
when c.claim_id = 525180 then 187
when c.claim_id = 525181 then 187
when c.claim_id = 525187 then 187
when c.claim_id = 525194 then 187
when c.claim_id = 525198 then 187
when c.claim_id = 525199 then 187
when c.claim_id = 525204 then 187
when c.claim_id = 525206 then 187
when c.claim_id = 525217 then 187
when c.claim_id = 525218 then 187
when c.claim_id = 525220 then 187
when c.claim_id = 525227 then 187
when c.claim_id = 525231 then 187
when c.claim_id = 525232 then 187
when c.claim_id = 525237 then 187
when c.claim_id = 525239 then 187
when c.claim_id = 525240 then 187
when c.claim_id = 525241 then 187
when c.claim_id = 525244 then 187
when c.claim_id = 525251 then 187
when c.claim_id = 525256 then 187
when c.claim_id = 525261 then 187
when c.claim_id = 525271 then 187
when c.claim_id = 525272 then 187
when c.claim_id = 525274 then 187
when c.claim_id = 525277 then 187
when c.claim_id = 525280 then 187
when c.claim_id = 525282 then 187
when c.claim_id = 525285 then 187
when c.claim_id = 525288 then 187
when c.claim_id = 525289 then 187
when c.claim_id = 525293 then 187
when c.claim_id = 525294 then 187
when c.claim_id = 525295 then 187
when c.claim_id = 525299 then 187
when c.claim_id = 525301 then 187
when c.claim_id = 525303 then 187
when c.claim_id = 525311 then 187
when c.claim_id = 525312 then 187
when c.claim_id = 525315 then 187
when c.claim_id = 525319 then 187
when c.claim_id = 525322 then 187
when c.claim_id = 525323 then 187
when c.claim_id = 525328 then 187
when c.claim_id = 525344 then 187
when c.claim_id = 525349 then 187
when c.claim_id = 525351 then 187
when c.claim_id = 525355 then 187
when c.claim_id = 525358 then 187
when c.claim_id = 525362 then 187
when c.claim_id = 525365 then 187
when c.claim_id = 525371 then 187
when c.claim_id = 525373 then 187
when c.claim_id = 525379 then 187
when c.claim_id = 525383 then 187
when c.claim_id = 525384 then 187
when c.claim_id = 525389 then 187
when c.claim_id = 525396 then 187
when c.claim_id = 525398 then 187
when c.claim_id = 525400 then 187
when c.claim_id = 525402 then 187
when c.claim_id = 525412 then 187
when c.claim_id = 525415 then 187
when c.claim_id = 525416 then 187
when c.claim_id = 525422 then 187
when c.claim_id = 525424 then 187
when c.claim_id = 525425 then 187
when c.claim_id = 525431 then 187
when c.claim_id = 525433 then 187
when c.claim_id = 525435 then 187
when c.claim_id = 525436 then 187
when c.claim_id = 525437 then 187
when c.claim_id = 525440 then 187
when c.claim_id = 525441 then 187
when c.claim_id = 525447 then 187
when c.claim_id = 525450 then 187
when c.claim_id = 525458 then 187
when c.claim_id = 525464 then 187
when c.claim_id = 525467 then 187
when c.claim_id = 525470 then 187
when c.claim_id = 525486 then 187
when c.claim_id = 525496 then 187
when c.claim_id = 525497 then 187
when c.claim_id = 525504 then 187
when c.claim_id = 525511 then 187
when c.claim_id = 525512 then 187
when c.claim_id = 525514 then 187
when c.claim_id = 525523 then 187
when c.claim_id = 525524 then 187
when c.claim_id = 525526 then 187
when c.claim_id = 525527 then 187
when c.claim_id = 525532 then 187
when c.claim_id = 525538 then 187
when c.claim_id = 525540 then 187
when c.claim_id = 525543 then 187
when c.claim_id = 525544 then 187
when c.claim_id = 525545 then 187
when c.claim_id = 525546 then 187
when c.claim_id = 525548 then 187
when c.claim_id = 525550 then 187
when c.claim_id = 525553 then 187
when c.claim_id = 525556 then 187
when c.claim_id = 525560 then 187
when c.claim_id = 525561 then 187
when c.claim_id = 525565 then 187
when c.claim_id = 525566 then 187
when c.claim_id = 525572 then 187
when c.claim_id = 525575 then 187
when c.claim_id = 525576 then 187
when c.claim_id = 525578 then 187
when c.claim_id = 525580 then 187
when c.claim_id = 525581 then 187
when c.claim_id = 525583 then 187
when c.claim_id = 525586 then 187
when c.claim_id = 525592 then 187
when c.claim_id = 525595 then 187
when c.claim_id = 525598 then 187
when c.claim_id = 525601 then 187
when c.claim_id = 525612 then 187
when c.claim_id = 525623 then 187
when c.claim_id = 525624 then 187
when c.claim_id = 525632 then 187
when c.claim_id = 525637 then 187
when c.claim_id = 525640 then 187
when c.claim_id = 525643 then 187
when c.claim_id = 525645 then 187
when c.claim_id = 525648 then 187
when c.claim_id = 525649 then 187
when c.claim_id = 525652 then 187
when c.claim_id = 525657 then 187
when c.claim_id = 525675 then 187
when c.claim_id = 525687 then 187
when c.claim_id = 525688 then 187
when c.claim_id = 525693 then 187
when c.claim_id = 525697 then 187
when c.claim_id = 525705 then 187
when c.claim_id = 525707 then 187
when c.claim_id = 525713 then 187
when c.claim_id = 525716 then 187
when c.claim_id = 525718 then 187
when c.claim_id = 525719 then 187
when c.claim_id = 525723 then 187
when c.claim_id = 525726 then 187
when c.claim_id = 525733 then 187
when c.claim_id = 525734 then 187
when c.claim_id = 525741 then 187
when c.claim_id = 525750 then 187
when c.claim_id = 525771 then 187
when c.claim_id = 525780 then 187
when c.claim_id = 525783 then 187
when c.claim_id = 525800 then 187
when c.claim_id = 525801 then 187
when c.claim_id = 525802 then 187
when c.claim_id = 525803 then 187
when c.claim_id = 525808 then 187
when c.claim_id = 525814 then 187
when c.claim_id = 525817 then 187
when c.claim_id = 525819 then 187
when c.claim_id = 525829 then 187
when c.claim_id = 525831 then 187
when c.claim_id = 525839 then 187
when c.claim_id = 525842 then 187
when c.claim_id = 525845 then 187
when c.claim_id = 525848 then 187
when c.claim_id = 525853 then 187
when c.claim_id = 525855 then 187
when c.claim_id = 525857 then 187
when c.claim_id = 525858 then 187
when c.claim_id = 525870 then 187
when c.claim_id = 525872 then 187
when c.claim_id = 525888 then 187
when c.claim_id = 525896 then 187
when c.claim_id = 525898 then 187
when c.claim_id = 525904 then 187
when c.claim_id = 525909 then 187
when c.claim_id = 525911 then 187
when c.claim_id = 525924 then 187
when c.claim_id = 525928 then 187
when c.claim_id = 525931 then 187
when c.claim_id = 525932 then 187
when c.claim_id = 525933 then 187
when c.claim_id = 525936 then 187
when c.claim_id = 525938 then 187
when c.claim_id = 525939 then 187
when c.claim_id = 525945 then 187
when c.claim_id = 525950 then 187
when c.claim_id = 525952 then 187
when c.claim_id = 525957 then 187
when c.claim_id = 525959 then 187
when c.claim_id = 525965 then 187
when c.claim_id = 525973 then 187
when c.claim_id = 525982 then 187
when c.claim_id = 525984 then 187
when c.claim_id = 525985 then 187
when c.claim_id = 525986 then 187
when c.claim_id = 525988 then 187
when c.claim_id = 525995 then 187
when c.claim_id = 526012 then 187
when c.claim_id = 526020 then 187
when c.claim_id = 526021 then 187
when c.claim_id = 526026 then 187
when c.claim_id = 526027 then 187
when c.claim_id = 526028 then 187
when c.claim_id = 526030 then 187
when c.claim_id = 526041 then 187
when c.claim_id = 526042 then 187
when c.claim_id = 526045 then 187
when c.claim_id = 526046 then 187
when c.claim_id = 526047 then 187
when c.claim_id = 526051 then 187
when c.claim_id = 526056 then 187
when c.claim_id = 526065 then 187
when c.claim_id = 526066 then 187
when c.claim_id = 526068 then 187
when c.claim_id = 526076 then 187
when c.claim_id = 526087 then 187
when c.claim_id = 526088 then 187
when c.claim_id = 526090 then 187
when c.claim_id = 526093 then 187
when c.claim_id = 526097 then 187
when c.claim_id = 526104 then 187
when c.claim_id = 526105 then 187
when c.claim_id = 526107 then 187
when c.claim_id = 526111 then 187
when c.claim_id = 526120 then 187
when c.claim_id = 526126 then 187
when c.claim_id = 526131 then 187
when c.claim_id = 526132 then 187
when c.claim_id = 526133 then 187
when c.claim_id = 526139 then 187
when c.claim_id = 526143 then 187
when c.claim_id = 526147 then 187
when c.claim_id = 526150 then 187
when c.claim_id = 526151 then 187
when c.claim_id = 526153 then 187
when c.claim_id = 526154 then 187
when c.claim_id = 526156 then 187
when c.claim_id = 526157 then 187
when c.claim_id = 526159 then 187
when c.claim_id = 526161 then 187
when c.claim_id = 526167 then 187
when c.claim_id = 526172 then 187
when c.claim_id = 526185 then 187
when c.claim_id = 526186 then 187
when c.claim_id = 526190 then 187
when c.claim_id = 526195 then 187
when c.claim_id = 526198 then 187
when c.claim_id = 526203 then 187
when c.claim_id = 526205 then 187
when c.claim_id = 526206 then 187
when c.claim_id = 526208 then 187
when c.claim_id = 526214 then 187
when c.claim_id = 526215 then 187
when c.claim_id = 526216 then 187
when c.claim_id = 526217 then 187
when c.claim_id = 526222 then 187
when c.claim_id = 526224 then 187
when c.claim_id = 526225 then 187
when c.claim_id = 526226 then 187
when c.claim_id = 526228 then 187
when c.claim_id = 526230 then 187
when c.claim_id = 526231 then 187
when c.claim_id = 526240 then 187
when c.claim_id = 526246 then 187
when c.claim_id = 526249 then 187
when c.claim_id = 526253 then 187
when c.claim_id = 526271 then 187
when c.claim_id = 526280 then 187
when c.claim_id = 526281 then 187
when c.claim_id = 526288 then 187
when c.claim_id = 526289 then 187
when c.claim_id = 526301 then 187
when c.claim_id = 526313 then 187
when c.claim_id = 526322 then 187
when c.claim_id = 526324 then 187
when c.claim_id = 526328 then 187
when c.claim_id = 526338 then 187
when c.claim_id = 526345 then 187
when c.claim_id = 526362 then 187
when c.claim_id = 526371 then 187
when c.claim_id = 526373 then 187
when c.claim_id = 526393 then 187
when c.claim_id = 526394 then 187
when c.claim_id = 526401 then 187
when c.claim_id = 526409 then 187
when c.claim_id = 526412 then 187
when c.claim_id = 526415 then 187
when c.claim_id = 526418 then 187
when c.claim_id = 526422 then 187
when c.claim_id = 526424 then 187
when c.claim_id = 526431 then 187
when c.claim_id = 526436 then 187
when c.claim_id = 526446 then 187
when c.claim_id = 526448 then 187
when c.claim_id = 526456 then 187
when c.claim_id = 526462 then 187
when c.claim_id = 526464 then 187
when c.claim_id = 526473 then 187
when c.claim_id = 526478 then 187
when c.claim_id = 526482 then 187
when c.claim_id = 526489 then 187
when c.claim_id = 526493 then 187
when c.claim_id = 526495 then 187
when c.claim_id = 526496 then 187
when c.claim_id = 526497 then 187
when c.claim_id = 526498 then 187
when c.claim_id = 526499 then 187
when c.claim_id = 526509 then 187
when c.claim_id = 526515 then 187
when c.claim_id = 526516 then 187
when c.claim_id = 526524 then 187
when c.claim_id = 526529 then 187
when c.claim_id = 526530 then 187
when c.claim_id = 526532 then 187
when c.claim_id = 526533 then 187
when c.claim_id = 526538 then 187
when c.claim_id = 526541 then 187
when c.claim_id = 526542 then 187
when c.claim_id = 526543 then 187
when c.claim_id = 526545 then 187
when c.claim_id = 523446 then 194
when c.claim_id = 523816 then 194                   
when c.claim_id = 523845 then 194                   
when c.claim_id = 523851 then 194                   
when c.claim_id = 523872 then 194                   
when c.claim_id = 523887 then 194
when c.claim_id = 523890 then 194
when c.claim_id = 523899 then 194
when c.claim_id = 523907 then 194
when c.claim_id = 523911 then 194
when c.claim_id = 523921 then 194
when c.claim_id = 523942 then 194
when c.claim_id = 523960 then 194
when c.claim_id = 523969 then 194
when c.claim_id = 523977 then 194
when c.claim_id = 523981 then 194
when c.claim_id = 523989 then 194
when c.claim_id = 524021 then 194
when c.claim_id = 524022 then 194
when c.claim_id = 524025 then 194
when c.claim_id = 524026 then 194
when c.claim_id = 524033 then 194
when c.claim_id = 524039 then 194
when c.claim_id = 524047 then 194
when c.claim_id = 524049 then 194
when c.claim_id = 524065 then 194
when c.claim_id = 524066 then 194
when c.claim_id = 524112 then 194
when c.claim_id = 524127 then 194
when c.claim_id = 524131 then 194
when c.claim_id = 524134 then 194
when c.claim_id = 524150 then 194
when c.claim_id = 524154 then 194
when c.claim_id = 524161 then 194
when c.claim_id = 524171 then 194
when c.claim_id = 524175 then 194
when c.claim_id = 524180 then 194
when c.claim_id = 524192 then 194
when c.claim_id = 524193 then 194
when c.claim_id = 524194 then 194
when c.claim_id = 524195 then 194
when c.claim_id = 524200 then 194
when c.claim_id = 524203 then 194
when c.claim_id = 524211 then 194
when c.claim_id = 524222 then 194
when c.claim_id = 524236 then 194
when c.claim_id = 524239 then 194
when c.claim_id = 524256 then 194
when c.claim_id = 524257 then 194
when c.claim_id = 524258 then 194
when c.claim_id = 524264 then 194
when c.claim_id = 524267 then 194
when c.claim_id = 524271 then 194
when c.claim_id = 524280 then 194
when c.claim_id = 524282 then 194
when c.claim_id = 524288 then 194
when c.claim_id = 524290 then 194
when c.claim_id = 524295 then 194
when c.claim_id = 524299 then 194
when c.claim_id = 524300 then 194
when c.claim_id = 524312 then 194
when c.claim_id = 524321 then 194
when c.claim_id = 524336 then 194
when c.claim_id = 524347 then 194
when c.claim_id = 524462 then 194
when c.claim_id = 524828 then 194
when c.claim_id = 524871 then 194
when c.claim_id = 524677 then 195
when c.claim_id = 524743 then 195
when c.claim_id = 524754 then 195
when c.claim_id = 524286 then 197
when c.claim_id = 523963 then 198
when c.claim_id = 524059 then 198
when c.claim_id = 524146 then 198
when c.claim_id = 524230 then 198
when c.claim_id = 524398 then 198
when c.claim_id = 524431 then 198
when c.claim_id = 524509 then 198
when c.claim_id = 524640 then 198
when c.claim_id = 524667 then 198
when c.claim_id = 524202 then 201
when c.claim_id = 524255 then 201
when c.claim_id = 524333 then 201
when c.claim_id = 524483 then 201
when c.claim_id = 524846 then 201
when c.claim_id = 573566 then 201
when c.claim_id = 523447 then 204
when c.claim_id = 523813 then 204
when c.claim_id = 523821 then 204
when c.claim_id = 523823 then 204
when c.claim_id = 523827 then 204
when c.claim_id = 523829 then 204
when c.claim_id = 523830 then 204
when c.claim_id = 523854 then 204
when c.claim_id = 523859 then 204
when c.claim_id = 523861 then 204
when c.claim_id = 523863 then 204
when c.claim_id = 523864 then 204
when c.claim_id = 523875 then 204
when c.claim_id = 523882 then 204
when c.claim_id = 523893 then 204
when c.claim_id = 523895 then 204
when c.claim_id = 523897 then 204
when c.claim_id = 523898 then 204
when c.claim_id = 523913 then 204
when c.claim_id = 523915 then 204
when c.claim_id = 523917 then 204
when c.claim_id = 523926 then 204
when c.claim_id = 523927 then 204
when c.claim_id = 523934 then 204
when c.claim_id = 523939 then 204
when c.claim_id = 523943 then 204
when c.claim_id = 523945 then 204
when c.claim_id = 523948 then 204
when c.claim_id = 523953 then 204
when c.claim_id = 523961 then 204
when c.claim_id = 523962 then 204
when c.claim_id = 523965 then 204
when c.claim_id = 523967 then 204
when c.claim_id = 523973 then 204
when c.claim_id = 523975 then 204
when c.claim_id = 523985 then 204
when c.claim_id = 523990 then 204
when c.claim_id = 523992 then 204
when c.claim_id = 524005 then 204
when c.claim_id = 524012 then 204
when c.claim_id = 524024 then 204
when c.claim_id = 524030 then 204
when c.claim_id = 524032 then 204
when c.claim_id = 524037 then 204
when c.claim_id = 524042 then 204
when c.claim_id = 524044 then 204
when c.claim_id = 524052 then 204
when c.claim_id = 524057 then 204
when c.claim_id = 524062 then 204
when c.claim_id = 524068 then 204
when c.claim_id = 524072 then 204
when c.claim_id = 524079 then 204
when c.claim_id = 524081 then 204
when c.claim_id = 524093 then 204
when c.claim_id = 524096 then 204
when c.claim_id = 524098 then 204
when c.claim_id = 524108 then 204
when c.claim_id = 524109 then 204
when c.claim_id = 524115 then 204
when c.claim_id = 524120 then 204
when c.claim_id = 524126 then 204
when c.claim_id = 524128 then 204
when c.claim_id = 524132 then 204
when c.claim_id = 524137 then 204
when c.claim_id = 524142 then 204
when c.claim_id = 524143 then 204
when c.claim_id = 524145 then 204
when c.claim_id = 524148 then 204
when c.claim_id = 524149 then 204
when c.claim_id = 524153 then 204
when c.claim_id = 524155 then 204
when c.claim_id = 524157 then 204
when c.claim_id = 524158 then 204
when c.claim_id = 524160 then 204
when c.claim_id = 524162 then 204
when c.claim_id = 524163 then 204
when c.claim_id = 524164 then 204
when c.claim_id = 524168 then 204
when c.claim_id = 524169 then 204
when c.claim_id = 524172 then 204
when c.claim_id = 524174 then 204
when c.claim_id = 524177 then 204
when c.claim_id = 524178 then 204
when c.claim_id = 524179 then 204
when c.claim_id = 524184 then 204
when c.claim_id = 524185 then 204
when c.claim_id = 524187 then 204
when c.claim_id = 524188 then 204
when c.claim_id = 524189 then 204
when c.claim_id = 524191 then 204
when c.claim_id = 524198 then 204
when c.claim_id = 524199 then 204
when c.claim_id = 524201 then 204
when c.claim_id = 524204 then 204
when c.claim_id = 524205 then 204
when c.claim_id = 524207 then 204
when c.claim_id = 524208 then 204
when c.claim_id = 524209 then 204
when c.claim_id = 524210 then 204
when c.claim_id = 524213 then 204
when c.claim_id = 524214 then 204
when c.claim_id = 524216 then 204
when c.claim_id = 524217 then 204
when c.claim_id = 524220 then 204
when c.claim_id = 524223 then 204
when c.claim_id = 524226 then 204
when c.claim_id = 524227 then 204
when c.claim_id = 524229 then 204
when c.claim_id = 524232 then 204
when c.claim_id = 524233 then 204
when c.claim_id = 524238 then 204
when c.claim_id = 524246 then 204
when c.claim_id = 524248 then 204
when c.claim_id = 524249 then 204
when c.claim_id = 524251 then 204
when c.claim_id = 524252 then 204
when c.claim_id = 524253 then 204
when c.claim_id = 524254 then 204
when c.claim_id = 524262 then 204
when c.claim_id = 524269 then 204
when c.claim_id = 524275 then 204
when c.claim_id = 524276 then 204
when c.claim_id = 524279 then 204
when c.claim_id = 524284 then 204
when c.claim_id = 524285 then 204
when c.claim_id = 524292 then 204
when c.claim_id = 524294 then 204
when c.claim_id = 524304 then 204
when c.claim_id = 524306 then 204
when c.claim_id = 524308 then 204
when c.claim_id = 524310 then 204
when c.claim_id = 524313 then 204
when c.claim_id = 524315 then 204
when c.claim_id = 524318 then 204
when c.claim_id = 524320 then 204
when c.claim_id = 524323 then 204
when c.claim_id = 524327 then 204
when c.claim_id = 524332 then 204
when c.claim_id = 524343 then 204
when c.claim_id = 524411 then 204
when c.claim_id = 524425 then 204
when c.claim_id = 524428 then 204
when c.claim_id = 524444 then 204
when c.claim_id = 524447 then 204
when c.claim_id = 524501 then 204
when c.claim_id = 524514 then 204
when c.claim_id = 524528 then 204
when c.claim_id = 524652 then 204
when c.claim_id = 524658 then 204
when c.claim_id = 524676 then 204
when c.claim_id = 524703 then 204
when c.claim_id = 524705 then 204
when c.claim_id = 524759 then 204
when c.claim_id = 524849 then 204                   
when c.claim_id = 524851 then 204
when c.claim_id = 572648 then 204
when c.claim_id = 572660 then 204
when c.claim_id = 572879 then 204
when c.claim_id = 523978 then 206
when c.claim_id = 523996 then 206
when c.claim_id = 524028 then 206
when c.claim_id = 524058 then 206
when c.claim_id = 524245 then 206
when c.claim_id = 524260 then 206
when c.claim_id = 524322 then 206
when c.claim_id = 524325 then 206
when c.claim_id = 524339 then 206
when c.claim_id = 524359 then 206
when c.claim_id = 524374 then 206
when c.claim_id = 524399 then 206
when c.claim_id = 524408 then 206
when c.claim_id = 524418 then 206
when c.claim_id = 524536 then 206
when c.claim_id = 524610 then 206
when c.claim_id = 524612 then 206
when c.claim_id = 524649 then 206
when c.claim_id = 524734 then 206
when c.claim_id = 524738 then 206
when c.claim_id = 524811 then 206
when c.claim_id = 524812 then 206
when c.claim_id = 523976 then 207
when c.claim_id = 524064 then 207
when c.claim_id = 524123 then 207
when c.claim_id = 524165 then 207
when c.claim_id = 524206 then 207
when c.claim_id = 524228 then 207
when c.claim_id = 524237 then 207
when c.claim_id = 524084 then 208
when c.claim_id = 524439 then 208
when c.claim_id = 524642 then 208
when c.claim_id = 524757 then 208
when c.claim_id = 524878 then 208
when c.claim_id = 572539 then 209
when c.claim_id = 572556 then 209
when c.claim_id = 572592 then 209
when c.claim_id = 572604 then 209
when c.claim_id = 572638 then 209
when c.claim_id = 572837 then 209
when c.claim_id = 572849 then 209
when c.claim_id = 572856 then 209
when c.claim_id = 572866 then 209
when c.claim_id = 572875 then 209
when c.claim_id = 524353 then 211
when c.claim_id = 524419 then 211
when c.claim_id = 524502 then 211
when c.claim_id = 524556 then 211
when c.claim_id = 524755 then 211
when c.claim_id = 523444 then 213
when c.claim_id = 523450 then 213
when c.claim_id = 523451 then 213
when c.claim_id = 523455 then 213
when c.claim_id = 523458 then 213
when c.claim_id = 523460 then 213
when c.claim_id = 523468 then 213
when c.claim_id = 523471 then 213
when c.claim_id = 523481 then 213
when c.claim_id = 523484 then 213
when c.claim_id = 523488 then 213
when c.claim_id = 523491 then 213
when c.claim_id = 523492 then 213
when c.claim_id = 523507 then 213
when c.claim_id = 523516 then 213
when c.claim_id = 523517 then 213
when c.claim_id = 523520 then 213
when c.claim_id = 523521 then 213
when c.claim_id = 523529 then 213
when c.claim_id = 523532 then 213
when c.claim_id = 523540 then 213
when c.claim_id = 523542 then 213
when c.claim_id = 523548 then 213
when c.claim_id = 523554 then 213
when c.claim_id = 523555 then 213
when c.claim_id = 523559 then 213
when c.claim_id = 523563 then 213
when c.claim_id = 523566 then 213
when c.claim_id = 523575 then 213
when c.claim_id = 523576 then 213
when c.claim_id = 523577 then 213
when c.claim_id = 523591 then 213
when c.claim_id = 523593 then 213
when c.claim_id = 523602 then 213
when c.claim_id = 523603 then 213
when c.claim_id = 523607 then 213
when c.claim_id = 523608 then 213
when c.claim_id = 523609 then 213
when c.claim_id = 523610 then 213
when c.claim_id = 523617 then 213
when c.claim_id = 523622 then 213
when c.claim_id = 523633 then 213
when c.claim_id = 523634 then 213
when c.claim_id = 523644 then 213
when c.claim_id = 523648 then 213
when c.claim_id = 523649 then 213
when c.claim_id = 523654 then 213
when c.claim_id = 523659 then 213
when c.claim_id = 523662 then 213
when c.claim_id = 523663 then 213
when c.claim_id = 523664 then 213
when c.claim_id = 523667 then 213
when c.claim_id = 523669 then 213
when c.claim_id = 523670 then 213
when c.claim_id = 523675 then 213
when c.claim_id = 523678 then 213
when c.claim_id = 523682 then 213
when c.claim_id = 523683 then 213
when c.claim_id = 523685 then 213
when c.claim_id = 523687 then 213
when c.claim_id = 523692 then 213
when c.claim_id = 523698 then 213
when c.claim_id = 523703 then 213
when c.claim_id = 523704 then 213
when c.claim_id = 523706 then 213
when c.claim_id = 523709 then 213
when c.claim_id = 523710 then 213
when c.claim_id = 523712 then 213
when c.claim_id = 523713 then 213
when c.claim_id = 523716 then 213
when c.claim_id = 523717 then 213
when c.claim_id = 523718 then 213
when c.claim_id = 523720 then 213
when c.claim_id = 523723 then 213
when c.claim_id = 523726 then 213
when c.claim_id = 523727 then 213
when c.claim_id = 523729 then 213
when c.claim_id = 523731 then 213
when c.claim_id = 523739 then 213
when c.claim_id = 523740 then 213
when c.claim_id = 523742 then 213
when c.claim_id = 523752 then 213
when c.claim_id = 523753 then 213
when c.claim_id = 523755 then 213
when c.claim_id = 523757 then 213
when c.claim_id = 523758 then 213
when c.claim_id = 523764 then 213
when c.claim_id = 523766 then 213
when c.claim_id = 523768 then 213
when c.claim_id = 523769 then 213
when c.claim_id = 523770 then 213
when c.claim_id = 523773 then 213
when c.claim_id = 523774 then 213
when c.claim_id = 523779 then 213
when c.claim_id = 523781 then 213
when c.claim_id = 523782 then 213
when c.claim_id = 523784 then 213
when c.claim_id = 523785 then 213
when c.claim_id = 523786 then 213
when c.claim_id = 523790 then 213
when c.claim_id = 523791 then 213
when c.claim_id = 523793 then 213
when c.claim_id = 523796 then 213
when c.claim_id = 523799 then 213
when c.claim_id = 523800 then 213
when c.claim_id = 523801 then 213
when c.claim_id = 523802 then 213
when c.claim_id = 523803 then 213
when c.claim_id = 523805 then 213
when c.claim_id = 523806 then 213
when c.claim_id = 523807 then 213
when c.claim_id = 523808 then 213
when c.claim_id = 523809 then 213
when c.claim_id = 523811 then 213
when c.claim_id = 523814 then 213
when c.claim_id = 523818 then 213
when c.claim_id = 523819 then 213
when c.claim_id = 523820 then 213
when c.claim_id = 523822 then 213
when c.claim_id = 523824 then 213
when c.claim_id = 523825 then 213
when c.claim_id = 523828 then 213
when c.claim_id = 523831 then 213
when c.claim_id = 523832 then 213
when c.claim_id = 523834 then 213
when c.claim_id = 523837 then 213
when c.claim_id = 523838 then 213
when c.claim_id = 523839 then 213
when c.claim_id = 523841 then 213
when c.claim_id = 523844 then 213
when c.claim_id = 523846 then 213
when c.claim_id = 523847 then 213
when c.claim_id = 523848 then 213
when c.claim_id = 523849 then 213
when c.claim_id = 523852 then 213
when c.claim_id = 523857 then 213
when c.claim_id = 523860 then 213
when c.claim_id = 523862 then 213
when c.claim_id = 523865 then 213
when c.claim_id = 523866 then 213
when c.claim_id = 523867 then 213
when c.claim_id = 523869 then 213
when c.claim_id = 523873 then 213
when c.claim_id = 523874 then 213
when c.claim_id = 523876 then 213
when c.claim_id = 523878 then 213
when c.claim_id = 523879 then 213
when c.claim_id = 523880 then 213
when c.claim_id = 523883 then 213
when c.claim_id = 523884 then 213
when c.claim_id = 523885 then 213
when c.claim_id = 523888 then 213
when c.claim_id = 523889 then 213
when c.claim_id = 523891 then 213
when c.claim_id = 523892 then 213
when c.claim_id = 523894 then 213
when c.claim_id = 523901 then 213
when c.claim_id = 523902 then 213
when c.claim_id = 523903 then 213
when c.claim_id = 523904 then 213
when c.claim_id = 523905 then 213
when c.claim_id = 523906 then 213
when c.claim_id = 523908 then 213
when c.claim_id = 523918 then 213
when c.claim_id = 523920 then 213
when c.claim_id = 523923 then 213
when c.claim_id = 523925 then 213
when c.claim_id = 523932 then 213
when c.claim_id = 523935 then 213
when c.claim_id = 523936 then 213
when c.claim_id = 523937 then 213
when c.claim_id = 523940 then 213
when c.claim_id = 523941 then 213
when c.claim_id = 523946 then 213
when c.claim_id = 523947 then 213
when c.claim_id = 523949 then 213
when c.claim_id = 523950 then 213
when c.claim_id = 523951 then 213
when c.claim_id = 523957 then 213
when c.claim_id = 523959 then 213
when c.claim_id = 523974 then 213
when c.claim_id = 523979 then 213
when c.claim_id = 523982 then 213
when c.claim_id = 523984 then 213
when c.claim_id = 523995 then 213
when c.claim_id = 523998 then 213
when c.claim_id = 523999 then 213
when c.claim_id = 524001 then 213
when c.claim_id = 524010 then 213
when c.claim_id = 524011 then 213
when c.claim_id = 524023 then 213
when c.claim_id = 524036 then 213
when c.claim_id = 524046 then 213
when c.claim_id = 524054 then 213
when c.claim_id = 524078 then 213
when c.claim_id = 524083 then 213
when c.claim_id = 524085 then 213
when c.claim_id = 524086 then 213
when c.claim_id = 524097 then 213
when c.claim_id = 524124 then 213
when c.claim_id = 524125 then 213
when c.claim_id = 524218 then 213
when c.claim_id = 524265 then 213
when c.claim_id = 524273 then 213
when c.claim_id = 524296 then 213
when c.claim_id = 524393 then 213
when c.claim_id = 524437 then 213
when c.claim_id = 524459 then 213
when c.claim_id = 524473 then 213
when c.claim_id = 524493 then 213
when c.claim_id = 524525 then 213
when c.claim_id = 524580 then 213
when c.claim_id = 524630 then 213
when c.claim_id = 524675 then 213
when c.claim_id = 524750 then 213
when c.claim_id = 524786 then 213
when c.claim_id = 524848 then 213
when c.claim_id = 524872 then 213
when c.claim_id = 571982 then 213
when c.claim_id = 572805 then 213
when c.claim_id = 572844 then 213
when c.claim_id = 572868 then 213
when c.claim_id = 572873 then 213
when c.claim_id = 573603 then 213
when c.claim_id = 573976 then 213
when c.claim_id = 524212 then 224       
when c.claim_id = 524240 then 224       
when c.claim_id = 524241 then 224       
when c.claim_id = 524242 then 224       
when c.claim_id = 524243 then 224       
when c.claim_id = 524281 then 224       
when c.claim_id = 524316 then 224       
when c.claim_id = 524328 then 224       
when c.claim_id = 524381 then 224       
when c.claim_id = 524382 then 224       
when c.claim_id = 524416 then 224       
when c.claim_id = 524489 then 224       
when c.claim_id = 524490 then 224       
when c.claim_id = 524741 then 224       
when c.claim_id = 524772 then 224       
when c.claim_id = 524857 then 224
when c.claim_id = 572741 then 249
when c.claim_id = 524122 then 259
when c.claim_id = 524247 then 259
when c.claim_id = 524605 then 259
when c.claim_id = 524781 then 259
when c.claim_id = 524795 then 259
when c.claim_id = 524682 then 263
when c.claim_id = 572304 then 274
when c.claim_id = 572499 then 274
when c.claim_id = 524955 then 845
when c.claim_id = 525032 then 845
when c.claim_id = 525174 then 845
when c.claim_id = 525182 then 845
when c.claim_id = 525214 then 845
when c.claim_id = 525247 then 845
when c.claim_id = 525286 then 845
when c.claim_id = 525397 then 845
when c.claim_id = 525409 then 845
when c.claim_id = 525516 then 845
when c.claim_id = 525541 then 845
when c.claim_id = 525542 then 845
when c.claim_id = 525554 then 845
when c.claim_id = 525563 then 845
when c.claim_id = 525613 then 845
when c.claim_id = 525641 then 845
when c.claim_id = 525660 then 845
when c.claim_id = 525759 then 845
when c.claim_id = 525769 then 845
when c.claim_id = 525770 then 845
when c.claim_id = 525852 then 845
when c.claim_id = 525935 then 845
when c.claim_id = 525960 then 845
when c.claim_id = 525966 then 845
when c.claim_id = 525976 then 845
when c.claim_id = 525977 then 845
when c.claim_id = 525989 then 845
when c.claim_id = 526011 then 845
when c.claim_id = 526058 then 845
when c.claim_id = 526067 then 845
when c.claim_id = 526106 then 845
when c.claim_id = 526236 then 845
when c.claim_id = 526239 then 845
when c.claim_id = 526255 then 845
when c.claim_id = 526260 then 845
when c.claim_id = 526350 then 845
when c.claim_id = 526398 then 845
when c.claim_id = 526400 then 845
when c.claim_id = 526428 then 845
when c.claim_id = 526443 then 845
when c.claim_id = 526453 then 845
when c.claim_id = 525210 then 847
when c.claim_id = 525304 then 847
when c.claim_id = 525348 then 847
when c.claim_id = 525361 then 847
when c.claim_id = 525520 then 847
when c.claim_id = 525642 then 847
when c.claim_id = 525720 then 847
when c.claim_id = 525745 then 847
when c.claim_id = 525746 then 847
when c.claim_id = 525753 then 847
when c.claim_id = 525761 then 847
when c.claim_id = 525762 then 847
when c.claim_id = 525797 then 847
when c.claim_id = 525813 then 847
when c.claim_id = 525816 then 847
when c.claim_id = 525822 then 847
when c.claim_id = 525856 then 847
when c.claim_id = 525868 then 847
when c.claim_id = 525981 then 847
when c.claim_id = 526003 then 847
when c.claim_id = 526114 then 847
when c.claim_id = 526165 then 847
when c.claim_id = 526180 then 847
when c.claim_id = 526212 then 847
when c.claim_id = 526296 then 847
when c.claim_id = 526310 then 847
when c.claim_id = 526339 then 847
when c.claim_id = 526360 then 847
when c.claim_id = 526396 then 847
when c.claim_id = 526514 then 847
when c.claim_id = 526537 then 847
when c.claim_id = 524917 then 849
when c.claim_id = 524963 then 849
when c.claim_id = 525078 then 849
when c.claim_id = 525112 then 849
when c.claim_id = 525141 then 849
when c.claim_id = 525145 then 849
when c.claim_id = 525186 then 849
when c.claim_id = 525245 then 849
when c.claim_id = 525343 then 849
when c.claim_id = 525366 then 849
when c.claim_id = 525369 then 849
when c.claim_id = 525370 then 849
when c.claim_id = 525414 then 849
when c.claim_id = 525428 then 849
when c.claim_id = 525429 then 849
when c.claim_id = 525446 then 849
when c.claim_id = 525528 then 849
when c.claim_id = 525534 then 849
when c.claim_id = 525605 then 849
when c.claim_id = 525631 then 849
when c.claim_id = 525677 then 849
when c.claim_id = 525681 then 849
when c.claim_id = 525686 then 849
when c.claim_id = 525715 then 849
when c.claim_id = 525727 then 849
when c.claim_id = 525728 then 849
when c.claim_id = 525782 then 849
when c.claim_id = 525789 then 849
when c.claim_id = 525790 then 849
when c.claim_id = 525792 then 849
when c.claim_id = 525840 then 849
when c.claim_id = 525877 then 849
when c.claim_id = 525878 then 849
when c.claim_id = 525889 then 849
when c.claim_id = 525934 then 849
when c.claim_id = 525948 then 849
when c.claim_id = 526040 then 849
when c.claim_id = 526044 then 849
when c.claim_id = 526077 then 849
when c.claim_id = 526080 then 849
when c.claim_id = 526099 then 849
when c.claim_id = 526102 then 849
when c.claim_id = 526103 then 849
when c.claim_id = 526144 then 849
when c.claim_id = 526209 then 849
when c.claim_id = 526219 then 849
when c.claim_id = 526259 then 849
when c.claim_id = 526269 then 849
when c.claim_id = 526319 then 849
when c.claim_id = 526349 then 849
when c.claim_id = 526357 then 849
when c.claim_id = 526358 then 849
when c.claim_id = 526365 then 849
when c.claim_id = 526388 then 849
when c.claim_id = 526389 then 849
when c.claim_id = 526408 then 849
when c.claim_id = 526411 then 849
when c.claim_id = 526416 then 849
when c.claim_id = 526425 then 849
when c.claim_id = 526437 then 849
when c.claim_id = 526449 then 849
when c.claim_id = 526454 then 849
when c.claim_id = 526470 then 849
when c.claim_id = 526481 then 849
when c.claim_id = 526490 then 849
when c.claim_id = 526512 then 849
when c.claim_id = 572751 then 907
when c.claim_id = 572826 then 907
when c.claim_id = 572861 then 907
when c.claim_id = 572583 then 932
when c.claim_id = 572814 then 932
when c.claim_id = 572852 then 932
when c.claim_id = 572855 then 932
when c.claim_id = 572874 then 932
when c.claim_id = 574317 then 932
when c.claim_id = 572644 then 933
when c.claim_id = 572679 then 933
when c.claim_id = 572870 then 933
when c.claim_id = 572478 then 970
when c.claim_id = 572872 then 971
when c.claim_id = 573587 then 971
when c.claim_id = 524899 then 5182
when c.claim_id = 524900 then 5182
when c.claim_id = 524901 then 5182
when c.claim_id = 524906 then 5182
when c.claim_id = 524907 then 5182
when c.claim_id = 524908 then 5182
when c.claim_id = 524909 then 5182
when c.claim_id = 524911 then 5182
when c.claim_id = 524914 then 5182
when c.claim_id = 524918 then 5182
when c.claim_id = 524919 then 5182
when c.claim_id = 524920 then 5182
when c.claim_id = 524921 then 5182
when c.claim_id = 524922 then 5182
when c.claim_id = 524925 then 5182
when c.claim_id = 524926 then 5182
when c.claim_id = 524927 then 5182
when c.claim_id = 524928 then 5182
when c.claim_id = 524930 then 5182
when c.claim_id = 524931 then 5182
when c.claim_id = 524933 then 5182
when c.claim_id = 524934 then 5182
when c.claim_id = 524938 then 5182
when c.claim_id = 524939 then 5182
when c.claim_id = 524942 then 5182
when c.claim_id = 524948 then 5182
when c.claim_id = 524950 then 5182
when c.claim_id = 524952 then 5182
when c.claim_id = 524953 then 5182
when c.claim_id = 524957 then 5182
when c.claim_id = 524958 then 5182
when c.claim_id = 524959 then 5182
when c.claim_id = 524960 then 5182
when c.claim_id = 524962 then 5182
when c.claim_id = 524965 then 5182
when c.claim_id = 524967 then 5182
when c.claim_id = 524973 then 5182
when c.claim_id = 524974 then 5182
when c.claim_id = 524975 then 5182
when c.claim_id = 524979 then 5182
when c.claim_id = 524984 then 5182
when c.claim_id = 524985 then 5182
when c.claim_id = 524988 then 5182
when c.claim_id = 524992 then 5182
when c.claim_id = 524995 then 5182
when c.claim_id = 524998 then 5182
when c.claim_id = 525000 then 5182
when c.claim_id = 525005 then 5182
when c.claim_id = 525006 then 5182
when c.claim_id = 525013 then 5182
when c.claim_id = 525014 then 5182
when c.claim_id = 525022 then 5182
when c.claim_id = 525024 then 5182
when c.claim_id = 525025 then 5182
when c.claim_id = 525026 then 5182
when c.claim_id = 525027 then 5182
when c.claim_id = 525033 then 5182
when c.claim_id = 525036 then 5182
when c.claim_id = 525038 then 5182
when c.claim_id = 525039 then 5182
when c.claim_id = 525041 then 5182
when c.claim_id = 525044 then 5182
when c.claim_id = 525046 then 5182
when c.claim_id = 525047 then 5182
when c.claim_id = 525048 then 5182
when c.claim_id = 525049 then 5182
when c.claim_id = 525050 then 5182
when c.claim_id = 525051 then 5182
when c.claim_id = 525052 then 5182
when c.claim_id = 525053 then 5182
when c.claim_id = 525054 then 5182
when c.claim_id = 525058 then 5182
when c.claim_id = 525060 then 5182
when c.claim_id = 525062 then 5182
when c.claim_id = 525065 then 5182
when c.claim_id = 525068 then 5182
when c.claim_id = 525069 then 5182
when c.claim_id = 525070 then 5182
when c.claim_id = 525073 then 5182
when c.claim_id = 525074 then 5182
when c.claim_id = 525075 then 5182
when c.claim_id = 525076 then 5182
when c.claim_id = 525077 then 5182
when c.claim_id = 525088 then 5182
when c.claim_id = 525092 then 5182
when c.claim_id = 525093 then 5182
when c.claim_id = 525095 then 5182
when c.claim_id = 525096 then 5182
when c.claim_id = 525098 then 5182
when c.claim_id = 525101 then 5182
when c.claim_id = 525102 then 5182
when c.claim_id = 525103 then 5182
when c.claim_id = 525104 then 5182
when c.claim_id = 525106 then 5182
when c.claim_id = 525107 then 5182
when c.claim_id = 525108 then 5182
when c.claim_id = 525109 then 5182
when c.claim_id = 525110 then 5182
when c.claim_id = 525113 then 5182
when c.claim_id = 525114 then 5182
when c.claim_id = 525119 then 5182
when c.claim_id = 525120 then 5182
when c.claim_id = 525124 then 5182
when c.claim_id = 525126 then 5182
when c.claim_id = 525127 then 5182
when c.claim_id = 525128 then 5182
when c.claim_id = 525129 then 5182
when c.claim_id = 525130 then 5182
when c.claim_id = 525131 then 5182
when c.claim_id = 525132 then 5182
when c.claim_id = 525133 then 5182
when c.claim_id = 525138 then 5182
when c.claim_id = 525142 then 5182
when c.claim_id = 525144 then 5182
when c.claim_id = 525146 then 5182
when c.claim_id = 525147 then 5182
when c.claim_id = 525148 then 5182
when c.claim_id = 525151 then 5182
when c.claim_id = 525152 then 5182
when c.claim_id = 525156 then 5182
when c.claim_id = 525158 then 5182
when c.claim_id = 525159 then 5182
when c.claim_id = 525160 then 5182
when c.claim_id = 525164 then 5182
when c.claim_id = 525165 then 5182
when c.claim_id = 525168 then 5182
when c.claim_id = 525173 then 5182
when c.claim_id = 525175 then 5182
when c.claim_id = 525178 then 5182
when c.claim_id = 525185 then 5182
when c.claim_id = 525189 then 5182
when c.claim_id = 525190 then 5182
when c.claim_id = 525191 then 5182
when c.claim_id = 525192 then 5182
when c.claim_id = 525195 then 5182
when c.claim_id = 525200 then 5182
when c.claim_id = 525209 then 5182
when c.claim_id = 525211 then 5182
when c.claim_id = 525212 then 5182
when c.claim_id = 525216 then 5182
when c.claim_id = 525224 then 5182
when c.claim_id = 525229 then 5182
when c.claim_id = 525235 then 5182
when c.claim_id = 525242 then 5182
when c.claim_id = 525243 then 5182
when c.claim_id = 525248 then 5182
when c.claim_id = 525249 then 5182
when c.claim_id = 525250 then 5182
when c.claim_id = 525252 then 5182
when c.claim_id = 525253 then 5182
when c.claim_id = 525254 then 5182
when c.claim_id = 525255 then 5182
when c.claim_id = 525258 then 5182
when c.claim_id = 525259 then 5182
when c.claim_id = 525263 then 5182
when c.claim_id = 525264 then 5182
when c.claim_id = 525265 then 5182
when c.claim_id = 525268 then 5182
when c.claim_id = 525269 then 5182
when c.claim_id = 525270 then 5182
when c.claim_id = 525273 then 5182
when c.claim_id = 525275 then 5182
when c.claim_id = 525281 then 5182
when c.claim_id = 525287 then 5182
when c.claim_id = 525290 then 5182
when c.claim_id = 525292 then 5182
when c.claim_id = 525297 then 5182
when c.claim_id = 525298 then 5182
when c.claim_id = 525302 then 5182
when c.claim_id = 525305 then 5182
when c.claim_id = 525309 then 5182
when c.claim_id = 525310 then 5182
when c.claim_id = 525313 then 5182
when c.claim_id = 525314 then 5182
when c.claim_id = 525317 then 5182
when c.claim_id = 525318 then 5182
when c.claim_id = 525320 then 5182
when c.claim_id = 525324 then 5182
when c.claim_id = 525327 then 5182
when c.claim_id = 525331 then 5182
when c.claim_id = 525334 then 5182
when c.claim_id = 525336 then 5182
when c.claim_id = 525337 then 5182
when c.claim_id = 525338 then 5182
when c.claim_id = 525339 then 5182
when c.claim_id = 525347 then 5182
when c.claim_id = 525350 then 5182
when c.claim_id = 525353 then 5182
when c.claim_id = 525354 then 5182
when c.claim_id = 525357 then 5182
when c.claim_id = 525359 then 5182
when c.claim_id = 525360 then 5182
when c.claim_id = 525363 then 5182
when c.claim_id = 525364 then 5182
when c.claim_id = 525368 then 5182
when c.claim_id = 525372 then 5182
when c.claim_id = 525374 then 5182
when c.claim_id = 525375 then 5182
when c.claim_id = 525377 then 5182
when c.claim_id = 525378 then 5182
when c.claim_id = 525380 then 5182
when c.claim_id = 525381 then 5182
when c.claim_id = 525388 then 5182
when c.claim_id = 525390 then 5182
when c.claim_id = 525391 then 5182
when c.claim_id = 525394 then 5182
when c.claim_id = 525399 then 5182
when c.claim_id = 525404 then 5182
when c.claim_id = 525405 then 5182
when c.claim_id = 525407 then 5182
when c.claim_id = 525408 then 5182
when c.claim_id = 525410 then 5182
when c.claim_id = 525411 then 5182
when c.claim_id = 525413 then 5182
when c.claim_id = 525417 then 5182
when c.claim_id = 525418 then 5182
when c.claim_id = 525419 then 5182
when c.claim_id = 525421 then 5182
when c.claim_id = 525423 then 5182
when c.claim_id = 525427 then 5182
when c.claim_id = 525434 then 5182
when c.claim_id = 525438 then 5182
when c.claim_id = 525442 then 5182
when c.claim_id = 525443 then 5182
when c.claim_id = 525445 then 5182
when c.claim_id = 525452 then 5182
when c.claim_id = 525453 then 5182
when c.claim_id = 525454 then 5182
when c.claim_id = 525457 then 5182
when c.claim_id = 525459 then 5182
when c.claim_id = 525460 then 5182
when c.claim_id = 525462 then 5182
when c.claim_id = 525463 then 5182
when c.claim_id = 525465 then 5182
when c.claim_id = 525466 then 5182
when c.claim_id = 525468 then 5182
when c.claim_id = 525471 then 5182
when c.claim_id = 525472 then 5182
when c.claim_id = 525473 then 5182
when c.claim_id = 525474 then 5182
when c.claim_id = 525475 then 5182
when c.claim_id = 525476 then 5182
when c.claim_id = 525477 then 5182
when c.claim_id = 525479 then 5182
when c.claim_id = 525482 then 5182
when c.claim_id = 525483 then 5182
when c.claim_id = 525484 then 5182
when c.claim_id = 525485 then 5182
when c.claim_id = 525487 then 5182
when c.claim_id = 525488 then 5182
when c.claim_id = 525489 then 5182
when c.claim_id = 525490 then 5182
when c.claim_id = 525493 then 5182
when c.claim_id = 525498 then 5182
when c.claim_id = 525499 then 5182
when c.claim_id = 525506 then 5182
when c.claim_id = 525507 then 5182
when c.claim_id = 525508 then 5182
when c.claim_id = 525517 then 5182
when c.claim_id = 525519 then 5182
when c.claim_id = 525521 then 5182
when c.claim_id = 525529 then 5182
when c.claim_id = 525530 then 5182
when c.claim_id = 525533 then 5182
when c.claim_id = 525535 then 5182
when c.claim_id = 525537 then 5182
when c.claim_id = 525547 then 5182
when c.claim_id = 525551 then 5182
when c.claim_id = 525552 then 5182
when c.claim_id = 525555 then 5182
when c.claim_id = 525567 then 5182
when c.claim_id = 525570 then 5182
when c.claim_id = 525571 then 5182
when c.claim_id = 525573 then 5182
when c.claim_id = 525574 then 5182
when c.claim_id = 525579 then 5182
when c.claim_id = 525585 then 5182
when c.claim_id = 525588 then 5182
when c.claim_id = 525593 then 5182
when c.claim_id = 525597 then 5182
when c.claim_id = 525602 then 5182
when c.claim_id = 525606 then 5182
when c.claim_id = 525607 then 5182
when c.claim_id = 525608 then 5182
when c.claim_id = 525609 then 5182
when c.claim_id = 525611 then 5182
when c.claim_id = 525614 then 5182
when c.claim_id = 525615 then 5182
when c.claim_id = 525616 then 5182
when c.claim_id = 525618 then 5182
when c.claim_id = 525620 then 5182
when c.claim_id = 525625 then 5182
when c.claim_id = 525627 then 5182
when c.claim_id = 525629 then 5182
when c.claim_id = 525633 then 5182
when c.claim_id = 525634 then 5182
when c.claim_id = 525638 then 5182
when c.claim_id = 525644 then 5182
when c.claim_id = 525646 then 5182
when c.claim_id = 525647 then 5182
when c.claim_id = 525650 then 5182
when c.claim_id = 525655 then 5182
when c.claim_id = 525659 then 5182
when c.claim_id = 525661 then 5182
when c.claim_id = 525662 then 5182
when c.claim_id = 525671 then 5182
when c.claim_id = 525672 then 5182
when c.claim_id = 525673 then 5182
when c.claim_id = 525674 then 5182
when c.claim_id = 525676 then 5182
when c.claim_id = 525680 then 5182
when c.claim_id = 525682 then 5182
when c.claim_id = 525683 then 5182
when c.claim_id = 525684 then 5182
when c.claim_id = 525691 then 5182
when c.claim_id = 525692 then 5182
when c.claim_id = 525696 then 5182
when c.claim_id = 525698 then 5182
when c.claim_id = 525699 then 5182
when c.claim_id = 525701 then 5182
when c.claim_id = 525704 then 5182
when c.claim_id = 525711 then 5182
when c.claim_id = 525714 then 5182
when c.claim_id = 525724 then 5182
when c.claim_id = 525725 then 5182
when c.claim_id = 525730 then 5182
when c.claim_id = 525732 then 5182
when c.claim_id = 525736 then 5182
when c.claim_id = 525737 then 5182
when c.claim_id = 525738 then 5182
when c.claim_id = 525739 then 5182
when c.claim_id = 525743 then 5182
when c.claim_id = 525748 then 5182
when c.claim_id = 525749 then 5182
when c.claim_id = 525751 then 5182
when c.claim_id = 525756 then 5182
when c.claim_id = 525757 then 5182
when c.claim_id = 525760 then 5182
when c.claim_id = 525763 then 5182
when c.claim_id = 525767 then 5182
when c.claim_id = 525773 then 5182
when c.claim_id = 525774 then 5182
when c.claim_id = 525777 then 5182
when c.claim_id = 525778 then 5182
when c.claim_id = 525779 then 5182
when c.claim_id = 525781 then 5182
when c.claim_id = 525787 then 5182
when c.claim_id = 525788 then 5182
when c.claim_id = 525793 then 5182
when c.claim_id = 525796 then 5182
when c.claim_id = 525798 then 5182
when c.claim_id = 525799 then 5182
when c.claim_id = 525805 then 5182
when c.claim_id = 525806 then 5182
when c.claim_id = 525811 then 5182
when c.claim_id = 525812 then 5182
when c.claim_id = 525815 then 5182
when c.claim_id = 525818 then 5182
when c.claim_id = 525821 then 5182
when c.claim_id = 525827 then 5182
when c.claim_id = 525830 then 5182
when c.claim_id = 525833 then 5182
when c.claim_id = 525835 then 5182
when c.claim_id = 525837 then 5182
when c.claim_id = 525841 then 5182
when c.claim_id = 525843 then 5182
when c.claim_id = 525849 then 5182
when c.claim_id = 525850 then 5182
when c.claim_id = 525851 then 5182
when c.claim_id = 525854 then 5182
when c.claim_id = 525859 then 5182
when c.claim_id = 525861 then 5182
when c.claim_id = 525862 then 5182
when c.claim_id = 525863 then 5182
when c.claim_id = 525864 then 5182
when c.claim_id = 525865 then 5182
when c.claim_id = 525866 then 5182
when c.claim_id = 525867 then 5182
when c.claim_id = 525869 then 5182
when c.claim_id = 525871 then 5182
when c.claim_id = 525873 then 5182
when c.claim_id = 525874 then 5182
when c.claim_id = 525875 then 5182
when c.claim_id = 525876 then 5182
when c.claim_id = 525880 then 5182
when c.claim_id = 525881 then 5182
when c.claim_id = 525882 then 5182
when c.claim_id = 525883 then 5182
when c.claim_id = 525885 then 5182
when c.claim_id = 525887 then 5182
when c.claim_id = 525890 then 5182
when c.claim_id = 525895 then 5182
when c.claim_id = 525899 then 5182
when c.claim_id = 525900 then 5182
when c.claim_id = 525902 then 5182
when c.claim_id = 525905 then 5182
when c.claim_id = 525907 then 5182
when c.claim_id = 525915 then 5182
when c.claim_id = 525919 then 5182
when c.claim_id = 525921 then 5182
when c.claim_id = 525922 then 5182
when c.claim_id = 525923 then 5182
when c.claim_id = 525927 then 5182
when c.claim_id = 525929 then 5182
when c.claim_id = 525937 then 5182
when c.claim_id = 525941 then 5182
when c.claim_id = 525943 then 5182
when c.claim_id = 525951 then 5182
when c.claim_id = 525954 then 5182
when c.claim_id = 525962 then 5182
when c.claim_id = 525967 then 5182
when c.claim_id = 525968 then 5182
when c.claim_id = 525970 then 5182
when c.claim_id = 525971 then 5182
when c.claim_id = 525975 then 5182
when c.claim_id = 525979 then 5182
when c.claim_id = 525983 then 5182
when c.claim_id = 525987 then 5182
when c.claim_id = 525990 then 5182
when c.claim_id = 525992 then 5182
when c.claim_id = 525993 then 5182
when c.claim_id = 525994 then 5182
when c.claim_id = 525996 then 5182
when c.claim_id = 526001 then 5182
when c.claim_id = 526004 then 5182
when c.claim_id = 526007 then 5182
when c.claim_id = 526008 then 5182
when c.claim_id = 526009 then 5182
when c.claim_id = 526017 then 5182
when c.claim_id = 526019 then 5182
when c.claim_id = 526022 then 5182
when c.claim_id = 526023 then 5182
when c.claim_id = 526025 then 5182
when c.claim_id = 526031 then 5182
when c.claim_id = 526035 then 5182
when c.claim_id = 526036 then 5182
when c.claim_id = 526038 then 5182
when c.claim_id = 526043 then 5182
when c.claim_id = 526048 then 5182
when c.claim_id = 526049 then 5182
when c.claim_id = 526052 then 5182
when c.claim_id = 526055 then 5182
when c.claim_id = 526059 then 5182
when c.claim_id = 526061 then 5182
when c.claim_id = 526062 then 5182
when c.claim_id = 526063 then 5182
when c.claim_id = 526069 then 5182
when c.claim_id = 526070 then 5182
when c.claim_id = 526072 then 5182
when c.claim_id = 526081 then 5182
when c.claim_id = 526082 then 5182
when c.claim_id = 526085 then 5182
when c.claim_id = 526086 then 5182
when c.claim_id = 526089 then 5182
when c.claim_id = 526091 then 5182
when c.claim_id = 526092 then 5182
when c.claim_id = 526094 then 5182
when c.claim_id = 526095 then 5182
when c.claim_id = 526096 then 5182
when c.claim_id = 526100 then 5182
when c.claim_id = 526101 then 5182
when c.claim_id = 526108 then 5182
when c.claim_id = 526109 then 5182
when c.claim_id = 526110 then 5182
when c.claim_id = 526117 then 5182
when c.claim_id = 526118 then 5182
when c.claim_id = 526121 then 5182
when c.claim_id = 526127 then 5182
when c.claim_id = 526128 then 5182
when c.claim_id = 526129 then 5182
when c.claim_id = 526134 then 5182
when c.claim_id = 526140 then 5182
when c.claim_id = 526141 then 5182
when c.claim_id = 526142 then 5182
when c.claim_id = 526145 then 5182
when c.claim_id = 526149 then 5182
when c.claim_id = 526152 then 5182
when c.claim_id = 526158 then 5182
when c.claim_id = 526160 then 5182
when c.claim_id = 526164 then 5182
when c.claim_id = 526168 then 5182
when c.claim_id = 526170 then 5182
when c.claim_id = 526173 then 5182
when c.claim_id = 526174 then 5182
when c.claim_id = 526175 then 5182
when c.claim_id = 526176 then 5182
when c.claim_id = 526177 then 5182
when c.claim_id = 526178 then 5182
when c.claim_id = 526179 then 5182
when c.claim_id = 526181 then 5182
when c.claim_id = 526182 then 5182
when c.claim_id = 526184 then 5182
when c.claim_id = 526187 then 5182
when c.claim_id = 526188 then 5182
when c.claim_id = 526192 then 5182
when c.claim_id = 526193 then 5182
when c.claim_id = 526194 then 5182
when c.claim_id = 526196 then 5182
when c.claim_id = 526199 then 5182
when c.claim_id = 526200 then 5182
when c.claim_id = 526201 then 5182
when c.claim_id = 526204 then 5182
when c.claim_id = 526207 then 5182
when c.claim_id = 526220 then 5182
when c.claim_id = 526221 then 5182
when c.claim_id = 526227 then 5182
when c.claim_id = 526229 then 5182
when c.claim_id = 526232 then 5182
when c.claim_id = 526233 then 5182
when c.claim_id = 526235 then 5182
when c.claim_id = 526237 then 5182
when c.claim_id = 526238 then 5182
when c.claim_id = 526242 then 5182
when c.claim_id = 526245 then 5182
when c.claim_id = 526247 then 5182
when c.claim_id = 526248 then 5182
when c.claim_id = 526250 then 5182
when c.claim_id = 526251 then 5182
when c.claim_id = 526258 then 5182
when c.claim_id = 526261 then 5182
when c.claim_id = 526262 then 5182
when c.claim_id = 526263 then 5182
when c.claim_id = 526264 then 5182
when c.claim_id = 526270 then 5182
when c.claim_id = 526272 then 5182
when c.claim_id = 526274 then 5182
when c.claim_id = 526275 then 5182
when c.claim_id = 526276 then 5182
when c.claim_id = 526278 then 5182
when c.claim_id = 526279 then 5182
when c.claim_id = 526283 then 5182
when c.claim_id = 526284 then 5182
when c.claim_id = 526285 then 5182
when c.claim_id = 526292 then 5182
when c.claim_id = 526294 then 5182
when c.claim_id = 526297 then 5182
when c.claim_id = 526298 then 5182
when c.claim_id = 526299 then 5182
when c.claim_id = 526302 then 5182
when c.claim_id = 526303 then 5182
when c.claim_id = 526304 then 5182
when c.claim_id = 526307 then 5182
when c.claim_id = 526308 then 5182
when c.claim_id = 526316 then 5182
when c.claim_id = 526317 then 5182
when c.claim_id = 526320 then 5182
when c.claim_id = 526321 then 5182
when c.claim_id = 526323 then 5182
when c.claim_id = 526329 then 5182
when c.claim_id = 526330 then 5182
when c.claim_id = 526331 then 5182
when c.claim_id = 526334 then 5182
when c.claim_id = 526336 then 5182
when c.claim_id = 526342 then 5182
when c.claim_id = 526343 then 5182
when c.claim_id = 526347 then 5182
when c.claim_id = 526348 then 5182
when c.claim_id = 526351 then 5182
when c.claim_id = 526352 then 5182
when c.claim_id = 526353 then 5182
when c.claim_id = 526354 then 5182
when c.claim_id = 526355 then 5182
when c.claim_id = 526363 then 5182
when c.claim_id = 526364 then 5182
when c.claim_id = 526366 then 5182
when c.claim_id = 526367 then 5182
when c.claim_id = 526368 then 5182
when c.claim_id = 526369 then 5182
when c.claim_id = 526375 then 5182
when c.claim_id = 526376 then 5182
when c.claim_id = 526380 then 5182
when c.claim_id = 526382 then 5182
when c.claim_id = 526385 then 5182
when c.claim_id = 526386 then 5182
when c.claim_id = 526387 then 5182
when c.claim_id = 526391 then 5182
when c.claim_id = 526392 then 5182
when c.claim_id = 526397 then 5182
when c.claim_id = 526399 then 5182
when c.claim_id = 526404 then 5182
when c.claim_id = 526405 then 5182
when c.claim_id = 526406 then 5182
when c.claim_id = 526414 then 5182
when c.claim_id = 526417 then 5182
when c.claim_id = 526420 then 5182
when c.claim_id = 526421 then 5182
when c.claim_id = 526423 then 5182
when c.claim_id = 526427 then 5182
when c.claim_id = 526432 then 5182
when c.claim_id = 526433 then 5182
when c.claim_id = 526435 then 5182
when c.claim_id = 526438 then 5182
when c.claim_id = 526440 then 5182
when c.claim_id = 526441 then 5182
when c.claim_id = 526442 then 5182
when c.claim_id = 526444 then 5182
when c.claim_id = 526445 then 5182
when c.claim_id = 526450 then 5182
when c.claim_id = 526452 then 5182
when c.claim_id = 526455 then 5182
when c.claim_id = 526457 then 5182
when c.claim_id = 526458 then 5182
when c.claim_id = 526460 then 5182
when c.claim_id = 526461 then 5182
when c.claim_id = 526463 then 5182
when c.claim_id = 526465 then 5182
when c.claim_id = 526467 then 5182
when c.claim_id = 526468 then 5182
when c.claim_id = 526472 then 5182
when c.claim_id = 526474 then 5182
when c.claim_id = 526477 then 5182
when c.claim_id = 526479 then 5182
when c.claim_id = 526480 then 5182
when c.claim_id = 526483 then 5182
when c.claim_id = 526484 then 5182
when c.claim_id = 526485 then 5182
when c.claim_id = 526487 then 5182
when c.claim_id = 526492 then 5182
when c.claim_id = 526494 then 5182
when c.claim_id = 526503 then 5182
when c.claim_id = 526505 then 5182
when c.claim_id = 526506 then 5182
when c.claim_id = 526507 then 5182
when c.claim_id = 526508 then 5182
when c.claim_id = 526511 then 5182
when c.claim_id = 526513 then 5182
when c.claim_id = 526518 then 5182
when c.claim_id = 526519 then 5182
when c.claim_id = 526521 then 5182
when c.claim_id = 526522 then 5182
when c.claim_id = 526523 then 5182
when c.claim_id = 526525 then 5182
when c.claim_id = 526526 then 5182
when c.claim_id = 526527 then 5182
when c.claim_id = 526528 then 5182
when c.claim_id = 526531 then 5182
when c.claim_id = 526534 then 5182
when c.claim_id = 526535 then 5182
when c.claim_id = 526536 then 5182
when c.claim_id = 526546 then 5182
when c.claim_id = 572828 then 5201
when c.claim_id = 524101 then 5205
when c.claim_id = 524166 then 5205
when c.claim_id = 524244 then 5205
when c.claim_id = 524685 then 5206
when c.claim_id = 612279 then 6402
when c.claim_id = 612388 then 6402
end)
where c.claim_id in (
524903,524905,524912,524913,524916,524923,524924,524929,524935,524940,
524946,524947,524951,524956,524969,524972,524977,524978,524980,524981,
524982,524986,524987,524990,524993,524997,525001,525003,525010,525011,
525015,525016,525028,525037,525040,525045,525059,525061,525066,525067,
525079,525081,525085,525089,525094,525097,525100,525105,525116,525121,
525136,525139,525149,525153,525154,525163,525166,525169,525172,525179,
525180,525181,525187,525194,525198,525199,525204,525206,525217,525218,
525220,525227,525231,525232,525237,525239,525240,525241,525244,525251,
525256,525261,525271,525272,525274,525277,525280,525282,525285,525288,
525289,525293,525294,525295,525299,525301,525303,525311,525312,525315,
525319,525322,525323,525328,525344,525349,525351,525355,525358,525362,
525365,525371,525373,525379,525383,525384,525389,525396,525398,525400,
525402,525412,525415,525416,525422,525424,525425,525431,525433,525435,
525436,525437,525440,525441,525447,525450,525458,525464,525467,525470,
525486,525496,525497,525504,525511,525512,525514,525523,525524,525526,
525527,525532,525538,525540,525543,525544,525545,525546,525548,525550,
525553,525556,525560,525561,525565,525566,525572,525575,525576,525578,
525580,525581,525583,525586,525592,525595,525598,525601,525612,525623,
525624,525632,525637,525640,525643,525645,525648,525649,525652,525657,
525675,525687,525688,525693,525697,525705,525707,525713,525716,525718,
525719,525723,525726,525733,525734,525741,525750,525771,525780,525783,
525800,525801,525802,525803,525808,525814,525817,525819,525829,525831,
525839,525842,525845,525848,525853,525855,525857,525858,525870,525872,
525888,525896,525898,525904,525909,525911,525924,525928,525931,525932,
525933,525936,525938,525939,525945,525950,525952,525957,525959,525965,
525973,525982,525984,525985,525986,525988,525995,526012,526020,526021,
526026,526027,526028,526030,526041,526042,526045,526046,526047,526051,
526056,526065,526066,526068,526076,526087,526088,526090,526093,526097,
526104,526105,526107,526111,526120,526126,526131,526132,526133,526139,
526143,526147,526150,526151,526153,526154,526156,526157,526159,526161,
526167,526172,526185,526186,526190,526195,526198,526203,526205,526206,
526208,526214,526215,526216,526217,526222,526224,526225,526226,526228,
526230,526231,526240,526246,526249,526253,526271,526280,526281,526288,
526289,526301,526313,526322,526324,526328,526338,526345,526362,526371,
526373,526393,526394,526401,526409,526412,526415,526418,526422,526424,
526431,526436,526446,526448,526456,526462,526464,526473,526478,526482,
526489,526493,526495,526496,526497,526498,526499,526509,526515,526516,
526524,526529,526530,526532,526533,526538,526541,526542,526543,526545,
523446,523816,523845,523851,523872,523887,523890,523899,523907,523911,
523921,523942,523960,523969,523977,523981,523989,524021,524022,524025,
524026,524033,524039,524047,524049,524065,524066,524112,524127,524131,
524134,524150,524154,524161,524171,524175,524180,524192,524193,524194,
524195,524200,524203,524211,524222,524236,524239,524256,524257,524258,
524264,524267,524271,524280,524282,524288,524290,524295,524299,524300,
524312,524321,524336,524347,524462,524828,524871,524677,524743,524754,
524286,523963,524059,524146,524230,524398,524431,524509,524640,524667,
524202,524255,524333,524483,524846,573566,523447,523813,523821,523823,
523827,523829,523830,523854,523859,523861,523863,523864,523875,523882,
523893,523895,523897,523898,523913,523915,523917,523926,523927,523934,
523939,523943,523945,523948,523953,523961,523962,523965,523967,523973,
523975,523985,523990,523992,524005,524012,524024,524030,524032,524037,
524042,524044,524052,524057,524062,524068,524072,524079,524081,524093,
524096,524098,524108,524109,524115,524120,524126,524128,524132,524137,
524142,524143,524145,524148,524149,524153,524155,524157,524158,524160,
524162,524163,524164,524168,524169,524172,524174,524177,524178,524179,
524184,524185,524187,524188,524189,524191,524198,524199,524201,524204,
524205,524207,524208,524209,524210,524213,524214,524216,524217,524220,
524223,524226,524227,524229,524232,524233,524238,524246,524248,524249,
524251,524252,524253,524254,524262,524269,524275,524276,524279,524284,
524285,524292,524294,524304,524306,524308,524310,524313,524315,524318,
524320,524323,524327,524332,524343,524411,524425,524428,524444,524447,
524501,524514,524528,524652,524658,524676,524703,524705,524759,524849,
524851,572648,572660,572879,523978,523996,524028,524058,524245,524260,
524322,524325,524339,524359,524374,524399,524408,524418,524536,524610,
524612,524649,524734,524738,524811,524812,523976,524064,524123,524165,
524206,524228,524237,524084,524439,524642,524757,524878,572539,572556,
572592,572604,572638,572837,572849,572856,572866,572875,524353,524419,
524502,524556,524755,523444,523450,523451,523455,523458,523460,523468,
523471,523481,523484,523488,523491,523492,523507,523516,523517,523520,
523521,523529,523532,523540,523542,523548,523554,523555,523559,523563,
523566,523575,523576,523577,523591,523593,523602,523603,523607,523608,
523609,523610,523617,523622,523633,523634,523644,523648,523649,523654,
523659,523662,523663,523664,523667,523669,523670,523675,523678,523682,
523683,523685,523687,523692,523698,523703,523704,523706,523709,523710,
523712,523713,523716,523717,523718,523720,523723,523726,523727,523729,
523731,523739,523740,523742,523752,523753,523755,523757,523758,523764,
523766,523768,523769,523770,523773,523774,523779,523781,523782,523784,
523785,523786,523790,523791,523793,523796,523799,523800,523801,523802,
523803,523805,523806,523807,523808,523809,523811,523814,523818,523819,
523820,523822,523824,523825,523828,523831,523832,523834,523837,523838,
523839,523841,523844,523846,523847,523848,523849,523852,523857,523860,
523862,523865,523866,523867,523869,523873,523874,523876,523878,523879,
523880,523883,523884,523885,523888,523889,523891,523892,523894,523901,
523902,523903,523904,523905,523906,523908,523918,523920,523923,523925,
523932,523935,523936,523937,523940,523941,523946,523947,523949,523950,
523951,523957,523959,523974,523979,523982,523984,523995,523998,523999,
524001,524010,524011,524023,524036,524046,524054,524078,524083,524085,
524086,524097,524124,524125,524218,524265,524273,524296,524393,524437,
524459,524473,524493,524525,524580,524630,524675,524750,524786,524848,
524872,571982,572805,572844,572868,572873,573603,573976,524212,524240,
524241,524242,524243,524281,524316,524328,524381,524382,524416,524489,
524490,524741,524772,524857,572741,524122,524247,524605,524781,524795,
524682,572304,572499,524955,525032,525174,525182,525214,525247,525286,
525397,525409,525516,525541,525542,525554,525563,525613,525641,525660,
525759,525769,525770,525852,525935,525960,525966,525976,525977,525989,
526011,526058,526067,526106,526236,526239,526255,526260,526350,526398,
526400,526428,526443,526453,525210,525304,525348,525361,525520,525642,
525720,525745,525746,525753,525761,525762,525797,525813,525816,525822,
525856,525868,525981,526003,526114,526165,526180,526212,526296,526310,
526339,526360,526396,526514,526537,524917,524963,525078,525112,525141,
525145,525186,525245,525343,525366,525369,525370,525414,525428,525429,
525446,525528,525534,525605,525631,525677,525681,525686,525715,525727,
525728,525782,525789,525790,525792,525840,525877,525878,525889,525934,
525948,526040,526044,526077,526080,526099,526102,526103,526144,526209,
526219,526259,526269,526319,526349,526357,526358,526365,526388,526389,
526408,526411,526416,526425,526437,526449,526454,526470,526481,526490,
526512,572751,572826,572861,572583,572814,572852,572855,572874,574317,
572644,572679,572870,572478,572872,573587,524899,524900,524901,524906,
524907,524908,524909,524911,524914,524918,524919,524920,524921,524922,
524925,524926,524927,524928,524930,524931,524933,524934,524938,524939,
524942,524948,524950,524952,524953,524957,524958,524959,524960,524962,
524965,524967,524973,524974,524975,524979,524984,524985,524988,524992,
524995,524998,525000,525005,525006,525013,525014,525022,525024,525025,
525026,525027,525033,525036,525038,525039,525041,525044,525046,525047,
525048,525049,525050,525051,525052,525053,525054,525058,525060,525062,
525065,525068,525069,525070,525073,525074,525075,525076,525077,525088,
525092,525093,525095,525096,525098,525101,525102,525103,525104,525106,
525107,525108,525109,525110,525113,525114,525119,525120,525124,525126,
525127,525128,525129,525130,525131,525132,525133,525138,525142,525144,
525146,525147,525148,525151,525152,525156,525158,525159,525160,525164,
525165,525168,525173,525175,525178,525185,525189,525190,525191,525192,
525195,525200,525209,525211,525212,525216,525224,525229,525235,525242,
525243,525248,525249,525250,525252,525253,525254,525255,525258,525259,
525263,525264,525265,525268,525269,525270,525273,525275,525281,525287,
525290,525292,525297,525298,525302,525305,525309,525310,525313,525314,
525317,525318,525320,525324,525327,525331,525334,525336,525337,525338,
525339,525347,525350,525353,525354,525357,525359,525360,525363,525364,
525368,525372,525374,525375,525377,525378,525380,525381,525388,525390,
525391,525394,525399,525404,525405,525407,525408,525410,525411,525413,
525417,525418,525419,525421,525423,525427,525434,525438,525442,525443,
525445,525452,525453,525454,525457,525459,525460,525462,525463,525465,
525466,525468,525471,525472,525473,525474,525475,525476,525477,525479,
525482,525483,525484,525485,525487,525488,525489,525490,525493,525498,
525499,525506,525507,525508,525517,525519,525521,525529,525530,525533,
525535,525537,525547,525551,525552,525555,525567,525570,525571,525573,
525574,525579,525585,525588,525593,525597,525602,525606,525607,525608,
525609,525611,525614,525615,525616,525618,525620,525625,525627,525629,
525633,525634,525638,525644,525646,525647,525650,525655,525659,525661,
525662,525671,525672,525673,525674,525676,525680,525682,525683,525684,
525691,525692,525696,525698,525699,525701,525704,525711,525714,525724,
525725,525730,525732,525736,525737,525738,525739,525743,525748,525749,
525751,525756,525757,525760,525763,525767,525773,525774,525777,525778,
525779,525781,525787,525788,525793,525796,525798,525799,525805,525806,
525811,525812,525815,525818,525821,525827,525830,525833,525835,525837,
525841,525843,525849,525850,525851,525854,525859,525861,525862,525863,
525864,525865,525866,525867,525869,525871,525873,525874,525875,525876,
525880,525881,525882,525883,525885,525887,525890,525895,525899,525900,
525902,525905,525907,525915,525919,525921,525922,525923,525927,525929,
525937,525941,525943,525951,525954,525962,525967,525968,525970,525971,
525975,525979,525983,525987,525990,525992,525993,525994,525996,526001,
526004,526007,526008,526009,526017,526019,526022,526023,526025,526031,
526035,526036,526038,526043,526048,526049,526052,526055,526059,526061,
526062,526063,526069,526070,526072,526081,526082,526085,526086,526089,
526091,526092,526094,526095,526096,526100,526101,526108,526109,526110,
526117,526118,526121,526127,526128,526129,526134,526140,526141,526142,
526145,526149,526152,526158,526160,526164,526168,526170,526173,526174,
526175,526176,526177,526178,526179,526181,526182,526184,526187,526188,
526192,526193,526194,526196,526199,526200,526201,526204,526207,526220,
526221,526227,526229,526232,526233,526235,526237,526238,526242,526245,
526247,526248,526250,526251,526258,526261,526262,526263,526264,526270,
526272,526274,526275,526276,526278,526279,526283,526284,526285,526292,
526294,526297,526298,526299,526302,526303,526304,526307,526308,526316,
526317,526320,526321,526323,526329,526330,526331,526334,526336,526342,
526343,526347,526348,526351,526352,526353,526354,526355,526363,526364,
526366,526367,526368,526369,526375,526376,526380,526382,526385,526386,
526387,526391,526392,526397,526399,526404,526405,526406,526414,526417,
526420,526421,526423,526427,526432,526433,526435,526438,526440,526441,
526442,526444,526445,526450,526452,526455,526457,526458,526460,526461,
526463,526465,526467,526468,526472,526474,526477,526479,526480,526483,
526484,526485,526487,526492,526494,526503,526505,526506,526507,526508,
526511,526513,526518,526519,526521,526522,526523,526525,526526,526527,
526528,526531,526534,526535,526536,526546,572828,524101,524166,524244,
524685,612279,612388
);

select c.claim_id, c.account_structure_id
from s_dis_claim c
where c.claim_id in (
524903,524905,524912,524913,524916,524923,524924,524929,524935,524940,
524946,524947,524951,524956,524969,524972,524977,524978,524980,524981,
524982,524986,524987,524990,524993,524997,525001,525003,525010,525011,
525015,525016,525028,525037,525040,525045,525059,525061,525066,525067,
525079,525081,525085,525089,525094,525097,525100,525105,525116,525121,
525136,525139,525149,525153,525154,525163,525166,525169,525172,525179,
525180,525181,525187,525194,525198,525199,525204,525206,525217,525218,
525220,525227,525231,525232,525237,525239,525240,525241,525244,525251,
525256,525261,525271,525272,525274,525277,525280,525282,525285,525288,
525289,525293,525294,525295,525299,525301,525303,525311,525312,525315,
525319,525322,525323,525328,525344,525349,525351,525355,525358,525362,
525365,525371,525373,525379,525383,525384,525389,525396,525398,525400,
525402,525412,525415,525416,525422,525424,525425,525431,525433,525435,
525436,525437,525440,525441,525447,525450,525458,525464,525467,525470,
525486,525496,525497,525504,525511,525512,525514,525523,525524,525526,
525527,525532,525538,525540,525543,525544,525545,525546,525548,525550,
525553,525556,525560,525561,525565,525566,525572,525575,525576,525578,
525580,525581,525583,525586,525592,525595,525598,525601,525612,525623,
525624,525632,525637,525640,525643,525645,525648,525649,525652,525657,
525675,525687,525688,525693,525697,525705,525707,525713,525716,525718,
525719,525723,525726,525733,525734,525741,525750,525771,525780,525783,
525800,525801,525802,525803,525808,525814,525817,525819,525829,525831,
525839,525842,525845,525848,525853,525855,525857,525858,525870,525872,
525888,525896,525898,525904,525909,525911,525924,525928,525931,525932,
525933,525936,525938,525939,525945,525950,525952,525957,525959,525965,
525973,525982,525984,525985,525986,525988,525995,526012,526020,526021,
526026,526027,526028,526030,526041,526042,526045,526046,526047,526051,
526056,526065,526066,526068,526076,526087,526088,526090,526093,526097,
526104,526105,526107,526111,526120,526126,526131,526132,526133,526139,
526143,526147,526150,526151,526153,526154,526156,526157,526159,526161,
526167,526172,526185,526186,526190,526195,526198,526203,526205,526206,
526208,526214,526215,526216,526217,526222,526224,526225,526226,526228,
526230,526231,526240,526246,526249,526253,526271,526280,526281,526288,
526289,526301,526313,526322,526324,526328,526338,526345,526362,526371,
526373,526393,526394,526401,526409,526412,526415,526418,526422,526424,
526431,526436,526446,526448,526456,526462,526464,526473,526478,526482,
526489,526493,526495,526496,526497,526498,526499,526509,526515,526516,
526524,526529,526530,526532,526533,526538,526541,526542,526543,526545,
523446,523816,523845,523851,523872,523887,523890,523899,523907,523911,
523921,523942,523960,523969,523977,523981,523989,524021,524022,524025,
524026,524033,524039,524047,524049,524065,524066,524112,524127,524131,
524134,524150,524154,524161,524171,524175,524180,524192,524193,524194,
524195,524200,524203,524211,524222,524236,524239,524256,524257,524258,
524264,524267,524271,524280,524282,524288,524290,524295,524299,524300,
524312,524321,524336,524347,524462,524828,524871,524677,524743,524754,
524286,523963,524059,524146,524230,524398,524431,524509,524640,524667,
524202,524255,524333,524483,524846,573566,523447,523813,523821,523823,
523827,523829,523830,523854,523859,523861,523863,523864,523875,523882,
523893,523895,523897,523898,523913,523915,523917,523926,523927,523934,
523939,523943,523945,523948,523953,523961,523962,523965,523967,523973,
523975,523985,523990,523992,524005,524012,524024,524030,524032,524037,
524042,524044,524052,524057,524062,524068,524072,524079,524081,524093,
524096,524098,524108,524109,524115,524120,524126,524128,524132,524137,
524142,524143,524145,524148,524149,524153,524155,524157,524158,524160,
524162,524163,524164,524168,524169,524172,524174,524177,524178,524179,
524184,524185,524187,524188,524189,524191,524198,524199,524201,524204,
524205,524207,524208,524209,524210,524213,524214,524216,524217,524220,
524223,524226,524227,524229,524232,524233,524238,524246,524248,524249,
524251,524252,524253,524254,524262,524269,524275,524276,524279,524284,
524285,524292,524294,524304,524306,524308,524310,524313,524315,524318,
524320,524323,524327,524332,524343,524411,524425,524428,524444,524447,
524501,524514,524528,524652,524658,524676,524703,524705,524759,524849,
524851,572648,572660,572879,523978,523996,524028,524058,524245,524260,
524322,524325,524339,524359,524374,524399,524408,524418,524536,524610,
524612,524649,524734,524738,524811,524812,523976,524064,524123,524165,
524206,524228,524237,524084,524439,524642,524757,524878,572539,572556,
572592,572604,572638,572837,572849,572856,572866,572875,524353,524419,
524502,524556,524755,523444,523450,523451,523455,523458,523460,523468,
523471,523481,523484,523488,523491,523492,523507,523516,523517,523520,
523521,523529,523532,523540,523542,523548,523554,523555,523559,523563,
523566,523575,523576,523577,523591,523593,523602,523603,523607,523608,
523609,523610,523617,523622,523633,523634,523644,523648,523649,523654,
523659,523662,523663,523664,523667,523669,523670,523675,523678,523682,
523683,523685,523687,523692,523698,523703,523704,523706,523709,523710,
523712,523713,523716,523717,523718,523720,523723,523726,523727,523729,
523731,523739,523740,523742,523752,523753,523755,523757,523758,523764,
523766,523768,523769,523770,523773,523774,523779,523781,523782,523784,
523785,523786,523790,523791,523793,523796,523799,523800,523801,523802,
523803,523805,523806,523807,523808,523809,523811,523814,523818,523819,
523820,523822,523824,523825,523828,523831,523832,523834,523837,523838,
523839,523841,523844,523846,523847,523848,523849,523852,523857,523860,
523862,523865,523866,523867,523869,523873,523874,523876,523878,523879,
523880,523883,523884,523885,523888,523889,523891,523892,523894,523901,
523902,523903,523904,523905,523906,523908,523918,523920,523923,523925,
523932,523935,523936,523937,523940,523941,523946,523947,523949,523950,
523951,523957,523959,523974,523979,523982,523984,523995,523998,523999,
524001,524010,524011,524023,524036,524046,524054,524078,524083,524085,
524086,524097,524124,524125,524218,524265,524273,524296,524393,524437,
524459,524473,524493,524525,524580,524630,524675,524750,524786,524848,
524872,571982,572805,572844,572868,572873,573603,573976,524212,524240,
524241,524242,524243,524281,524316,524328,524381,524382,524416,524489,
524490,524741,524772,524857,572741,524122,524247,524605,524781,524795,
524682,572304,572499,524955,525032,525174,525182,525214,525247,525286,
525397,525409,525516,525541,525542,525554,525563,525613,525641,525660,
525759,525769,525770,525852,525935,525960,525966,525976,525977,525989,
526011,526058,526067,526106,526236,526239,526255,526260,526350,526398,
526400,526428,526443,526453,525210,525304,525348,525361,525520,525642,
525720,525745,525746,525753,525761,525762,525797,525813,525816,525822,
525856,525868,525981,526003,526114,526165,526180,526212,526296,526310,
526339,526360,526396,526514,526537,524917,524963,525078,525112,525141,
525145,525186,525245,525343,525366,525369,525370,525414,525428,525429,
525446,525528,525534,525605,525631,525677,525681,525686,525715,525727,
525728,525782,525789,525790,525792,525840,525877,525878,525889,525934,
525948,526040,526044,526077,526080,526099,526102,526103,526144,526209,
526219,526259,526269,526319,526349,526357,526358,526365,526388,526389,
526408,526411,526416,526425,526437,526449,526454,526470,526481,526490,
526512,572751,572826,572861,572583,572814,572852,572855,572874,574317,
572644,572679,572870,572478,572872,573587,524899,524900,524901,524906,
524907,524908,524909,524911,524914,524918,524919,524920,524921,524922,
524925,524926,524927,524928,524930,524931,524933,524934,524938,524939,
524942,524948,524950,524952,524953,524957,524958,524959,524960,524962,
524965,524967,524973,524974,524975,524979,524984,524985,524988,524992,
524995,524998,525000,525005,525006,525013,525014,525022,525024,525025,
525026,525027,525033,525036,525038,525039,525041,525044,525046,525047,
525048,525049,525050,525051,525052,525053,525054,525058,525060,525062,
525065,525068,525069,525070,525073,525074,525075,525076,525077,525088,
525092,525093,525095,525096,525098,525101,525102,525103,525104,525106,
525107,525108,525109,525110,525113,525114,525119,525120,525124,525126,
525127,525128,525129,525130,525131,525132,525133,525138,525142,525144,
525146,525147,525148,525151,525152,525156,525158,525159,525160,525164,
525165,525168,525173,525175,525178,525185,525189,525190,525191,525192,
525195,525200,525209,525211,525212,525216,525224,525229,525235,525242,
525243,525248,525249,525250,525252,525253,525254,525255,525258,525259,
525263,525264,525265,525268,525269,525270,525273,525275,525281,525287,
525290,525292,525297,525298,525302,525305,525309,525310,525313,525314,
525317,525318,525320,525324,525327,525331,525334,525336,525337,525338,
525339,525347,525350,525353,525354,525357,525359,525360,525363,525364,
525368,525372,525374,525375,525377,525378,525380,525381,525388,525390,
525391,525394,525399,525404,525405,525407,525408,525410,525411,525413,
525417,525418,525419,525421,525423,525427,525434,525438,525442,525443,
525445,525452,525453,525454,525457,525459,525460,525462,525463,525465,
525466,525468,525471,525472,525473,525474,525475,525476,525477,525479,
525482,525483,525484,525485,525487,525488,525489,525490,525493,525498,
525499,525506,525507,525508,525517,525519,525521,525529,525530,525533,
525535,525537,525547,525551,525552,525555,525567,525570,525571,525573,
525574,525579,525585,525588,525593,525597,525602,525606,525607,525608,
525609,525611,525614,525615,525616,525618,525620,525625,525627,525629,
525633,525634,525638,525644,525646,525647,525650,525655,525659,525661,
525662,525671,525672,525673,525674,525676,525680,525682,525683,525684,
525691,525692,525696,525698,525699,525701,525704,525711,525714,525724,
525725,525730,525732,525736,525737,525738,525739,525743,525748,525749,
525751,525756,525757,525760,525763,525767,525773,525774,525777,525778,
525779,525781,525787,525788,525793,525796,525798,525799,525805,525806,
525811,525812,525815,525818,525821,525827,525830,525833,525835,525837,
525841,525843,525849,525850,525851,525854,525859,525861,525862,525863,
525864,525865,525866,525867,525869,525871,525873,525874,525875,525876,
525880,525881,525882,525883,525885,525887,525890,525895,525899,525900,
525902,525905,525907,525915,525919,525921,525922,525923,525927,525929,
525937,525941,525943,525951,525954,525962,525967,525968,525970,525971,
525975,525979,525983,525987,525990,525992,525993,525994,525996,526001,
526004,526007,526008,526009,526017,526019,526022,526023,526025,526031,
526035,526036,526038,526043,526048,526049,526052,526055,526059,526061,
526062,526063,526069,526070,526072,526081,526082,526085,526086,526089,
526091,526092,526094,526095,526096,526100,526101,526108,526109,526110,
526117,526118,526121,526127,526128,526129,526134,526140,526141,526142,
526145,526149,526152,526158,526160,526164,526168,526170,526173,526174,
526175,526176,526177,526178,526179,526181,526182,526184,526187,526188,
526192,526193,526194,526196,526199,526200,526201,526204,526207,526220,
526221,526227,526229,526232,526233,526235,526237,526238,526242,526245,
526247,526248,526250,526251,526258,526261,526262,526263,526264,526270,
526272,526274,526275,526276,526278,526279,526283,526284,526285,526292,
526294,526297,526298,526299,526302,526303,526304,526307,526308,526316,
526317,526320,526321,526323,526329,526330,526331,526334,526336,526342,
526343,526347,526348,526351,526352,526353,526354,526355,526363,526364,
526366,526367,526368,526369,526375,526376,526380,526382,526385,526386,
526387,526391,526392,526397,526399,526404,526405,526406,526414,526417,
526420,526421,526423,526427,526432,526433,526435,526438,526440,526441,
526442,526444,526445,526450,526452,526455,526457,526458,526460,526461,
526463,526465,526467,526468,526472,526474,526477,526479,526480,526483,
526484,526485,526487,526492,526494,526503,526505,526506,526507,526508,
526511,526513,526518,526519,526521,526522,526523,526525,526526,526527,
526528,526531,526534,526535,526536,526546,572828,524101,524166,524244,
524685,612279,612388
);
0
Comment
Question by:jtarbox
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 15

Accepted Solution

by:
ishando earned 500 total points
Comment Utility
I would say create a table to hold you values, then

select c.claim_id, c.account_structure_id
from s_dis_claim c, temp_claims t
where c.claim_id = t.claim_id;

update s_dis_claim c
set c.account_structure_id = (select new_id from temp_claims t where c.claim_id = t.claim_id)
where exists (select 1 from temp_claims t where c.claim_id = t.claim_id);
0
 

Author Comment

by:jtarbox
Comment Utility
Could you explain how to create the table and load the values? Also, is there a better way than mine without a creating a table? I'm not a PL/SQL expert, but would it be a better choice?
0
 
LVL 15

Expert Comment

by:ishando
Comment Utility
use CREATE TABLE command to create table eg
  CREATE TABLE temp_claims (claim_id integer, new_id integer);

You can load the data either from a file via sql*loader or with a set of insert statements. eg

insert into temp_claims values (524903, 187);
insert into temp_claims values (524905, 187);
insert into temp_claims values (524912, 187);
insert into temp_claims values (524913, 187);
....


You could do it with PL/SQL wihtout creating a table something like:

declare
  type iTabType is table of integer;
  itClaim iTabType := iTabType(524903, 524905, 524912, 524913, ...);
  itNew iTabType := iTabType(187, 187, 187, 187, ...);      
    --- Not sure how long you can make a single line in PL/SQL so you may need to come up with a better way to
    --- populate these arrays.

begin
  for i in itClaim.first .. itClaim.last loop
    update s_dis_claim c
    set c.account_structure_id = itNew(i)
    where claim_id = itClaim(i);
  end loop;
  commit;
end;
/
0
 

Author Comment

by:jtarbox
Comment Utility
Should the temp_claims table have an index on claim_id? If so, is there a CREATE INDEX type statement?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 15

Expert Comment

by:ishando
Comment Utility
Yes, it probably should. There is, but I'd probably create it is an index-organised table instead -

CREATE TABLE temp_claims
  (claim_id integer CONSTRAINT temp_claims_pk PRIMARY KEY,
   new_id integer)
ORGANIZATION INDEX;
0
 

Author Comment

by:jtarbox
Comment Utility
Just curious, I know there is much discussion regarding the IN vs. the EXISTS statement. Would that do anything for me in this case as far as efficiency? If so, how could I implement it?

It seems that the CREATE TABLE solution would probably be the best to me.

Thank you.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
The best way to test efficiency is to generate the plans for each approach based on your tables.  Typically, but not always, the SQL with the lowest cost is the fastest/best.

The discussion between IN and EXISTS are all due to how the Oracle Cost Based Optimizer (CBO) will re-write the SQL and the different access methods it will take.

If you are unfamiliar with generating plans w/o actually running the SQL do the following:
1: create a plan table:  run the script ?/rdbms/admin/utlxplan

note: The easiest way I've found is to just keep cleaning out the plan table between runs.  You can keep multiple plans by setting a statement id but I'll let you go to the docs for that.

2: generate the plan for the specific SQL by adding 'explain plan for' the the sql.

for example:  explain plan for select sysdate from dual;

3: look at the plan.  Everyone has their favorite script for this and there are many on the net.

Here's mine:
---------------------------
SELECT LPAD(' ',2*(LEVEL-1))||operation||' '||options||' '||optimizer
   ||' '||object_name
   ||' '||DECODE(id, 0, 'Cost = '||position) "Query Plan"
   FROM plan_table
   START WITH id = 0
   CONNECT BY PRIOR id = parent_id
/


0
 
LVL 9

Expert Comment

by:konektor
Comment Utility
probably you might use MERGE statement with CASE operator or DECODE function
0
 
LVL 9

Expert Comment

by:konektor
Comment Utility
be carefull, i think there is a limit to ues max 1000 values in "IN" clause :-)
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now