This query returns the legacy Capital IQ corporate tree for a selected Company ID using the company relationship dataset. It includes selected filters: current investments, subsidiaries/operating units, investment arms, and merged entities, across all ownership types. Up to level 2, the hierarchy expands across all stake types; from level 3 onward, only entities with Majority ownership are returned, with recursion limited to seven levels. Link - https://www.capitaliq.com/CIQDotNet/CorporateTree/CorporateTree.aspx?CompanyId=25915843