drop table my_hierarchy; create table my_hierarchy ( id_h number , id_lvl number , id_lvl_sup number , nb number , ord number ); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,1,null,null,1); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,2,1,1,2); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,3,1,null,3); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,4,3,1,4); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,5,3,1,5); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,7,3,1,7); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,8,3,1,8); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,9,3,1,9); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,10,3,2,10); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,11,1,null,11); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,12,11,1,12); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,13,11,1,13); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,14,11,1,14); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,15,11,1,15); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,16,1,null,16); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,17,16,1,17); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,18,16,1,18); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,19,16,null,19); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,20,19,1,20); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,21,19,1,21); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,22,19,1,22); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,23,19,1,23); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,24,null,null,3); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,25,24,1,25); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,26,24,1,26); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,27,24,1,27); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,28,24,null,28); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,29,28,1,29); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,30,28,1,30); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,31,28,1,31); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,32,28,1,32); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,33,28,1,33); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,34,24,null,34); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,35,34,1,35); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,36,34,1,36); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,37,34,1,37); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,38,34,1,38); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,39,24,null,39); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,40,39,1,40); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,41,39,1,41); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,42,39,1,42); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,43,39,1,1); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,44,39,null,44); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,45,44,1,45); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,46,44,1,46); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,47,44,1,47); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,48,44,1,48); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,49,44,1,49); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,50,39,null,50); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,51,50,1,1); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,52,50,1,2); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,53,50,1,4); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,54,50,1,5); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,55,50,1,3); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,56,39,null,56); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,57,24,null,57); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,58,57,null,200); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,59,57,null,200); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,60,24,null,60); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,61,60,null,61); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,62,60,null,62); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,63,62,null,63); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,64,62,null,64); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,65,62,null,65); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,66,60,null,66); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,67,60,null,67); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,68,67,null,68); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,69,67,null,69); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,70,67,null,70); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,71,60,null,71); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,72,71,null,72); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,73,71,null,73); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,74,71,null,74); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,75,71,null,75); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,76,24,null,76); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,77,76,null,77); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,78,76,null,78); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,79,76,null,79); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,80,76,null,80); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,81,24,null,81); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,82,81,null,82); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,83,81,null,83); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,84,81,null,84); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,85,81,null,85); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,86,24,null,86); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,87,86,null,87); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,88,86,null,88); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,89,86,null,89); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,90,86,null,90); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,91,null,null,4); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,92,91,1,92); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,93,56,1,1); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,94,56,1,2); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,95,56,1,3); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,97,56,1,97); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,98,56,1,98); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,99,39,null,99); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,100,99,1,1); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,101,99,1,2); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,102,99,1,3); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,104,99,1,104); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,105,99,1,105); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,107,57,1,2); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,108,57,1,108); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,109,57,1,1); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,110,58,1,110); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,111,58,1,111); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,112,58,1,112); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,113,58,1,113); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,114,58,1,114); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,115,59,1,115); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,116,59,2,116); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,117,59,1,117); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,118,59,1,118); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,119,59,1,119); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,120,60,1,1); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,121,60,1,2); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,122,60,1,3); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,123,61,1,110); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,124,61,1,124); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,125,61,1,125); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,126,61,2,126); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,127,61,2,127); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,128,61,6,128); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,129,62,1,0); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,130,63,1,130); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,131,63,2,131); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,132,63,1,132); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,133,63,1,133); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,134,64,2,134); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,135,64,2,135); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,136,65,2,136); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,137,66,1,137); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,138,66,1,138); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,139,66,1,139); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,140,66,1,140); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,141,66,4,141); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,142,67,1,142); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,143,67,1,143); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,144,67,1,144); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,145,67,1,145); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,146,67,1,146); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,147,67,1,147); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,148,null,null,2); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,149,148,1,149); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,150,148,null,150); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,151,150,1,151); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,152,148,null,152); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,153,148,null,153); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,154,148,null,154); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,155,148,null,155); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,156,148,null,156); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,157,152,1,151); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,158,153,1,151); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,159,154,1,151); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,160,155,1,151); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,161,156,1,161); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,162,1,null,162); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,163,1,null,163); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,164,1,null,164); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,165,162,1,165); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,166,163,1,166); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,167,164,1,167); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,168,150,null,168); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,169,168,1,169); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,170,168,1,170); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,171,168,1,171); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,172,168,null,172); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,173,172,1,173); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,174,172,1,174); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,175,172,null,175); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,176,175,1,176); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,177,172,null,177); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,178,177,1,176); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,179,168,null,179); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,180,179,1,173); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,181,179,1,174); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,182,179,null,182); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,183,182,1,173); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,184,182,1,174); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,185,182,1,185); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,186,179,null,186); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,187,186,1,176); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,188,186,1,177); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,189,150,null,189); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,190,189,1,169); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,191,189,1,170); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,192,189,null,192); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,193,192,1,173); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,194,192,1,174); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,195,192,null,195); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,196,195,1,176); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,197,195,1,177); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,198,192,null,198); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,199,192,null,199); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,200,198,1,176); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,201,198,1,177); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,202,199,1,176); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,203,199,1,177); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,204,189,null,204); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,205,204,1,173); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,206,204,1,174); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,207,204,null,207); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,208,204,null,208); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,209,204,null,209); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,210,207,1,210); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,211,208,1,210); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,212,209,1,212); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,213,189,null,213); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,214,213,null,214); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,215,213,null,215); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,216,213,1,173); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,217,213,1,174); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,218,214,1,176); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,219,215,1,176); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,220,1,null,220); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,221,91,1,221); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,222,91,null,222); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,223,222,1,223); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,224,222,1,224); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,225,222,1,225); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,226,91,null,226); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,227,226,1,227); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,228,226,1,228); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,229,226,1,229); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,230,91,null,230); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,231,230,1,231); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,232,230,1,232); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,233,230,null,233); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,234,233,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,235,233,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,236,235,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,237,235,null,237); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,238,237,1,238); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,239,237,1,239); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,240,237,1,240); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,241,237,1,241); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,242,237,1,242); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,243,235,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,244,243,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,245,243,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,246,233,null,246); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,247,246,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,248,250,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,249,250,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,250,246,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,251,246,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,252,251,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,253,251,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,254,233,null,246); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,255,254,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,256,254,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,257,256,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,258,256,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,259,254,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,260,259,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,261,259,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,262,230,null,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,263,262,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,264,262,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,265,264,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,272,264,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,273,272,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,274,272,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,275,264,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,276,275,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,277,275,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,278,262,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,279,278,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,280,278,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,281,280,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,282,280,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,283,278,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,284,283,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,285,283,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,286,262,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,287,286,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,288,286,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,289,288,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,290,288,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,291,286,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,292,291,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,293,291,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,294,230,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,295,294,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,296,294,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,297,296,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,298,296,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,299,298,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,300,298,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,301,296,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,302,301,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,303,301,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,304,294,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,305,304,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,306,304,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,307,306,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,308,306,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,309,304,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,310,309,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,311,309,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,312,294,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,313,312,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,314,312,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,315,314,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,316,314,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,317,312,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,318,317,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,319,317,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,320,230,null,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,321,320,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,322,320,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,323,322,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,324,322,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,325,324,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,326,324,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,327,322,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,328,327,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,329,327,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,330,320,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,331,330,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,332,330,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,333,332,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,334,332,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,335,330,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,336,335,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,337,335,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,338,320,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,339,338,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,340,338,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,341,340,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,342,340,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,343,338,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,344,343,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,345,343,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,566,1,null,566); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,567,91,null,231); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,568,567,1,231); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,569,567,1,232); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,570,567,null,233); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,571,570,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,572,570,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,573,572,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,574,572,null,237); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,575,574,1,238); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,576,574,1,239); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,577,574,1,240); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,578,574,1,241); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,579,574,1,242); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,580,572,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,581,580,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,582,580,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,583,570,null,246); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,584,583,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,585,583,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,586,585,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,587,585,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,588,583,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,589,588,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,590,588,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,591,570,null,246); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,592,591,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,593,591,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,594,593,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,595,593,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,596,591,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,597,596,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,598,596,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,599,567,null,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,600,599,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,601,599,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,602,601,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,603,601,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,604,603,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,605,603,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,606,601,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,607,606,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,608,606,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,609,599,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,610,609,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,611,609,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,612,611,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,613,611,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,614,609,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,615,614,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,616,614,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,617,599,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,618,617,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,619,617,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,620,619,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,621,619,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,622,617,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,623,622,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,624,622,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,625,567,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,626,625,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,627,625,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,628,627,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,629,627,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,630,629,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,631,629,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,632,627,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,633,632,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,634,632,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,635,625,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,636,635,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,637,635,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,638,637,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,639,637,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,640,635,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,641,640,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,642,640,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,643,625,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,644,643,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,645,643,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,646,645,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,647,645,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,648,643,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,649,648,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,650,648,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,651,567,null,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,652,651,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,653,651,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,654,653,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,655,653,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,656,655,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,657,655,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,658,653,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,659,658,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,660,658,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,661,651,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,662,661,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,663,661,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,664,663,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,665,663,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,666,661,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,667,666,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,668,666,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,669,651,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,670,669,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,671,669,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,672,671,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,673,671,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,674,669,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,675,674,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,676,674,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,677,91,null,232); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,678,677,1,231); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,679,677,1,232); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,680,677,null,233); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,681,680,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,682,680,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,683,682,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,684,682,null,237); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,685,684,1,238); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,686,684,1,239); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,687,684,1,240); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,688,684,1,241); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,689,684,1,242); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,690,682,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,691,690,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,692,690,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,693,680,null,246); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,694,693,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,695,693,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,696,695,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,697,695,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,698,693,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,699,698,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,700,698,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,701,680,null,246); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,702,701,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,703,701,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,704,703,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,705,703,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,706,701,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,707,706,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,708,706,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,709,677,null,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,710,709,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,711,709,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,712,711,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,713,711,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,714,713,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,715,713,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,716,711,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,717,716,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,718,716,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,719,709,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,720,719,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,721,719,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,722,721,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,723,721,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,724,719,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,725,724,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,726,724,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,727,709,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,728,727,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,729,727,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,730,729,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,731,729,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,732,727,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,733,732,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,734,732,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,735,677,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,736,735,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,737,735,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,738,737,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,739,737,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,740,739,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,741,739,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,742,737,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,743,742,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,744,742,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,745,735,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,746,745,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,747,745,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,748,747,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,749,747,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,750,745,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,751,750,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,752,750,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,753,735,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,754,753,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,755,753,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,756,755,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,757,755,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,758,753,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,759,758,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,760,758,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,761,677,null,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,762,761,1,234); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,763,761,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,764,763,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,765,763,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,766,765,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,767,765,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,768,763,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,769,768,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,770,768,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,771,761,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,772,771,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,773,771,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,774,773,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,775,773,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,776,771,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,777,776,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,778,776,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,779,761,null,235); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,780,779,1,236); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,781,779,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,782,781,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,783,781,4,245); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,784,779,null,243); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,785,784,1,244); insert into my_hierarchy(id_h, id_lvl, id_lvl_sup, nb, ord) values (1000,786,784,4,245); drop table my_items; create table my_items ( id_h number , id_lvl number , id_item number , qty number , ord number , id_item_sup number , ord_sup number ); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,2,2102,1,2102,2100,2100); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,2,2106,1,2106,2100,2100); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,2,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,2,2104,1,2104,2100,2100); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,2,2103,1,2103,2100,2100); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,2,2105,1,2105,2100,2100); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,4,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,5,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,9,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,10,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,12,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,13,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,14,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,15,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,16,7003,1,7003,7001,7001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,16,7004,600,7004,7001,7001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,16,7002,1,7002,7001,7001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,17,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,18,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,20,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,21,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,22,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3015,1,3015,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3016,1,3016,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3017,1,3017,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3018,1,3018,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3019,1,3019,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3020,1,3020,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3021,1,3021,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3022,1,3022,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3023,1,3023,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3024,1,3024,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3025,1,3025,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3026,1,3026,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3501,1,3501,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3502,1,3502,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3503,1,3503,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3504,1,3504,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3505,1,3505,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3506,1,3506,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3507,1,3507,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3508,1,3508,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3509,1,3509,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3510,1,3510,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3511,1,3511,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3512,1,3512,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3513,1,3513,3500,3500); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2201,1,2201,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2202,5,2202,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2203,2,2203,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2204,2,2204,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2205,1,2205,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2206,7,2206,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2207,5,2207,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2208,5,2208,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2209,2,2209,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2210,1,2210,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2211,4,2211,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2212,3,2212,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2213,1,2213,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2214,1,2214,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2215,1,2215,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2216,1,2216,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2217,1,2217,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2218,1,2218,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2219,1,2219,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2220,1,2220,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2221,1,2221,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2222,1,2222,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2223,1,2223,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2224,1,2224,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2225,1,2225,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2226,1,2226,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2227,1,2227,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2228,1,2228,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2229,1,2229,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2230,1,2230,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2231,1,2231,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2232,1,2232,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2233,1,2233,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2234,1,2234,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2235,1,2235,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2236,1,2236,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2237,1,2237,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2238,1,2238,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2239,1,2239,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,2240,1,2240,2200,2200); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3002,1,3002,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3003,1,3003,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3004,1,3004,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3005,1,3005,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3006,1,3006,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3007,1,3007,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3008,1,3008,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3009,1,3009,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3010,1,3010,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3011,1,3011,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3012,1,3012,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3013,1,3013,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,24,3014,1,3014,3001,3001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,25,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,26,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,29,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,30,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,31,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,32,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,35,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,36,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,38,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,40,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,41,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,43,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,45,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,46,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,47,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,51,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,52,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,55,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,81,6005,1,6005,6001,6001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,81,6004,1,6004,6001,6001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,81,6006,1,6006,6001,6001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,81,6002,1,6002,6001,6001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,81,6010,1,6010,6001,6001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,81,6009,1,6009,6001,6001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,81,6008,1,6008,6001,6001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,81,6007,1,6007,6001,6001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,81,6003,1,6003,6001,6001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,86,4002,1,4002,4001,4001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,91,2106,5,2106,2100,2100); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,91,2102,5,2102,2100,2100); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,91,2105,5,2105,2100,2100); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,91,2104,12,2104,2100,2100); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,91,2103,4,2103,2100,2100); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,92,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,93,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,94,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,95,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,100,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,101,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,102,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,107,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,109,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,110,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,111,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,115,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,116,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,119,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,120,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,121,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,123,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,124,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,125,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,126,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,127,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,128,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,129,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,130,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,131,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,132,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,134,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,136,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,137,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,138,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,140,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,141,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,142,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,143,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,144,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,145,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,146,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,147,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,149,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,151,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,157,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,158,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,159,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,160,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,161,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1003,1,1003,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1004,1,1004,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1005,2,1005,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1006,1,1006,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1007,2,1007,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1008,1,1008,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1009,10,1009,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1010,1,1010,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1011,1,1011,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1012,1,1012,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,162,1013,1,1013,1002,1002); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,164,8002,1,8002,8001,8001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,164,8003,1,8003,8001,8001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,164,8004,1,8004,8001,8001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,164,8005,1,8005,8001,8001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,164,8006,1,8006,8001,8001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,164,8007,1,8007,8001,8001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,164,8008,1,8008,8001,8001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,164,8009,1,8009,8001,8001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,164,8010,1,8010,8001,8001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,165,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,166,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,167,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,169,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,170,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,171,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,173,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,174,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,176,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,178,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,180,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,181,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,183,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,184,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,185,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,187,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,188,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,190,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,191,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,193,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,194,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,196,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,197,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,200,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,201,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,202,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,203,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,205,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,206,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,210,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,211,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,216,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,217,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,218,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,219,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,221,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,223,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,224,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,225,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,227,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,228,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,229,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,231,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,232,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,234,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,236,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,238,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,239,2004,1,2004,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,239,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,240,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,241,2007,1,2007,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,241,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,242,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,244,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,245,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,247,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,248,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,249,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,252,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,253,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,255,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,257,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,258,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,260,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,261,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,263,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,265,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,273,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,274,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,276,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,277,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,279,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,281,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,282,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,284,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,285,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,287,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,289,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,290,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,292,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,293,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,295,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,297,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,299,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,300,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,302,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,303,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,305,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,307,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,308,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,310,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,311,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,313,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,315,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,316,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,318,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,319,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,321,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,323,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,325,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,326,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,328,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,329,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,331,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,333,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,334,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,336,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,337,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,339,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,341,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,342,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,344,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,345,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,568,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,569,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,571,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,573,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,575,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,576,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,576,2004,1,2004,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,577,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,578,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,578,2007,1,2007,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,579,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,581,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,582,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,584,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,586,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,587,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,589,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,590,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,592,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,594,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,595,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,597,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,598,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,600,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,602,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,604,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,605,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,607,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,608,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,610,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,612,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,613,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,615,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,616,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,618,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,620,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,621,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,623,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,624,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,626,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,628,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,630,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,631,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,633,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,634,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,636,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,638,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,639,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,641,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,642,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,644,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,646,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,647,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,649,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,650,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,652,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,654,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,656,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,657,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,659,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,660,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,662,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,664,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,665,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,667,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,668,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,670,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,672,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,673,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,675,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,676,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,678,2002,1,2002,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,679,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,681,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,683,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,685,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,686,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,686,2004,1,2004,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,687,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,688,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,688,2007,1,2007,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,689,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,691,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,692,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,694,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,696,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,697,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,699,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,700,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,702,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,704,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,705,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,707,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,708,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,710,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,712,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,714,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,715,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,717,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,718,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,720,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,722,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,723,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,725,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,726,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,728,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,730,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,731,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,733,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,734,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,736,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,738,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,740,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,741,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,743,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,744,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,746,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,748,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,749,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,751,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,752,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,754,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,756,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,757,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,759,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,760,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,762,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,764,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,766,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,767,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,769,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,770,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,772,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,774,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,775,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,777,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,778,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,780,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,782,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,783,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,785,2003,1,2003,2001,2001); insert into my_items(id_h, id_lvl, id_item, qty, ord, id_item_sup, ord_sup) values (1000,786,2003,1,2003,2001,2001); create or replace view my_view as select * from ( with v_params as ( select null p_id_lvl_start , 1000 p_id_h , 10 p_nb_item_per_grp from dual ), v000 as ( select id_h , id_lvl , connect_by_root id_lvl id_lvl_root , sys_connect_by_path(id_lvl, '|') || '|' path_id_lvl , level lvl , nb , p_nb_item_per_grp from my_hierarchy -- ---- join v_params on 1 = 1 -- ---- where 1 = 1 and id_h = p_id_h connect by prior id_lvl = id_lvl_sup and prior id_h = id_h start with ( id_lvl_sup is null and p_id_lvl_start is null or id_lvl = to_number(p_id_lvl_start) and p_id_lvl_start is not null ) ), v001 as ( select v000.* -- ---- , qty , id_item , my_items.ord ord_item -- , id_item_sup , my_items.ord_sup ord_item_sup from v000 -- ---- left join my_items on v000.id_h = my_items.id_h and v000.id_lvl = my_items.id_lvl and (nb >= 1 or qty > 0) ) , v002 as ( select v001.id_h , id_lvl , qty * nvl(nb,1) qty -- -- , id_item , ord_item -- -- , id_item_sup , ord_item_sup , p_nb_item_per_grp -- ======================= lvl 1 , to_number(trim(nvl(substr(path_id_lvl , instr(path_id_lvl, '|', 1, 1) + 1 , instr(path_id_lvl, '|', 1, 2) - instr(path_id_lvl, '|', 1, 1) - 1), id_lvl_root))) id_lvl1 -- ======================= lvl 2 , to_number(trim(nvl(substr(path_id_lvl , instr(path_id_lvl, '|', 1, 2) + 1 , instr(path_id_lvl, '|', 1, 3) - instr(path_id_lvl, '|', 1, 2) - 1), id_lvl_root))) id_lvl2 from v001 where 1 = 1 ) , v003 as ( select v002.id_h -- ---- , v002.id_lvl1 , my_hierarchy1.ord ord_lvl1 -- ---- , v002.id_lvl2 , my_hierarchy1.ord ord_lvl2 -- ---- , id_item , ord_item -- ---- , qty , id_item_sup , ord_item_sup from v002 -- ---- left join my_hierarchy my_hierarchy1 on v002.id_h = my_hierarchy1.id_h and v002.id_lvl1 = my_hierarchy1.id_lvl -- ---- left join my_hierarchy my_hierarchy2 on v002.id_h = my_hierarchy2.id_h and v002.id_lvl2 = my_hierarchy2.id_lvl where 1 = 1 ), v004 as ( select id_h , id_lvl1, ord_lvl1 , id_lvl2, ord_lvl2 -- -- , id_item_sup , to_char(id_item_sup) lib_item_sup , ord_item_sup -- -- , id_item , to_char(id_item) lib_item , ord_item , sum(qty) total from v003 group by id_h , id_lvl1, ord_lvl1 , id_lvl2, ord_lvl2 -- -- , id_item_sup , to_char(id_item_sup) , ord_item_sup -- -- , id_item , to_char(id_item) , ord_item ) select * from v004 ) ;