ok, thank you.

Thanks for the post and the solution!

Altought i know the solution has already been posted i think this can help people with similar problems in case you need to get the entire reference hierarchy (it wont work if theres any circular reference in your application and you remove the "Level" limit):

/*Module dependencies*/
WITH DependencyTable AS (
 SELECT distinct E1.[Id] as ConsumerId, E1.[Name] as ConsumerName, E2.[Id] as ProducerId , E2.[Name] as ProducerName
    FROM {Espace} E1
    INNER JOIN {Espace_Version} EV1 ON E1.[Version_Id] = EV1.[Id]
    INNER JOIN {Espace_Reference} ON {Espace_Reference}.[Consumer_Version_Id] = EV1.[Id]
    INNER JOIN {Espace_Version} EV2 ON {Espace_Reference}.[Published_Prod_Version_Id] = EV2.[Id]
    INNER JOIN {Espace} E2 ON E2.[Id] = EV2.[eSpace_Id]
      WHERE 1 = 1
)

, RecursiveDependency AS (
    SELECT ConsumerId
           ,ConsumerName
          ,ProducerId
          ,ProducerName
        ,1 AS [Level]
    FROM DependencyTable
    WHERE ConsumerName = -- Insert eSpace Name --

    UNION ALL

    SELECT d.ConsumerId
           ,d.ConsumerName
          ,d.ProducerId
          ,d.ProducerName
        ,[Level] + 1 AS [Level]
    FROM
       RecursiveDependency r
       INNER JOIN DependencyTable d ON d.ConsumerId = r.ProducerId
  WHERE [Level] < 5 -- Ajust how deep you want to search
 
)

SELECT *
FROM RecursiveDependency
In the end you can ajust your last select to get the module you want