Object fetch with joins view

vwImportingSystemTestResult.sql

create view tmp.vwImportingSystemTestResult
AS
SELECT TR.ImportingSystemTestResultId, TR.EnteredTimestamp, TR.RunTimestamp, TR.ImportingSystemTestId, TR.ImportingSystemId, TR.EnvironmentId, TR.RequesterId, TR.ImportingSystemTestExecutionStatusId, 
	TR.ResultFilename, Q.RequestId, DurationMs,
	T.TestName, ImpSys.ImportingSystemName, E.Name, U.Username
FROM dbo.ImportingSystemTestResult TR
	JOIN dbo.ImportingSystemTestRunTime TRT ON TRT.ImportingSystemTestResultId = TR.ImportingSystemTestResultId
	JOIN dbo.ImportingSystemTestQueue Q ON Q.ImportingSystemTestQueueId = TR.ImportingSystemTestQueueId
	-- names joins
	JOIN dbo.ImportingSystemTest T ON T.ImportingSystemTestId = TR.ImportingSystemTestId
	JOIN dbo.ImportingSystem ImpSys ON ImpSys.ImportingSystemId = T.ImportingSystemId
	JOIN dbo.Environment E ON E.EnvironmentId = TR.EnvironmentId
	JOIN dbo.AppUser U ON U.AppUserId = TR.RequesterId
GO