The attached view will show the record id and record type that are associated with an element_global record. For each element_global, it will show:
HIGHER_CLASS_UNIT
ANIMAL_CAG
PLANT_CAG
COMM_CAG
EGR
ELEMENT_NATIONAL and subsequent ELEMENT_SUBNATIONAL and subsequent EOs, EO_RANK_SPECS
EO_SPECS
ELEMENT_SITE
ELEMENT_GROUP
SYNONYM_GLOBAL,
COMM_CAL
ELEMENT_GLOBAL (of which it is a parent),
ELEMENT_LINEAGE
ELEMENT_STD_NONSTD_REL
ELEMENT_MANAGEMENT

This can be modified to include other records. Just copy over the basic select and change the record names.