@Entity
@Table(name = "Organization")
public class Organization implements Serializable {

	@Id
	@Column(name = "OrganizationId", nullable = false)
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	private Integer id;

	@Column(name = "Name", nullable = false, length = 128)
	private String name;

	@Column(name = "Level", nullable = false)
	private int level;

	@Column(name = "Alias", nullable = false, length = 50)
	private String alias;

	@JoinTable(name = "OrganizationAncestry", 
			joinColumns = { 
				@JoinColumn(name = "Ancestor", referencedColumnName = "OrganizationId", nullable = false) 
			}, 
			inverseJoinColumns = { 
				@JoinColumn(name = "Descendent", referencedColumnName = "OrganizationId", nullable = false) 
			})
	@ManyToMany(fetch = FetchType.EAGER)
	private Collection<Organization> descendents;

	@ManyToMany(mappedBy = "descendents", fetch = FetchType.EAGER)
	private Collection<Organization> ancestors;

@Entity
@Table(name = "DocumentType")
public class DocumentType implements Serializable {

	@Id
  @Column(name = "DocumentTypeID", nullable = false)
	@GeneratedValue(strategy = GenerationType.IDENTITY)
  private Integer id;

  @Column(name = "TypeName", nullable = false, length = 40)
  private String name;

  @Column(name = "Alias", nullable = false, length = 40)
  private String alias;

  @Column(name = "Description", length = 256)
  private String description;

  @Column(name = "IsActive", nullable = false)
  private boolean active;
        
	@JoinColumn(name = "OrganizationID", referencedColumnName = "OrganizationID")
	@ManyToOne(fetch = FetchType.LAZY)
	private Organization organization;
	
}

SELECT
	t1.* 
FROM
    DocumentType AS t1 
JOIN
    OrganizationAncestry AS t2 
ON 
    t1.OrganizationId = t2.Ancestor 
JOIN 
	Organization AS t3 
ON 
    t3.OrganizationId = t2.Descendent
LEFT OUTER JOIN (
            OrganizationAncestry AS t4 
		JOIN 
            Organization AS t5 
		ON 
            t4.Descendent = t5.OrganizationId 
		JOIN 
            DocumentType AS t6 
		ON 
            t5.OrganizationId = t6.OrganizationId 
    ) 
ON 
    t2.Ancestor = t4.Ancestor 
AND
	t4.Ancestor <> t4.Descendent 
AND
	t1.Alias = t6.Alias 
WHERE
    t1.IsActive = 1
AND
	t3.Alias = 'IWT' 
AND
	t6.Alias IS NULL