Peguei de outro forum: Porque eu odeio o hibernate

Por causa disso:

O Simpes método save(obj) resulta nesses selects:

17:14:44,295 INFO [ValidarFiliais] Validar alteração
17:14:44,305 INFO [STDOUT] Hibernate: select bob0_.ID as ID45_, bob0_.ID_FIL as ID_FIL45_, bob0_.ID_BOB as ID_BOB45_, bob0_.ID_PRO as ID_PRO45_, bob0_.ID_CNF as ID_CNF45_, bob0_.ID_FUN as ID_FUN45_, bob0_.numBob as numBob45_, bob0_.numOri as numOri45_, bob0_.locBob as locBob45_, bob0_.comBob as comBob45_, bob0_.larBob as larBob45_, bob0_.datVal as datVal45_, bob0_.datCor as datCor45_, bob0_.datSai as datSai45_, bob0_.datRet as datRet45_, bob0_.sitBob as sitBob45_, bob0_.comAtu as comAtu45_, bob0_.graFro as graFro45_, bob0_.espFro as espFro45_, bob0_.graLin as graLin45_, bob0_.espLin as espLin45_, bob0_.adesiv as adesiv45_, bob1_.ID as ID0_, bob1_.ID_FIL as ID_FIL0_, bob1_.ID_BOB as ID_BOB0_, bob1_.ID_PRO as ID_PRO0_, bob1_.ID_CNF as ID_CNF0_, bob1_.ID_FUN as ID_FUN0_, bob1_.numBob as numBob0_, bob1_.numOri as numOri0_, bob1_.locBob as locBob0_, bob1_.comBob as comBob0_, bob1_.larBob as larBob0_, bob1_.datVal as datVal0_, bob1_.datCor as datCor0_, bob1_.datSai as datSai0_, bob1_.datRet as datRet0_, bob1_.sitBob as sitBob0_, bob1_.comAtu as comAtu0_, bob1_.graFro as graFro0_, bob1_.espFro as espFro0_, bob1_.graLin as graLin0_, bob1_.espLin as espLin0_, bob1_.adesiv as adesiv0_, prored2_.ID as ID1_, prored2_.ID_FIL as ID_FIL1_, prored2_.codPro as codPro1_, prored2_.diaVal as diaVal1_, prored2_.codBar as codBar1_, prored2_.codRef as codRef1_, prored2_.codExt as codExt1_, prored2_.desAbr as desAbr1_, prored2_.regAti as regAti1_, cnf3_.ID as ID2_, cnf3_.ID_FIL as ID_FIL2_, cnf3_.ID_TPD as ID_TPD2_, cnf3_.ID_SER as ID_SER2_, cnf3_.ID_OPE as ID_OPE2_, cnf3_.ID_ENT as ID_ENT2_, cnf3_.ID_ERE as ID_ERE2_, cnf3_.ID_ETR as ID_ETR2_, cnf3_.ID_EEN as ID_EEN2_, cnf3_.ID_ECO as ID_ECO2_, cnf3_.ID_EFA as ID_EFA2_, cnf3_.ID_FRE as ID_FRE2_, cnf3_.ID_RPA as ID_RPA2_, cnf3_.tipEmi as tipEmi2_, cnf3_.tipMov as tipMov2_, cnf3_.sitDoc as sitDoc2_, cnf3_.tipFre as tipFre2_, cnf3_.numDoc as numDoc2_, cnf3_.datDoc as datDoc2_, cnf3_.datMov as datMov2_, cnf3_.vlrBru as vlrBru2_, cnf3_.vlrLiq as vlrLiq2_, cnf3_.basIcm as basIcm2_, cnf3_.vlrIcm as vlrIcm2_, cnf3_.basIse as basIse2_, cnf3_.basSub as basSub2_, cnf3_.vlrSub as vlrSub2_, cnf3_.basOut as basOut2_, cnf3_.vlrOut as vlrOut2_, cnf3_.basIpi as basIpi2_, cnf3_.vlrIpi as vlrIpi2_, cnf3_.basIss as basIss2_, cnf3_.perIss as perIss2_, cnf3_.vlrIss as vlrIss2_, cnf3_.basIrr as basIrr2_, cnf3_.basIns as basIns2_, cnf3_.vlrIns as vlrIns2_, cnf3_.vlrIrr as vlrIrr2_, cnf3_.vlrFre as vlrFre2_, cnf3_.vlrSeg as vlrSeg2_, cnf3_.vlrOde as vlrOde2_, cnf3_.vlrEmb as vlrEmb2_, cnf3_.vlrDes as vlrDes2_, cnf3_.perDes as perDes2_, cnf3_.vlrAcr as vlrAcr2_, cnf3_.perAcr as perAcr2_, cnf3_.obsDoc as obsDoc2_, cnf3_.plaVei as plaVei2_, cnf3_.estVei as estVei2_, cnf3_.espVol as espVol2_, cnf3_.marVol as marVol2_, cnf3_.numVol as numVol2_, cnf3_.qtdVol as qtdVol2_, cnf3_.pesBru as pesBru2_, cnf3_.pesLiq as pesLiq2_, cnf3_.movEst as movEst2_, cnf3_.movFin as movFin2_, cnf3_.conFin as conFin2_, cnf3_.vlrCom as vlrCom2_, cnf3_.ID_SIT as ID_SIT2_, cnf3_.ID_POR as ID_POR2_, cnf3_.datEmb as datEmb2_, cnf3_.tipSit as tipSit2_, cnf3_.tipTip as tipTip2_, cnf3_.pagFil as pagFil2_, cnf3_.escFis as escFis2_, cnf3_.codFis as codFis2_, cnf3_.vlrMat as vlrMat2_, cnf3_.vlrDev as vlrDev2_, cnf3_.ID_C01 as ID_C012_, cnf3_.ID_C02 as ID_C022_, cnf3_.ID_C03 as ID_C032_, cnf3_.ID_C04 as ID_C042_, cnf3_.ID_C05 as ID_C052_, cnf3_.ID_C06 as ID_C062_, cnf3_.ID_C07 as ID_C072_, cnf3_.ID_C08 as ID_C082_, cnf3_.ID_C09 as ID_C092_, cnf3_.ID_C10 as ID_C102_, cnf3_.ID_C11 as ID_C112_, cnf3_.ID_C12 as ID_C122_, cnf3_.ID_C13 as ID_C132_, cnf3_.ID_C14 as ID_C142_, cnf3_.ID_C15 as ID_C152_, cnf3_.basDif as basDif2_, cnf3_.perDif as perDif2_, cnf3_.vlrDif as vlrDif2_, tpd4_.ID as ID3_, tpd4_.codTpd as codTpd3_, tpd4_.desTpd as desTpd3_, tpd4_.regAti as regAti3_, ser5_.ID as ID4_, ser5_.desSer as desSer4_, ser5_.regAti as regAti4_, ope6_.ID as ID5_, ope6_.codOpe as codOpe5_, ope6_.ID_REV as ID_REV5_, ope6_.desOpe as desOpe5_, ope6_.lanEst as lanEst5_, ope6_.lanFin as lanFin5_, ope6_.regAti as regAti5_, ope6_.emiDoc as emiDoc5_, ope6_.conDev as conDev5_, ope6_.calCus as calCus5_, ope6_.diaPra as diaPra5_, ope6_.ID_LEG as ID_LEG5_, ope7_.ID as ID6_, ope7_.codOpe as codOpe6_, ope7_.ID_REV as ID_REV6_, ope7_.desOpe as desOpe6_, ope7_.lanEst as lanEst6_, ope7_.lanFin as lanFin6_, ope7_.regAti as regAti6_, ope7_.emiDoc as emiDoc6_, ope7_.conDev as conDev6_, ope7_.calCus as calCus6_, ope7_.diaPra as diaPra6_, ope7_.ID_LEG as ID_LEG6_, leg8_.ID as ID7_, leg8_.desLeg as desLeg7_, leg8_.ID_FIL as ID_FIL7_, leg8_.txtLeg as txtLeg7_, leg8_.codExt as codExt7_, leg9_.ID as ID8_, leg9_.desLeg as desLeg8_, leg9_.ID_FIL as ID_FIL8_, leg9_.txtLeg as txtLeg8_, leg9_.codExt as codExt8_, ent10_.ID as ID9_, ent10_.tipEnt as tipEnt9_, ent10_.nomEnt as nomEnt9_, ent10_.regAti as regAti9_, ent10_.fabExt as fabExt9_, fis11_.ID as ID10_, fis11_.nomPai as nomPai10_, fis11_.nomMae as nomMae10_, fis11_.datNas as datNas10_, fis11_.E_MAIL as E_MAIL10_, fis11_.refCo1 as refCo110_, fis11_.refCo2 as refCo210_, fis11_.refCo3 as refCo310_, fis11_.refFo1 as refFo110_, fis11_.refFo2 as refFo210_, fis11_.refFo3 as refFo310_, jur12_.ID as ID11_, jur12_.numMun as numMun11_, jur12_.datFun as datFun11_, jur12_.END_HP as END_HP11_, jur12_.nomFan as nomFan11_, cli13_.ID as ID12_, cli13_.codExt as codExt12_, cli13_.cliBlo as cliBlo12_, cli13_.usaCer as usaCer12_, cli13_.ID_LEG as ID_LEG12_, cli13_.conFin as conFin12_, cli13_.tipFre as tipFre12_, cli13_.ID_SIT as ID_SIT12_, cli13_.vlrLim as vlrLim12_, cli13_.vlrAbe as vlrAbe12_, cli13_.difere as difere12_, leg14_.ID as ID13_, leg14_.desLeg as desLeg13_, leg14_.ID_FIL as ID_FIL13_, leg14_.txtLeg as txtLeg13_, leg14_.codExt as codExt13_, sit15_.ID as ID14_, sit15_.desSit as desSit14_, sit15_.regAti as regAti14_, fnc16_.ID as ID15_, fnc16_.codExt as codExt15_, fnc16_.regAti as regAti15_, rep17_.ID as ID16_, rep17_.codExt as codExt16_, rep17_.comFat as comFat16_, rep17_.comLiq as comLiq16_, rep17_.regAti as regAti16_, tra18_.ID as ID17_, tra18_.codExt as codExt17_, tra18_.regAti as regAti17_, usu19_.ID as ID18_, usu19_.codExt as codExt18_, usu19_.senUsu as senUsu18_, usu19_.nomLog as nomLog18_, usu19_.regAti as regAti18_, por20_.ID as ID19_, por20_.codExt as codExt19_, por20_.regAti as regAti19_, fil21_.ID as ID20_, fil21_.codExt as codExt20_, fil21_.sufFil as sufFil20_, fil21_.regAti as regAti20_, end22_.ID as ID21_, end22_.endCob as endCob21_, end22_.endCor as endCor21_, end22_.codCep as codCep21_, end22_.codLog as codLog21_, end22_.tipEnd as tipEnd21_, end22_.desEnd as desEnd21_, end22_.comEnd as comEnd21_, end22_.baiEnd as baiEnd21_, end22_.numEnd as numEnd21_, end22_.DDDFon as DDDFon21_, end22_.numFon as numFon21_, end22_.DDDFax as DDDFax21_, end22_.numFax as numFax21_, end22_.ID_ENT as ID_ENT21_, end22_.ID_MUN as ID_MUN21_, end22_.nrDoc1 as nrDoc121_, end22_.nrDoc2 as nrDoc221_, mun23_.ID as ID22_, mun23_.cepIni as cepIni22_, mun23_.cepFin as cepFin22_, mun23_.nomMun as nomMun22_, mun23_.ID_EST as ID_EST22_, est24_.ID as ID23_, est24_.uniFed as uniFed23_, est24_.nomEst as nomEst23_, est24_.ID_ICM as ID_ICM23_, icm25_.ID as ID24_, icm25_.desIcm as desIcm24_, icm25_.codTri as codTri24_, icm25_.perIcm as perIcm24_, icm25_.perRed as perRed24_, rpa26_.ID as ID25_, rpa26_.ID_FIL as ID_FIL25_, rpa26_.ID_TRA as ID_TRA25_, rpa26_.ID_EST as ID_EST25_, rpa26_.numRpa as numRpa25_, rpa26_.datRpa as datRpa25_, rpa26_.vlrRpa as vlrRpa25_, rpa26_.perIcm as perIcm25_, rpa26_.vlrIcm as vlrIcm25_, rpa26_.plaVei as plaVei25_, sit27_.ID as ID26_, sit27_.desSit as desSit26_, sit27_.regAti as regAti26_, cte28_.ID as ID27_, cte28_.ID_FIL as ID_FIL27_, cte28_.codCte as codCte27_, cte28_.desCte as desCte27_, cte28_.regAti as regAti27_, cte29_.ID as ID28_, cte29_.ID_FIL as ID_FIL28_, cte29_.codCte as codCte28_, cte29_.desCte as desCte28_, cte29_.regAti as regAti28_, cte30_.ID as ID29_, cte30_.ID_FIL as ID_FIL29_, cte30_.codCte as codCte29_, cte30_.desCte as desCte29_, cte30_.regAti as regAti29_, cte31_.ID as ID30_, cte31_.ID_FIL as ID_FIL30_, cte31_.codCte as codCte30_, cte31_.desCte as desCte30_, cte31_.regAti as regAti30_, cte32_.ID as ID31_, cte32_.ID_FIL as ID_FIL31_, cte32_.codCte as codCte31_, cte32_.desCte as desCte31_, cte32_.regAti as regAti31_, cte33_.ID as ID32_, cte33_.ID_FIL as ID_FIL32_, cte33_.codCte as codCte32_, cte33_.desCte as desCte32_, cte33_.regAti as regAti32_, cte34_.ID as ID33_, cte34_.ID_FIL as ID_FIL33_, cte34_.codCte as codCte33_, cte34_.desCte as desCte33_, cte34_.regAti as regAti33_, cte35_.ID as ID34_, cte35_.ID_FIL as ID_FIL34_, cte35_.codCte as codCte34_, cte35_.desCte as desCte34_, cte35_.regAti as regAti34_, cte36_.ID as ID35_, cte36_.ID_FIL as ID_FIL35_, cte36_.codCte as codCte35_, cte36_.desCte as desCte35_, cte36_.regAti as regAti35_, cte37_.ID as ID36_, cte37_.ID_FIL as ID_FIL36_, cte37_.codCte as codCte36_, cte37_.desCte as desCte36_, cte37_.regAti as regAti36_, cte38_.ID as ID37_, cte38_.ID_FIL as ID_FIL37_, cte38_.codCte as codCte37_, cte38_.desCte as desCte37_, cte38_.regAti as regAti37_, cte39_.ID as ID38_, cte39_.ID_FIL as ID_FIL38_, cte39_.codCte as codCte38_, cte39_.desCte as desCte38_, cte39_.regAti as regAti38_, cte40_.ID as ID39_, cte40_.ID_FIL as ID_FIL39_, cte40_.codCte as codCte39_, cte40_.desCte as desCte39_, cte40_.regAti as regAti39_, cte41_.ID as ID40_, cte41_.ID_FIL as ID_FIL40_, cte41_.codCte as codCte40_, cte41_.desCte as desCte40_, cte41_.regAti as regAti40_, cte42_.ID as ID41_, cte42_.ID_FIL as ID_FIL41_, cte42_.codCte as codCte41_, cte42_.desCte as desCte41_, cte42_.regAti as regAti41_, fun43_.ID as ID42_, fun43_.ID_FIL as ID_FIL42_, fun43_.nomFun as nomFun42_, fun43_.codExt as codExt42_, fun43_.regAti as regAti42_, prored44_.ID as ID43_, prored44_.ID_FIL as ID_FIL43_, prored44_.codPro as codPro43_, prored44_.diaVal as diaVal43_, prored44_.codBar as codBar43_, prored44_.codRef as codRef43_, prored44_.codExt as codExt43_, prored44_.desAbr as desAbr43_, prored44_.regAti as regAti43_, fun45_.ID as ID44_, fun45_.ID_FIL as ID_FIL44_, fun45_.nomFun as nomFun44_, fun45_.codExt as codExt44_, fun45_.regAti as regAti44_ from TB_BOB bob0_ left outer join TB_BOB bob1_ on bob0_.ID_BOB=bob1_.ID left outer join TB_PRO prored2_ on bob1_.ID_PRO=prored2_.ID left outer join TB_CNF cnf3_ on bob1_.ID_CNF=cnf3_.ID left outer join TB_TPD tpd4_ on cnf3_.ID_TPD=tpd4_.ID left outer join TB_SER ser5_ on cnf3_.ID_SER=ser5_.ID left outer join TB_OPE ope6_ on cnf3_.ID_OPE=ope6_.ID left outer join TB_OPE ope7_ on ope6_.ID_REV=ope7_.ID left outer join TB_LEG leg8_ on ope7_.ID_LEG=leg8_.ID left outer join TB_LEG leg9_ on ope6_.ID_LEG=leg9_.ID left outer join TB_ENT ent10_ on cnf3_.ID_ENT=ent10_.ID left outer join TB_FIS fis11_ on ent10_.ID=fis11_.ID left outer join TB_JUR jur12_ on ent10_.ID=jur12_.ID left outer join TB_CLI cli13_ on ent10_.ID=cli13_.ID left outer join TB_LEG leg14_ on cli13_.ID_LEG=leg14_.ID left outer join TB_SIT sit15_ on cli13_.ID_SIT=sit15_.ID left outer join TB_FNC fnc16_ on ent10_.ID=fnc16_.ID left outer join TB_REP rep17_ on ent10_.ID=rep17_.ID left outer join TB_TRA tra18_ on ent10_.ID=tra18_.ID left outer join TB_USU usu19_ on ent10_.ID=usu19_.ID left outer join TB_POR por20_ on ent10_.ID=por20_.ID left outer join TB_FIL fil21_ on ent10_.ID=fil21_.ID left outer join TB_END end22_ on cnf3_.ID_EEN=end22_.ID left outer join TB_MUN mun23_ on end22_.ID_MUN=mun23_.ID left outer join TB_EST est24_ on mun23_.ID_EST=est24_.ID left outer join TB_ICM icm25_ on est24_.ID_ICM=icm25_.ID left outer join TB_RPA rpa26_ on cnf3_.ID_RPA=rpa26_.ID left outer join TB_SIT sit27_ on cnf3_.ID_SIT=sit27_.ID left outer join TB_CTE cte28_ on cnf3_.ID_C01=cte28_.ID left outer join TB_CTE cte29_ on cnf3_.ID_C02=cte29_.ID left outer join TB_CTE cte30_ on cnf3_.ID_C03=cte30_.ID left outer join TB_CTE cte31_ on cnf3_.ID_C04=cte31_.ID left outer join TB_CTE cte32_ on cnf3_.ID_C05=cte32_.ID left outer join TB_CTE cte33_ on cnf3_.ID_C06=cte33_.ID left outer join TB_CTE cte34_ on cnf3_.ID_C07=cte34_.ID left outer join TB_CTE cte35_ on cnf3_.ID_C08=cte35_.ID left outer join TB_CTE cte36_ on cnf3_.ID_C09=cte36_.ID left outer join TB_CTE cte37_ on cnf3_.ID_C10=cte37_.ID left outer join TB_CTE cte38_ on cnf3_.ID_C11=cte38_.ID left outer join TB_CTE cte39_ on cnf3_.ID_C12=cte39_.ID left outer join TB_CTE cte40_ on cnf3_.ID_C13=cte40_.ID left outer join TB_CTE cte41_ on cnf3_.ID_C14=cte41_.ID left outer join TB_CTE cte42_ on cnf3_.ID_C15=cte42_.ID left outer join TB_FUN fun43_ on bob1_.ID_FUN=fun43_.ID left outer join TB_PRO prored44_ on bob0_.ID_PRO=prored44_.ID left outer join TB_FUN fun45_ on bob0_.ID_FUN=fun45_.ID where bob0_.ID=?
17:14:44,626 INFO [STDOUT] Hibernate: select mbo0_.ID as ID82_, mbo0_.ID_BOB as ID_BOB82_, mbo0_.ID_OSP as ID_OSP82_, mbo0_.datSai as datSai82_, mbo0_.datRet as datRet82_, mbo0_.comSai as comSai82_, mbo0_.comRet as comRet82_, mbo0_.id_fil as id_fil82_, mbo0_.numbob as numbob82_, bob1_.ID as ID0_, bob1_.ID_FIL as ID_FIL0_, bob1_.ID_BOB as ID_BOB0_, bob1_.ID_PRO as ID_PRO0_, bob1_.ID_CNF as ID_CNF0_, bob1_.ID_FUN as ID_FUN0_, bob1_.numBob as numBob0_, bob1_.numOri as numOri0_, bob1_.locBob as locBob0_, bob1_.comBob as comBob0_, bob1_.larBob as larBob0_, bob1_.datVal as datVal0_, bob1_.datCor as datCor0_, bob1_.datSai as datSai0_, bob1_.datRet as datRet0_, bob1_.sitBob as sitBob0_, bob1_.comAtu as comAtu0_, bob1_.graFro as graFro0_, bob1_.espFro as espFro0_, bob1_.graLin as graLin0_, bob1_.espLin as espLin0_, bob1_.adesiv as adesiv0_, bob2_.ID as ID1_, bob2_.ID_FIL as ID_FIL1_, bob2_.ID_BOB as ID_BOB1_, bob2_.ID_PRO as ID_PRO1_, bob2_.ID_CNF as ID_CNF1_, bob2_.ID_FUN as ID_FUN1_, bob2_.numBob as numBob1_, bob2_.numOri as numOri1_, bob2_.locBob as locBob1_, bob2_.comBob as comBob1_, bob2_.larBob as larBob1_, bob2_.datVal as datVal1_, bob2_.datCor as datCor1_, bob2_.datSai as datSai1_, bob2_.datRet as datRet1_, bob2_.sitBob as sitBob1_, bob2_.comAtu as comAtu1_, bob2_.graFro as graFro1_, bob2_.espFro as espFro1_, bob2_.graLin as graLin1_, bob2_.espLin as espLin1_, bob2_.adesiv as adesiv1_, prored3_.ID as ID2_, prored3_.ID_FIL as ID_FIL2_, prored3_.codPro as codPro2_, prored3_.diaVal as diaVal2_, prored3_.codBar as codBar2_, prored3_.codRef as codRef2_, prored3_.codExt as codExt2_, prored3_.desAbr as desAbr2_, prored3_.regAti as regAti2_, cnf4_.ID as ID3_, cnf4_.ID_FIL as ID_FIL3_, cnf4_.ID_TPD as ID_TPD3_, cnf4_.ID_SER as ID_SER3_, cnf4_.ID_OPE as ID_OPE3_, cnf4_.ID_ENT as ID_ENT3_, cnf4_.ID_ERE as ID_ERE3_, cnf4_.ID_ETR as ID_ETR3_, cnf4_.ID_EEN as ID_EEN3_, cnf4_.ID_ECO as ID_ECO3_, cnf4_.ID_EFA as ID_EFA3_, cnf4_.ID_FRE as ID_FRE3_, cnf4_.ID_RPA as ID_RPA3_, cnf4_.tipEmi as tipEmi3_, cnf4_.tipMov as tipMov3_, cnf4_.sitDoc as sitDoc3_, cnf4_.tipFre as tipFre3_, cnf4_.numDoc as numDoc3_, cnf4_.datDoc as datDoc3_, cnf4_.datMov as datMov3_, cnf4_.vlrBru as vlrBru3_, cnf4_.vlrLiq as vlrLiq3_, cnf4_.basIcm as basIcm3_, cnf4_.vlrIcm as vlrIcm3_, cnf4_.basIse as basIse3_, cnf4_.basSub as basSub3_, cnf4_.vlrSub as vlrSub3_, cnf4_.basOut as basOut3_, cnf4_.vlrOut as vlrOut3_, cnf4_.basIpi as basIpi3_, cnf4_.vlrIpi as vlrIpi3_, cnf4_.basIss as basIss3_, cnf4_.perIss as perIss3_, cnf4_.vlrIss as vlrIss3_, cnf4_.basIrr as basIrr3_, cnf4_.basIns as basIns3_, cnf4_.vlrIns as vlrIns3_, cnf4_.vlrIrr as vlrIrr3_, cnf4_.vlrFre as vlrFre3_, cnf4_.vlrSeg as vlrSeg3_, cnf4_.vlrOde as vlrOde3_, cnf4_.vlrEmb as vlrEmb3_, cnf4_.vlrDes as vlrDes3_, cnf4_.perDes as perDes3_, cnf4_.vlrAcr as vlrAcr3_, cnf4_.perAcr as perAcr3_, cnf4_.obsDoc as obsDoc3_, cnf4_.plaVei as plaVei3_, cnf4_.estVei as estVei3_, cnf4_.espVol as espVol3_, cnf4_.marVol as marVol3_, cnf4_.numVol as numVol3_, cnf4_.qtdVol as qtdVol3_, cnf4_.pesBru as pesBru3_, cnf4_.pesLiq as pesLiq3_, cnf4_.movEst as movEst3_, cnf4_.movFin as movFin3_, cnf4_.conFin as conFin3_, cnf4_.vlrCom as vlrCom3_, cnf4_.ID_SIT as ID_SIT3_, cnf4_.ID_POR as ID_POR3_, cnf4_.datEmb as datEmb3_, cnf4_.tipSit as tipSit3_, cnf4_.tipTip as tipTip3_, cnf4_.pagFil as pagFil3_, cnf4_.escFis as escFis3_, cnf4_.codFis as codFis3_, cnf4_.vlrMat as vlrMat3_, cnf4_.vlrDev as vlrDev3_, cnf4_.ID_C01 as ID_C013_, cnf4_.ID_C02 as ID_C023_, cnf4_.ID_C03 as ID_C033_, cnf4_.ID_C04 as ID_C043_, cnf4_.ID_C05 as ID_C053_, cnf4_.ID_C06 as ID_C063_, cnf4_.ID_C07 as ID_C073_, cnf4_.ID_C08 as ID_C083_, cnf4_.ID_C09 as ID_C093_, cnf4_.ID_C10 as ID_C103_, cnf4_.ID_C11 as ID_C113_, cnf4_.ID_C12 as ID_C123_, cnf4_.ID_C13 as ID_C133_, cnf4_.ID_C14 as ID_C143_, cnf4_.ID_C15 as ID_C153_, cnf4_.basDif as basDif3_, cnf4_.perDif as perDif3_, cnf4_.vlrDif as vlrDif3_, tpd5_.ID as ID4_, tpd5_.codTpd as codTpd4_, tpd5_.desTpd as desTpd4_, tpd5_.regAti as regAti4_, ser6_.ID as ID5_, ser6_.desSer as desSer5_, ser6_.regAti as regAti5_, ope7_.ID as ID6_, ope7_.codOpe as codOpe6_, ope7_.ID_REV as ID_REV6_, ope7_.desOpe as desOpe6_, ope7_.lanEst as lanEst6_, ope7_.lanFin as lanFin6_, ope7_.regAti as regAti6_, ope7_.emiDoc as emiDoc6_, ope7_.conDev as conDev6_, ope7_.calCus as calCus6_, ope7_.diaPra as diaPra6_, ope7_.ID_LEG as ID_LEG6_, ope8_.ID as ID7_, ope8_.codOpe as codOpe7_, ope8_.ID_REV as ID_REV7_, ope8_.desOpe as desOpe7_, ope8_.lanEst as lanEst7_, ope8_.lanFin as lanFin7_, ope8_.regAti as regAti7_, ope8_.emiDoc as emiDoc7_, ope8_.conDev as conDev7_, ope8_.calCus as calCus7_, ope8_.diaPra as diaPra7_, ope8_.ID_LEG as ID_LEG7_, leg9_.ID as ID8_, leg9_.desLeg as desLeg8_, leg9_.ID_FIL as ID_FIL8_, leg9_.txtLeg as txtLeg8_, leg9_.codExt as codExt8_, leg10_.ID as ID9_, leg10_.desLeg as desLeg9_, leg10_.ID_FIL as ID_FIL9_, leg10_.txtLeg as txtLeg9_, leg10_.codExt as codExt9_, ent11_.ID as ID10_, ent11_.tipEnt as tipEnt10_, ent11_.nomEnt as nomEnt10_, ent11_.regAti as regAti10_, ent11_.fabExt as fabExt10_, fis12_.ID as ID11_, fis12_.nomPai as nomPai11_, fis12_.nomMae as nomMae11_, fis12_.datNas as datNas11_, fis12_.E_MAIL as E_MAIL11_, fis12_.refCo1 as refCo111_, fis12_.refCo2 as refCo211_, fis12_.refCo3 as refCo311_, fis12_.refFo1 as refFo111_, fis12_.refFo2 as refFo211_, fis12_.refFo3 as refFo311_, jur13_.ID as ID12_, jur13_.numMun as numMun12_, jur13_.datFun as datFun12_, jur13_.END_HP as END_HP12_, jur13_.nomFan as nomFan12_, cli14_.ID as ID13_, cli14_.codExt as codExt13_, cli14_.cliBlo as cliBlo13_, cli14_.usaCer as usaCer13_, cli14_.ID_LEG as ID_LEG13_, cli14_.conFin as conFin13_, cli14_.tipFre as tipFre13_, cli14_.ID_SIT as ID_SIT13_, cli14_.vlrLim as vlrLim13_, cli14_.vlrAbe as vlrAbe13_, cli14_.difere as difere13_, leg15_.ID as ID14_, leg15_.desLeg as desLeg14_, leg15_.ID_FIL as ID_FIL14_, leg15_.txtLeg as txtLeg14_, leg15_.codExt as codExt14_, sit16_.ID as ID15_, sit16_.desSit as desSit15_, sit16_.regAti as regAti15_, fnc17_.ID as ID16_, fnc17_.codExt as codExt16_, fnc17_.regAti as regAti16_, rep18_.ID as ID17_, rep18_.codExt as codExt17_, rep18_.comFat as comFat17_, rep18_.comLiq as comLiq17_, rep18_.regAti as regAti17_, tra19_.ID as ID18_, tra19_.codExt as codExt18_, tra19_.regAti as regAti18_, usu20_.ID as ID19_, usu20_.codExt as codExt19_, usu20_.senUsu as senUsu19_, usu20_.nomLog as nomLog19_, usu20_.regAti as regAti19_, por21_.ID as ID20_, por21_.codExt as codExt20_, por21_.regAti as regAti20_, fil22_.ID as ID21_, fil22_.codExt as codExt21_, fil22_.sufFil as sufFil21_, fil22_.regAti as regAti21_, end23_.ID as ID22_, end23_.endCob as endCob22_, end23_.endCor as endCor22_, end23_.codCep as codCep22_, end23_.codLog as codLog22_, end23_.tipEnd as tipEnd22_, end23_.desEnd as desEnd22_, end23_.comEnd as comEnd22_, end23_.baiEnd as baiEnd22_, end23_.numEnd as numEnd22_, end23_.DDDFon as DDDFon22_, end23_.numFon as numFon22_, end23_.DDDFax as DDDFax22_, end23_.numFax as numFax22_, end23_.ID_ENT as ID_ENT22_, end23_.ID_MUN as ID_MUN22_, end23_.nrDoc1 as nrDoc122_, end23_.nrDoc2 as nrDoc222_, mun24_.ID as ID23_, mun24_.cepIni as cepIni23_, mun24_.cepFin as cepFin23_, mun24_.nomMun as nomMun23_, mun24_.ID_EST as ID_EST23_, est25_.ID as ID24_, est25_.uniFed as uniFed24_, est25_.nomEst as nomEst24_, est25_.ID_ICM as ID_ICM24_, icm26_.ID as ID25_, icm26_.desIcm as desIcm25_, icm26_.codTri as codTri25_, icm26_.perIcm as perIcm25_, icm26_.perRed as perRed25_, rpa27_.ID as ID26_, rpa27_.ID_FIL as ID_FIL26_, rpa27_.ID_TRA as ID_TRA26_, rpa27_.ID_EST as ID_EST26_, rpa27_.numRpa as numRpa26_, rpa27_.datRpa as datRpa26_, rpa27_.vlrRpa as vlrRpa26_, rpa27_.perIcm as perIcm26_, rpa27_.vlrIcm as vlrIcm26_, rpa27_.plaVei as plaVei26_, sit28_.ID as ID27_, sit28_.desSit as desSit27_, sit28_.regAti as regAti27_, cte29_.ID as ID28_, cte29_.ID_FIL as ID_FIL28_, cte29_.codCte as codCte28_, cte29_.desCte as desCte28_, cte29_.regAti as regAti28_, cte30_.ID as ID29_, cte30_.ID_FIL as ID_FIL29_, cte30_.codCte as codCte29_, cte30_.desCte as desCte29_, cte30_.regAti as regAti29_, cte31_.ID as ID30_, cte31_.ID_FIL as ID_FIL30_, cte31_.codCte as codCte30_, cte31_.desCte as desCte30_, cte31_.regAti as regAti30_, cte32_.ID as ID31_, cte32_.ID_FIL as ID_FIL31_, cte32_.codCte as codCte31_, cte32_.desCte as desCte31_, cte32_.regAti as regAti31_, cte33_.ID as ID32_, cte33_.ID_FIL as ID_FIL32_, cte33_.codCte as codCte32_, cte33_.desCte as desCte32_, cte33_.regAti as regAti32_, cte34_.ID as ID33_, cte34_.ID_FIL as ID_FIL33_, cte34_.codCte as codCte33_, cte34_.desCte as desCte33_, cte34_.regAti as regAti33_, cte35_.ID as ID34_, cte35_.ID_FIL as ID_FIL34_, cte35_.codCte as codCte34_, cte35_.desCte as desCte34_, cte35_.regAti as regAti34_, cte36_.ID as ID35_, cte36_.ID_FIL as ID_FIL35_, cte36_.codCte as codCte35_, cte36_.desCte as desCte35_, cte36_.regAti as regAti35_, cte37_.ID as ID36_, cte37_.ID_FIL as ID_FIL36_, cte37_.codCte as codCte36_, cte37_.desCte as desCte36_, cte37_.regAti as regAti36_, cte38_.ID as ID37_, cte38_.ID_FIL as ID_FIL37_, cte38_.codCte as codCte37_, cte38_.desCte as desCte37_, cte38_.regAti as regAti37_, cte39_.ID as ID38_, cte39_.ID_FIL as ID_FIL38_, cte39_.codCte as codCte38_, cte39_.desCte as desCte38_, cte39_.regAti as regAti38_, cte40_.ID as ID39_, cte40_.ID_FIL as ID_FIL39_, cte40_.codCte as codCte39_, cte40_.desCte as desCte39_, cte40_.regAti as regAti39_, cte41_.ID as ID40_, cte41_.ID_FIL as ID_FIL40_, cte41_.codCte as codCte40_, cte41_.desCte as desCte40_, cte41_.regAti as regAti40_, cte42_.ID as ID41_, cte42_.ID_FIL as ID_FIL41_, cte42_.codCte as codCte41_, cte42_.desCte as desCte41_, cte42_.regAti as regAti41_, cte43_.ID as ID42_, cte43_.ID_FIL as ID_FIL42_, cte43_.codCte as codCte42_, cte43_.desCte as desCte42_, cte43_.regAti as regAti42_, fun44_.ID as ID43_, fun44_.ID_FIL as ID_FIL43_, fun44_.nomFun as nomFun43_, fun44_.codExt as codExt43_, fun44_.regAti as regAti43_, prored45_.ID as ID44_, prored45_.ID_FIL as ID_FIL44_, prored45_.codPro as codPro44_, prored45_.diaVal as diaVal44_, prored45_.codBar as codBar44_, prored45_.codRef as codRef44_, prored45_.codExt as codExt44_, prored45_.desAbr as desAbr44_, prored45_.regAti as regAti44_, fun46_.ID as ID45_, fun46_.ID_FIL as ID_FIL45_, fun46_.nomFun as nomFun45_, fun46_.codExt as codExt45_, fun46_.regAti as regAti45_, osp47_.ID as ID46_, case when osp47__1_.ID is not null then 1 when osp47__2_.ID is not null then 2 when osp47_.ID is not null then 0 end as clazz_46_, osp47_.ID_CLI as ID_CLI14_46_, osp47_.numOsp as numOsp14_46_, osp47_.datOsp as datOsp14_46_, osp47_.datEtg as datEtg14_46_, osp47_.ID_FIL as ID_FIL14_46_, osp47_.ID_MOD as ID_MOD14_46_, osp47_.desMod as desMod14_46_, osp47_.ID_UNI as ID_UNI14_46_, osp47_.datPro as datPro14_46_, osp47_.ID_MAQ as ID_MAQ14_46_, osp47_.ID_FAC as ID_FAC14_46_, osp47_.ID_PR1 as ID_PR114_46_, osp47_.ID_PR2 as ID_PR214_46_, osp47_.ID_PR3 as ID_PR314_46_, osp47_.ID_EMB as ID_EMB14_46_, osp47_.ID_CRT as ID_CRT14_46_, osp47_.qtdEmb as qtdEmb14_46_, osp47_.tipBob as tipBob14_46_, osp47_.tipSer as tipSer14_46_, osp47_.tipApl as tipApl14_46_, osp47_.artSer as artSer14_46_, osp47_.artAlt as artAlt14_46_, osp47_.corMat as corMat14_46_, osp47_.medCom as medCom14_46_, osp47_.medLar as medLar14_46_, osp47_.ID_IPI as ID_IPI14_46_, osp47_.ID_REP as ID_REP14_46_, osp47_.perCom as perCom14_46_, osp47_.fatCor as fatCor14_46_, osp47_.diaPr1 as diaPr114_46_, osp47_.diaPr2 as diaPr214_46_, osp47_.diaPr3 as diaPr314_46_, osp47_.diaPr4 as diaPr414_46_, osp47_.vlrUni as vlrUni14_46_, osp47_.numOrd as numOrd14_46_, osp47_.pedRep as pedRep14_46_, osp47_.obsMod as obsMod14_46_, osp47__1_.ID_FAM as ID_FAM13_46_, osp47__1_.desAce as desAce13_46_, osp47__1_.desPro as desPro13_46_, osp47__1_.endArt as endArt13_46_, osp47__1_.corFle as corFle13_46_, osp47__1_.corLet as corLet13_46_, osp47__1_.corOff as corOff13_46_, osp47__1_.corSil as corSil13_46_, osp47__1_.pintad as pintad13_46_, osp47__1_.qtdCai as qtdCai13_46_, osp47__1_.tipRot as tipRot13_46_, osp47__1_.tipVer as tipVer13_46_, osp47__1_.cilind as cilind13_46_, osp47__1_.lamina as lamina13_46_, osp47__1_.pesUni as pesUni13_46_, osp47__1_.entAlm as entAlm13_46_, osp47__1_.saiAlm as saiAlm13_46_, osp47__1_.obsAlm as obsAlm13_46_, osp47__1_.entImp as entImp13_46_, osp47__1_.saiImp as saiImp13_46_, osp47__1_.obsImp as obsImp13_46_, osp47__1_.entAca as entAca13_46_, osp47__1_.saiAca as saiAca13_46_, osp47__1_.obsAca as obsAca13_46_, osp47__1_.entIns as entIns13_46_, osp47__1_.saiIns as saiIns13_46_, osp47__1_.obsIns as obsIns13_46_, osp47__2_.corImp as corImp80_46_, osp47__2_.tipFor as tipFor80_46_, osp47__2_.numCol as numCol80_46_, osp47__2_.tipPin as tipPin80_46_, osp47__2_.numSet as numSet80_46_, osp47__2_.tipEmb as tipEmb80_46_, osp47__2_.tipImp as tipImp80_46_, osp47__2_.tipTub as tipTub80_46_, osp47__2_.avaMon as avaMon80_46_, osp47__2_.comMon as comMon80_46_, osp47__2_.larMon as larMon80_46_, osp47__2_.larPap as larPap80_46_, osp47__2_.espCol as espCol80_46_, osp47__2_.nuRaio as nuRaio80_46_, osp47__2_.larSol as larSol80_46_, osp47__2_.larMaq as larMaq80_46_, osp47__2_.numAmg as numAmg80_46_, osp47__2_.obsVen as obsVen80_46_, osp47__2_.flgCli as flgCli80_46_, osp47__2_.datCli as datCli80_46_, osp47__2_.ID_FCL as ID_FCL80_46_, osp47__2_.lg1Cli as lg1Cli80_46_, osp47__2_.lg2Cli as lg2Cli80_46_, osp47__2_.flgFac as flgFac80_46_, osp47__2_.datFac as datFac80_46_, osp47__2_.ID_FFC as ID_FFC80_46_, osp47__2_.lg1Fac as lg1Fac80_46_, osp47__2_.lg2Fac as lg2Fac80_46_, osp47__2_.flgTin as flgTin80_46_, osp47__2_.datTin as datTin80_46_, osp47__2_.ID_FTI as ID_FTI80_46_, osp47__2_.lg1Tin as lg1Tin80_46_, osp47__2_.lg2Tin as lg2Tin80_46_, osp47__2_.ID_EMQ as ID_EMQ80_46_, osp47__2_.datMaq as datMaq80_46_, osp47__2_.ID_FMQ as ID_FMQ80_46_, osp47__2_.lg1Maq as lg1Maq80_46_, osp47__2_.lg2Maq as lg2Maq80_46_, osp47__2_.flgPrc as flgPrc80_46_, osp47__2_.datPrc as datPrc80_46_, osp47__2_.ID_FPR as ID_FPR80_46_, osp47__2_.flgReb as flgReb80_46_, osp47__2_.datReb as datReb80_46_, osp47__2_.ID_FRB as ID_FRB80_46_, osp47__2_.flgIns as flgIns80_46_, osp47__2_.datIns as datIns80_46_, osp47__2_.ID_FIS as ID_FIS80_46_, osp47__2_.flgPar as flgPar80_46_, osp47__2_.datPar as datPar80_46_, osp47__2_.ID_FPA as ID_FPA80_46_, osp47__2_.flgAca as flgAca80_46_, osp47__2_.datAca as datAca80_46_, osp47__2_.ID_FCA as ID_FCA80_46_, mod48_.ID as ID47_, case when mod48__1_.ID is not null then 1 when mod48__2_.ID is not null then 2 when mod48_.ID is not null then 0 end as clazz_47_, mod48_.ID_FIL as ID_FIL20_47_, mod48_.ID_CLI as ID_CLI20_47_, mod48_.ID_PRO as ID_PRO20_47_, mod48_.ID_MAQ as ID_MAQ20_47_, mod48_.ID_FAC as ID_FAC20_47_, mod48_.ID_PR1 as ID_PR120_47_, mod48_.ID_PR2 as ID_PR220_47_, mod48_.ID_PR3 as ID_PR320_47_, mod48_.ID_EMB as ID_EMB20_47_, mod48_.ID_CRT as ID_CRT20_47_, mod48_.ID_IPI as ID_IPI20_47_, mod48_.ID_REP as ID_REP20_47_, mod48_.numMod as numMod20_47_, mod48_.tipBob as tipBob20_47_, mod48_.tipSer as tipSer20_47_, mod48_.tipApl as tipApl20_47_, mod48_.corMat as corMat20_47_, mod48_.fatCor as fatCor20_47_, mod48_.perCom as perCom20_47_, mod48_.diaPr1 as diaPr120_47_, mod48_.diaPr2 as diaPr220_47_, mod48_.diaPr3 as diaPr320_47_, mod48_.diaPr4 as diaPr420_47_, mod48_.obsMod as obsMod20_47_, mod48_.regAti as regAti20_47_, mod48_.ordImp as ordImp20_47_, mod48_.qtdCai as qtdCai20_47_, mod48_.pesUni as pesUni20_47_, mod48__1_.ID_FAM as ID_FAM39_47_, mod48__1_.ID_LEG as ID_LEG39_47_, mod48__1_.desAce as desAce39_47_, mod48__1_.desPro as desPro39_47_, mod48__1_.endArt as endArt39_47_, mod48__1_.corFle as corFle39_47_, mod48__1_.corLet as corLet39_47_, mod48__1_.corOff as corOff39_47_, mod48__1_.corSil as corSil39_47_, mod48__1_.pintad as pintad39_47_, mod48__1_.tipRot as tipRot39_47_, mod48__1_.tipVer as tipVer39_47_, mod48__1_.cilind as cilind39_47_, mod48__1_.lamina as lamina39_47_, mod48__1_.numOrc as numOrc39_47_, mod48__2_.ID_PIN as ID_PIN40_47_, mod48__2_.ID_PRH as ID_PRH40_47_, mod48__2_.ID_PRT as ID_PRT40_47_, mod48__2_.ID_PRV as ID_PRV40_47_, mod48__2_.corImp as corImp40_47_, mod48__2_.tipFor as tipFor40_47_, mod48__2_.numCol as numCol40_47_, mod48__2_.tipPin as tipPin40_47_, mod48__2_.numSet as numSet40_47_, mod48__2_.tipEmb as tipEmb40_47_, mod48__2_.tipImp as tipImp40_47_, mod48__2_.tipTub as tipTub40_47_, mod48__2_.vlrFer as vlrFer40_47_, mod48__2_.avaMon as avaMon40_47_, mod48__2_.comMon as comMon40_47_, mod48__2_.larMon as larMon40_47_, mod48__2_.larPap as larPap40_47_, mod48__2_.vlrUnf as vlrUnf40_47_, mod48__2_.fatRnf as fatRnf40_47_, mod48__2_.qtdCor as qtdCor40_47_, mod48__2_.espCol as espCol40_47_, mod48__2_.nuRaio as nuRaio40_47_, mod48__2_.larSol as larSol40_47_, mod48__2_.larMaq as larMaq40_47_, mod48__2_.numAmg as numAmg40_47_, pro49_.ID as ID48_, pro49_.ID_FIL as ID_FIL48_, pro49_.ID_SUB as ID_SUB48_, pro49_.ID_UNP as ID_UNP48_, pro49_.ID_UNC as ID_UNC48_, pro49_.ID_UNV as ID_UNV48_, pro49_.ID_IPI as ID_IPI48_, pro49_.ID_ICM as ID_ICM48_, pro49_.ID_DES as ID_DES48_, pro49_.ID_LEG as ID_LEG48_, pro49_.ID_ENM as ID_ENM48_, pro49_.ID_CCP as ID_CCP48_, pro49_.codPro as codPro48_, pro49_.codBar as codBar48_, pro49_.codRef as codRef48_, pro49_.codExt as codExt48_, pro49_.desAbr as desAbr48_, pro49_.desLon as desLon48_, pro49_.aplica as aplica48_, pro49_.camImg as camImg48_, pro49_.codOri as codOri48_, pro49_.codCst as codCst48_, pro49_.proVen as proVen48_, pro49_.proLis as proLis48_, pro49_.diaMin as diaMin48_, pro49_.diaMax as diaMax48_, pro49_.qtdMin as qtdMin48_, pro49_.qtdMax as qtdMax48_, pro49_.qtdEmb as qtdEmb48_, pro49_.salQtd as salQtd48_, pro49_.qtdPre as qtdPre48_, pro49_.salVlr as salVlr48_, pro49_.salIcm as salIcm48_, pro49_.salIpi as salIpi48_, pro49_.salAdc as salAdc48_, pro49_.perLuc as perLuc48_, pro49_.vlrRep as vlrRep48_, pro49_.vlrCus as vlrCus48_, pro49_.vlrMed as vlrMed48_, pro49_.locali as locali48_, pro49_.perCof as perCof48_, pro49_.perCol as perCol48_, pro49_.diaVal as diaVal48_, pro49_.comPro as comPro48_, pro49_.larPro as larPro48_, pro49_.altPro as altPro48_, pro49_.pesLiq as pesLiq48_, pro49_.pesBru as pesBru48_, pro49_.vlrVen as vlrVen48_, pro49_.proKit as proKit48_, pro49_.regAti as regAti48_, pro49_.proBob as proBob48_, pro49_.matPri as matPri48_, maq50_.ID as ID49_, maq50_.ID_FIL as ID_FIL49_, maq50_.codMaq as codMaq49_, maq50_.desMaq as desMaq49_, fac51_.ID as ID50_, fac51_.ID_FIL as ID_FIL50_, fac51_.ID_MAQ as ID_MAQ50_, fac51_.codFac as codFac50_, fac51_.desFac as desFac50_, fac51_.larFac as larFac50_, fac51_.comFac as comFac50_, fac51_.larMon as larMon50_, fac51_.comMon as comMon50_, fac51_.larPap as larPap50_, fac51_.avaMon as avaMon50_, fac51_.espCol as espCol50_, fac51_.numRai as numRai50_, fac51_.larSol as larSol50_, fac51_.larMaq as larMaq50_, fac51_.larPro as larPro50_, fac51_.monHst as monHst50_, fac51_.cilind as cilind50_, maq52_.ID as ID51_, maq52_.ID_FIL as ID_FIL51_, maq52_.codMaq as codMaq51_, maq52_.desMaq as desMaq51_, prored53_.ID as ID52_, prored53_.ID_FIL as ID_FIL52_, prored53_.codPro as codPro52_, prored53_.diaVal as diaVal52_, prored53_.codBar as codBar52_, prored53_.codRef as codRef52_, prored53_.codExt as codExt52_, prored53_.desAbr as desAbr52_, prored53_.regAti as regAti52_, prored54_.ID as ID53_, prored54_.ID_FIL as ID_FIL53_, prored54_.codPro as codPro53_, prored54_.diaVal as diaVal53_, prored54_.codBar as codBar53_, prored54_.codRef as codRef53_, prored54_.codExt as codExt53_, prored54_.desAbr as desAbr53_, prored54_.regAti as regAti53_, prored55_.ID as ID54_, prored55_.ID_FIL as ID_FIL54_, prored55_.codPro as codPro54_, prored55_.diaVal as diaVal54_, prored55_.codBar as codBar54_, prored55_.codRef as codRef54_, prored55_.codExt as codExt54_, prored55_.desAbr as desAbr54_, prored55_.regAti as regAti54_, prored56_.ID as ID55_, prored56_.ID_FIL as ID_FIL55_, prored56_.codPro as codPro55_, prored56_.diaVal as diaVal55_, prored56_.codBar as codBar55_, prored56_.codRef as codRef55_, prored56_.codExt as codExt55_, prored56_.desAbr as desAbr55_, prored56_.regAti as regAti55_, crt57_.ID as ID56_, crt57_.ID_FIL as ID_FIL56_, crt57_.codRec as codRec56_, crt57_.codCor as codCor56_, crt57_.nomTin as nomTin56_, crt57_.ID_MAQ as ID_MAQ56_, crt57_.tipImp as tipImp56_, crt57_.graM2 as graM256_, crt57_.quaM2 as quaM256_, maq58_.ID as ID57_, maq58_.ID_FIL as ID_FIL57_, maq58_.codMaq as codMaq57_, maq58_.desMaq as desMaq57_, ipi59_.ID as ID58_, ipi59_.desIpi as desIpi58_, ipi59_.desNcm as desNcm58_, ipi59_.claIpi as claIpi58_, ipi59_.codExt as codExt58_, ipi59_.perIpi as perIpi58_, ipi59_.ID_LEG as ID_LEG58_, leg60_.ID as ID59_, leg60_.desLeg as desLeg59_, leg60_.ID_FIL as ID_FIL59_, leg60_.txtLeg as txtLeg59_, leg60_.codExt as codExt59_, fam61_.ID as ID60_, fam61_.ID_FIL as ID_FIL60_, fam61_.codFam as codFam60_, fam61_.desFam as desFam60_, fam61_.regAti as regAti60_, leg62_.ID as ID61_, leg62_.desLeg as desLeg61_, leg62_.ID_FIL as ID_FIL61_, leg62_.txtLeg as txtLeg61_, leg62_.codExt as codExt61_, prored63_.ID as ID62_, prored63_.ID_FIL as ID_FIL62_, prored63_.codPro as codPro62_, prored63_.diaVal as diaVal62_, prored63_.codBar as codBar62_, prored63_.codRef as codRef62_, prored63_.codExt as codExt62_, prored63_.desAbr as desAbr62_, prored63_.regAti as regAti62_, prored64_.ID as ID63_, prored64_.ID_FIL as ID_FIL63_, prored64_.codPro as codPro63_, prored64_.diaVal as diaVal63_, prored64_.codBar as codBar63_, prored64_.codRef as codRef63_, prored64_.codExt as codExt63_, prored64_.desAbr as desAbr63_, prored64_.regAti as regAti63_, prored65_.ID as ID64_, prored65_.ID_FIL as ID_FIL64_, prored65_.codPro as codPro64_, prored65_.diaVal as diaVal64_, prored65_.codBar as codBar64_, prored65_.codRef as codRef64_, prored65_.codExt as codExt64_, prored65_.desAbr as desAbr64_, prored65_.regAti as regAti64_, uni66_.ID as ID65_, uni66_.desUni as desUni65_, uni66_.abrUni as abrUni65_, maq67_.ID as ID66_, maq67_.ID_FIL as ID_FIL66_, maq67_.codMaq as codMaq66_, maq67_.desMaq as desMaq66_, prored68_.ID as ID67_, prored68_.ID_FIL as ID_FIL67_, prored68_.codPro as codPro67_, prored68_.diaVal as diaVal67_, prored68_.codBar as codBar67_, prored68_.codRef as codRef67_, prored68_.codExt as codExt67_, prored68_.desAbr as desAbr67_, prored68_.regAti as regAti67_, prored69_.ID as ID68_, prored69_.ID_FIL as ID_FIL68_, prored69_.codPro as codPro68_, prored69_.diaVal as diaVal68_, prored69_.codBar as codBar68_, prored69_.codRef as codRef68_, prored69_.codExt as codExt68_, prored69_.desAbr as desAbr68_, prored69_.regAti as regAti68_, prored70_.ID as ID69_, prored70_.ID_FIL as ID_FIL69_, prored70_.codPro as codPro69_, prored70_.diaVal as diaVal69_, prored70_.codBar as codBar69_, prored70_.codRef as codRef69_, prored70_.codExt as codExt69_, prored70_.desAbr as desAbr69_, prored70_.regAti as regAti69_, prored71_.ID as ID70_, prored71_.ID_FIL as ID_FIL70_, prored71_.codPro as codPro70_, prored71_.diaVal as diaVal70_, prored71_.codBar as codBar70_, prored71_.codRef as codRef70_, prored71_.codExt as codExt70_, prored71_.desAbr as desAbr70_, prored71_.regAti as regAti70_, fam72_.ID as ID71_, fam72_.ID_FIL as ID_FIL71_, fam72_.codFam as codFam71_, fam72_.desFam as desFam71_, fam72_.regAti as regAti71_, fun73_.ID as ID72_, fun73_.ID_FIL as ID_FIL72_, fun73_.nomFun as nomFun72_, fun73_.codExt as codExt72_, fun73_.regAti as regAti72_, fun74_.ID as ID73_, fun74_.ID_FIL as ID_FIL73_, fun74_.nomFun as nomFun73_, fun74_.codExt as codExt73_, fun74_.regAti as regAti73_, fun75_.ID as ID74_, fun75_.ID_FIL as ID_FIL74_, fun75_.nomFun as nomFun74_, fun75_.codExt as codExt74_, fun75_.regAti as regAti74_, maq76_.ID as ID75_, maq76_.ID_FIL as ID_FIL75_, maq76_.codMaq as codMaq75_, maq76_.desMaq as desMaq75_, fun77_.ID as ID76_, fun77_.ID_FIL as ID_FIL76_, fun77_.nomFun as nomFun76_, fun77_.codExt as codExt76_, fun77_.regAti as regAti76_, fun78_.ID as ID77_, fun78_.ID_FIL as ID_FIL77_, fun78_.nomFun as nomFun77_, fun78_.codExt as codExt77_, fun78_.regAti as regAti77_, fun79_.ID as ID78_, fun79_.ID_FIL as ID_FIL78_, fun79_.nomFun as nomFun78_, fun79_.codExt as codExt78_, fun79_.regAti as regAti78_, fun80_.ID as ID79_, fun80_.ID_FIL as ID_FIL79_, fun80_.nomFun as nomFun79_, fun80_.codExt as codExt79_, fun80_.regAti as regAti79_, fun81_.ID as ID80_, fun81_.ID_FIL as ID_FIL80_, fun81_.nomFun as nomFun80_, fun81_.codExt as codExt80_, fun81_.regAti as regAti80_, fun82_.ID as ID81_, fun82_.ID_FIL as ID_FIL81_, fun82_.nomFun as nomFun81_, fun82_.codExt as codExt81_, fun82_.regAti as regAti81_ from TB_MBO mbo0_ left outer join TB_BOB bob1_ on mbo0_.ID_BOB=bob1_.ID left outer join TB_BOB bob2_ on bob1_.ID_BOB=bob2_.ID left outer join TB_PRO prored3_ on bob2_.ID_PRO=prored3_.ID left outer join TB_CNF cnf4_ on bob2_.ID_CNF=cnf4_.ID left outer join TB_TPD tpd5_ on cnf4_.ID_TPD=tpd5_.ID left outer join TB_SER ser6_ on cnf4_.ID_SER=ser6_.ID left outer join TB_OPE ope7_ on cnf4_.ID_OPE=ope7_.ID left outer join TB_OPE ope8_ on ope7_.ID_REV=ope8_.ID left outer join TB_LEG leg9_ on ope8_.ID_LEG=leg9_.ID left outer join TB_LEG leg10_ on ope7_.ID_LEG=leg10_.ID left outer join TB_ENT ent11_ on cnf4_.ID_ENT=ent11_.ID left outer join TB_FIS fis12_ on ent11_.ID=fis12_.ID left outer join TB_JUR jur13_ on ent11_.ID=jur13_.ID left outer join TB_CLI cli14_ on ent11_.ID=cli14_.ID left outer join TB_LEG leg15_ on cli14_.ID_LEG=leg15_.ID left outer join TB_SIT sit16_ on cli14_.ID_SIT=sit16_.ID left outer join TB_FNC fnc17_ on ent11_.ID=fnc17_.ID left outer join TB_REP rep18_ on ent11_.ID=rep18_.ID left outer join TB_TRA tra19_ on ent11_.ID=tra19_.ID left outer join TB_USU usu20_ on ent11_.ID=usu20_.ID left outer join TB_POR por21_ on ent11_.ID=por21_.ID left outer join TB_FIL fil22_ on ent11_.ID=fil22_.ID left outer join TB_END end23_ on cnf4_.ID_EEN=end23_.ID left outer join TB_MUN mun24_ on end23_.ID_MUN=mun24_.ID left outer join TB_EST est25_ on mun24_.ID_EST=est25_.ID left outer join TB_ICM icm26_ on est25_.ID_ICM=icm26_.ID left outer join TB_RPA rpa27_ on cnf4_.ID_RPA=rpa27_.ID left outer join TB_SIT sit28_ on cnf4_.ID_SIT=sit28_.ID left outer join TB_CTE cte29_ on cnf4_.ID_C01=cte29_.ID left outer join TB_CTE cte30_ on cnf4_.ID_C02=cte30_.ID left outer join TB_CTE cte31_ on cnf4_.ID_C03=cte31_.ID left outer join TB_CTE cte32_ on cnf4_.ID_C04=cte32_.ID left outer join TB_CTE cte33_ on cnf4_.ID_C05=cte33_.ID left outer join TB_CTE cte34_ on cnf4_.ID_C06=cte34_.ID left outer join TB_CTE cte35_ on cnf4_.ID_C07=cte35_.ID left outer join TB_CTE cte36_ on cnf4_.ID_C08=cte36_.ID left outer join TB_CTE cte37_ on cnf4_.ID_C09=cte37_.ID left outer join TB_CTE cte38_ on cnf4_.ID_C10=cte38_.ID left outer join TB_CTE cte39_ on cnf4_.ID_C11=cte39_.ID left outer join TB_CTE cte40_ on cnf4_.ID_C12=cte40_.ID left outer join TB_CTE cte41_ on cnf4_.ID_C13=cte41_.ID left outer join TB_CTE cte42_ on cnf4_.ID_C14=cte42_.ID left outer join TB_CTE cte43_ on cnf4_.ID_C15=cte43_.ID left outer join TB_FUN fun44_ on bob2_.ID_FUN=fun44_.ID left outer join TB_PRO prored45_ on bob1_.ID_PRO=prored45_.ID left outer join TB_FUN fun46_ on bob1_.ID_FUN=fun46_.ID left outer join TB_OSP osp47_ on mbo0_.ID_OSP=osp47_.ID left outer join TB_OSPLAB osp47__1_ on osp47_.ID=osp47__1_.ID left outer join TB_OSPBIE osp47__2_ on osp47_.ID=osp47__2_.ID left outer join TB_MOD mod48_ on osp47_.ID_MOD=mod48_.ID left outer join TB_MODLAB mod48__1_ on mod48_.ID=mod48__1_.ID left outer join TB_MODBIE mod48__2_ on mod48_.ID=mod48__2_.ID left outer join TB_PRO pro49_ on mod48_.ID_PRO=pro49_.ID left outer join TB_MAQ maq50_ on mod48_.ID_MAQ=maq50_.ID left outer join TB_FAC fac51_ on mod48_.ID_FAC=fac51_.ID left outer join TB_MAQ maq52_ on fac51_.ID_MAQ=maq52_.ID left outer join TB_PRO prored53_ on mod48_.ID_PR1=prored53_.ID left outer join TB_PRO prored54_ on mod48_.ID_PR2=prored54_.ID left outer join TB_PRO prored55_ on mod48_.ID_PR3=prored55_.ID left outer join TB_PRO prored56_ on mod48_.ID_EMB=prored56_.ID left outer join TB_CRT crt57_ on mod48_.ID_CRT=crt57_.ID left outer join TB_MAQ maq58_ on crt57_.ID_MAQ=maq58_.ID left outer join TB_IPI ipi59_ on mod48_.ID_IPI=ipi59_.ID left outer join TB_LEG leg60_ on ipi59_.ID_LEG=leg60_.ID left outer join TB_FAM fam61_ on mod48__1_.ID_FAM=fam61_.ID left outer join TB_LEG leg62_ on mod48__1_.ID_LEG=leg62_.ID left outer join TB_PRO prored63_ on mod48__2_.ID_PRH=prored63_.ID left outer join TB_PRO prored64_ on mod48__2_.ID_PRT=prored64_.ID left outer join TB_PRO prored65_ on mod48__2_.ID_PRV=prored65_.ID left outer join TB_UNI uni66_ on osp47_.ID_UNI=uni66_.ID left outer join TB_MAQ maq67_ on osp47_.ID_MAQ=maq67_.ID left outer join TB_PRO prored68_ on osp47_.ID_PR1=prored68_.ID left outer join TB_PRO prored69_ on osp47_.ID_PR2=prored69_.ID left outer join TB_PRO prored70_ on osp47_.ID_PR3=prored70_.ID left outer join TB_PRO prored71_ on osp47_.ID_EMB=prored71_.ID left outer join TB_FAM fam72_ on osp47__1_.ID_FAM=fam72_.ID left outer join TB_FUN fun73_ on osp47__2_.ID_FCL=fun73_.ID left outer join TB_FUN fun74_ on osp47__2_.ID_FFC=fun74_.ID left outer join TB_FUN fun75_ on osp47__2_.ID_FTI=fun75_.ID left outer join TB_MAQ maq76_ on osp47__2_.ID_EMQ=maq76_.ID left outer join TB_FUN fun77_ on osp47__2_.ID_FMQ=fun77_.ID left outer join TB_FUN fun78_ on osp47__2_.ID_FPR=fun78_.ID left outer join TB_FUN fun79_ on osp47__2_.ID_FRB=fun79_.ID left outer join TB_FUN fun80_ on osp47__2_.ID_FIS=fun80_.ID left outer join TB_FUN fun81_ on osp47__2_.ID_FPA=fun81_.ID left outer join TB_FUN fun82_ on osp47__2_.ID_FCA=fun82_.ID where mbo0_.ID=?
17:14:59,036 INFO [STDOUT] Hibernate: select sub0_.ID as ID13_, sub0_.codSub as codSub13_, sub0_.desSub as desSub13_, sub0_.codExt as codExt13_, sub0_.ID_GRU as ID_GRU13_, gru1_.ID as ID0_, gru1_.ID_FIL as ID_FIL0_, gru1_.codGru as codGru0_, gru1_.desGru as desGru0_, gru1_.codExt as codExt0_, fil2_.ID as ID1_, fil2_.codExt as codExt1_, fil2_.sufFil as sufFil1_, fil2_.regAti as regAti1_, ent3_.ID as ID2_, ent3_.tipEnt as tipEnt2_, ent3_.nomEnt as nomEnt2_, ent3_.regAti as regAti2_, ent3_.fabExt as fabExt2_, fis4_.ID as ID3_, fis4_.nomPai as nomPai3_, fis4_.nomMae as nomMae3_, fis4_.datNas as datNas3_, fis4_.E_MAIL as E_MAIL3_, fis4_.refCo1 as refCo13_, fis4_.refCo2 as refCo23_, fis4_.refCo3 as refCo33_, fis4_.refFo1 as refFo13_, fis4_.refFo2 as refFo23_, fis4_.refFo3 as refFo33_, jur5_.ID as ID4_, jur5_.numMun as numMun4_, jur5_.datFun as datFun4_, jur5_.END_HP as END_HP4_, jur5_.nomFan as nomFan4_, cli6_.ID as ID5_, cli6_.codExt as codExt5_, cli6_.cliBlo as cliBlo5_, cli6_.usaCer as usaCer5_, cli6_.ID_LEG as ID_LEG5_, cli6_.conFin as conFin5_, cli6_.tipFre as tipFre5_, cli6_.ID_SIT as ID_SIT5_, cli6_.vlrLim as vlrLim5_, cli6_.vlrAbe as vlrAbe5_, cli6_.difere as difere5_, leg7_.ID as ID6_, leg7_.desLeg as desLeg6_, leg7_.ID_FIL as ID_FIL6_, leg7_.txtLeg as txtLeg6_, leg7_.codExt as codExt6_, sit8_.ID as ID7_, sit8_.desSit as desSit7_, sit8_.regAti as regAti7_, fnc9_.ID as ID8_, fnc9_.codExt as codExt8_, fnc9_.regAti as regAti8_, rep10_.ID as ID9_, rep10_.codExt as codExt9_, rep10_.comFat as comFat9_, rep10_.comLiq as comLiq9_, rep10_.regAti as regAti9_, tra11_.ID as ID10_, tra11_.codExt as codExt10_, tra11_.regAti as regAti10_, usu12_.ID as ID11_, usu12_.codExt as codExt11_, usu12_.senUsu as senUsu11_, usu12_.nomLog as nomLog11_, usu12_.regAti as regAti11_, por13_.ID as ID12_, por13_.codExt as codExt12_, por13_.regAti as regAti12_ from TB_SUB sub0_ left outer join TB_GRU gru1_ on sub0_.ID_GRU=gru1_.ID left outer join TB_FIL fil2_ on gru1_.ID_FIL=fil2_.ID left outer join TB_ENT ent3_ on fil2_.ID=ent3_.ID left outer join TB_FIS fis4_ on ent3_.ID=fis4_.ID left outer join TB_JUR jur5_ on ent3_.ID=jur5_.ID left outer join TB_CLI cli6_ on ent3_.ID=cli6_.ID left outer join TB_LEG leg7_ on cli6_.ID_LEG=leg7_.ID left outer join TB_SIT sit8_ on cli6_.ID_SIT=sit8_.ID left outer join TB_FNC fnc9_ on ent3_.ID=fnc9_.ID left outer join TB_REP rep10_ on ent3_.ID=rep10_.ID left outer join TB_TRA tra11_ on ent3_.ID=tra11_.ID left outer join TB_USU usu12_ on ent3_.ID=usu12_.ID left outer join TB_POR por13_ on ent3_.ID=por13_.ID where sub0_.ID=?
17:14:59,577 INFO [STDOUT] Hibernate: select uni0_.ID as ID0_, uni0_.desUni as desUni0_, uni0_.abrUni as abrUni0_ from TB_UNI uni0_ where uni0_.ID=?
17:14:59,597 INFO [STDOUT] Hibernate: select uni0_.ID as ID0_, uni0_.desUni as desUni0_, uni0_.abrUni as abrUni0_ from TB_UNI uni0_ where uni0_.ID=?
17:14:59,607 INFO [STDOUT] Hibernate: select ipi0_.ID as ID1_, ipi0_.desIpi as desIpi1_, ipi0_.desNcm as desNcm1_, ipi0_.claIpi as claIpi1_, ipi0_.codExt as codExt1_, ipi0_.perIpi as perIpi1_, ipi0_.ID_LEG as ID_LEG1_, leg1_.ID as ID0_, leg1_.desLeg as desLeg0_, leg1_.ID_FIL as ID_FIL0_, leg1_.txtLeg as txtLeg0_, leg1_.codExt as codExt0_ from TB_IPI ipi0_ left outer join TB_LEG leg1_ on ipi0_.ID_LEG=leg1_.ID where ipi0_.ID=?
17:14:59,637 INFO [STDOUT] Hibernate: select icm0_.ID as ID0_, icm0_.desIcm as desIcm0_, icm0_.codTri as codTri0_, icm0_.perIcm as perIcm0_, icm0_.perRed as perRed0_ from TB_ICM icm0_ where icm0_.ID=?
17:14:59,657 INFO [STDOUT] Hibernate: select des0_.ID as ID0_, des0_.desDes as desDes0_, des0_.creIcm as creIcm0_, des0_.creIpi as creIpi0_, des0_.creAdc as creAdc0_ from TB_DES des0_ where des0_.ID=?
17:14:59,667 INFO [STDOUT] Hibernate: select leg0_.ID as ID0_, leg0_.desLeg as desLeg0_, leg0_.ID_FIL as ID_FIL0_, leg0_.txtLeg as txtLeg0_, leg0_.codExt as codExt0_ from TB_LEG leg0_ where leg0_.ID=?
17:14:59,697 INFO [STDOUT] Hibernate: select mbo0_.ID as ID82_, mbo0_.ID_BOB as ID_BOB82_, mbo0_.ID_OSP as ID_OSP82_, mbo0_.datSai as datSai82_, mbo0_.datRet as datRet82_, mbo0_.comSai as comSai82_, mbo0_.comRet as comRet82_, mbo0_.id_fil as id_fil82_, mbo0_.numbob as numbob82_, bob1_.ID as ID0_, bob1_.ID_FIL as ID_FIL0_, bob1_.ID_BOB as ID_BOB0_, bob1_.ID_PRO as ID_PRO0_, bob1_.ID_CNF as ID_CNF0_, bob1_.ID_FUN as ID_FUN0_, bob1_.numBob as numBob0_, bob1_.numOri as numOri0_, bob1_.locBob as locBob0_, bob1_.comBob as comBob0_, bob1_.larBob as larBob0_, bob1_.datVal as datVal0_, bob1_.datCor as datCor0_, bob1_.datSai as datSai0_, bob1_.datRet as datRet0_, bob1_.sitBob as sitBob0_, bob1_.comAtu as comAtu0_, bob1_.graFro as graFro0_, bob1_.espFro as espFro0_, bob1_.graLin as graLin0_, bob1_.espLin as espLin0_, bob1_.adesiv as adesiv0_, bob2_.ID as ID1_, bob2_.ID_FIL as ID_FIL1_, bob2_.ID_BOB as ID_BOB1_, bob2_.ID_PRO as ID_PRO1_, bob2_.ID_CNF as ID_CNF1_, bob2_.ID_FUN as ID_FUN1_, bob2_.numBob as numBob1_, bob2_.numOri as numOri1_, bob2_.locBob as locBob1_, bob2_.comBob as comBob1_, bob2_.larBob as larBob1_, bob2_.datVal as datVal1_, bob2_.datCor as datCor1_, bob2_.datSai as datSai1_, bob2_.datRet as datRet1_, bob2_.sitBob as sitBob1_, bob2_.comAtu as comAtu1_, bob2_.graFro as graFro1_, bob2_.espFro as espFro1_, bob2_.graLin as graLin1_, bob2_.espLin as espLin1_, bob2_.adesiv as adesiv1_, prored3_.ID as ID2_, prored3_.ID_FIL as ID_FIL2_, prored3_.codPro as codPro2_, prored3_.diaVal as diaVal2_, prored3_.codBar as codBar2_, prored3_.codRef as codRef2_, prored3_.codExt as codExt2_, prored3_.desAbr as desAbr2_, prored3_.regAti as regAti2_, cnf4_.ID as ID3_, cnf4_.ID_FIL as ID_FIL3_, cnf4_.ID_TPD as ID_TPD3_, cnf4_.ID_SER as ID_SER3_, cnf4_.ID_OPE as ID_OPE3_, cnf4_.ID_ENT as ID_ENT3_, cnf4_.ID_ERE as ID_ERE3_, cnf4_.ID_ETR as ID_ETR3_, cnf4_.ID_EEN as ID_EEN3_, cnf4_.ID_ECO as ID_ECO3_, cnf4_.ID_EFA as ID_EFA3_, cnf4_.ID_FRE as ID_FRE3_, cnf4_.ID_RPA as ID_RPA3_, cnf4_.tipEmi as tipEmi3_, cnf4_.tipMov as tipMov3_, cnf4_.sitDoc as sitDoc3_, cnf4_.tipFre as tipFre3_, cnf4_.numDoc as numDoc3_, cnf4_.datDoc as datDoc3_, cnf4_.datMov as datMov3_, cnf4_.vlrBru as vlrBru3_, cnf4_.vlrLiq as vlrLiq3_, cnf4_.basIcm as basIcm3_, cnf4_.vlrIcm as vlrIcm3_, cnf4_.basIse as basIse3_, cnf4_.basSub as basSub3_, cnf4_.vlrSub as vlrSub3_, cnf4_.basOut as basOut3_, cnf4_.vlrOut as vlrOut3_, cnf4_.basIpi as basIpi3_, cnf4_.vlrIpi as vlrIpi3_, cnf4_.basIss as basIss3_, cnf4_.perIss as perIss3_, cnf4_.vlrIss as vlrIss3_, cnf4_.basIrr as basIrr3_, cnf4_.basIns as basIns3_, cnf4_.vlrIns as vlrIns3_, cnf4_.vlrIrr as vlrIrr3_, cnf4_.vlrFre as vlrFre3_, cnf4_.vlrSeg as vlrSeg3_, cnf4_.vlrOde as vlrOde3_, cnf4_.vlrEmb as vlrEmb3_, cnf4_.vlrDes as vlrDes3_, cnf4_.perDes as perDes3_, cnf4_.vlrAcr as vlrAcr3_, cnf4_.perAcr as perAcr3_, cnf4_.obsDoc as obsDoc3_, cnf4_.plaVei as plaVei3_, cnf4_.estVei as estVei3_, cnf4_.espVol as espVol3_, cnf4_.marVol as marVol3_, cnf4_.numVol as numVol3_, cnf4_.qtdVol as qtdVol3_, cnf4_.pesBru as pesBru3_, cnf4_.pesLiq as pesLiq3_, cnf4_.movEst as movEst3_, cnf4_.movFin as movFin3_, cnf4_.conFin as conFin3_, cnf4_.vlrCom as vlrCom3_, cnf4_.ID_SIT as ID_SIT3_, cnf4_.ID_POR as ID_POR3_, cnf4_.datEmb as datEmb3_, cnf4_.tipSit as tipSit3_, cnf4_.tipTip as tipTip3_, cnf4_.pagFil as pagFil3_, cnf4_.escFis as escFis3_, cnf4_.codFis as codFis3_, cnf4_.vlrMat as vlrMat3_, cnf4_.vlrDev as vlrDev3_, cnf4_.ID_C01 as ID_C013_, cnf4_.ID_C02 as ID_C023_, cnf4_.ID_C03 as ID_C033_, cnf4_.ID_C04 as ID_C043_, cnf4_.ID_C05 as ID_C053_, cnf4_.ID_C06 as ID_C063_, cnf4_.ID_C07 as ID_C073_, cnf4_.ID_C08 as ID_C083_, cnf4_.ID_C09 as ID_C093_, cnf4_.ID_C10 as ID_C103_, cnf4_.ID_C11 as ID_C113_, cnf4_.ID_C12 as ID_C123_, cnf4_.ID_C13 as ID_C133_, cnf4_.ID_C14 as ID_C143_, cnf4_.ID_C15 as ID_C153_, cnf4_.basDif as basDif3_, cnf4_.perDif as perDif3_, cnf4_.vlrDif as vlrDif3_, tpd5_.ID as ID4_, tpd5_.codTpd as codTpd4_, tpd5_.desTpd as desTpd4_, tpd5_.regAti as regAti4_, ser6_.ID as ID5_, ser6_.desSer as desSer5_, ser6_.regAti as regAti5_, ope7_.ID as ID6_, ope7_.codOpe as codOpe6_, ope7_.ID_REV as ID_REV6_, ope7_.desOpe as desOpe6_, ope7_.lanEst as lanEst6_, ope7_.lanFin as lanFin6_, ope7_.regAti as regAti6_, ope7_.emiDoc as emiDoc6_, ope7_.conDev as conDev6_, ope7_.calCus as calCus6_, ope7_.diaPra as diaPra6_, ope7_.ID_LEG as ID_LEG6_, ope8_.ID as ID7_, ope8_.codOpe as codOpe7_, ope8_.ID_REV as ID_REV7_, ope8_.desOpe as desOpe7_, ope8_.lanEst as lanEst7_, ope8_.lanFin as lanFin7_, ope8_.regAti as regAti7_, ope8_.emiDoc as emiDoc7_, ope8_.conDev as conDev7_, ope8_.calCus as calCus7_, ope8_.diaPra as diaPra7_, ope8_.ID_LEG as ID_LEG7_, leg9_.ID as ID8_, leg9_.desLeg as desLeg8_, leg9_.ID_FIL as ID_FIL8_, leg9_.txtLeg as txtLeg8_, leg9_.codExt as codExt8_, leg10_.ID as ID9_, leg10_.desLeg as desLeg9_, leg10_.ID_FIL as ID_FIL9_, leg10_.txtLeg as txtLeg9_, leg10_.codExt as codExt9_, ent11_.ID as ID10_, ent11_.tipEnt as tipEnt10_, ent11_.nomEnt as nomEnt10_, ent11_.regAti as regAti10_, ent11_.fabExt as fabExt10_, fis12_.ID as ID11_, fis12_.nomPai as nomPai11_, fis12_.nomMae as nomMae11_, fis12_.datNas as datNas11_, fis12_.E_MAIL as E_MAIL11_, fis12_.refCo1 as refCo111_, fis12_.refCo2 as refCo211_, fis12_.refCo3 as refCo311_, fis12_.refFo1 as refFo111_, fis12_.refFo2 as refFo211_, fis12_.refFo3 as refFo311_, jur13_.ID as ID12_, jur13_.numMun as numMun12_, jur13_.datFun as datFun12_, jur13_.END_HP as END_HP12_, jur13_.nomFan as nomFan12_, cli14_.ID as ID13_, cli14_.codExt as codExt13_, cli14_.cliBlo as cliBlo13_, cli14_.usaCer as usaCer13_, cli14_.ID_LEG as ID_LEG13_, cli14_.conFin as conFin13_, cli14_.tipFre as tipFre13_, cli14_.ID_SIT as ID_SIT13_, cli14_.vlrLim as vlrLim13_, cli14_.vlrAbe as vlrAbe13_, cli14_.difere as difere13_, leg15_.ID as ID14_, leg15_.desLeg as desLeg14_, leg15_.ID_FIL as ID_FIL14_, leg15_.txtLeg as txtLeg14_, leg15_.codExt as codExt14_, sit16_.ID as ID15_, sit16_.desSit as desSit15_, sit16_.regAti as regAti15_, fnc17_.ID as ID16_, fnc17_.codExt as codExt16_, fnc17_.regAti as regAti16_, rep18_.ID as ID17_, rep18_.codExt as codExt17_, rep18_.comFat as comFat17_, rep18_.comLiq as comLiq17_, rep18_.regAti as regAti17_, tra19_.ID as ID18_, tra19_.codExt as codExt18_, tra19_.regAti as regAti18_, usu20_.ID as ID19_, usu20_.codExt as codExt19_, usu20_.senUsu as senUsu19_, usu20_.nomLog as nomLog19_, usu20_.regAti as regAti19_, por21_.ID as ID20_, por21_.codExt as codExt20_, por21_.regAti as regAti20_, fil22_.ID as ID21_, fil22_.codExt as codExt21_, fil22_.sufFil as sufFil21_, fil22_.regAti as regAti21_, end23_.ID as ID22_, end23_.endCob as endCob22_, end23_.endCor as endCor22_, end23_.codCep as codCep22_, end23_.codLog as codLog22_, end23_.tipEnd as tipEnd22_, end23_.desEnd as desEnd22_, end23_.comEnd as comEnd22_, end23_.baiEnd as baiEnd22_, end23_.numEnd as numEnd22_, end23_.DDDFon as DDDFon22_, end23_.numFon as numFon22_, end23_.DDDFax as DDDFax22_, end23_.numFax as numFax22_, end23_.ID_ENT as ID_ENT22_, end23_.ID_MUN as ID_MUN22_, end23_.nrDoc1 as nrDoc122_, end23_.nrDoc2 as nrDoc222_, mun24_.ID as ID23_, mun24_.cepIni as cepIni23_, mun24_.cepFin as cepFin23_, mun24_.nomMun as nomMun23_, mun24_.ID_EST as ID_EST23_, est25_.ID as ID24_, est25_.uniFed as uniFed24_, est25_.nomEst as nomEst24_, est25_.ID_ICM as ID_ICM24_, icm26_.ID as ID25_, icm26_.desIcm as desIcm25_, icm26_.codTri as codTri25_, icm26_.perIcm as perIcm25_, icm26_.perRed as perRed25_, rpa27_.ID as ID26_, rpa27_.ID_FIL as ID_FIL26_, rpa27_.ID_TRA as ID_TRA26_, rpa27_.ID_EST as ID_EST26_, rpa27_.numRpa as numRpa26_, rpa27_.datRpa as datRpa26_, rpa27_.vlrRpa as vlrRpa26_, rpa27_.perIcm as perIcm26_, rpa27_.vlrIcm as vlrIcm26_, rpa27_.plaVei as plaVei26_, sit28_.ID as ID27_, sit28_.desSit as desSit27_, sit28_.regAti as regAti27_, cte29_.ID as ID28_, cte29_.ID_FIL as ID_FIL28_, cte29_.codCte as codCte28_, cte29_.desCte as desCte28_, cte29_.regAti as regAti28_, cte30_.ID as ID29_, cte30_.ID_FIL as ID_FIL29_, cte30_.codCte as codCte29_, cte30_.desCte as desCte29_, cte30_.regAti as regAti29_, cte31_.ID as ID30_, cte31_.ID_FIL as ID_FIL30_, cte31_.codCte as codCte30_, cte31_.desCte as desCte30_, cte31_.regAti as regAti30_, cte32_.ID as ID31_, cte32_.ID_FIL as ID_FIL31_, cte32_.codCte as codCte31_, cte32_.desCte as desCte31_, cte32_.regAti as regAti31_, cte33_.ID as ID32_, cte33_.ID_FIL as ID_FIL32_, cte33_.codCte as codCte32_, cte33_.desCte as desCte32_, cte33_.regAti as regAti32_, cte34_.ID as ID33_, cte34_.ID_FIL as ID_FIL33_, cte34_.codCte as codCte33_, cte34_.desCte as desCte33_, cte34_.regAti as regAti33_, cte35_.ID as ID34_, cte35_.ID_FIL as ID_FIL34_, cte35_.codCte as codCte34_, cte35_.desCte as desCte34_, cte35_.regAti as regAti34_, cte36_.ID as ID35_, cte36_.ID_FIL as ID_FIL35_, cte36_.codCte as codCte35_, cte36_.desCte as desCte35_, cte36_.regAti as regAti35_, cte37_.ID as ID36_, cte37_.ID_FIL as ID_FIL36_, cte37_.codCte as codCte36_, cte37_.desCte as desCte36_, cte37_.regAti as regAti36_, cte38_.ID as ID37_, cte38_.ID_FIL as ID_FIL37_, cte38_.codCte as codCte37_, cte38_.desCte as desCte37_, cte38_.regAti as regAti37_, cte39_.ID as ID38_, cte39_.ID_FIL as ID_FIL38_, cte39_.codCte as codCte38_, cte39_.desCte as desCte38_, cte39_.regAti as regAti38_, cte40_.ID as ID39_, cte40_.ID_FIL as ID_FIL39_, cte40_.codCte as codCte39_, cte40_.desCte as desCte39_, cte40_.regAti as regAti39_, cte41_.ID as ID40_, cte41_.ID_FIL as ID_FIL40_, cte41_.codCte as codCte40_, cte41_.desCte as desCte40_, cte41_.regAti as regAti40_, cte42_.ID as ID41_, cte42_.ID_FIL as ID_FIL41_, cte42_.codCte as codCte41_, cte42_.desCte as desCte41_, cte42_.regAti as regAti41_, cte43_.ID as ID42_, cte43_.ID_FIL as ID_FIL42_, cte43_.codCte as codCte42_, cte43_.desCte as desCte42_, cte43_.regAti as regAti42_, fun44_.ID as ID43_, fun44_.ID_FIL as ID_FIL43_, fun44_.nomFun as nomFun43_, fun44_.codExt as codExt43_, fun44_.regAti as regAti43_, prored45_.ID as ID44_, prored45_.ID_FIL as ID_FIL44_, prored45_.codPro as codPro44_, prored45_.diaVal as diaVal44_, prored45_.codBar as codBar44_, prored45_.codRef as codRef44_, prored45_.codExt as codExt44_, prored45_.desAbr as desAbr44_, prored45_.regAti as regAti44_, fun46_.ID as ID45_, fun46_.ID_FIL as ID_FIL45_, fun46_.nomFun as nomFun45_, fun46_.codExt as codExt45_, fun46_.regAti as regAti45_, osp47_.ID as ID46_, case when osp47__1_.ID is not null then 1 when osp47__2_.ID is not null then 2 when osp47_.ID is not null then 0 end as clazz_46_, osp47_.ID_CLI as ID_CLI14_46_, osp47_.numOsp as numOsp14_46_, osp47_.datOsp as datOsp14_46_, osp47_.datEtg as datEtg14_46_, osp47_.ID_FIL as ID_FIL14_46_, osp47_.ID_MOD as ID_MOD14_46_, osp47_.desMod as desMod14_46_, osp47_.ID_UNI as ID_UNI14_46_, osp47_.datPro as datPro14_46_, osp47_.ID_MAQ as ID_MAQ14_46_, osp47_.ID_FAC as ID_FAC14_46_, osp47_.ID_PR1 as ID_PR114_46_, osp47_.ID_PR2 as ID_PR214_46_, osp47_.ID_PR3 as ID_PR314_46_, osp47_.ID_EMB as ID_EMB14_46_, osp47_.ID_CRT as ID_CRT14_46_, osp47_.qtdEmb as qtdEmb14_46_, osp47_.tipBob as tipBob14_46_, osp47_.tipSer as tipSer14_46_, osp47_.tipApl as tipApl14_46_, osp47_.artSer as artSer14_46_, osp47_.artAlt as artAlt14_46_, osp47_.corMat as corMat14_46_, osp47_.medCom as medCom14_46_, osp47_.medLar as medLar14_46_, osp47_.ID_IPI as ID_IPI14_46_, osp47_.ID_REP as ID_REP14_46_, osp47_.perCom as perCom14_46_, osp47_.fatCor as fatCor14_46_, osp47_.diaPr1 as diaPr114_46_, osp47_.diaPr2 as diaPr214_46_, osp47_.diaPr3 as diaPr314_46_, osp47_.diaPr4 as diaPr414_46_, osp47_.vlrUni as vlrUni14_46_, osp47_.numOrd as numOrd14_46_, osp47_.pedRep as pedRep14_46_, osp47_.obsMod as obsMod14_46_, osp47__1_.ID_FAM as ID_FAM13_46_, osp47__1_.desAce as desAce13_46_, osp47__1_.desPro as desPro13_46_, osp47__1_.endArt as endArt13_46_, osp47__1_.corFle as corFle13_46_, osp47__1_.corLet as corLet13_46_, osp47__1_.corOff as corOff13_46_, osp47__1_.corSil as corSil13_46_, osp47__1_.pintad as pintad13_46_, osp47__1_.qtdCai as qtdCai13_46_, osp47__1_.tipRot as tipRot13_46_, osp47__1_.tipVer as tipVer13_46_, osp47__1_.cilind as cilind13_46_, osp47__1_.lamina as lamina13_46_, osp47__1_.pesUni as pesUni13_46_, osp47__1_.entAlm as entAlm13_46_, osp47__1_.saiAlm as saiAlm13_46_, osp47__1_.obsAlm as obsAlm13_46_, osp47__1_.entImp as entImp13_46_, osp47__1_.saiImp as saiImp13_46_, osp47__1_.obsImp as obsImp13_46_, osp47__1_.entAca as entAca13_46_, osp47__1_.saiAca as saiAca13_46_, osp47__1_.obsAca as obsAca13_46_, osp47__1_.entIns as entIns13_46_, osp47__1_.saiIns as saiIns13_46_, osp47__1_.obsIns as obsIns13_46_, osp47__2_.corImp as corImp80_46_, osp47__2_.tipFor as tipFor80_46_, osp47__2_.numCol as numCol80_46_, osp47__2_.tipPin as tipPin80_46_, osp47__2_.numSet as numSet80_46_, osp47__2_.tipEmb as tipEmb80_46_, osp47__2_.tipImp as tipImp80_46_, osp47__2_.tipTub as tipTub80_46_, osp47__2_.avaMon as avaMon80_46_, osp47__2_.comMon as comMon80_46_, osp47__2_.larMon as larMon80_46_, osp47__2_.larPap as larPap80_46_, osp47__2_.espCol as espCol80_46_, osp47__2_.nuRaio as nuRaio80_46_, osp47__2_.larSol as larSol80_46_, osp47__2_.larMaq as larMaq80_46_, osp47__2_.numAmg as numAmg80_46_, osp47__2_.obsVen as obsVen80_46_, osp47__2_.flgCli as flgCli80_46_, osp47__2_.datCli as datCli80_46_, osp47__2_.ID_FCL as ID_FCL80_46_, osp47__2_.lg1Cli as lg1Cli80_46_, osp47__2_.lg2Cli as lg2Cli80_46_, osp47__2_.flgFac as flgFac80_46_, osp47__2_.datFac as datFac80_46_, osp47__2_.ID_FFC as ID_FFC80_46_, osp47__2_.lg1Fac as lg1Fac80_46_, osp47__2_.lg2Fac as lg2Fac80_46_, osp47__2_.flgTin as flgTin80_46_, osp47__2_.datTin as datTin80_46_, osp47__2_.ID_FTI as ID_FTI80_46_, osp47__2_.lg1Tin as lg1Tin80_46_, osp47__2_.lg2Tin as lg2Tin80_46_, osp47__2_.ID_EMQ as ID_EMQ80_46_, osp47__2_.datMaq as datMaq80_46_, osp47__2_.ID_FMQ as ID_FMQ80_46_, osp47__2_.lg1Maq as lg1Maq80_46_, osp47__2_.lg2Maq as lg2Maq80_46_, osp47__2_.flgPrc as flgPrc80_46_, osp47__2_.datPrc as datPrc80_46_, osp47__2_.ID_FPR as ID_FPR80_46_, osp47__2_.flgReb as flgReb80_46_, osp47__2_.datReb as datReb80_46_, osp47__2_.ID_FRB as ID_FRB80_46_, osp47__2_.flgIns as flgIns80_46_, osp47__2_.datIns as datIns80_46_, osp47__2_.ID_FIS as ID_FIS80_46_, osp47__2_.flgPar as flgPar80_46_, osp47__2_.datPar as datPar80_46_, osp47__2_.ID_FPA as ID_FPA80_46_, osp47__2_.flgAca as flgAca80_46_, osp47__2_.datAca as datAca80_46_, osp47__2_.ID_FCA as ID_FCA80_46_, mod48_.ID as ID47_, case when mod48__1_.ID is not null then 1 when mod48__2_.ID is not null then 2 when mod48_.ID is not null then 0 end as clazz_47_, mod48_.ID_FIL as ID_FIL20_47_, mod48_.ID_CLI as ID_CLI20_47_, mod48_.ID_PRO as ID_PRO20_47_, mod48_.ID_MAQ as ID_MAQ20_47_, mod48_.ID_FAC as ID_FAC20_47_, mod48_.ID_PR1 as ID_PR120_47_, mod48_.ID_PR2 as ID_PR220_47_, mod48_.ID_PR3 as ID_PR320_47_, mod48_.ID_EMB as ID_EMB20_47_, mod48_.ID_CRT as ID_CRT20_47_, mod48_.ID_IPI as ID_IPI20_47_, mod48_.ID_REP as ID_REP20_47_, mod48_.numMod as numMod20_47_, mod48_.tipBob as tipBob20_47_, mod48_.tipSer as tipSer20_47_, mod48_.tipApl as tipApl20_47_, mod48_.corMat as corMat20_47_, mod48_.fatCor as fatCor20_47_, mod48_.perCom as perCom20_47_, mod48_.diaPr1 as diaPr120_47_, mod48_.diaPr2 as diaPr220_47_, mod48_.diaPr3 as diaPr320_47_, mod48_.diaPr4 as diaPr420_47_, mod48_.obsMod as obsMod20_47_, mod48_.regAti as regAti20_47_, mod48_.ordImp as ordImp20_47_, mod48_.qtdCai as qtdCai20_47_, mod48_.pesUni as pesUni20_47_, mod48__1_.ID_FAM as ID_FAM39_47_, mod48__1_.ID_LEG as ID_LEG39_47_, mod48__1_.desAce as desAce39_47_, mod48__1_.desPro as desPro39_47_, mod48__1_.endArt as endArt39_47_, mod48__1_.corFle as corFle39_47_, mod48__1_.corLet as corLet39_47_, mod48__1_.corOff as corOff39_47_, mod48__1_.corSil as corSil39_47_, mod48__1_.pintad as pintad39_47_, mod48__1_.tipRot as tipRot39_47_, mod48__1_.tipVer as tipVer39_47_, mod48__1_.cilind as cilind39_47_, mod48__1_.lamina as lamina39_47_, mod48__1_.numOrc as numOrc39_47_, mod48__2_.ID_PIN as ID_PIN40_47_, mod48__2_.ID_PRH as ID_PRH40_47_, mod48__2_.ID_PRT as ID_PRT40_47_, mod48__2_.ID_PRV as ID_PRV40_47_, mod48__2_.corImp as corImp40_47_, mod48__2_.tipFor as tipFor40_47_, mod48__2_.numCol as numCol40_47_, mod48__2_.tipPin as tipPin40_47_, mod48__2_.numSet as numSet40_47_, mod48__2_.tipEmb as tipEmb40_47_, mod48__2_.tipImp as tipImp40_47_, mod48__2_.tipTub as tipTub40_47_, mod48__2_.vlrFer as vlrFer40_47_, mod48__2_.avaMon as avaMon40_47_, mod48__2_.comMon as comMon40_47_, mod48__2_.larMon as larMon40_47_, mod48__2_.larPap as larPap40_47_, mod48__2_.vlrUnf as vlrUnf40_47_, mod48__2_.fatRnf as fatRnf40_47_, mod48__2_.qtdCor as qtdCor40_47_, mod48__2_.espCol as espCol40_47_, mod48__2_.nuRaio as nuRaio40_47_, mod48__2_.larSol as larSol40_47_, mod48__2_.larMaq as larMaq40_47_, mod48__2_.numAmg as numAmg40_47_, pro49_.ID as ID48_, pro49_.ID_FIL as ID_FIL48_, pro49_.ID_SUB as ID_SUB48_, pro49_.ID_UNP as ID_UNP48_, pro49_.ID_UNC as ID_UNC48_, pro49_.ID_UNV as ID_UNV48_, pro49_.ID_IPI as ID_IPI48_, pro49_.ID_ICM as ID_ICM48_, pro49_.ID_DES as ID_DES48_, pro49_.ID_LEG as ID_LEG48_, pro49_.ID_ENM as ID_ENM48_, pro49_.ID_CCP as ID_CCP48_, pro49_.codPro as codPro48_, pro49_.codBar as codBar48_, pro49_.codRef as codRef48_, pro49_.codExt as codExt48_, pro49_.desAbr as desAbr48_, pro49_.desLon as desLon48_, pro49_.aplica as aplica48_, pro49_.camImg as camImg48_, pro49_.codOri as codOri48_, pro49_.codCst as codCst48_, pro49_.proVen as proVen48_, pro49_.proLis as proLis48_, pro49_.diaMin as diaMin48_, pro49_.diaMax as diaMax48_, pro49_.qtdMin as qtdMin48_, pro49_.qtdMax as qtdMax48_, pro49_.qtdEmb as qtdEmb48_, pro49_.salQtd as salQtd48_, pro49_.qtdPre as qtdPre48_, pro49_.salVlr as salVlr48_, pro49_.salIcm as salIcm48_, pro49_.salIpi as salIpi48_, pro49_.salAdc as salAdc48_, pro49_.perLuc as perLuc48_, pro49_.vlrRep as vlrRep48_, pro49_.vlrCus as vlrCus48_, pro49_.vlrMed as vlrMed48_, pro49_.locali as locali48_, pro49_.perCof as perCof48_, pro49_.perCol as perCol48_, pro49_.diaVal as diaVal48_, pro49_.comPro as comPro48_, pro49_.larPro as larPro48_, pro49_.altPro as altPro48_, pro49_.pesLiq as pesLiq48_, pro49_.pesBru as pesBru48_, pro49_.vlrVen as vlrVen48_, pro49_.proKit as proKit48_, pro49_.regAti as regAti48_, pro49_.proBob as proBob48_, pro49_.matPri as matPri48_, maq50_.ID as ID49_, maq50_.ID_FIL as ID_FIL49_, maq50_.codMaq as codMaq49_, maq50_.desMaq as desMaq49_, fac51_.ID as ID50_, fac51_.ID_FIL as ID_FIL50_, fac51_.ID_MAQ as ID_MAQ50_, fac51_.codFac as codFac50_, fac51_.desFac as desFac50_, fac51_.larFac as larFac50_, fac51_.comFac as comFac50_, fac51_.larMon as larMon50_, fac51_.comMon as comMon50_, fac51_.larPap as larPap50_, fac51_.avaMon as avaMon50_, fac51_.espCol as espCol50_, fac51_.numRai as numRai50_, fac51_.larSol as larSol50_, fac51_.larMaq as larMaq50_, fac51_.larPro as larPro50_, fac51_.monHst as monHst50_, fac51_.cilind as cilind50_, maq52_.ID as ID51_, maq52_.ID_FIL as ID_FIL51_, maq52_.codMaq as codMaq51_, maq52_.desMaq as desMaq51_, prored53_.ID as ID52_, prored53_.ID_FIL as ID_FIL52_, prored53_.codPro as codPro52_, prored53_.diaVal as diaVal52_, prored53_.codBar as codBar52_, prored53_.codRef as codRef52_, prored53_.codExt as codExt52_, prored53_.desAbr as desAbr52_, prored53_.regAti as regAti52_, prored54_.ID as ID53_, prored54_.ID_FIL as ID_FIL53_, prored54_.codPro as codPro53_, prored54_.diaVal as diaVal53_, prored54_.codBar as codBar53_, prored54_.codRef as codRef53_, prored54_.codExt as codExt53_, prored54_.desAbr as desAbr53_, prored54_.r

O Hibernate não sabe fazer select * :expressionless:

Isso eh do javafree neh? um post do Vitor… jprogrammer, por favor, coloque o link original de onde voce pegou esse sql.

Rafael

Me sinto como um artista da globo que faz propaganda do SBT mas vai lá:

http://www.javafree.com.br/forum/viewtopic.php?t=847890

se o cara aprender a configurar direitinho o que deve ser lazy load, para que a hierarquia de objetos não seja carregada toda na memoria de uma vez só, vai ajudar bastante :smiley:

[quote=urubatan]se o cara aprender a configurar direitinho o que deve ser lazy load, para que a hierarquia de objetos não seja carregada toda na memoria de uma vez só, vai ajudar bastante :smiley:
[/quote]

Olá galera…

Acontece que one-to-one e many-to-one não tem lazy e não adianta usar proxy. E essa coisa toda aih é durante um SAVE, ele está validando as dependências

Lipe, não é que o hibernate não saiba fazer select, é que ele adora fazer selects :smiley:

PS: Notem que o jprogrammer copiou só metade do select :smiley:

[quote]Me sinto como um artista da globo que faz propaganda do SBT mas vai lá:

http://www.javafree.com.br/forum/viewtopic.php?t=847890
[/quote]

hum… e o que tu diz de um administrador do JavaFree respondendo no GUJ? :stuck_out_tongue:

[]s

Sempre achei esse Hibernate um tanto promiscuo.
deve ser uma baita gambiarra por baixo dos panos…

Mas acho que não tenha solução melhor ou tem ?

Os nomes dos campos dessas tabelas precisam seriamente de uma revisao, ou vao comecar a perguntar onde foi parar o molho bolonhesa ao ver o diagrama :mrgreen:

Tirando isso, qual o problema do hibernate fazer selects e trazer dados em lazy-loading? Sabendo configurar o bichinho, o aumento de performance eh bem significativo :wink:

alguém sabe se no hibernate 3 isso é diferente?
já ouvi todo mundo falar que em relacionamento <many-to-one> nao tem como fazer lazy…
mas eu fiz um relacionamento assim no hibernate 3 e carreguei um objeto (usando Criteria) que possuía outros objetos… se eu tentasse usar esses objetos de outras classes dava pau, pois elas nao tinham sido carregadas. Mas como no meu caso eu precisava que carregasse tudo, eu usei

ou entao eu tinha que colocar no hbm.xml que eu queria que carregasse tudo (fetch=“true”)… alguem pode responder se isso muda do hibernate 2 pro 3?

PROMISCUO! Como eu nao pensei em chamar um projeto opensource de promiscuo antes!? Uau!

Uhh…erhm… o que isso quer dizer? Que eu posso chegar abanando uma nota de $100 pro Gavin King e ele faz coisas indecentes? Hmm… melhor nao, valeu :mrgreen:

[quote=cv]Os nomes dos campos dessas tabelas precisam seriamente de uma revisao, ou vao comecar a perguntar onde foi parar o molho bolonhesa ao ver o diagrama :mrgreen:

Tirando isso, qual o problema do hibernate fazer selects e trazer dados em lazy-loading? Sabendo configurar o bichinho, o aumento de performance eh bem significativo ;)[/quote]

O problema é que esses selects todos aih ele faz num UPDATE de registro. Não precisa nem verificar o lazy é só salvar… saca, aquele update xxx set xx = xxx where id = x

E só fazer isso!!! :smiley:

ah… o Objeto é um master / detail com certa de 10 campos e uns 3 many-to-one

Quando digo promisc…(não vou sem dizer) quero dizer que por baixo dos panos ele faz gambiarra a rodo para garantir a funcionalidade.

Não que seja um mal projeto ,pelo contrário é excelente.
Mas os meios não justificam os fins…

Eu falei que ele não sabe fazer “select *” hehe

Peraí !!! O “mapeamento + esquema do BD” tá caprichado demais…
Nunca consegui tal proeza!

Se você não quer salvar (ou atualizar) em cascata todas entidades penduradas… cascade=none (ou delete).
Acho que manter as chaves bem simples, também deve ajudar horrores.

Mas, precisaria ver o mapeamento para entender o problema.

Que ele é muuuuuuito gente boa, oras !
:wink:

Mas onde tu viu gambiarra?? Claro fora que o proprio Hibernate pode ser considerado uma gambiarra pra interligar os dois mundos, OO e relacional,.
Mas no exemplo do Vitor o unico problema é ele fazer coisa demais, só isso.

]['s

Pois é LIPE, mas a maioria dos desenvolvedores nao sabem, niguem se peocupa muito com isso. :stuck_out_tongue:

Ps.: Sem pedras pessoal :mrgreen:

Cascade está ativo só no detalhe do cara (uma tabelinha com 3 registros).

Mas, exato… o mapeamento e as classes do hibernate estão overpower, praticamente uma cópia do diagrama de classe da aplicação. Muita coisa interligada… e é por isso que da essas merdas aih.

E quem disse que select * é bom? SQL de 20 linha é um problema bem menor que usar select *. Ainda mais para o hibernate, um software, que não tem um oraculo para adivinhar a nhaca que virá do banco.

Vitor, o hibernate não executa nenhum select para atualizar um objeto. Você primeiro procurou pelo objeto antes de atualizar, correto?

O ideal é trabalhar com objetos desconectados e optimistic locking nesse caso. Com Hibernate3 você pode usar update queries.

Eu acho que o problema é que você não entendeu como funciona ORM, a implicações disso e as configurações de caching da tua aplicação tão zuadas.

hum… vejamos…

Não, o Hibernate fez aquelas consultas sozinho no save.

Os objetos que compõem o registro que estou salvando estão desconectados sim, foram caregados em outras seções pelo Swing.

Esse select é para validar as dependências dos relacionamentos que existem no objeto que eu estou salvando.

Aí já não sei… eu vi, re-vi, re-li, debuguei o fonte o hib2 e nada…

A solução que eu fiz foi retirar as dependências dos relacionamentos eu tinha no objeto. Ou seja, dupliquei o mapeamento para uma outra classe. :frowning:

Já tive que fazer algo parecido, ter 2 classes, uma leve e outra pesada herdando da primeira.Fiz isso para evitar carregar um clob toda hora, uma vez que o Hibernate2 não suporta fetch groups. O mesmo pode ser feito para relacionamentos.

O mapeamento original tinha os relaciomanentos todos como casacade=“all” pelo visto. Isso é uma coisa que eles não falam nos docs, mas qualquer opção de cascade diferente de “none” no caso de objetos detached custa muito em termos de performance. É um custo que não tem como escapar.