Archive for November 2007
Kuri!
Klassivõitlus ägeneb
Selline uudis EPLis: Ilves kiitis Narva monumendi vastast allkirjade kogumist
Tõepoolest, Eesti Vabariigiga tunduvad lood olevat sedavõrd kehvad, et 90 aasta taguseid poliitilisi vastaseid mälestavat müüri peab hakkama kangutama. Et nagu sünnipäevakingiks, või nii. Kui siia lisada mõningate poliitikute vihjed, et krooni devalveerimisest rääkivad inimesed peaks kroonu ülalpidamisele saatma, siis hakkab kuidagii eriti imelik…
Valitud kohti kirjavahetusest projektijuhtidega
Kirjavahetus sai alguse probleemist, et üks osa ühest teatud ärikriitilisest rakendusest sureb vaprate surma vähemalt korra päevas testkeskkonnas, ja vähemalt korra nädalas tootekeskkonnas. Mille peale kirjutas meie arenduse valdkonnajuht:
täpsustuseks seda ka, et praegune XXXi arendus ei puuduta komm.moodulit.
Tegemist on sama rakendusega, mis 2004 -ltoodangusse pandi ja millega nii 2004 kui 2005 a edukalt teste tehti – nii et puhas süsteemihoolduse rida.
Mille peale ei pidanud mul närv vastu:
Haruldaselt mõnus suhtumine. Käkite mingi rakenduse valmis, määrite süsteemihooldusele pähe ja olete pärast veel pisarateni solvunud, kui süsteemihooldus teie s.takäki haldamisega hakkama ei saa. Tõepoolest.
Jumalate viha ei lasknud ennast kaua oodata:
täiesti tüüpiline sellise inimese jutt, kes ise millegi märkimisväärse tegemiseks suuteline ei ole, eks teiste põlastamisega saab ju ennast tähtsamana tunda muidugi – vaene mehike
))- YY on üks kõvemaid tegijaid Eestis – ja see käkk on 3 aastat tuksunud
Uuu, ärge vaadake mind, ma olen nii väike ja roojane! Isegi eilne törts punki ei suutnud mu räpast hinge kuigivõrd puhastada. Võib-olla peaks tõesti minema ja esmaspäeval tegema arendajate ukse taga harakiri?
Miks on pungikontserdil hea nahast riideid kanda
Poolel teel Kultuurikatla juurde kohtasime looklevat järjekorda. Peale väikest trügimist pääsesime sisse, erinevalt kaheksakümnendatest ei olnud päästeingliks mitte tuttav šveitser, vaid pilet. Peale väikest ekslemist leidsime üles koha, kust müüdi õlut. Selleks ajaks kui esimene õlle käes, oli esimene bänd juba lõpetamas. Vaheaeg ja natuke Propellerit kulus peldikusabas, välipeldikuid nähes saabus korralik dežavuu: viis aastat tagasi tselluloosikombinaadis olid samuti välipeldikuid, kuid minu mäletamist mõõda oli neid oluliselt rohkem. (Mitte et ma sellest üritusest eriti palju mäletaksin, aga siiski.)
Järgmisel vaheajal sai hangitud veel üks õlu. Selleks ajaks, kui karastav vedelik oli otsa lõppemas, saabus õige aeg minna lava ette hüppama. Jaa, elu on läinud paremaks, elu on läinud lõbusamaks. Sedapuhku pakkus Velikije Luki tuld ja sädemeid, Munk paugutas püstolitest ja hüppas “Enesetapja laulu” ajal verise särgiga ringi. Ei mäletagi, et oleksin kunagi varem peale kahte õlut lava ees hüpanud, ja ega ma ei ole kunagi varem ka peaaegu kainena pungikontserdile saabunud. Ealised iseärasused löövad välja, mis muu…
Publik oli lahe, oli noori, oli vanu ja oli ka meie-ealisi, kes Velikije Luki sündimise hetkeks olid juba algkooli jõudnud. Oli üks ratastoolis poiss, päris lava ees, koos isa või mõne muu sugulasega.
Aftekal kurtis Blond Lilleke, et tema udupeene pluusi sisse on kontserdi käigus tekkinud augud. Ta olnud päris lava ees, esimeses reas, sest ta vaatab alati esinejale silma, või midagi säärast. Mingid tegelased hüppasid selja taga, ja ilgelt segasid, ta togis neid küünarnukkidega kõigest jõust vastu, nii et loodetavasti on nad täna kõik sinised. Kui ta lava eest lahkus, siis üritasid kõik karvased liibuda ja talle suud anda. Ühesõnaga, täielik košmaar!
Tegelikult jõuame nüüd jutu pealkirjas tõstatatud kõsimuseni. Nimelt ei imendu õlu, okse, kusi ja muud pungikontserdi käigus ette tulevad vedelikud nahka ja voolavad maha. (Kui need vedelikud ei ole just eriti söövitavad.) Samuti ei tee nahale suuremat kahju konid ja igasugu metallist kulinad, millega inimesed end kaunistama kipuvad. Kui teid keegi tulistab pulberkustutist, siis naha külge jääb seda möginat oluliselt vähem, kui näiteks fliisi sisse. (Selline sündmus leidis aset hiljem katlamajast lahkudes.)
Ja kui teel kontserdile või kontserdilt koju peaks mõni sopalomp pahasti ette jääma, siis piisab täiesti, kui peale lombist pääsemist natuke horisontaalis seista. Igasugu hooned, puud ja muud tehised on selles osas abiks, sõbrad ja võitluskaaslased võivad osutuda ebakindlateks. Saast kuivab ära ja selle saab lihtsa vaevaga maha pühkida.
Sõber sõbra naha koorib
Selline pealkiri EPLis: Parts kaebas AFP-s Ansipi peale
Kas Andrus ja Juhan ka tegelikult sõbrasuhetes on, vajaks tegelikult eraldi uurimist. Samas, ühes valitsuses nad on. Alluva mässu ülemuse ja tööandja vastu siin ka ei näeks, sest eks need valisuskoalitsiooni poliitikud ole üks vereimejate klikk puha. Ühesõnaga, lihtslt naljakas.
Usaldamisest ja teadlaste mainest
Inimesi on igasuguseid ja arvamusi on igasuguseid. Õnneks annab arvamusi koguda ja süstematiseerida. Hea tahtmise korral saab sellise kogumise ja süstematiseerimise tulemuse põhjal teha järeldusi. Näiteks järeldas meie lugupeetud sõjaminister hiljuti avaliku arvamuse küsitlusest, et avaliku arvamuse küsitlused ei peegelda tegelikkust.
Mida sellisest paradoksist arvata? Meie sõjaminister arvas järgmist:
Arusaadav, et usaldatavuse teema tõstatub ühiskonnas kõige teravamalt just sotsiaalteaduste puhul, selles valdkonnas on meil kõigil nii isiklik huvi kui ka oma teadmine; vaevalt et kaks kolmandikku meist ei usaldaks arsti- või loodusteaduste tulemusi.
Ja veidi edasi:
Usaldus ei põhine kunagi meeldivusel, vaid kindlustundel, et see, millena midagi esitletakse, seda ka tegelikult on. Et teadustulemus on teaduslikel printsiipidel põhineva tegevuse produkt ja teadlane teaduseetika kandja. Me usaldame gravitatsiooniseadust ja Newtonit sellele vaatamata, et maha kukkudes võime pea veriseks lüüa.
Tõepoolest, kas geneetikuid ja nende poolt muundatud geneetikaga organisme ei usalda inimesed seetõttu, et geneetikutel puudub teaduslik meetod ja nad esitlevad seda, mida tegelikult pole? Newtoni kaasaegsed usaldasid tema gravitatsiooniteooriat hoolimata sellest, et esialgsed vaatlused selle falsifitseerisid. Seega Newtoni kaasaegsete jaoks esitas tema teooria asja, mida tegelikult polnud. Või kui kaugele peaks usaldamisega üldse minema? Kas Newtoni alkeemia alaseid tõid peaks usaldama? Sest nende autor on ju ikkagi Newton!
Teaduses, ka sotsiaalteadustes, peab tõepüüdlus käima eespool isiklikke (poliitilisi) hoiakuid ja huve. Kui on vastupidi, on tegemist poliitikaga, ja siis on asjaosaline lihtsalt tädi Raivo, kirjutagu ta siis oma arvamusele alla sotsiaalteadlane või professor või akadeemik.
Sellele jutule võiks isegi alla kirjutada, kui ülalpool poleks esinenud keegi Newton. Tema Opticks sisaldab muuhulgas spekulatsioone selle kohta, kuidas Jumal lõi aine, milline on õige viis teha teadust, lisaks törts natuurifilosoofiat ja eetikat. Tõepoolest, Opticks‘is on see osa esitatud viimasena, nii et Newtonil käis tõepüüdlus enne isiklikku arvamust. Samuti ei tahaks ma nüüd “tädi Raivot” kõigi aegade suurima füüsikuga võrrelda. Lisaks on ju teada, kui pingelist elu elavad meie ministrid, eriti veel sõjaminister: pole siis ime, et mingisse ajaleheartiklisse minevaid näiteid ei jõua päris lõpuni mõelda. Samas, kui juba küsimusi tõstatada, siis võiks see tõstatus olla loogiliselt ja statistiliselt laitmatu. Kohatisest demagoogiast rääkimata…
PS. Palju tänu Sirjele, kelle blogist leidsin viite sellele artiklile. Kuna ma Postimeest üldjuhul ei loe, siis oleks muidu meie sõjaministri väärt artikkel märkamata jäänud.
Skorpion merevaigus
Romaani esimesest kõitest oli eelmisel nädalal põgusalt juttu. Nüüd on ka teine kõide läbi ja aeg kokkuvõtteid teha 
Teises kõites jätkab Aleksandr Šulgin mõõda alternatiivseid reaalsusi kolamist ja laseb muude tegemiste kõrvalt vanade vaenlaste superarvutil juhtme kokku. Nii et neist tegelastest peaks vähemalt mõneks ajaks olema rahu. Seejärel jätkab ta Hispaanias laamendamist, sest sõda tahab ju võitmist. Ja et võit ikka võimalikult suure efektiga tuleks, laseb Šulgin koos nõukogude kommandostega mingisuguses keskaegses kindluses maha mingisuguse kindral Franco.
Ootasin sel hetkel, et Šulgin pöördub Moskvasse Stalini manu tagasi ja raamat muutub ehk jälle mõnuga loetavaks. Tagasi ta pöördubki, süžee teeb aga seejuures ühe õige isemoodi käänaku. Et kirjanikuhärral leib laualt otsa ei lõpeks, tekib inimkonnale uus vaenlane. Uus nuhtlus on muidugi hästi verejänuline ja kuri, et mitte õelda suisa puhta kurjuse kehastus. Raamat lõpeb sellega, et sm Lihharev teleporteerub Moskvasse, et tankidiviis Stalini suvilat kaitsma saata. Nii et vähemalt üks teravasüžeeline kahekõiteline romaan tuleb kindlasti veel.
Et mis siis kokkuvõtteks õelda? Esimene osa andis lootust. Sel hetkel, kui wookiet (pean silmas seda tähevarte filmist pärit kolmemeetrist ja karvast kolli) meenutavad tegelased Jossif Vissarionovitši limusiini õhku lasid, muutus Zvjagintsevi alternatiivne reaalsus minu jaoks juba liiga alternatiivseks. Miks peaks täiesti korralikku alternatiivajalugu mingite päkapikkude ja mäekollidega solkima? Rääkimata juba sellest, et eri masti kirjamehed on jõudnud folkloorsete tegelaste tulnukateks pidamise teema korralikult ära leierdada, minu jaoks vähemalt. No ja vaevalt et Zvjagintsevil selles osas midagi lisada on. Maa-maa tüüpi rakettidega Moskvas ringi uimerdavad trollid nüüd küll see originaalne panus ei ole.
Mis teha, tundub, et Zvjagintsevi peab siiski maha kandma. Eks ajaviiteks kõlbavad tema raamatud ehk edaspidigi lugeda, mingit tõsisemat huvi Zvjagintsevi tegemised vaevalt et pakuvad. Kurb, aga nii on…
Insenerid tööhoos
Tegelikult ei tea kunagi, mida arendajad enne arendama asumist on suitsetanud või mida üks loomepalangusse sattunud inimene suudab baasis vaadete otsa vaateid ehitades korda saata.
Hakkasin täna uurima, miks “ei tööta” ja miks on kasutajad õnnetud. Baasis hakkas silma selline kena tilluke päring:
SELECT * FROM SUMMARY_STATISTICS_UNION WHERE to_date(YEAR||MONTH,'yyyymm') >= :s AND to_date(YEAR||MONTH,'yyyymm') <= :d
Arvake ära, milline on selle päringu plaan? Selline. (Kahjuks lõikab plogi kujundus plaanitabelist osa maha, keda huvitab, peab lehekülje sortsu uurima:))
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Inst |IN-OUT|
---------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 22357| 10484| | 44200(100)| | |
| 1 | SORT GROUP BY | | 22357| 10484| | 44200(100)| | |
| 2 | VIEW | DETAIL_STATISTICS_UNION | 22357| 10484| | | | |
| 3 | SORT GROUP BY | | 22357| 20532| | 29394(100)| | |
| 4 | VIEW | STATISTICS_UNION | 22357| 20532| | | | |
| 5 | UNION-ALL | | | | | | | |
| 6 | SORT GROUP BY | | 485G| 363T| | 18G(100)| | |
|* 7 | HASH JOIN | | 485G| 363T| 760M| 1844K (85)| | |
| 8 | VIEW | | 1020K| 748M| | | | |
| 9 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 10 | UNION-ALL | | | | | | | |
|* 11 | FILTER | | | | | | | |
| 12 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|* 13 | FILTER | | | | | | | |
| 14 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 15 | VIEW | STATISTICS_CONSIGNMENT | 47M| 2493M| | | | |
|* 16 | FILTER | | | | | | | |
| 17 | SORT GROUP BY | | 47M| 8479M| | 1331K (94)| | |
|* 18 | HASH JOIN | | 47M| 8479M| | 143K (40)| | |
| 19 | VIEW | | 6812 | 1051K| | | | |
| 20 | SORT UNIQUE | | 6812 | 1861K| 4888K| 27250 (58)| | |
| 21 | UNION-ALL | | | | | | | |
|* 22 | TABLE ACCESS FULL | CONSIGNMENT | 6089 | 1647K| | 23954 (53)| | |
| 23 | REMOTE | | 723 | 214K| | | ENCTS~ | R->S |
| 24 | VIEW | | 697K| 19M| | | | |
| 25 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 26 | UNION-ALL | | | | | | | |
| 27 | INLIST ITERATOR | | | | | | | |
| 28 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|* 29 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 30 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 31 | SORT GROUP BY | | 440G| 329T| | 16G(100)| | |
|* 32 | HASH JOIN | | 440G| 329T| 689M| 1833K (85)| | |
| 33 | VIEW | | 925K| 678M| | | | |
| 34 | SORT UNIQUE | | 925K| 148M| 482M| 98004 (61)| | |
| 35 | UNION-ALL | | | | | | | |
|* 36 | FILTER | | | | | | | |
|* 37 | TABLE ACCESS FULL | DECLARATION | 903K| 144M| | 32601 (79)| | |
|* 38 | FILTER | | | | | | | |
| 39 | REMOTE | | 22805 | 4030K| | | ENCTS~ | R->S |
| 40 | VIEW | STATISTICS_CONSIGNMENT | 47M| 2493M| | | | |
|* 41 | FILTER | | | | | | | |
| 42 | SORT GROUP BY | | 47M| 8479M| | 1331K (94)| | |
|* 43 | HASH JOIN | | 47M| 8479M| | 143K (40)| | |
| 44 | VIEW | | 6812 | 1051K| | | | |
| 45 | SORT UNIQUE | | 6812 | 1861K| 4888K| 27250 (58)| | |
| 46 | UNION-ALL | | | | | | | |
|* 47 | TABLE ACCESS FULL | CONSIGNMENT | 6089 | 1647K| | 23954 (53)| | |
| 48 | REMOTE | | 723 | 214K| | | ENCTS~ | R->S |
| 49 | VIEW | | 697K| 19M| | | | |
| 50 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 51 | UNION-ALL | | | | | | | |
| 52 | INLIST ITERATOR | | | | | | | |
| 53 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|* 54 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 55 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 56 | SORT GROUP BY | | 12G| 9484G| | 407M(100)| | |
|* 57 | HASH JOIN | | 12G| 9484G| 19M| 1722K (88)| | |
| 58 | VIEW | | 25993 | 19M| | | | |
| 59 | SORT UNIQUE | | 25993 | 4553K| 12M| 24970 (72)| | |
| 60 | UNION-ALL | | | | | | | |
|* 61 | FILTER | | | | | | | |
|* 62 | TABLE ACCESS FULL | DECLARATION | 3188 | 523K| | 20470 (66)| | |
|* 63 | FILTER | | | | | | | |
| 64 | REMOTE | | 22805 | 4030K| | | ENCTS~ | R->S |
| 65 | VIEW | STATISTICS_CONSIGNMENT | 47M| 2493M| | | | |
|* 66 | FILTER | | | | | | | |
| 67 | SORT GROUP BY | | 47M| 8479M| | 1331K (94)| | |
|* 68 | HASH JOIN | | 47M| 8479M| | 143K (40)| | |
| 69 | VIEW | | 6812 | 1051K| | | | |
| 70 | SORT UNIQUE | | 6812 | 1861K| 4888K| 27250 (58)| | |
| 71 | UNION-ALL | | | | | | | |
|* 72 | TABLE ACCESS FULL | CONSIGNMENT | 6089 | 1647K| | 23954 (53)| | |
| 73 | REMOTE | | 723 | 214K| | | ENCTS~ | R->S |
| 74 | VIEW | | 697K| 19M| | | | |
| 75 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 76 | UNION-ALL | | | | | | | |
| 77 | INLIST ITERATOR | | | | | | | |
| 78 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|* 79 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 80 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 81 | SORT GROUP BY | | 11G| 8441G| | 361M(100)| | |
|* 82 | HASH JOIN | | 11G| 8441G| 17M| 1722K (88)| | |
| 83 | VIEW | | 23136 | 16M| | | | |
| 84 | SORT UNIQUE | | 23136 | 4085K| 12M| 24898 (72)| | |
| 85 | UNION-ALL | | | | | | | |
|* 86 | FILTER | | | | | | | |
|* 87 | TABLE ACCESS FULL | DECLARATION | 331 | 55608 | | 20431 (66)| | |
|* 88 | FILTER | | | | | | | |
| 89 | REMOTE | | 22805 | 4030K| | | ENCTS~ | R->S |
| 90 | VIEW | STATISTICS_CONSIGNMENT | 47M| 2493M| | | | |
|* 91 | FILTER | | | | | | | |
| 92 | SORT GROUP BY | | 47M| 8479M| | 1331K (94)| | |
|* 93 | HASH JOIN | | 47M| 8479M| | 143K (40)| | |
| 94 | VIEW | | 6812 | 1051K| | | | |
| 95 | SORT UNIQUE | | 6812 | 1861K| 4888K| 27250 (58)| | |
| 96 | UNION-ALL | | | | | | | |
|* 97 | TABLE ACCESS FULL | CONSIGNMENT | 6089 | 1647K| | 23954 (53)| | |
| 98 | REMOTE | | 723 | 214K| | | ENCTS~ | R->S |
| 99 | VIEW | | 697K| 19M| | | | |
| 100 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 101 | UNION-ALL | | | | | | | |
| 102 | INLIST ITERATOR | | | | | | | |
| 103 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*104 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 105 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 106 | SORT GROUP BY | | 485G| 257T| | 18G(100)| | |
|*107 | FILTER | | | | | | | |
|*108 | HASH JOIN | | 485G| 257T| 515M| 1857K (85)| | |
| 109 | VIEW | | 1020K| 503M| | | | |
| 110 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 111 | UNION-ALL | | | | | | | |
| 112 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
| 113 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 114 | VIEW | STATISTICS_CONSIGNMENT | 47M| 2992M| | | | |
|*115 | FILTER | | | | | | | |
| 116 | SORT GROUP BY | | 47M| 8479M| | 1331K (94)| | |
|*117 | HASH JOIN | | 47M| 8479M| | 143K (40)| | |
| 118 | VIEW | | 6812 | 1051K| | | | |
| 119 | SORT UNIQUE | | 6812 | 1861K| 4888K| 27250 (58)| | |
| 120 | UNION-ALL | | | | | | | |
|*121 | FILTER | | | | | | | |
|*122 | TABLE ACCESS FULL | CONSIGNMENT | 6089 | 1647K| | 23954 (53)| | |
|*123 | FILTER | | | | | | | |
| 124 | REMOTE | | 723 | 214K| | | ENCTS~ | R->S |
| 125 | VIEW | | 697K| 19M| | | | |
| 126 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 127 | UNION-ALL | | | | | | | |
| 128 | INLIST ITERATOR | | | | | | | |
| 129 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*130 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 131 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 132 | SORT UNIQUE | | 3561 | 187K| | 102 (90)| | |
| 133 | UNION-ALL | | | | | | | |
| 134 | TABLE ACCESS FULL | TRANSIT_CONSIGNMENT | 3560 | 187K| | 53 (80)| | |
| 135 | REMOTE | | 1 | 72 | | | ENCTS~ | R->S |
| 136 | SORT GROUP BY | | 33G| 17T| | 1144M(100)| | |
|*137 | HASH JOIN | | 33G| 17T| 184M| 389K (55)| | |
| 138 | VIEW | STATISTICS_CONSIGNMENT | 3273K| 146M| | | | |
|*139 | FILTER | | | | | | | |
| 140 | SORT GROUP BY | | 3273K| 583M| | 216K (61)| | |
|*141 | HASH JOIN | | 3273K| 583M| | 146K (42)| | |
| 142 | VIEW | | 469 | 74102 | | | | |
| 143 | SORT UNIQUE | | 469 | 136K| | 30519 (64)| | |
| 144 | UNION-ALL | | | | | | | |
|*145 | FILTER | | | | | | | |
|*146 | TABLE ACCESS FULL | CONSIGNMENT | 107 | 29639 | | 27252 (59)| | |
|*147 | FILTER | | | | | | | |
| 148 | REMOTE | | 362 | 107K| | | ENCTS~ | R->S |
| 149 | VIEW | | 697K| 19M| | | | |
| 150 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 151 | UNION-ALL | | | | | | | |
| 152 | INLIST ITERATOR | | | | | | | |
| 153 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*154 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 155 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 156 | VIEW | | 1020K| 503M| | | | |
| 157 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 158 | UNION-ALL | | | | | | | |
| 159 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
| 160 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 161 | SORT GROUP BY | | 17G| 9426G| | 574M(100)| | |
|*162 | HASH JOIN | | 17G| 9426G| 132M| 302K (52)| | |
| 163 | VIEW | STATISTICS_CONSIGNMENT | 1689K| 112M| | | | |
|*164 | FILTER | | | | | | | |
| 165 | SORT GROUP BY | | 1689K| 301M| | 154K (52)| | |
|*166 | HASH JOIN | | 1689K| 301M| | 120K (38)| | |
| 167 | VIEW | | 242 | 38236 | | | | |
| 168 | SORT UNIQUE | | 242 | 73541 | | 3837 (86)| | |
| 169 | UNION-ALL | | | | | | | |
|*170 | FILTER | | | | | | | |
|*171 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT | 1 | 277 | | 821 (34)| | |
|*172 | INDEX RANGE SCAN | IND_CONS_STATE_AT_DEP | 7783 | | | 39 (70)| | |
|*173 | FILTER | | | | | | | |
| 174 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 175 | VIEW | | 697K| 19M| | | | |
| 176 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 177 | UNION-ALL | | | | | | | |
| 178 | INLIST ITERATOR | | | | | | | |
| 179 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*180 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 181 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 182 | VIEW | | 1020K| 503M| | | | |
| 183 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 184 | UNION-ALL | | | | | | | |
| 185 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
| 186 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 187 | SORT GROUP BY | | 17G| 9435G| | 584M(100)| | |
|*188 | HASH JOIN | | 17G| 9435G| 119M| 301K (52)| | |
| 189 | VIEW | STATISTICS_CONSIGNMENT | 1717K| 99M| | | | |
|*190 | FILTER | | | | | | | |
| 191 | SORT GROUP BY | | 1717K| 306M| | 153K (52)| | |
|*192 | HASH JOIN | | 1717K| 306M| | 119K (37)| | |
| 193 | VIEW | | 246 | 38868 | | | | |
| 194 | SORT UNIQUE | | 246 | 74649 | | 2652 (99)| | |
| 195 | UNION-ALL | | | | | | | |
|*196 | FILTER | | | | | | | |
|*197 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT | 5 | 1385 | | 54 (34)| | |
|*198 | INDEX RANGE SCAN | IND_CONS_STATE_AT_DEP | 473 | | | 5 (40)| | |
|*199 | FILTER | | | | | | | |
| 200 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 201 | VIEW | | 697K| 19M| | | | |
| 202 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 203 | UNION-ALL | | | | | | | |
| 204 | INLIST ITERATOR | | | | | | | |
| 205 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*206 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 207 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 208 | VIEW | | 1020K| 503M| | | | |
| 209 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 210 | UNION-ALL | | | | | | | |
| 211 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
| 212 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 213 | SORT GROUP BY | | 10G| 8346G| | 356M(100)| | |
|*214 | HASH JOIN | | 10G| 8346G| 17M| 1722K (88)| | |
| 215 | VIEW | | 22874 | 16M| | | | |
| 216 | SORT UNIQUE | | 22874 | 4042K| 12M| 24892 (72)| | |
| 217 | UNION-ALL | | | | | | | |
|*218 | FILTER | | | | | | | |
|*219 | TABLE ACCESS FULL | DECLARATION | 69 | 11592 | | 20428 (66)| | |
|*220 | FILTER | | | | | | | |
| 221 | REMOTE | | 22805 | 4030K| | | ENCTS~ | R->S |
| 222 | VIEW | STATISTICS_CONSIGNMENT | 47M| 2493M| | | | |
|*223 | FILTER | | | | | | | |
| 224 | SORT GROUP BY | | 47M| 8479M| | 1331K (94)| | |
|*225 | HASH JOIN | | 47M| 8479M| | 143K (40)| | |
| 226 | VIEW | | 6812 | 1051K| | | | |
| 227 | SORT UNIQUE | | 6812 | 1861K| 4888K| 27250 (58)| | |
| 228 | UNION-ALL | | | | | | | |
|*229 | TABLE ACCESS FULL | CONSIGNMENT | 6089 | 1647K| | 23954 (53)| | |
| 230 | REMOTE | | 723 | 214K| | | ENCTS~ | R->S |
| 231 | VIEW | | 697K| 19M| | | | |
| 232 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 233 | UNION-ALL | | | | | | | |
| 234 | INLIST ITERATOR | | | | | | | |
| 235 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*236 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 237 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 238 | SORT GROUP BY | | 6911M| 3874G| | 221M(100)| | |
|*239 | HASH JOIN | | 6911M| 3874G| 62M| 304K (50)| | |
| 240 | VIEW | STATISTICS_CONSIGNMENT | 677K| 54M| | | | |
|*241 | FILTER | | | | | | | |
| 242 | SORT GROUP BY | | 677K| 120M| | 162K (47)| | |
|*243 | HASH JOIN | | 677K| 120M| | 150K (43)| | |
| 244 | VIEW | | 97 | 15326 | | | | |
| 245 | SORT UNIQUE | | 97 | 28165 | | 33683 (67)| | |
| 246 | UNION-ALL | | | | | | | |
|*247 | FILTER | | | | | | | |
|*248 | TABLE ACCESS FULL | CONSIGNMENT | 49 | 13573 | | 30212 (63)| | |
|*249 | FILTER | | | | | | | |
| 250 | REMOTE | | 48 | 14592 | | | ENCTS~ | R->S |
| 251 | VIEW | | 697K| 19M| | | | |
| 252 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 253 | UNION-ALL | | | | | | | |
| 254 | INLIST ITERATOR | | | | | | | |
| 255 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*256 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 257 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 258 | VIEW | | 1020K| 503M| | | | |
| 259 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 260 | UNION-ALL | | | | | | | |
| 261 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
| 262 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 263 | SORT GROUP BY | | 383G| 209T| | 14G(100)| | |
|*264 | HASH JOIN | | 383G| 209T| 515M| 1556K (82)| | |
| 265 | VIEW | | 1020K| 503M| | | | |
| 266 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 267 | UNION-ALL | | | | | | | |
| 268 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
| 269 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 270 | VIEW | STATISTICS_CONSIGNMENT | 37M| 3042M| | | | |
|*271 | FILTER | | | | | | | |
| 272 | SORT GROUP BY | | 37M| 6694M| | 1077K (92)| | |
|*273 | HASH JOIN | | 37M| 6694M| | 152K (44)| | |
| 274 | VIEW | | 5378 | 829K| | | | |
| 275 | SORT UNIQUE | | 5378 | 1456K| 4280K| 36115 (68)| | |
| 276 | UNION-ALL | | | | | | | |
|*277 | FILTER | | | | | | | |
|*278 | TABLE ACCESS FULL | CONSIGNMENT | 5330 | 1441K| | 32163 (65)| | |
|*279 | FILTER | | | | | | | |
| 280 | REMOTE | | 48 | 14592 | | | ENCTS~ | R->S |
| 281 | VIEW | | 697K| 19M| | | | |
| 282 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 283 | UNION-ALL | | | | | | | |
| 284 | INLIST ITERATOR | | | | | | | |
| 285 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*286 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 287 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 288 | SORT GROUP BY | | 3491M| 1957G| | 108M(100)| | |
|*289 | HASH JOIN | | 3491M| 1957G| 31M| 295K (49)| | |
| 290 | VIEW | STATISTICS_CONSIGNMENT | 342K| 27M| | | | |
|*291 | FILTER | | | | | | | |
| 292 | SORT GROUP BY | | 342K| 60M| | 156K (45)| | |
|*293 | HASH JOIN | | 342K| 60M| | 150K (43)| | |
| 294 | VIEW | | 49 | 7742 | | | | |
| 295 | SORT UNIQUE | | 49 | 14869 | | 33658 (67)| | |
| 296 | UNION-ALL | | | | | | | |
|*297 | FILTER | | | | | | | |
|*298 | TABLE ACCESS FULL | CONSIGNMENT | 1 | 277 | | 30187 (63)| | |
|*299 | FILTER | | | | | | | |
| 300 | REMOTE | | 48 | 14592 | | | ENCTS~ | R->S |
| 301 | VIEW | | 697K| 19M| | | | |
| 302 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 303 | UNION-ALL | | | | | | | |
| 304 | INLIST ITERATOR | | | | | | | |
| 305 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*306 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 307 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 308 | VIEW | | 1020K| 503M| | | | |
| 309 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 310 | UNION-ALL | | | | | | | |
| 311 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
| 312 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 313 | SORT GROUP BY | | 5058M| 2836G| | 160M(100)| | |
|*314 | HASH JOIN | | 5058M| 2836G| 45M| 299K (49)| | |
| 315 | VIEW | STATISTICS_CONSIGNMENT | 495K| 40M| | | | |
|*316 | FILTER | | | | | | | |
| 317 | SORT GROUP BY | | 495K| 88M| | 159K (46)| | |
|*318 | HASH JOIN | | 495K| 88M| | 150K (43)| | |
| 319 | VIEW | | 71 | 11218 | | | | |
| 320 | SORT UNIQUE | | 71 | 20963 | | 33670 (67)| | |
| 321 | UNION-ALL | | | | | | | |
|*322 | FILTER | | | | | | | |
|*323 | TABLE ACCESS FULL | CONSIGNMENT | 23 | 6371 | | 30199 (63)| | |
|*324 | FILTER | | | | | | | |
| 325 | REMOTE | | 48 | 14592 | | | ENCTS~ | R->S |
| 326 | VIEW | | 697K| 19M| | | | |
| 327 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 328 | UNION-ALL | | | | | | | |
| 329 | INLIST ITERATOR | | | | | | | |
| 330 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*331 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 332 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 333 | VIEW | | 1020K| 503M| | | | |
| 334 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 335 | UNION-ALL | | | | | | | |
| 336 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
| 337 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 338 | SORT GROUP BY | | 11G| 6631G| | 388M(100)| | |
|*339 | HASH JOIN | | 11G| 6631G| 107M| 318K (51)| | |
| 340 | VIEW | STATISTICS_CONSIGNMENT | 1158K| 93M| | | | |
|*341 | FILTER | | | | | | | |
| 342 | SORT GROUP BY | | 1158K| 206M| | 173K (51)| | |
|*343 | HASH JOIN | | 1158K| 206M| | 150K (43)| | |
| 344 | VIEW | | 166 | 26228 | | | | |
| 345 | SORT UNIQUE | | 166 | 47278 | | 33719 (67)| | |
| 346 | UNION-ALL | | | | | | | |
|*347 | FILTER | | | | | | | |
|*348 | TABLE ACCESS FULL | CONSIGNMENT | 118 | 32686 | | 30248 (63)| | |
|*349 | FILTER | | | | | | | |
| 350 | REMOTE | | 48 | 14592 | | | ENCTS~ | R->S |
| 351 | VIEW | | 697K| 19M| | | | |
| 352 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 353 | UNION-ALL | | | | | | | |
| 354 | INLIST ITERATOR | | | | | | | |
| 355 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*356 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 357 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 358 | VIEW | | 1020K| 503M| | | | |
| 359 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 360 | UNION-ALL | | | | | | | |
| 361 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
| 362 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 363 | SORT GROUP BY | | 12G| 7110G| | 417M(100)| | |
|*364 | HASH JOIN | | 12G| 7110G| 114M| 320K (52)| | |
| 365 | VIEW | STATISTICS_CONSIGNMENT | 1242K| 100M| | | | |
|*366 | FILTER | | | | | | | |
| 367 | SORT GROUP BY | | 1242K| 221M| | 174K (51)| | |
|*368 | HASH JOIN | | 1242K| 221M| | 150K (43)| | |
| 369 | VIEW | | 178 | 28124 | | | | |
| 370 | SORT UNIQUE | | 178 | 50602 | | 33726 (67)| | |
| 371 | UNION-ALL | | | | | | | |
|*372 | FILTER | | | | | | | |
|*373 | TABLE ACCESS FULL | CONSIGNMENT | 130 | 36010 | | 30254 (63)| | |
|*374 | FILTER | | | | | | | |
| 375 | REMOTE | | 48 | 14592 | | | ENCTS~ | R->S |
| 376 | VIEW | | 697K| 19M| | | | |
| 377 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 378 | UNION-ALL | | | | | | | |
| 379 | INLIST ITERATOR | | | | | | | |
| 380 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*381 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 382 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 383 | VIEW | | 1020K| 503M| | | | |
| 384 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 385 | UNION-ALL | | | | | | | |
| 386 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
| 387 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 388 | SORT GROUP BY | | 13G| 10T| | 441M(100)| | |
|*389 | HASH JOIN | | 13G| 10T| 464M| 1392K (88)| | |
| 390 | MERGE JOIN | | 1308K| 449M| | 1227K (93)| | |
| 391 | SORT JOIN | | 43M| 3950M| | 1227K (93)| | |
| 392 | VIEW | STATISTICS_CONSIGNMENT | 43M| 3950M| | | | |
|*393 | FILTER | | | | | | | |
| 394 | SORT GROUP BY | | 43M| 7776M| | 1227K (93)| | |
|*395 | HASH JOIN | | 43M| 7776M| | 143K (40)| | |
| 396 | VIEW | | 6247 | 963K| | | | |
| 397 | SORT UNIQUE | | 6247 | 1696K| 4824K| 27082 (58)| | |
| 398 | UNION-ALL | | | | | | | |
|*399 | TABLE ACCESS FULL | CONSIGNMENT | 6006 | 1624K| | 23942 (53)| | |
| 400 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 401 | VIEW | | 697K| 19M| | | | |
| 402 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 403 | UNION-ALL | | | | | | | |
| 404 | INLIST ITERATOR | | | | | | | |
| 405 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*406 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 407 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|*408 | SORT JOIN | | 3 | 795 | | 9 (45)| | |
| 409 | VIEW | | 3 | 795 | | | | |
| 410 | SORT UNIQUE | | 3 | 179 | | 9 (67)| | |
| 411 | UNION-ALL | | | | | | | |
| 412 | TABLE ACCESS FULL | RECOVERY | 2 | 148 | | 4 (25)| | |
| 413 | REMOTE | | 1 | 31 | | | ENCTS~ | R->S |
| 414 | VIEW | | 1020K| 503M| | | | |
| 415 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 416 | UNION-ALL | | | | | | | |
|*417 | FILTER | | | | | | | |
| 418 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|*419 | FILTER | | | | | | | |
| 420 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 421 | SORT GROUP BY | | 8902M| 7271G| | 289M(100)| | |
|*422 | HASH JOIN | | 8902M| 7271G| 309M| 1382K (89)| | |
| 423 | MERGE JOIN | | 872K| 299M| | 1227K (93)| | |
| 424 | SORT JOIN | | 43M| 3950M| | 1227K (93)| | |
| 425 | VIEW | STATISTICS_CONSIGNMENT | 43M| 3950M| | | | |
|*426 | FILTER | | | | | | | |
| 427 | SORT GROUP BY | | 43M| 7776M| | 1227K (93)| | |
|*428 | HASH JOIN | | 43M| 7776M| | 143K (40)| | |
| 429 | VIEW | | 6247 | 963K| | | | |
| 430 | SORT UNIQUE | | 6247 | 1696K| 4824K| 27082 (58)| | |
| 431 | UNION-ALL | | | | | | | |
|*432 | TABLE ACCESS FULL | CONSIGNMENT | 6006 | 1624K| | 23942 (53)| | |
| 433 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 434 | VIEW | | 697K| 19M| | | | |
| 435 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 436 | UNION-ALL | | | | | | | |
| 437 | INLIST ITERATOR | | | | | | | |
| 438 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*439 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 440 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|*441 | SORT JOIN | | 2 | 530 | | 9 (45)| | |
| 442 | VIEW | | 2 | 530 | | | | |
| 443 | SORT UNIQUE | | 2 | 105 | | 9 (67)| | |
| 444 | UNION-ALL | | | | | | | |
|*445 | TABLE ACCESS FULL | RECOVERY | 1 | 74 | | 4 (25)| | |
| 446 | REMOTE | | 1 | 31 | | | ENCTS~ | R->S |
| 447 | VIEW | | 1020K| 503M| | | | |
| 448 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 449 | UNION-ALL | | | | | | | |
|*450 | FILTER | | | | | | | |
| 451 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|*452 | FILTER | | | | | | | |
| 453 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 454 | SORT GROUP BY | | 8902M| 7271G| | 289M(100)| | |
|*455 | HASH JOIN | | 8902M| 7271G| 309M| 1382K (89)| | |
| 456 | MERGE JOIN | | 872K| 299M| | 1227K (93)| | |
| 457 | SORT JOIN | | 43M| 3950M| | 1227K (93)| | |
| 458 | VIEW | STATISTICS_CONSIGNMENT | 43M| 3950M| | | | |
|*459 | FILTER | | | | | | | |
| 460 | SORT GROUP BY | | 43M| 7776M| | 1227K (93)| | |
|*461 | HASH JOIN | | 43M| 7776M| | 143K (40)| | |
| 462 | VIEW | | 6247 | 963K| | | | |
| 463 | SORT UNIQUE | | 6247 | 1696K| 4824K| 27082 (58)| | |
| 464 | UNION-ALL | | | | | | | |
|*465 | TABLE ACCESS FULL | CONSIGNMENT | 6006 | 1624K| | 23942 (53)| | |
| 466 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 467 | VIEW | | 697K| 19M| | | | |
| 468 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 469 | UNION-ALL | | | | | | | |
| 470 | INLIST ITERATOR | | | | | | | |
| 471 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*472 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 473 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|*474 | SORT JOIN | | 2 | 530 | | 9 (45)| | |
| 475 | VIEW | | 2 | 530 | | | | |
| 476 | SORT UNIQUE | | 2 | 105 | | 9 (67)| | |
| 477 | UNION-ALL | | | | | | | |
|*478 | TABLE ACCESS FULL | RECOVERY | 1 | 74 | | 4 (25)| | |
| 479 | REMOTE | | 1 | 31 | | | ENCTS~ | R->S |
| 480 | VIEW | | 1020K| 503M| | | | |
| 481 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 482 | UNION-ALL | | | | | | | |
|*483 | FILTER | | | | | | | |
| 484 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|*485 | FILTER | | | | | | | |
| 486 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 487 | SORT GROUP BY | | 8902M| 7271G| | 289M(100)| | |
|*488 | HASH JOIN | | 8902M| 7271G| 309M| 1382K (89)| | |
| 489 | MERGE JOIN | | 872K| 299M| | 1227K (93)| | |
| 490 | SORT JOIN | | 43M| 3950M| | 1227K (93)| | |
| 491 | VIEW | STATISTICS_CONSIGNMENT | 43M| 3950M| | | | |
|*492 | FILTER | | | | | | | |
| 493 | SORT GROUP BY | | 43M| 7776M| | 1227K (93)| | |
|*494 | HASH JOIN | | 43M| 7776M| | 143K (40)| | |
| 495 | VIEW | | 6247 | 963K| | | | |
| 496 | SORT UNIQUE | | 6247 | 1696K| 4824K| 27082 (58)| | |
| 497 | UNION-ALL | | | | | | | |
|*498 | TABLE ACCESS FULL | CONSIGNMENT | 6006 | 1624K| | 23942 (53)| | |
| 499 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 500 | VIEW | | 697K| 19M| | | | |
| 501 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 502 | UNION-ALL | | | | | | | |
| 503 | INLIST ITERATOR | | | | | | | |
| 504 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*505 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 506 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|*507 | SORT JOIN | | 2 | 530 | | 9 (45)| | |
| 508 | VIEW | | 2 | 530 | | | | |
| 509 | SORT UNIQUE | | 2 | 105 | | 9 (67)| | |
| 510 | UNION-ALL | | | | | | | |
|*511 | TABLE ACCESS FULL | RECOVERY | 1 | 74 | | 4 (25)| | |
| 512 | REMOTE | | 1 | 31 | | | ENCTS~ | R->S |
| 513 | VIEW | | 1020K| 503M| | | | |
| 514 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 515 | UNION-ALL | | | | | | | |
|*516 | FILTER | | | | | | | |
| 517 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|*518 | FILTER | | | | | | | |
| 519 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 520 | SORT GROUP BY | | 36G| 21T| | 1272M(100)| | |
|*521 | HASH JOIN | | 36G| 21T| | 3821K (98)| | |
| 522 | VIEW | | 3316 | 110K| | | | |
| 523 | SORT UNIQUE | | 3316 | 92432 | | 2801 (37)| | |
| 524 | UNION-ALL | | | | | | | |
| 525 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 2539 | 66014 | | 2095 (15)| | |
|*526 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 2539 | | | 20 (65)| | |
| 527 | REMOTE | | 777 | 26418 | | | ENCTS~ | R->S |
|*528 | HASH JOIN | | 1112M| 632G| | 1398K (94)| | |
| 529 | VIEW | | 2552 | 1310K| | | | |
| 530 | SORT UNIQUE | | 2552 | 422K| | 76216 (91)| | |
| 531 | UNION-ALL | | | | | | | |
|*532 | FILTER | | | | | | | |
|*533 | TABLE ACCESS FULL | DECLARATION | 2267 | 371K| | 67606 (90)| | |
|*534 | FILTER | | | | | | | |
| 535 | REMOTE | | 285 | 51585 | | | ENCTS~ | R->S |
| 536 | VIEW | STATISTICS_CONSIGNMENT | 43M| 3492M| | | | |
| 537 | SORT GROUP BY | | 43M| 7776M| | 1227K (93)| | |
|*538 | HASH JOIN | | 43M| 7776M| | 143K (40)| | |
| 539 | VIEW | | 6247 | 963K| | | | |
| 540 | SORT UNIQUE | | 6247 | 1696K| 4824K| 27082 (58)| | |
| 541 | UNION-ALL | | | | | | | |
|*542 | TABLE ACCESS FULL | CONSIGNMENT | 6006 | 1624K| | 23942 (53)| | |
| 543 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 544 | VIEW | | 697K| 19M| | | | |
| 545 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 546 | UNION-ALL | | | | | | | |
| 547 | INLIST ITERATOR | | | | | | | |
| 548 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*549 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 550 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 551 | SORT GROUP BY | | 17G| 10T| | 572M(100)| | |
|*552 | HASH JOIN | | 17G| 10T| | 2856K (97)| | |
| 553 | VIEW | | 2552 | 1310K| | | | |
| 554 | SORT UNIQUE | | 2552 | 422K| | 76216 (91)| | |
| 555 | UNION-ALL | | | | | | | |
|*556 | FILTER | | | | | | | |
|*557 | TABLE ACCESS FULL | DECLARATION | 2267 | 371K| | 67606 (90)| | |
|*558 | FILTER | | | | | | | |
| 559 | REMOTE | | 285 | 51585 | | | ENCTS~ | R->S |
|*560 | HASH JOIN | | 669M| 73G| | 1323K (94)| | |
| 561 | VIEW | | 1536 | 52224 | | | | |
| 562 | SORT UNIQUE | | 1536 | 46152 | | 1314 (60)| | |
| 563 | UNION-ALL | | | | | | | |
| 564 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 759 | 19734 | | 629 (15)| | |
|*565 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 759 | | | 8 (50)| | |
| 566 | REMOTE | | 777 | 26418 | | | ENCTS~ | R->S |
| 567 | VIEW | STATISTICS_CONSIGNMENT | 43M| 3492M| | | | |
| 568 | SORT GROUP BY | | 43M| 7776M| | 1227K (93)| | |
|*569 | HASH JOIN | | 43M| 7776M| | 143K (40)| | |
| 570 | VIEW | | 6247 | 963K| | | | |
| 571 | SORT UNIQUE | | 6247 | 1696K| 4824K| 27082 (58)| | |
| 572 | UNION-ALL | | | | | | | |
|*573 | TABLE ACCESS FULL | CONSIGNMENT | 6006 | 1624K| | 23942 (53)| | |
| 574 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 575 | VIEW | | 697K| 19M| | | | |
| 576 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 577 | UNION-ALL | | | | | | | |
| 578 | INLIST ITERATOR | | | | | | | |
| 579 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*580 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 581 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 582 | SORT GROUP BY | | 35G| 37T| | 1228M(100)| | |
|*583 | HASH JOIN | | 35G| 37T| 447M| 352K (51)| | |
|*584 | HASH JOIN | | 3503K| 407M| | 155K (55)| | |
| 585 | VIEW | | 467 | 26152 | | | | |
| 586 | SORT UNIQUE | | 467 | 16246 | | 711 (25)| | |
| 587 | UNION-ALL | | | | | | | |
|*588 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 381 | 11430 | | 629 (15)| | |
|*589 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 759 | | | 8 (50)| | |
| 590 | REMOTE | | 86 | 4816 | | | ENCTS~ | R->S |
|*591 | HASH JOIN | | 750K| 47M| | 153K (54)| | |
| 592 | VIEW | | 78 | 2262 | | | | |
| 593 | SORT UNIQUE | | 78 | 4212 | | 11361 (99)| | |
| 594 | UNION-ALL | | | | | | | |
|*595 | FILTER | | | | | | | |
|*596 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 4 | 216 | | 199 (21)| | |
|*597 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 1510 | | | 15 (54)| | |
|*598 | FILTER | | | | | | | |
| 599 | REMOTE | | 74 | 3996 | | | ENCTS~ | R->S |
| 600 | VIEW | | 961K| 33M| | | | |
| 601 | SORT UNIQUE | | 961K| 256M| 755M| 140K (57)| | |
| 602 | UNION-ALL | | | | | | | |
| 603 | TABLE ACCESS FULL | CONSIGNMENT | 865K| 228M| | 41666 (73)| | |
| 604 | REMOTE | | 96406 | 27M| | | ENCTS~ | R->S |
| 605 | VIEW | | 1020K| 993M| | | | |
| 606 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 607 | UNION-ALL | | | | | | | |
|*608 | FILTER | | | | | | | |
| 609 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|*610 | FILTER | | | | | | | |
| 611 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 612 | SORT GROUP BY | | 10G| 6220G| | 340M(100)| | |
|*613 | HASH JOIN | | 10G| 6220G| | 2283K (96)| | |
| 614 | VIEW | | 2552 | 1310K| | | | |
| 615 | SORT UNIQUE | | 2552 | 422K| | 76216 (91)| | |
| 616 | UNION-ALL | | | | | | | |
|*617 | FILTER | | | | | | | |
|*618 | TABLE ACCESS FULL | DECLARATION | 2267 | 371K| | 67606 (90)| | |
|*619 | FILTER | | | | | | | |
| 620 | REMOTE | | 285 | 51585 | | | ENCTS~ | R->S |
|*621 | HASH JOIN | | 406M| 44G| | 1323K (94)| | |
| 622 | VIEW | | 932 | 31688 | | | | |
| 623 | SORT UNIQUE | | 932 | 30448 | | 810 (87)| | |
| 624 | UNION-ALL | | | | | | | |
| 625 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 155 | 4030 | | 131 (15)| | |
|*626 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 155 | | | 5 (40)| | |
| 627 | REMOTE | | 777 | 26418 | | | ENCTS~ | R->S |
| 628 | VIEW | STATISTICS_CONSIGNMENT | 43M| 3492M| | | | |
| 629 | SORT GROUP BY | | 43M| 7776M| | 1227K (93)| | |
|*630 | HASH JOIN | | 43M| 7776M| | 143K (40)| | |
| 631 | VIEW | | 6247 | 963K| | | | |
| 632 | SORT UNIQUE | | 6247 | 1696K| 4824K| 27082 (58)| | |
| 633 | UNION-ALL | | | | | | | |
|*634 | TABLE ACCESS FULL | CONSIGNMENT | 6006 | 1624K| | 23942 (53)| | |
| 635 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 636 | VIEW | | 697K| 19M| | | | |
| 637 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 638 | UNION-ALL | | | | | | | |
| 639 | INLIST ITERATOR | | | | | | | |
| 640 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*641 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 642 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 643 | SORT GROUP BY | | 445G| 246T| | 16G(100)| | |
|*644 | FILTER | | | | | | | |
|*645 | HASH JOIN | | 445G| 246T| 515M| 1779K (82)| | |
| 646 | VIEW | | 1020K| 503M| | | | |
| 647 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 648 | UNION-ALL | | | | | | | |
|*649 | FILTER | | | | | | | |
| 650 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|*651 | FILTER | | | | | | | |
| 652 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 653 | VIEW | STATISTICS_CONSIGNMENT | 43M| 3867M| | | | |
|*654 | FILTER | | | | | | | |
| 655 | SORT GROUP BY | | 43M| 7776M| | 1227K (93)| | |
|*656 | HASH JOIN | | 43M| 7776M| | 143K (40)| | |
| 657 | VIEW | | 6247 | 963K| | | | |
| 658 | SORT UNIQUE | | 6247 | 1696K| 4824K| 27082 (58)| | |
| 659 | UNION-ALL | | | | | | | |
|*660 | TABLE ACCESS FULL | CONSIGNMENT | 6006 | 1624K| | 23942 (53)| | |
| 661 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 662 | VIEW | | 697K| 19M| | | | |
| 663 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 664 | UNION-ALL | | | | | | | |
| 665 | INLIST ITERATOR | | | | | | | |
| 666 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*667 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 668 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 669 | SORT UNIQUE | | 4197K| 47 | 32M| 116K (91)| | |
| 670 | UNION-ALL | | | | | | | |
| 671 | INDEX FAST FULL SCAN | SYS_C003591 | 4197K| | | 15582 (81)| | |
| 672 | REMOTE | | 1 | 47 | | | ENCTS~ | R->S |
| 673 | SORT GROUP BY | | 22G| 12T| | 748M(100)| | |
|*674 | HASH JOIN | | 22G| 12T| 195M| 351K (55)| | |
| 675 | VIEW | STATISTICS_CONSIGNMENT | 2177K| 170M| | | | |
|*676 | FILTER | | | | | | | |
| 677 | SORT GROUP BY | | 2177K| 388M| | 198K (57)| | |
|*678 | HASH JOIN | | 2177K| 388M| | 153K (44)| | |
| 679 | VIEW | | 312 | 49296 | | | | |
| 680 | SORT UNIQUE | | 312 | 86748 | | 36892 (70)| | |
| 681 | UNION-ALL | | | | | | | |
|*682 | TABLE ACCESS FULL | CONSIGNMENT | 300 | 83100 | | 33249 (67)| | |
| 683 | REMOTE | | 12 | 3648 | | | ENCTS~ | R->S |
| 684 | VIEW | | 697K| 19M| | | | |
| 685 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 686 | UNION-ALL | | | | | | | |
| 687 | INLIST ITERATOR | | | | | | | |
| 688 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*689 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 690 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 691 | VIEW | | 1020K| 503M| | | | |
| 692 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 693 | UNION-ALL | | | | | | | |
|*694 | FILTER | | | | | | | |
| 695 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|*696 | FILTER | | | | | | | |
| 697 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 698 | SORT GROUP BY | | 4417M| 2464G| | 138M(100)| | |
|*699 | HASH JOIN | | 4417M| 2464G| 38M| 300K (50)| | |
| 700 | VIEW | STATISTICS_CONSIGNMENT | 432K| 33M| | | | |
|*701 | FILTER | | | | | | | |
| 702 | SORT GROUP BY | | 432K| 77M| | 161K (47)| | |
|*703 | HASH JOIN | | 432K| 77M| | 153K (44)| | |
| 704 | VIEW | | 62 | 9796 | | | | |
| 705 | SORT UNIQUE | | 62 | 17228 | | 36885 (70)| | |
| 706 | UNION-ALL | | | | | | | |
|*707 | TABLE ACCESS FULL | CONSIGNMENT | 60 | 16620 | | 33246 (67)| | |
| 708 | REMOTE | | 2 | 608 | | | ENCTS~ | R->S |
| 709 | VIEW | | 697K| 19M| | | | |
| 710 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 711 | UNION-ALL | | | | | | | |
| 712 | INLIST ITERATOR | | | | | | | |
| 713 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*714 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 715 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 716 | VIEW | | 1020K| 503M| | | | |
| 717 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 718 | UNION-ALL | | | | | | | |
|*719 | FILTER | | | | | | | |
| 720 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|*721 | FILTER | | | | | | | |
| 722 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 723 | SORT GROUP BY | | 1086G| 868T| | 42G(100)| | |
|*724 | HASH JOIN | | 1086G| 868T| 515M| 3803K (56)| | |
| 725 | VIEW | | 1020K| 503M| | | | |
| 726 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
| 727 | UNION-ALL | | | | | | | |
|*728 | FILTER | | | | | | | |
| 729 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|*730 | FILTER | | | | | | | |
| 731 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
| 732 | MERGE JOIN | | 106M| 35G| | 1228K (93)| | |
| 733 | SORT JOIN | | 43M| 3950M| | 1227K (93)| | |
| 734 | VIEW | STATISTICS_CONSIGNMENT | 43M| 3950M| | | | |
|*735 | FILTER | | | | | | | |
| 736 | SORT GROUP BY | | 43M| 7776M| | 1227K (93)| | |
|*737 | HASH JOIN | | 43M| 7776M| | 143K (40)| | |
| 738 | VIEW | | 6247 | 963K| | | | |
| 739 | SORT UNIQUE | | 6247 | 1696K| 4824K| 27082 (58)| | |
| 740 | UNION-ALL | | | | | | | |
|*741 | TABLE ACCESS FULL | CONSIGNMENT | 6006 | 1624K| | 23942 (53)| | |
| 742 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
| 743 | VIEW | | 697K| 19M| | | | |
| 744 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 745 | UNION-ALL | | | | | | | |
| 746 | INLIST ITERATOR | | | | | | | |
| 747 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*748 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 749 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|*750 | SORT JOIN | | 244 | 65148 | | 819 (93)| | |
| 751 | VIEW | | 244 | 65148 | | | | |
| 752 | SORT UNIQUE | | 244 | 3954 | | 817 (94)| | |
| 753 | UNION-ALL | | | | | | | |
|*754 | TABLE ACCESS FULL | DIVERSION | 10 | 210 | | 706 (92)| | |
| 755 | REMOTE | | 234 | 3744 | | | ENCTS~ | R->S |
| 756 | SORT GROUP BY | | 4853M| 3629G| | 154M(100)| | |
|*757 | HASH JOIN | | 4853M| 3629G| 7792K| 1686K (90)| | |
| 758 | VIEW | | 10208 | 7665K| | | | |
| 759 | SORT UNIQUE | | 10208 | 1689K| 4856K| 38746 (82)| | |
| 760 | UNION-ALL | | | | | | | |
|*761 | FILTER | | | | | | | |
|*762 | TABLE ACCESS FULL | DECLARATION | 9068 | 1487K| | 33842 (80)| | |
|*763 | FILTER | | | | | | | |
| 764 | REMOTE | | 1140 | 201K| | | ENCTS~ | R->S |
| 765 | VIEW | STATISTICS_CONSIGNMENT | 47M| 1541M| | | | |
|*766 | FILTER | | | | | | | |
| 767 | SORT GROUP BY | | 47M| 8479M| | 1331K (94)| | |
|*768 | HASH JOIN | | 47M| 8479M| | 143K (40)| | |
| 769 | VIEW | | 6812 | 1051K| | | | |
| 770 | SORT UNIQUE | | 6812 | 1861K| 4888K| 27250 (58)| | |
| 771 | UNION-ALL | | | | | | | |
|*772 | TABLE ACCESS FULL | CONSIGNMENT | 6089 | 1647K| | 23954 (53)| | |
| 773 | REMOTE | | 723 | 214K| | | ENCTS~ | R->S |
| 774 | VIEW | | 697K| 19M| | | | |
| 775 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 776 | UNION-ALL | | | | | | | |
| 777 | INLIST ITERATOR | | | | | | | |
| 778 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*779 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 780 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 781 | SORT GROUP BY | | 4853M| 3629G| | 154M(100)| | |
|*782 | HASH JOIN | | 4853M| 3629G| 7792K| 1686K (90)| | |
| 783 | VIEW | | 10208 | 7665K| | | | |
| 784 | SORT UNIQUE | | 10208 | 1689K| 4856K| 38746 (82)| | |
| 785 | UNION-ALL | | | | | | | |
|*786 | FILTER | | | | | | | |
|*787 | TABLE ACCESS FULL | DECLARATION | 9068 | 1487K| | 33842 (80)| | |
|*788 | FILTER | | | | | | | |
| 789 | REMOTE | | 1140 | 201K| | | ENCTS~ | R->S |
| 790 | VIEW | STATISTICS_CONSIGNMENT | 47M| 1541M| | | | |
|*791 | FILTER | | | | | | | |
| 792 | SORT GROUP BY | | 47M| 8479M| | 1331K (94)| | |
|*793 | HASH JOIN | | 47M| 8479M| | 143K (40)| | |
| 794 | VIEW | | 6812 | 1051K| | | | |
| 795 | SORT UNIQUE | | 6812 | 1861K| 4888K| 27250 (58)| | |
| 796 | UNION-ALL | | | | | | | |
|*797 | TABLE ACCESS FULL | CONSIGNMENT | 6089 | 1647K| | 23954 (53)| | |
| 798 | REMOTE | | 723 | 214K| | | ENCTS~ | R->S |
| 799 | VIEW | | 697K| 19M| | | | |
| 800 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 801 | UNION-ALL | | | | | | | |
| 802 | INLIST ITERATOR | | | | | | | |
| 803 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*804 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 805 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 806 | SORT GROUP BY | | 4853M| 3629G| | 154M(100)| | |
|*807 | HASH JOIN | | 4853M| 3629G| 7792K| 1686K (90)| | |
| 808 | VIEW | | 10208 | 7665K| | | | |
| 809 | SORT UNIQUE | | 10208 | 1689K| 4856K| 38746 (82)| | |
| 810 | UNION-ALL | | | | | | | |
|*811 | FILTER | | | | | | | |
|*812 | TABLE ACCESS FULL | DECLARATION | 9068 | 1487K| | 33842 (80)| | |
|*813 | FILTER | | | | | | | |
| 814 | REMOTE | | 1140 | 201K| | | ENCTS~ | R->S |
| 815 | VIEW | STATISTICS_CONSIGNMENT | 47M| 1541M| | | | |
|*816 | FILTER | | | | | | | |
| 817 | SORT GROUP BY | | 47M| 8479M| | 1331K (94)| | |
|*818 | HASH JOIN | | 47M| 8479M| | 143K (40)| | |
| 819 | VIEW | | 6812 | 1051K| | | | |
| 820 | SORT UNIQUE | | 6812 | 1861K| 4888K| 27250 (58)| | |
| 821 | UNION-ALL | | | | | | | |
|*822 | TABLE ACCESS FULL | CONSIGNMENT | 6089 | 1647K| | 23954 (53)| | |
| 823 | REMOTE | | 723 | 214K| | | ENCTS~ | R->S |
| 824 | VIEW | | 697K| 19M| | | | |
| 825 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 826 | UNION-ALL | | | | | | | |
| 827 | INLIST ITERATOR | | | | | | | |
| 828 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*829 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 830 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 831 | SORT GROUP BY | | 225T| 189P| | 10T(100)| | |
|*832 | HASH JOIN | | 225T| 189P| 7792K| 32G (48)| | |
| 833 | VIEW | | 10208 | 7665K| | | | |
| 834 | SORT UNIQUE | | 10208 | 1689K| 4856K| 38746 (82)| | |
| 835 | UNION-ALL | | | | | | | |
|*836 | FILTER | | | | | | | |
|*837 | TABLE ACCESS FULL | DECLARATION | 9068 | 1487K| | 33842 (80)| | |
|*838 | FILTER | | | | | | | |
| 839 | REMOTE | | 1140 | 201K| | | ENCTS~ | R->S |
|*840 | HASH JOIN | | 2212G| 352T| 25M| 1870M (51)| | |
| 841 | VIEW | | 561K| 19M| | | | |
| 842 | SORT GROUP BY | | 561K| 23M| | 490K (19)| | |
| 843 | VIEW | | 561K| 23M| | | | |
| 844 | SORT UNIQUE | | 561K| 18M| 47M| 480K (17)| | |
| 845 | UNION-ALL | | | | | | | |
| 846 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 560K| 18M| | 462K (15)| | |
|*847 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 560K| | | 3529 (74)| | |
| 848 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|*849 | HASH JOIN | | 157G| 19T| 25M| 1609K (63)| | |
| 850 | VIEW | | 557K| 19M| | | | |
| 851 | SORT GROUP BY | | 557K| 22M| | 486K (19)| | |
| 852 | VIEW | | 557K| 22M| | | | |
| 853 | SORT UNIQUE | | 557K| 18M| 46M| 476K (17)| | |
| 854 | UNION-ALL | | | | | | | |
| 855 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 556K| 18M| | 458K (15)| | |
|*856 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 556K| | | 3500 (74)| | |
| 857 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
| 858 | VIEW | STATISTICS_CONSIGNMENT | 28M| 2779M| | | | |
|*859 | FILTER | | | | | | | |
| 860 | SORT GROUP BY | | 28M| 5046M| | 835K (90)| | |
|*861 | HASH JOIN | | 28M| 5046M| | 149K (42)| | |
| 862 | VIEW | | 4054 | 625K| | | | |
| 863 | SORT UNIQUE | | 4054 | 1099K| 3160K| 32666 (65)| | |
| 864 | UNION-ALL | | | | | | | |
|*865 | TABLE ACCESS FULL | CONSIGNMENT | 3933 | 1063K| | 29146 (62)| | |
| 866 | REMOTE | | 121 | 36784 | | | ENCTS~ | R->S |
| 867 | VIEW | | 697K| 19M| | | | |
| 868 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 869 | UNION-ALL | | | | | | | |
| 870 | INLIST ITERATOR | | | | | | | |
| 871 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*872 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 873 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 874 | SORT GROUP BY | | 225T| 189P| | 10T(100)| | |
|*875 | HASH JOIN | | 225T| 189P| 7792K| 32G (48)| | |
| 876 | VIEW | | 10208 | 7665K| | | | |
| 877 | SORT UNIQUE | | 10208 | 1689K| 4856K| 38746 (82)| | |
| 878 | UNION-ALL | | | | | | | |
|*879 | FILTER | | | | | | | |
|*880 | TABLE ACCESS FULL | DECLARATION | 9068 | 1487K| | 33842 (80)| | |
|*881 | FILTER | | | | | | | |
| 882 | REMOTE | | 1140 | 201K| | | ENCTS~ | R->S |
|*883 | HASH JOIN | | 2212G| 352T| 25M| 1870M (51)| | |
| 884 | VIEW | | 561K| 19M| | | | |
| 885 | SORT GROUP BY | | 561K| 23M| | 490K (19)| | |
| 886 | VIEW | | 561K| 23M| | | | |
| 887 | SORT UNIQUE | | 561K| 18M| 47M| 480K (17)| | |
| 888 | UNION-ALL | | | | | | | |
| 889 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 560K| 18M| | 462K (15)| | |
|*890 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 560K| | | 3529 (74)| | |
| 891 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|*892 | HASH JOIN | | 157G| 19T| 25M| 1609K (63)| | |
| 893 | VIEW | | 557K| 19M| | | | |
| 894 | SORT GROUP BY | | 557K| 22M| | 486K (19)| | |
| 895 | VIEW | | 557K| 22M| | | | |
| 896 | SORT UNIQUE | | 557K| 18M| 46M| 476K (17)| | |
| 897 | UNION-ALL | | | | | | | |
| 898 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 556K| 18M| | 458K (15)| | |
|*899 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 556K| | | 3500 (74)| | |
| 900 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
| 901 | VIEW | STATISTICS_CONSIGNMENT | 28M| 2779M| | | | |
|*902 | FILTER | | | | | | | |
| 903 | SORT GROUP BY | | 28M| 5046M| | 835K (90)| | |
|*904 | HASH JOIN | | 28M| 5046M| | 149K (42)| | |
| 905 | VIEW | | 4054 | 625K| | | | |
| 906 | SORT UNIQUE | | 4054 | 1099K| 3160K| 32666 (65)| | |
| 907 | UNION-ALL | | | | | | | |
|*908 | TABLE ACCESS FULL | CONSIGNMENT | 3933 | 1063K| | 29146 (62)| | |
| 909 | REMOTE | | 121 | 36784 | | | ENCTS~ | R->S |
| 910 | VIEW | | 697K| 19M| | | | |
| 911 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 912 | UNION-ALL | | | | | | | |
| 913 | INLIST ITERATOR | | | | | | | |
| 914 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*915 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 916 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 917 | SORT GROUP BY | | 225T| 189P| | 10T(100)| | |
|*918 | HASH JOIN | | 225T| 189P| 7792K| 32G (48)| | |
| 919 | VIEW | | 10208 | 7665K| | | | |
| 920 | SORT UNIQUE | | 10208 | 1689K| 4856K| 38746 (82)| | |
| 921 | UNION-ALL | | | | | | | |
|*922 | FILTER | | | | | | | |
|*923 | TABLE ACCESS FULL | DECLARATION | 9068 | 1487K| | 33842 (80)| | |
|*924 | FILTER | | | | | | | |
| 925 | REMOTE | | 1140 | 201K| | | ENCTS~ | R->S |
|*926 | HASH JOIN | | 2212G| 352T| 25M| 1870M (51)| | |
| 927 | VIEW | | 561K| 19M| | | | |
| 928 | SORT GROUP BY | | 561K| 23M| | 490K (19)| | |
| 929 | VIEW | | 561K| 23M| | | | |
| 930 | SORT UNIQUE | | 561K| 18M| 47M| 480K (17)| | |
| 931 | UNION-ALL | | | | | | | |
| 932 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 560K| 18M| | 462K (15)| | |
|*933 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 560K| | | 3529 (74)| | |
| 934 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|*935 | HASH JOIN | | 157G| 19T| 25M| 1609K (63)| | |
| 936 | VIEW | | 557K| 19M| | | | |
| 937 | SORT GROUP BY | | 557K| 22M| | 486K (19)| | |
| 938 | VIEW | | 557K| 22M| | | | |
| 939 | SORT UNIQUE | | 557K| 18M| 46M| 476K (17)| | |
| 940 | UNION-ALL | | | | | | | |
| 941 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 556K| 18M| | 458K (15)| | |
|*942 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 556K| | | 3500 (74)| | |
| 943 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
| 944 | VIEW | STATISTICS_CONSIGNMENT | 28M| 2779M| | | | |
|*945 | FILTER | | | | | | | |
| 946 | SORT GROUP BY | | 28M| 5046M| | 835K (90)| | |
|*947 | HASH JOIN | | 28M| 5046M| | 149K (42)| | |
| 948 | VIEW | | 4054 | 625K| | | | |
| 949 | SORT UNIQUE | | 4054 | 1099K| 3160K| 32666 (65)| | |
| 950 | UNION-ALL | | | | | | | |
|*951 | TABLE ACCESS FULL | CONSIGNMENT | 3933 | 1063K| | 29146 (62)| | |
| 952 | REMOTE | | 121 | 36784 | | | ENCTS~ | R->S |
| 953 | VIEW | | 697K| 19M| | | | |
| 954 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 955 | UNION-ALL | | | | | | | |
| 956 | INLIST ITERATOR | | | | | | | |
| 957 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|*958 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
| 959 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
| 960 | SORT GROUP BY | | 4517T| 3787P| | 230T(100)| | |
|*961 | HASH JOIN | | 4517T| 3787P| 7792K| 605G (47)| | |
| 962 | VIEW | | 10208 | 7665K| | | | |
| 963 | SORT UNIQUE | | 10208 | 1689K| 4856K| 38746 (82)| | |
| 964 | UNION-ALL | | | | | | | |
|*965 | FILTER | | | | | | | |
|*966 | TABLE ACCESS FULL | DECLARATION | 9068 | 1487K| | 33842 (80)| | |
|*967 | FILTER | | | | | | | |
| 968 | REMOTE | | 1140 | 201K| | | ENCTS~ | R->S |
|*969 | HASH JOIN | | 44T| 7043T| 25M| 1870M (51)| | |
| 970 | VIEW | | 561K| 19M| | | | |
| 971 | SORT GROUP BY | | 561K| 23M| | 490K (19)| | |
| 972 | VIEW | | 561K| 23M| | | | |
| 973 | SORT UNIQUE | | 561K| 18M| 47M| 480K (17)| | |
| 974 | UNION-ALL | | | | | | | |
| 975 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 560K| 18M| | 462K (15)| | |
|*976 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 560K| | | 3529 (74)| | |
| 977 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|*978 | HASH JOIN | | 157G| 19T| 25M| 1609K (63)| | |
| 979 | VIEW | | 557K| 19M| | | | |
| 980 | SORT GROUP BY | | 557K| 22M| | 486K (19)| | |
| 981 | VIEW | | 557K| 22M| | | | |
| 982 | SORT UNIQUE | | 557K| 18M| 46M| 476K (17)| | |
| 983 | UNION-ALL | | | | | | | |
| 984 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 556K| 18M| | 458K (15)| | |
|*985 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 556K| | | 3500 (74)| | |
| 986 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
| 987 | VIEW | STATISTICS_CONSIGNMENT | 28M| 2779M| | | | |
|*988 | FILTER | | | | | | | |
| 989 | SORT GROUP BY | | 28M| 5046M| | 835K (90)| | |
|*990 | HASH JOIN | | 28M| 5046M| | 149K (42)| | |
| 991 | VIEW | | 4054 | 625K| | | | |
| 992 | SORT UNIQUE | | 4054 | 1099K| 3160K| 32666 (65)| | |
| 993 | UNION-ALL | | | | | | | |
|*994 | TABLE ACCESS FULL | CONSIGNMENT | 3933 | 1063K| | 29146 (62)| | |
| 995 | REMOTE | | 121 | 36784 | | | ENCTS~ | R->S |
| 996 | VIEW | | 697K| 19M| | | | |
| 997 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
| 998 | UNION-ALL | | | | | | | |
| 999 | INLIST ITERATOR | | | | | | | |
|1000 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1001 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1002 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1003 | VIEW | STATISTICS_801_V | 9315P| 44677| | | | |
|1004 | UNION-ALL | | | | | | | |
|1005 | SORT GROUP BY | | 7652T| 4696P| | 395T(100)| | |
|1006 | HASH JOIN | | 7652T| 4696P| 515M| 11G (48)| | |
|1007 | VIEW | | 1020K| 503M| | | | |
|1008 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
|1009 | UNION-ALL | | | | | | | |
|1010 | FILTER | | | | | | | |
|1011 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|1012 | FILTER | | | | | | | |
|1013 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
|1014 | HASH JOIN | | 749G| 118T| 12M| 1296M (51)| | |
|1015 | VIEW | | 273K| 9610K| | | | |
|1016 | SORT GROUP BY | | 273K| 11M| | 238K (19)| | |
|1017 | VIEW | | 273K| 11M| | | | |
|1018 | SORT UNIQUE | | 273K| 9083K| 23M| 233K (17)| | |
|1019 | UNION-ALL | | | | | | | |
|1020 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 272K| 9051K| | 224K (15)| | |
|1021 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 272K| | | 1717 (74)| | |
|1022 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|1023 | HASH JOIN | | 109G| 13T| 12M| 1817K (75)| | |
|1024 | VIEW | | 266K| 9379K| | | | |
|1025 | SORT GROUP BY | | 266K| 10M| | 232K (19)| | |
|1026 | VIEW | | 266K| 10M| | | | |
|1027 | SORT UNIQUE | | 266K| 8865K| 22M| 227K (17)| | |
|1028 | UNION-ALL | | | | | | | |
|1029 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 266K| 8832K| | 219K (15)| | |
|1030 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 266K| | | 1676 (74)| | |
|1031 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|1032 | VIEW | STATISTICS_CONSIGNMENT | 41M| 3999M| | | | |
|1033 | FILTER | | | | | | | |
|1034 | SORT GROUP BY | | 41M| 7331M| | 1171K (93)| | |
|1035 | HASH JOIN | | 41M| 7331M| | 152K (44)| | |
|1036 | VIEW | | 5890 | 908K| | | | |
|1037 | SORT UNIQUE | | 5890 | 1599K| 4536K| 36190 (68)| | |
|1038 | UNION-ALL | | | | | | | |
|1039 | TABLE ACCESS FULL | CONSIGNMENT | 5649 | 1528K| | 32162 (65)| | |
|1040 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
|1041 | VIEW | | 697K| 19M| | | | |
|1042 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
|1043 | UNION-ALL | | | | | | | |
|1044 | INLIST ITERATOR | | | | | | | |
|1045 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1046 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1047 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1048 | SORT GROUP BY | | 9307P| 59107| | 574P(100)| | |
|1049 | HASH JOIN | | 9307P| 59107| 515M| 13T (45)| | |
|1050 | VIEW | | 1020K| 503M| | | | |
|1051 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
|1052 | UNION-ALL | | | | | | | |
|1053 | FILTER | | | | | | | |
|1054 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|1055 | FILTER | | | | | | | |
|1056 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
|1057 | MERGE JOIN | | 911T| 160P| | 1248K (88)| | |
|1058 | MERGE JOIN OUTER | | 91T| 13P| | 1135K (89)| | |
|1059 | MERGE JOIN | | 218G| 26T| | 1123K (90)| | |
|1060 | SORT JOIN | | 34M| 3444M| | 1005K (92)| | |
|1061 | VIEW | STATISTICS_CONSIGNMENT | 34M| 3444M| | | | |
|1062 | FILTER | | | | | | | |
|1063 | SORT GROUP BY | | 34M| 6192M| | 1005K (92)| | |
|1064 | HASH JOIN | | 34M| 6192M| | 153K (44)| | |
|1065 | VIEW | | 4975 | 767K| | | | |
|1066 | SORT UNIQUE | | 4975 | 1345K| 3992K| 37351 (70)| | |
|1067 | UNION-ALL | | | | | | | |
|1068 | TABLE ACCESS FULL | CONSIGNMENT | 4974 | 1345K| | 33292 (67)| | |
|1069 | REMOTE | | 1 | 304 | | | ENCTS~ | R->S |
|1070 | VIEW | | 697K| 19M| | | | |
|1071 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
|1072 | UNION-ALL | | | | | | | |
|1073 | INLIST ITERATOR | | | | | | | |
|1074 | TABLE ACCESS BY INDEX ROWID| CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1075 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1076 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1077 | SORT JOIN | | 630K| 17M| 48M| 117K (71)| | |
|1078 | VIEW | | 630K| 17M| | | | |
|1079 | SORT UNIQUE | | 630K| 32M| 92M| 98715 (73)| | |
|1080 | UNION-ALL | | | | | | | |
|1081 | TABLE ACCESS FULL | CONSIGNMENT_STATUS_HISTORY | 600K| 30M| | 66998 (72)| | |
|1082 | REMOTE | | 29607 | 1561K| | | ENCTS~ | R->S |
|1083 | SORT JOIN | | 41588 | 1177K| 3272K| 12813 (66)| | |
|1084 | VIEW | | 41588 | 1177K| | | | |
|1085 | SORT UNIQUE | | 41588 | 2193K| 4440K| 11755 (90)| | |
|1086 | UNION-ALL | | | | | | | |
|1087 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 11981 | 631K| | 1551 (21)| | |
|1088 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 11981 | | | 93 (63)| | |
|1089 | REMOTE | | 29607 | 1561K| | | ENCTS~ | R->S |
|1090 | FILTER | | | | | | | |
|1091 | SORT JOIN | | | | | | | |
|1092 | VIEW | | 400K| 13M| | | | |
|1093 | SORT UNIQUE | | 400K| 20M| 57M| 100K (77)| | |
|1094 | UNION-ALL | | | | | | | |
|1095 | TABLE ACCESS FULL | CONSIGNMENT_STATUS_HISTORY | 395K| 20M| | 75964 (75)| | |
|1096 | REMOTE | | 4935 | 260K| | | ENCTS~ | R->S |
|1097 | VIEW | STATISTICS_802_V | 9315P| 44677| | | | |
|1098 | UNION-ALL | | | | | | | |
|1099 | SORT GROUP BY | | 7652T| 4696P| | 395T(100)| | |
|1100 | HASH JOIN | | 7652T| 4696P| 515M| 11G (48)| | |
|1101 | VIEW | | 1020K| 503M| | | | |
|1102 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
|1103 | UNION-ALL | | | | | | | |
|1104 | FILTER | | | | | | | |
|1105 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|1106 | FILTER | | | | | | | |
|1107 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
|1108 | HASH JOIN | | 749G| 118T| 12M| 1296M (51)| | |
|1109 | VIEW | | 273K| 9610K| | | | |
|1110 | SORT GROUP BY | | 273K| 11M| | 238K (19)| | |
|1111 | VIEW | | 273K| 11M| | | | |
|1112 | SORT UNIQUE | | 273K| 9083K| 23M| 233K (17)| | |
|1113 | UNION-ALL | | | | | | | |
|1114 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 272K| 9051K| | 224K (15)| | |
|1115 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 272K| | | 1717 (74)| | |
|1116 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|1117 | HASH JOIN | | 109G| 13T| 12M| 1817K (75)| | |
|1118 | VIEW | | 266K| 9379K| | | | |
|1119 | SORT GROUP BY | | 266K| 10M| | 232K (19)| | |
|1120 | VIEW | | 266K| 10M| | | | |
|1121 | SORT UNIQUE | | 266K| 8865K| 22M| 227K (17)| | |
|1122 | UNION-ALL | | | | | | | |
|1123 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 266K| 8832K| | 219K (15)| | |
|1124 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 266K| | | 1676 (74)| | |
|1125 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|1126 | VIEW | STATISTICS_CONSIGNMENT | 41M| 3999M| | | | |
|1127 | FILTER | | | | | | | |
|1128 | SORT GROUP BY | | 41M| 7331M| | 1171K (93)| | |
|1129 | HASH JOIN | | 41M| 7331M| | 152K (44)| | |
|1130 | VIEW | | 5890 | 908K| | | | |
|1131 | SORT UNIQUE | | 5890 | 1599K| 4536K| 36190 (68)| | |
|1132 | UNION-ALL | | | | | | | |
|1133 | TABLE ACCESS FULL | CONSIGNMENT | 5649 | 1528K| | 32162 (65)| | |
|1134 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
|1135 | VIEW | | 697K| 19M| | | | |
|1136 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
|1137 | UNION-ALL | | | | | | | |
|1138 | INLIST ITERATOR | | | | | | | |
|1139 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1140 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1141 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1142 | SORT GROUP BY | | 9307P| 59107| | 574P(100)| | |
|1143 | HASH JOIN | | 9307P| 59107| 515M| 13T (45)| | |
|1144 | VIEW | | 1020K| 503M| | | | |
|1145 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
|1146 | UNION-ALL | | | | | | | |
|1147 | FILTER | | | | | | | |
|1148 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|1149 | FILTER | | | | | | | |
|1150 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
|1151 | MERGE JOIN | | 911T| 160P| | 1248K (88)| | |
|1152 | MERGE JOIN OUTER | | 91T| 13P| | 1135K (89)| | |
|1153 | MERGE JOIN | | 218G| 26T| | 1123K (90)| | |
|1154 | SORT JOIN | | 34M| 3444M| | 1005K (92)| | |
|1155 | VIEW | STATISTICS_CONSIGNMENT | 34M| 3444M| | | | |
|1156 | FILTER | | | | | | | |
|1157 | SORT GROUP BY | | 34M| 6192M| | 1005K (92)| | |
|1158 | HASH JOIN | | 34M| 6192M| | 153K (44)| | |
|1159 | VIEW | | 4975 | 767K| | | | |
|1160 | SORT UNIQUE | | 4975 | 1345K| 3992K| 37351 (70)| | |
|1161 | UNION-ALL | | | | | | | |
|1162 | TABLE ACCESS FULL | CONSIGNMENT | 4974 | 1345K| | 33292 (67)| | |
|1163 | REMOTE | | 1 | 304 | | | ENCTS~ | R->S |
|1164 | VIEW | | 697K| 19M| | | | |
|1165 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
|1166 | UNION-ALL | | | | | | | |
|1167 | INLIST ITERATOR | | | | | | | |
|1168 | TABLE ACCESS BY INDEX ROWID| CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1169 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1170 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1171 | SORT JOIN | | 630K| 17M| 48M| 117K (71)| | |
|1172 | VIEW | | 630K| 17M| | | | |
|1173 | SORT UNIQUE | | 630K| 32M| 92M| 98715 (73)| | |
|1174 | UNION-ALL | | | | | | | |
|1175 | TABLE ACCESS FULL | CONSIGNMENT_STATUS_HISTORY | 600K| 30M| | 66998 (72)| | |
|1176 | REMOTE | | 29607 | 1561K| | | ENCTS~ | R->S |
|1177 | SORT JOIN | | 41588 | 1177K| 3272K| 12813 (66)| | |
|1178 | VIEW | | 41588 | 1177K| | | | |
|1179 | SORT UNIQUE | | 41588 | 2193K| 4440K| 11755 (90)| | |
|1180 | UNION-ALL | | | | | | | |
|1181 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 11981 | 631K| | 1551 (21)| | |
|1182 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 11981 | | | 93 (63)| | |
|1183 | REMOTE | | 29607 | 1561K| | | ENCTS~ | R->S |
|1184 | FILTER | | | | | | | |
|1185 | SORT JOIN | | | | | | | |
|1186 | VIEW | | 400K| 13M| | | | |
|1187 | SORT UNIQUE | | 400K| 20M| 57M| 100K (77)| | |
|1188 | UNION-ALL | | | | | | | |
|1189 | TABLE ACCESS FULL | CONSIGNMENT_STATUS_HISTORY | 395K| 20M| | 75964 (75)| | |
|1190 | REMOTE | | 4935 | 260K| | | ENCTS~ | R->S |
|1191 | VIEW | STATISTICS_803_V | 9315P| 44677| | | | |
|1192 | UNION-ALL | | | | | | | |
|1193 | SORT GROUP BY | | 7652T| 4696P| | 395T(100)| | |
|1194 | HASH JOIN | | 7652T| 4696P| 515M| 11G (48)| | |
|1195 | VIEW | | 1020K| 503M| | | | |
|1196 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
|1197 | UNION-ALL | | | | | | | |
|1198 | FILTER | | | | | | | |
|1199 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|1200 | FILTER | | | | | | | |
|1201 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
|1202 | HASH JOIN | | 749G| 118T| 12M| 1296M (51)| | |
|1203 | VIEW | | 273K| 9610K| | | | |
|1204 | SORT GROUP BY | | 273K| 11M| | 238K (19)| | |
|1205 | VIEW | | 273K| 11M| | | | |
|1206 | SORT UNIQUE | | 273K| 9083K| 23M| 233K (17)| | |
|1207 | UNION-ALL | | | | | | | |
|1208 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 272K| 9051K| | 224K (15)| | |
|1209 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 272K| | | 1717 (74)| | |
|1210 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|1211 | HASH JOIN | | 109G| 13T| 12M| 1817K (75)| | |
|1212 | VIEW | | 266K| 9379K| | | | |
|1213 | SORT GROUP BY | | 266K| 10M| | 232K (19)| | |
|1214 | VIEW | | 266K| 10M| | | | |
|1215 | SORT UNIQUE | | 266K| 8865K| 22M| 227K (17)| | |
|1216 | UNION-ALL | | | | | | | |
|1217 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 266K| 8832K| | 219K (15)| | |
|1218 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 266K| | | 1676 (74)| | |
|1219 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|1220 | VIEW | STATISTICS_CONSIGNMENT | 41M| 3999M| | | | |
|1221 | FILTER | | | | | | | |
|1222 | SORT GROUP BY | | 41M| 7331M| | 1171K (93)| | |
|1223 | HASH JOIN | | 41M| 7331M| | 152K (44)| | |
|1224 | VIEW | | 5890 | 908K| | | | |
|1225 | SORT UNIQUE | | 5890 | 1599K| 4536K| 36190 (68)| | |
|1226 | UNION-ALL | | | | | | | |
|1227 | TABLE ACCESS FULL | CONSIGNMENT | 5649 | 1528K| | 32162 (65)| | |
|1228 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
|1229 | VIEW | | 697K| 19M| | | | |
|1230 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
|1231 | UNION-ALL | | | | | | | |
|1232 | INLIST ITERATOR | | | | | | | |
|1233 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1234 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1235 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1236 | SORT GROUP BY | | 9307P| 59107| | 574P(100)| | |
|1237 | HASH JOIN | | 9307P| 59107| 515M| 13T (45)| | |
|1238 | VIEW | | 1020K| 503M| | | | |
|1239 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
|1240 | UNION-ALL | | | | | | | |
|1241 | FILTER | | | | | | | |
|1242 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|1243 | FILTER | | | | | | | |
|1244 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
|1245 | MERGE JOIN | | 911T| 160P| | 1248K (88)| | |
|1246 | MERGE JOIN OUTER | | 91T| 13P| | 1135K (89)| | |
|1247 | MERGE JOIN | | 218G| 26T| | 1123K (90)| | |
|1248 | SORT JOIN | | 34M| 3444M| | 1005K (92)| | |
|1249 | VIEW | STATISTICS_CONSIGNMENT | 34M| 3444M| | | | |
|1250 | FILTER | | | | | | | |
|1251 | SORT GROUP BY | | 34M| 6192M| | 1005K (92)| | |
|1252 | HASH JOIN | | 34M| 6192M| | 153K (44)| | |
|1253 | VIEW | | 4975 | 767K| | | | |
|1254 | SORT UNIQUE | | 4975 | 1345K| 3992K| 37351 (70)| | |
|1255 | UNION-ALL | | | | | | | |
|1256 | TABLE ACCESS FULL | CONSIGNMENT | 4974 | 1345K| | 33292 (67)| | |
|1257 | REMOTE | | 1 | 304 | | | ENCTS~ | R->S |
|1258 | VIEW | | 697K| 19M| | | | |
|1259 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
|1260 | UNION-ALL | | | | | | | |
|1261 | INLIST ITERATOR | | | | | | | |
|1262 | TABLE ACCESS BY INDEX ROWID| CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1263 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1264 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1265 | SORT JOIN | | 630K| 17M| 48M| 117K (71)| | |
|1266 | VIEW | | 630K| 17M| | | | |
|1267 | SORT UNIQUE | | 630K| 32M| 92M| 98715 (73)| | |
|1268 | UNION-ALL | | | | | | | |
|1269 | TABLE ACCESS FULL | CONSIGNMENT_STATUS_HISTORY | 600K| 30M| | 66998 (72)| | |
|1270 | REMOTE | | 29607 | 1561K| | | ENCTS~ | R->S |
|1271 | SORT JOIN | | 41588 | 1177K| 3272K| 12813 (66)| | |
|1272 | VIEW | | 41588 | 1177K| | | | |
|1273 | SORT UNIQUE | | 41588 | 2193K| 4440K| 11755 (90)| | |
|1274 | UNION-ALL | | | | | | | |
|1275 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 11981 | 631K| | 1551 (21)| | |
|1276 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 11981 | | | 93 (63)| | |
|1277 | REMOTE | | 29607 | 1561K| | | ENCTS~ | R->S |
|1278 | FILTER | | | | | | | |
|1279 | SORT JOIN | | | | | | | |
|1280 | VIEW | | 400K| 13M| | | | |
|1281 | SORT UNIQUE | | 400K| 20M| 57M| 100K (77)| | |
|1282 | UNION-ALL | | | | | | | |
|1283 | TABLE ACCESS FULL | CONSIGNMENT_STATUS_HISTORY | 395K| 20M| | 75964 (75)| | |
|1284 | REMOTE | | 4935 | 260K| | | ENCTS~ | R->S |
|1285 | VIEW | STATISTICS_804_V | 9315P| 44677| | | | |
|1286 | UNION-ALL | | | | | | | |
|1287 | SORT GROUP BY | | 7652T| 4696P| | 395T(100)| | |
|1288 | HASH JOIN | | 7652T| 4696P| 515M| 11G (48)| | |
|1289 | VIEW | | 1020K| 503M| | | | |
|1290 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
|1291 | UNION-ALL | | | | | | | |
|1292 | FILTER | | | | | | | |
|1293 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|1294 | FILTER | | | | | | | |
|1295 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
|1296 | HASH JOIN | | 749G| 118T| 12M| 1296M (51)| | |
|1297 | VIEW | | 273K| 9610K| | | | |
|1298 | SORT GROUP BY | | 273K| 11M| | 238K (19)| | |
|1299 | VIEW | | 273K| 11M| | | | |
|1300 | SORT UNIQUE | | 273K| 9083K| 23M| 233K (17)| | |
|1301 | UNION-ALL | | | | | | | |
|1302 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 272K| 9051K| | 224K (15)| | |
|1303 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 272K| | | 1717 (74)| | |
|1304 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|1305 | HASH JOIN | | 109G| 13T| 12M| 1817K (75)| | |
|1306 | VIEW | | 266K| 9379K| | | | |
|1307 | SORT GROUP BY | | 266K| 10M| | 232K (19)| | |
|1308 | VIEW | | 266K| 10M| | | | |
|1309 | SORT UNIQUE | | 266K| 8865K| 22M| 227K (17)| | |
|1310 | UNION-ALL | | | | | | | |
|1311 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 266K| 8832K| | 219K (15)| | |
|1312 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 266K| | | 1676 (74)| | |
|1313 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|1314 | VIEW | STATISTICS_CONSIGNMENT | 41M| 3999M| | | | |
|1315 | FILTER | | | | | | | |
|1316 | SORT GROUP BY | | 41M| 7331M| | 1171K (93)| | |
|1317 | HASH JOIN | | 41M| 7331M| | 152K (44)| | |
|1318 | VIEW | | 5890 | 908K| | | | |
|1319 | SORT UNIQUE | | 5890 | 1599K| 4536K| 36190 (68)| | |
|1320 | UNION-ALL | | | | | | | |
|1321 | TABLE ACCESS FULL | CONSIGNMENT | 5649 | 1528K| | 32162 (65)| | |
|1322 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
|1323 | VIEW | | 697K| 19M| | | | |
|1324 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
|1325 | UNION-ALL | | | | | | | |
|1326 | INLIST ITERATOR | | | | | | | |
|1327 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1328 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1329 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1330 | SORT GROUP BY | | 9307P| 59107| | 574P(100)| | |
|1331 | HASH JOIN | | 9307P| 59107| 515M| 13T (45)| | |
|1332 | VIEW | | 1020K| 503M| | | | |
|1333 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
|1334 | UNION-ALL | | | | | | | |
|1335 | FILTER | | | | | | | |
|1336 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|1337 | FILTER | | | | | | | |
|1338 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
|1339 | MERGE JOIN | | 911T| 160P| | 1248K (88)| | |
|1340 | MERGE JOIN OUTER | | 91T| 13P| | 1135K (89)| | |
|1341 | MERGE JOIN | | 218G| 26T| | 1123K (90)| | |
|1342 | SORT JOIN | | 34M| 3444M| | 1005K (92)| | |
|1343 | VIEW | STATISTICS_CONSIGNMENT | 34M| 3444M| | | | |
|1344 | FILTER | | | | | | | |
|1345 | SORT GROUP BY | | 34M| 6192M| | 1005K (92)| | |
|1346 | HASH JOIN | | 34M| 6192M| | 153K (44)| | |
|1347 | VIEW | | 4975 | 767K| | | | |
|1348 | SORT UNIQUE | | 4975 | 1345K| 3992K| 37351 (70)| | |
|1349 | UNION-ALL | | | | | | | |
|1350 | TABLE ACCESS FULL | CONSIGNMENT | 4974 | 1345K| | 33292 (67)| | |
|1351 | REMOTE | | 1 | 304 | | | ENCTS~ | R->S |
|1352 | VIEW | | 697K| 19M| | | | |
|1353 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
|1354 | UNION-ALL | | | | | | | |
|1355 | INLIST ITERATOR | | | | | | | |
|1356 | TABLE ACCESS BY INDEX ROWID| CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1357 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1358 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1359 | SORT JOIN | | 630K| 17M| 48M| 117K (71)| | |
|1360 | VIEW | | 630K| 17M| | | | |
|1361 | SORT UNIQUE | | 630K| 32M| 92M| 98715 (73)| | |
|1362 | UNION-ALL | | | | | | | |
|1363 | TABLE ACCESS FULL | CONSIGNMENT_STATUS_HISTORY | 600K| 30M| | 66998 (72)| | |
|1364 | REMOTE | | 29607 | 1561K| | | ENCTS~ | R->S |
|1365 | SORT JOIN | | 41588 | 1177K| 3272K| 12813 (66)| | |
|1366 | VIEW | | 41588 | 1177K| | | | |
|1367 | SORT UNIQUE | | 41588 | 2193K| 4440K| 11755 (90)| | |
|1368 | UNION-ALL | | | | | | | |
|1369 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 11981 | 631K| | 1551 (21)| | |
|1370 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 11981 | | | 93 (63)| | |
|1371 | REMOTE | | 29607 | 1561K| | | ENCTS~ | R->S |
|1372 | FILTER | | | | | | | |
|1373 | SORT JOIN | | | | | | | |
|1374 | VIEW | | 400K| 13M| | | | |
|1375 | SORT UNIQUE | | 400K| 20M| 57M| 100K (77)| | |
|1376 | UNION-ALL | | | | | | | |
|1377 | TABLE ACCESS FULL | CONSIGNMENT_STATUS_HISTORY | 395K| 20M| | 75964 (75)| | |
|1378 | REMOTE | | 4935 | 260K| | | ENCTS~ | R->S |
|1379 | VIEW | STATISTICS_805_V | 18630| 89354| | | | |
|1380 | UNION-ALL | | | | | | | |
|1381 | SORT GROUP BY | | 153P| 93925| | 8559T(100)| | |
|1382 | HASH JOIN | | 153P| 93925| 515M| 205G (47)| | |
|1383 | VIEW | | 1020K| 503M| | | | |
|1384 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
|1385 | UNION-ALL | | | | | | | |
|1386 | FILTER | | | | | | | |
|1387 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|1388 | FILTER | | | | | | | |
|1389 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
|1390 | HASH JOIN | | 14T| 2372T| 12M| 1296M (51)| | |
|1391 | VIEW | | 273K| 9610K| | | | |
|1392 | SORT GROUP BY | | 273K| 11M| | 238K (19)| | |
|1393 | VIEW | | 273K| 11M| | | | |
|1394 | SORT UNIQUE | | 273K| 9083K| 23M| 233K (17)| | |
|1395 | UNION-ALL | | | | | | | |
|1396 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 272K| 9051K| | 224K (15)| | |
|1397 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 272K| | | 1717 (74)| | |
|1398 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|1399 | HASH JOIN | | 109G| 13T| 12M| 1817K (75)| | |
|1400 | VIEW | | 266K| 9379K| | | | |
|1401 | SORT GROUP BY | | 266K| 10M| | 232K (19)| | |
|1402 | VIEW | | 266K| 10M| | | | |
|1403 | SORT UNIQUE | | 266K| 8865K| 22M| 227K (17)| | |
|1404 | UNION-ALL | | | | | | | |
|1405 | TABLE ACCESS BY INDEX ROWID | MESSAGE_HISTORY | 266K| 8832K| | 219K (15)| | |
|1406 | INDEX RANGE SCAN | MESSAGE_TYPE_CODE_IDX | 266K| | | 1676 (74)| | |
|1407 | REMOTE | | 777 | 33411 | | | ENCTS~ | R->S |
|1408 | VIEW | STATISTICS_CONSIGNMENT | 41M| 3999M| | | | |
|1409 | FILTER | | | | | | | |
|1410 | SORT GROUP BY | | 41M| 7331M| | 1171K (93)| | |
|1411 | HASH JOIN | | 41M| 7331M| | 152K (44)| | |
|1412 | VIEW | | 5890 | 908K| | | | |
|1413 | SORT UNIQUE | | 5890 | 1599K| 4536K| 36190 (68)| | |
|1414 | UNION-ALL | | | | | | | |
|1415 | TABLE ACCESS FULL | CONSIGNMENT | 5649 | 1528K| | 32162 (65)| | |
|1416 | REMOTE | | 241 | 73264 | | | ENCTS~ | R->S |
|1417 | VIEW | | 697K| 19M| | | | |
|1418 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
|1419 | UNION-ALL | | | | | | | |
|1420 | INLIST ITERATOR | | | | | | | |
|1421 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1422 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1423 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1424 | SORT GROUP BY | | 18615| 11821| | 12279(100)| | |
|1425 | HASH JOIN | | 18615| 11821| 515M| 269T (45)| | |
|1426 | VIEW | | 1020K| 503M| | | | |
|1427 | SORT UNIQUE | | 1020K| 164M| 533M| 104K (63)| | |
|1428 | UNION-ALL | | | | | | | |
|1429 | FILTER | | | | | | | |
|1430 | TABLE ACCESS FULL | DECLARATION | 906K| 145M| | 31665 (78)| | |
|1431 | FILTER | | | | | | | |
|1432 | REMOTE | | 114K| 19M| | | ENCTS~ | R->S |
|1433 | MERGE JOIN | | 18P| 3206P| | 1248K (88)| | |
|1434 | MERGE JOIN OUTER | | 91T| 13P| | 1135K (89)| | |
|1435 | MERGE JOIN | | 218G| 26T| | 1123K (90)| | |
|1436 | SORT JOIN | | 34M| 3444M| | 1005K (92)| | |
|1437 | VIEW | STATISTICS_CONSIGNMENT | 34M| 3444M| | | | |
|1438 | FILTER | | | | | | | |
|1439 | SORT GROUP BY | | 34M| 6192M| | 1005K (92)| | |
|1440 | HASH JOIN | | 34M| 6192M| | 153K (44)| | |
|1441 | VIEW | | 4975 | 767K| | | | |
|1442 | SORT UNIQUE | | 4975 | 1345K| 3992K| 37351 (70)| | |
|1443 | UNION-ALL | | | | | | | |
|1444 | TABLE ACCESS FULL | CONSIGNMENT | 4974 | 1345K| | 33292 (67)| | |
|1445 | REMOTE | | 1 | 304 | | | ENCTS~ | R->S |
|1446 | VIEW | | 697K| 19M| | | | |
|1447 | SORT UNIQUE | | 697K| 35M| 101M| 114K (39)| | |
|1448 | UNION-ALL | | | | | | | |
|1449 | INLIST ITERATOR | | | | | | | |
|1450 | TABLE ACCESS BY INDEX ROWID| CONSIGNMENT_STATUS_HISTORY | 609K| 31M| | 78662 (21)| | |
|1451 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 609K| | | 4569 (64)| | |
|1452 | REMOTE | | 88822 | 4683K| | | ENCTS~ | R->S |
|1453 | SORT JOIN | | 630K| 17M| 48M| 117K (71)| | |
|1454 | VIEW | | 630K| 17M| | | | |
|1455 | SORT UNIQUE | | 630K| 32M| 92M| 98715 (73)| | |
|1456 | UNION-ALL | | | | | | | |
|1457 | TABLE ACCESS FULL | CONSIGNMENT_STATUS_HISTORY | 600K| 30M| | 66998 (72)| | |
|1458 | REMOTE | | 29607 | 1561K| | | ENCTS~ | R->S |
|1459 | SORT JOIN | | 41588 | 1177K| 3272K| 12813 (66)| | |
|1460 | VIEW | | 41588 | 1177K| | | | |
|1461 | SORT UNIQUE | | 41588 | 2193K| 4440K| 11755 (90)| | |
|1462 | UNION-ALL | | | | | | | |
|1463 | TABLE ACCESS BY INDEX ROWID | CONSIGNMENT_STATUS_HISTORY | 11981 | 631K| | 1551 (21)| | |
|1464 | INDEX RANGE SCAN | CSH_CONSIGNMENT_STATUS_IDX | 11981 | | | 93 (63)| | |
|1465 | REMOTE | | 29607 | 1561K| | | ENCTS~ | R->S |
|1466 | FILTER | | | | | | | |
|1467 | SORT JOIN | | | | | | | |
|1468 | VIEW | | 400K| 13M| | | | |
|1469 | SORT UNIQUE | | 400K| 20M| 57M| 100K (77)| | |
|1470 | UNION-ALL | | | | | | | |
|1471 | TABLE ACCESS FULL | CONSIGNMENT_STATUS_HISTORY | 395K| 20M| | 75964 (75)| | |
|1472 | REMOTE | | 4935 | 260K| | | ENCTS~ | R->S |
---------------------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
7 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
11 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
13 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
18 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
22 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND ("CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT25' OR
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' OR "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT30'))
29 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
32 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
36 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
37 - filter("DECLARATION"."DECLARATION_TYPE"='T1')
38 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
43 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
47 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND ("CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT25' OR
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' OR "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT30'))
54 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
57 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
61 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
62 - filter("DECLARATION"."DECLARATION_TYPE"='T2')
63 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
68 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
72 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND ("CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT25' OR
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' OR "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT30'))
79 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
82 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
86 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
87 - filter("DECLARATION"."DECLARATION_TYPE"='T2F')
88 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
117 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
121 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
122 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND ("CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT25' OR
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' OR "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT30'))
123 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
141 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
145 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
146 - filter("CONSIGNMENT"."DEP_SIMPLIFIED_PROCEDURE"=1 AND SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND
("CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT25' OR "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' OR
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT30'))
147 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
166 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
170 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
171 - filter("CONSIGNMENT"."DEP_CANCELLATION_DATE" IS NOT NULL AND SUBSTR("CONSIGNMENT"."MRN",3,2)='EE')
172 - access("CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT30')
173 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
192 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
196 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
197 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE')
198 - access("CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT25')
199 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
206 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
214 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
218 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
219 - filter("DECLARATION"."DECLARATION_TYPE"='T-')
220 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
243 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
247 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
248 - filter("CONSIGNMENT"."DES_CONTROL_RESULT_CODE"='A1' AND SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
249 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
273 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
277 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
278 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' AND
"CONSIGNMENT"."DES_CONTROL_RESULT_CODE"='A2')
279 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
293 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
297 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
298 - filter("CONSIGNMENT"."DES_CONTROL_RESULT_CODE"='A3' AND SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
299 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
318 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
322 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
323 - filter("CONSIGNMENT"."DES_CONTROL_RESULT_CODE"='A4' AND SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
324 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
343 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
347 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
348 - filter("CONSIGNMENT"."DES_CONTROL_RESULT_CODE"='A5' AND SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
349 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
368 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
372 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
373 - filter("CONSIGNMENT"."DES_CONTROL_RESULT_CODE"='B1' AND SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
374 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
395 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
399 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
406 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
408 - access("CONS"."SID"="REC"."CONSIGNMENT_SID")
filter("CONS"."SID"="REC"."CONSIGNMENT_SID")
417 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
419 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
428 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
432 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
439 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
441 - access("CONS"."SID"="REC"."CONSIGNMENT_SID")
filter("CONS"."SID"="REC"."CONSIGNMENT_SID")
445 - filter(TO_NUMBER("RECOVERY"."RESULT")=1)
450 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
452 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
461 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
465 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
472 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
474 - access("CONS"."SID"="REC"."CONSIGNMENT_SID")
filter("CONS"."SID"="REC"."CONSIGNMENT_SID")
478 - filter(TO_NUMBER("RECOVERY"."RESULT")=2)
483 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
485 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
494 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
498 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
505 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
507 - access("CONS"."SID"="REC"."CONSIGNMENT_SID")
filter("CONS"."SID"="REC"."CONSIGNMENT_SID")
511 - filter(TO_NUMBER("RECOVERY"."RESULT")=3)
516 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
518 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
521 - access("MESS_HIST"."ORIGINAL_REFERENCE"="CONS"."MRN")
526 - access("MESSAGE_HISTORY"."MESSAGE_TYPE_CODE"='IE104')
528 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
532 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR("DECLARATION"."DECLARATION_DATE",'YYYY')||TO_CHAR("DECLARATION"."DECLARATION_DATE",'MM'),'yyyymm')<=:Z)
534 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
538 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
542 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
549 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
552 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
556 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR("DECLARATION"."DECLARATION_DATE",'YYYY')||TO_CHAR("DECLARATION"."DECLARATION_DATE",'MM'),'yyyymm')<=:Z)
558 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
560 - access("MESS_HIST"."ORIGINAL_REFERENCE"="CONS"."MRN")
565 - access("MESSAGE_HISTORY"."MESSAGE_TYPE_CODE"='IE106')
569 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
573 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
580 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
583 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
584 - access("CONS"."MRN"="MESS"."ORIGINAL_REFERENCE")
588 - filter("MESSAGE_HISTORY"."MESSAGE_STATE_CODE"='OK')
589 - access("MESSAGE_HISTORY"."MESSAGE_TYPE_CODE"='IE106')
591 - access("CONS"."SID"="HIST"."CONSIGNMENT_SID")
595 - filter(TO_DATE(:Z)=:Z AND TO_DATE(TO_CHAR("CONSIGNMENT_STATUS_HISTORY"."DATE_CREATED",'YYYY')||TO_CHAR("CONSIGNMENT_STATUS_HISTORY"."DATE_CREATE
D",'M
M'),'yyyymm')<=:Z)
597 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT7')
598 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
608 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
610 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
613 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
617 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR("DECLARATION"."DECLARATION_DATE",'YYYY')||TO_CHAR("DECLARATION"."DECLARATION_DATE",'MM'),'yyyymm')<=:Z)
619 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
621 - access("MESS_HIST"."ORIGINAL_REFERENCE"="CONS"."MRN")
626 - access("MESSAGE_HISTORY"."MESSAGE_TYPE_CODE"='IE105')
630 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
634 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
641 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
644 - filter( EXISTS ( (SELECT /*+ */ '' FROM "MESSAGE_HISTORY" "MESSAGE_HISTORY")UNION (SELECT /*+ */ '' FROM
"MESSAGE_HISTORY"@ENCTS_ARCHIVE.MTA "MESSAGE_HISTORY" WHERE "MESSAGE_HISTORY"."ORIGINAL_REFERENCE"=:B1 AND
"MESSAGE_HISTORY"."MESSAGE_TYPE_CODE"='IE003' AND "MESSAGE_HISTORY"."DIRECTION"=1)))
645 - access("DECL"."SID"="SYS_ALIAS_1"."LAST_DECLARATION_SID")
649 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
651 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
678 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
682 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND SUBSTR("CONSIGNMENT"."DECL_DEST_CUSTOMS_OFFICE_ID",1,2)SUBSTR("CONSIGNMENT"."DES_ARR
IVAL_CUSTOMS_OFFICE_ID",1,2) AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
689 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
694 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
696 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
703 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
707 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND SUBSTR("CONSIGNMENT"."DECL_DEST_CUSTOMS_OFFICE_ID",1,2)=SUBSTR("CONSIGNMENT"."DES_ARRI
VAL_CUSTOMS_OFFICE_ID",1,2) AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
714 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
719 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
721 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
724 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
728 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
730 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
737 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
741 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26')
748 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
750 - access("DIV"."CONSIGNMENT_SID"="CONS"."SID")
filter("DIV"."CONSIGNMENT_SID"="CONS"."SID")
754 - filter(SUBSTR("DIVERSION"."PRESENTATION_CUSTOMS_OFFICE_ID",1,2)'EE' AND TO_NUMBER("DIVERSION"."DIVERSION_ALLOWED_DECISION")=0)
757 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
761 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
762 - filter(UPPER("DECLARATION"."COMMUNICATIONS_CHANNEL")='EDI')
763 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
768 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
772 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND ("CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT25' OR
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' OR "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT30'))
779 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
782 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
786 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
787 - filter(UPPER("DECLARATION"."COMMUNICATIONS_CHANNEL")='WEB')
788 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
793 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
797 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND ("CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT25' OR
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' OR "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT30'))
804 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
807 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
811 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
812 - filter(UPPER("DECLARATION"."COMMUNICATIONS_CHANNEL")='SCREEN')
813 - filter(TO_DATE(:Z)=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
818 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
822 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND ("CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT25' OR
"CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' OR "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT30'))
829 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
832 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
836 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
837 - filter(UPPER("DECLARATION"."COMMUNICATIONS_CHANNEL")='EDI')
838 - filter(TO_DATE(:Z)=0 AND NVL("HISTORYIE029"."TIMESTAMP"-"HISTORYIE028"."TIMESTAMP","CONS"."DEP_RELEASED_FOR_MOVEMENT_TIME"-"CONS"."DEP_ACCEPTED_DATE"
)*24*
60=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
861 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
865 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' AND
"CONSIGNMENT"."DEP_SIMPLIFIED_PROCEDURE"=0)
872 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
875 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
879 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
880 - filter(UPPER("DECLARATION"."COMMUNICATIONS_CHANNEL")='EDI')
881 - filter(TO_DATE(:Z)=61 AND NVL("HISTORYIE029"."TIMESTAMP"-"HISTORYIE028"."TIMESTAMP","CONS"."DEP_RELEASED_FOR_MOVEMENT_TIME"-"CONS"."DEP_ACCEPTED_DATE
")*24
*60=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
904 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
908 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' AND
"CONSIGNMENT"."DEP_SIMPLIFIED_PROCEDURE"=0)
915 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
918 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
922 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
923 - filter(UPPER("DECLARATION"."COMMUNICATIONS_CHANNEL")='EDI')
924 - filter(TO_DATE(:Z)=721 AND NVL("HISTORYIE029"."TIMESTAMP"-"HISTORYIE028"."TIMESTAMP","CONS"."DEP_RELEASED_FOR_MOVEMENT_TIME"-"CONS"."DEP_ACCEPTED_DAT
E")*2
4*60=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
947 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
951 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' AND
"CONSIGNMENT"."DEP_SIMPLIFIED_PROCEDURE"=0)
958 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
961 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
965 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
966 - filter(UPPER("DECLARATION"."COMMUNICATIONS_CHANNEL")='EDI')
967 - filter(TO_DATE(:Z)1440)
976 - access("MESSAGE_HISTORY"."MESSAGE_TYPE_CODE"='IE028')
978 - access("HISTORYIE029"."ORIGINAL_REFERENCE"="CONS"."MRN")
985 - access("MESSAGE_HISTORY"."MESSAGE_TYPE_CODE"='IE029')
988 - filter(TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')>=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
990 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
994 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."STATE_AT_DEPARTURE_CO"='STAT26' AND
"CONSIGNMENT"."DEP_SIMPLIFIED_PROCEDURE"=0)
1001 - access("CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT25' OR "CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT26' OR
"CONSIGNMENT_STATUS_HISTORY"."CONSIGNMENT_STATUS"='STAT30')
1006 - access("DECL"."SID"="CONS"."LAST_DECLARATION_SID")
1010 - filter(TO_DATE(:Z)<=TO_DATE(:Z))
1012 - filter(TO_DATE(:Z)=0
AND NVL("HISTORYIE018"."TIMESTAMP"-"HISTORYIE006"."TIMESTAMP","CONS"."DES_CONTROL_RESULT_DATE"-"CONS"."DES_ARRIVAL_TIME")*24*60=:Z AND
TO_DATE(TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'YYYY')||TO_CHAR(MAX("CONS_HIST"."DATE_CREATED"),'MM'),'yyyymm')<=:Z)
1035 - access("CONS"."SID"="CONS_HIST"."CONSIGNMENT_SID")
1039 - filter(SUBSTR("CONSIGNMENT"."MRN",3,2)='EE' AND "CONSIGNMENT"."DES_CONTROL_RESULT_CODE" IS NOT NULL AND
Freak show?
Juba teist päeva käib blogtrees sõda, teadagi mille üle. Kirge ja elaani on rohkem kui rubla eest, mõtet sellevõrra jälle vähem. Täiesti hämmastav, kuidas omastarust arukatel ja normaalsetel inimestel katus ära sõidab. Las kivi viskab ikka see, kes ise patust puutumata. Ja las vooruse verstaposti või -samba püstitab ikkagi see, kellel… seisab?
Zvjagintseviga sügiskaamose vastu
Reedel ühes Kilulinna raamatupoes ringi kolades avastasin riiulist Vassili Zvajagintsevi uue eepose, nimega Скорпион в янтаре. Et mul on enamus Zvjagintsevi raamatuid olemas (välja arvatud Андреевское братство), siis ostsin ka selle. Teatud kahtlus küll oli, et kas see romaan on raha ja riiulipinda väärt…
Et millest siis kahtlused? Viimased kolm-neli Zvjagintsevi romaani ei ole olnud, kuidas seda nüüd viisakalt õeldagi, tema esimeste limunud romaanide tasemel. Kui Билет на ладью Харона aitas veel lugeda, siis Бремя живых oli täielik katastroof. Kohati tekkis ebameeldiv kahtlus, ega ometiauväärt kirjanik ole millegagi vastu pead saanud.
Esimesed paarkümmend lehekülge olid eelmise romaani puisevõitu ümberjutustus. Siis mingi hetk läks tegevus käima, käis natuke kuni põrkus tema kõrgeaususe vürst Oleg Konstantinovitši vastu. Zvjagintsevi poolt kirjeldatud reaalsuses võis Oleg Konstantinovitš ju olla silmapaistvalt terane poliitikateoreetik, meil siin tunduvad tema mõtelused aga äärmiselt lapsikud. Rääkimata juba sellest, et auväärt vürsti ja tema mõteluste tagant paistavad Vladimir Vladimirovitši eeslikõrvad. Jaa, putinjugend seda raamatut ostaks. Neile on ilmselt mõeldud ka joonealused märkused, millest kaks kolmandikku mõjuvad keskharidusega lugejale õige ärritavalt.
Mõni positiivne moment on selle raamatul juures siiski olemas. Nii saavad deržaava lammutamise eest sõimata poolakad, mitte aga pribaltika rahvad. Et auväärt kirjanik sõimamises selgelt üle hea maitse piiride läheb, ei vajagi vist mainimist. Igatahes minul oli piinlik ja peatüki või paar läbisin diagonaalis.
Samas võtmes kulgeb ka Zvjagintsevi järgmine raamat, Дальше фронта. Sõim poolakate aadressil, sumbuurne poliitiline rähklemine ja sõda. Samas ilmub selles raamatus välja Andrejevi (Andrejevski?) vennaskond, mis annab lootust.
Mõnes mõttes oli lootus õigustatud, sest järgmine romaan, Хлопок одной ладонью on mõneti parem, kui eelmised kaks. Selles seotakse kokku sarjad Одиссей покидает Итаку ja Дырка для ордена. Kolmandik või neljandik romaanist näib põhinevat otseselt sarja Одиссей покидает Итаку raamatutel. Kas on tegemist kerge ümberjutustusega või otsese kopipasteediga, ei viitsinud välja selgitada. Ainult sel põhjusel varasemat Zvjagintsevi nüüd küll üle lugema ei tahaks hakata… Ühesõnaga, enamus ripnevaid süžeelõngu sõlmitakse kokku, mõni isegi õige mitu korda, nii et osa käike jäi üpriski segaseks.
Kõige eelneva taustal oli Скорпион в янтаре meeldiv üllatus. Tegevus läks edasi enam-vähem samast kohast, kus raamat Время игры ära lõppes. Aleksandr Šulgin on jälle 1938 aasta Moskvas, üritab Stalini režiimi mõjutada ja nõukogude armeed kaosest välja tuua.
Mis teha, mulle Zvjagintsevi kirjeldus Stalini režiimist ja nõukogude inimesest meeldivad. Põnev on ka, isegi Šulgini ekskurss Hispaania kodusõtta ja alternatiivsetesse reaalsustesse oli täiesti loetav. Mõnes mõttes Zvjagintsev rehabiliteerib end selle romaaniga. Samas oli ka raamatu Одиссей покидает Итаку huvitavam osa just 1941. aasta Stalini režiim. Nii et osalt on Скорпион в янтаре vana ja tuttav ja seega üsna turvaline teema.
PS. Vahepeal tundus, et sügiskaamos läheb vaikselt üle talvekaamoseks. Aga võta näpust, laupäeval sadanud lumi ei jäänudki maha… Zvjagintsevi romaani esimene kõide on läbi ja teine pooleli.
