HQL QUERY
=================
SELECT e.campus,
e.agreementNumber,
e.agreementTypeAgreementTypes.agreementClassAgreementClasses.classDesc,
e.contractNumber,
e.effectiveDate,
e.expirationDate,
e.agreementTypeAgreementTypes.typeDescription,
e.agreementComment,
e.responsibleOrganization,
e.companyNumberCoCompany.companyName,
e.agreementStatusAgreementStatuses.statusDesc,
e.billingStatusBillingStatuses.statusDesc,
e.coOperatingNamesCompositeFK1.operatingName,
e.coContactCompositeFK2.lastName,
e.coContactCompositeFK2.firstName
FROM Agreements e
LEFT OUTER JOIN e.coOperatingNamesCompositeFK1 a
LEFT OUTER JOIN e.coContactCompositeFK2 b
WHERE 1 =1
AND (e.agreementNumber = '004243')

INCORRECT GENERATED SQL WITH HIBERNATE 4.3.5 Final
========================================
SELECT agreements0_.CAMPUS AS col_0_0_,
agreements0_.AGREEMENT_NUMBER AS col_1_0_,
agreementc4_.CLASS_DESC AS col_2_0_,
agreements0_.CONTRACT_NUMBER AS col_3_0_,
agreements0_.EFFECTIVE_DATE AS col_4_0_,
agreements0_.EXPIRATION_DATE AS col_5_0_,
agreementt3_.TYPE_DESCRIPTION AS col_6_0_,
agreements0_.AGREEMENT_COMMENT AS col_7_0_,
agreements0_.RESPONSIBLE_ORGANIZATION AS col_8_0_,
cocompany6_.COMPANY_NAME AS col_9_0_,
agreements7_.STATUS_DESC AS col_10_0_,
billingsta8_.STATUS_DESC AS col_11_0_,
cooperatin9_.OPERATING_NAME AS col_12_0_,
cocontact10_.LAST_NAME AS col_13_0_,
cocontact10_.FIRST_NAME AS col_14_0_
FROM AGREEMENTS agreements0_
LEFT OUTER JOIN CO_OPERATING_NAMES cooperatin1_
ON agreements0_.COMPANY_NUMBER =cooperatin1_.COMPANY_NUMBER
AND agreements0_.OPERATING_NAME_ID=cooperatin1_.OPERATING_NAME_ID
LEFT OUTER JOIN CO_CONTACT cocontact2_
ON agreements0_.MANAGE_COMPANY =cocontact2_.COMPANY_NUMBER
AND agreements0_.MANAGE_CONTACT=cocontact2_.CONTACT_NUMBER,
AGREEMENT_TYPES agreementt3_,
AGREEMENT_CLASSES agreementc4_,
CO_COMPANY cocompany6_,
AGREEMENT_STATUSES agreements7_,
BILLING_STATUSES billingsta8_,
CO_OPERATING_NAMES cooperatin9_,
CO_CONTACT cocontact10_
WHERE agreements0_.AGREEMENT_TYPE =agreementt3_.AGREEMENT_TYPE
AND agreementt3_.AGREEMENT_CLASS =agreementc4_.AGREEMENT_CLASS
AND agreements0_.COMPANY_NUMBER =cocompany6_.COMPANY_NUMBER
AND agreements0_.AGREEMENT_STATUS =agreements7_.AGREEMENT_STATUS
AND agreements0_.BILLING_STATUS =billingsta8_.BILLING_STATUS
AND agreements0_.COMPANY_NUMBER =cooperatin9_.COMPANY_NUMBER
AND agreements0_.OPERATING_NAME_ID=cooperatin9_.OPERATING_NAME_ID
AND agreements0_.MANAGE_COMPANY =cocontact10_.COMPANY_NUMBER
AND agreements0_.MANAGE_CONTACT =cocontact10_.CONTACT_NUMBER
AND 1 =1
AND agreements0_.AGREEMENT_NUMBER ='004243'

EXPECTED GENERATED SQL
=======================================
SELECT agreements0_.CAMPUS AS col_0_0_,
agreements0_.AGREEMENT_NUMBER AS col_1_0_,
agreementc4_.CLASS_DESC AS col_2_0_,
agreements0_.CONTRACT_NUMBER AS col_3_0_,
agreements0_.EFFECTIVE_DATE AS col_4_0_,
agreements0_.EXPIRATION_DATE AS col_5_0_,
agreementt3_.TYPE_DESCRIPTION AS col_6_0_,
agreements0_.AGREEMENT_COMMENT AS col_7_0_,
agreements0_.RESPONSIBLE_ORGANIZATION AS col_8_0_,
cocompany6_.COMPANY_NAME AS col_9_0_,
agreements7_.STATUS_DESC AS col_10_0_,
billingsta8_.STATUS_DESC AS col_11_0_,
cooperatin1_.OPERATING_NAME AS col_12_0_,
cocontact2_.LAST_NAME AS col_13_0_,
cocontact2_.FIRST_NAME AS col_14_0_
FROM AGREEMENTS agreements0_
LEFT OUTER JOIN CO_OPERATING_NAMES cooperatin1_
ON agreements0_.COMPANY_NUMBER =cooperatin1_.COMPANY_NUMBER
AND agreements0_.OPERATING_NAME_ID=cooperatin1_.OPERATING_NAME_ID
LEFT OUTER JOIN CO_CONTACT cocontact2_
ON agreements0_.MANAGE_COMPANY =cocontact2_.COMPANY_NUMBER
AND agreements0_.MANAGE_CONTACT=cocontact2_.CONTACT_NUMBER,
AGREEMENT_TYPES agreementt3_,
AGREEMENT_CLASSES agreementc4_,
CO_COMPANY cocompany6_,
AGREEMENT_STATUSES agreements7_,
BILLING_STATUSES billingsta8_
WHERE agreements0_.AGREEMENT_TYPE =agreementt3_.AGREEMENT_TYPE
AND agreementt3_.AGREEMENT_CLASS =agreementc4_.AGREEMENT_CLASS
AND agreements0_.COMPANY_NUMBER =cocompany6_.COMPANY_NUMBER
AND agreements0_.AGREEMENT_STATUS =agreements7_.AGREEMENT_STATUS
AND agreements0_.BILLING_STATUS =billingsta8_.BILLING_STATUS
AND 1 =1
AND agreements0_.AGREEMENT_NUMBER ='004243'