Hibernate: select this.reportID as reportID2_, this.active as active2_, this.clinTrace as clinTrace2_, this.closedDate as closedDate2_, this.daysToClose as daysToCl5_2_, this.daysToIndy as daysToIndy2_, this.daysToRegAgence as daysToRe7_2_, this.followUp as followUp2_, this.forwardIndy as forwardI9_2_, this.idNumber as idNumber2_, this.initialReview as initial11_2_, this.investigationNumber as investi12_2_, this.lotNumber as lotNumber2_, this.receivedIndy as receive14_2_, this.receivedLocalPhV as receive15_2_, this.reportDate as reportDate2_, this.reporterType as reporte17_2_, this.reportType as reportType2_, this.sentLocalPhV as sentLoc19_2_, this.sentRegAgence as sentReg20_2_, this.spontaneousSource as spontan21_2_, this.studyAlias as studyAlias2_, this.validCase as validCase2_, this.userID as userID2_, this.country as country2_, this.regionOwner as regionO26_2_, user1_.userID as userID0_, user1_.roleID as roleID0_, user1_.active as active0_, user1_.country as country0_, user1_.name as name0_, user1_.password as password0_, user1_.region as region0_, user1_.systemID as systemID0_, role2_.roleID as roleID1_, role2_.active as active1_, role2_.description as descript3_1_ from Report this, UserPharma user1_, Role role2_ where this.active=? and this.closedDate is null and this.userID=user1_.userID(+) and user1_.roleID=role2_.roleID(+)
Hibernate: select seriousnes0_.seriousnessCriteriaID as seriousn2___, seriousnes0_.reportID as reportID__, seriousnes1_.seriousnessCriteriaID as seriousn1_0_, seriousnes1_.active as active0_, seriousnes1_.description as descript3_0_ from Report_Criterias seriousnes0_, SeriousnessCriteria seriousnes1_ where seriousnes0_.reportID=? and seriousnes0_.seriousnessCriteriaID=seriousnes1_.seriousnessCriteriaID
Hibernate: select reactions0_.reactionID as reactionID__, reactions0_.reportID as reportID__, reaction1_.reactionID as reactionID0_, reaction1_.active as active0_, reaction1_.description as descript3_0_ from Report_Reactions reactions0_, Reaction reaction1_ where reactions0_.reportID=? and reactions0_.reactionID=reaction1_.reactionID
Hibernate: select products0_.productID as productID__, products0_.reportID as reportID__, product1_.productID as productID0_, product1_.active as active0_, product1_.description as descript3_0_ from Report_Products products0_, Product product1_ where products0_.reportID=? and products0_.productID=product1_.productID
Hibernate: select contacts0_.contactID as contactID__, contacts0_.reportID as reportID__, contact1_.contactID as contactID0_, contact1_.active as active0_, contact1_.contactDate as contactD3_0_, contact1_.description as descript4_0_ from Report_Contacts contacts0_, Contact contact1_ where contacts0_.reportID=? and contacts0_.contactID=contact1_.contactID
Hibernate: delete from Report_Products where reportID=?