SCCM 2012 View installer programs by ResourceID

SELECT vARP.DisplayName0, vARP.Publisher0, vARP.Version0 ,vARP.InstallDate0,vARP.TimeStamp
FROM[dbo].v_Add_Remove_Programs vARP
JOIN  [dbo].v_R_System vRS ON vARP.ResourceID = vRS.ResourceID 
WHERE vRS.ResourceID = @ID