SQL query for packages and Source path of the packages

Below is the SQL query for a Task sequence ID” 'CE100053'” with referenced packages and Source path of the packages

SELECT     TOP (100) PERCENT ps.Name AS C062, ps.SourceVersion, ps.SourceDate, ps.Targeted AS NumberOfDPsTargeted0, ps.Installed AS NumberOfDPsInstalled0,

                      ps.Retrying AS NumberOfDPsRetrying0, ps.Failed AS NumberOfDPsFailed0, ps.SourceSite, ps.SourceSize, ps.SourceCompressedSize, ps.PackageID,

                      dbo.v_Package.PkgSourcePath AS [Pkg Source Path]

FROM         (SELECT DISTINCT ReferencePackageID AS PackageID

                       FROM          dbo.v_TaskSequenceReferencesInfo

                       WHERE      (PackageID = 'CE100053')) AS RefPkgs INNER JOIN

                      dbo.v_PackageStatusRootSummarizer AS ps ON ps.PackageID = RefPkgs.PackageID INNER JOIN

                      dbo.v_Package ON ps.PackageID = dbo.v_Package.PackageID

ORDER BY C062