Query works fine as direct query but not in stored proc

[dbrewerton]

Greetings experts. I'm trying to figure something out and I'm having no luck. This query works fine as a direct query but my requirement is to make it into a procedure. The error from the proc is "Invalid object name 'Query'". Here is the query.

SELECT TOP 5 Name, Sev, COUNT(SimID) AS Count
FROM (
    SELECT C.Name, B.SimID, (CASE 
    WHEN C.Sev = 1 THEN 'Low' 
    WHEN C.Sev = 2 THEN 'Medium' 
    WHEN C.Sev = 3 THEN 'High' END) AS Severity
    FROM [LINKEDSRV].[MYDB2].[Entities].[Scan] AS A 
    INNER JOIN [LINKEDSRV].[MYDB2].[Entities].[Result] AS B ON A.Id = B.ScanId 
    INNER JOIN Query AS C ON B.QueryVersionId = C.QueryId
    WHERE (C.Sev = 1)) AS Z
GROUP BY Name, Severity
ORDER BY Severity, Count DESC;
 

[Rabbit]

Try disambiguating query by supplying the database name and schema like you did with the other tables.