Answer:
This should provide the answer:
SELECT DISTINCT
HE.ENVIRONMENTNAME AS PROJECTNAME,
HARPACKAGE.PACKAGENAME,
HPFN.PATHFULLNAME,
HIN.ITEMNAME,
HVD.DATASIZE
FROM HARVERSIONDATA HVD
INNER JOIN HARVERSIONS HV ON HV.VERSIONDATAOBJID = HVD.VERSIONDATAOBJID
INNER JOIN HARPATHFULLNAME HPFN ON HV.PATHVERSIONID = HPFN.VERSIONOBJID
INNER JOIN HARITEMNAME HIN ON HIN.NAMEOBJID = HV.ITEMNAMEID
INNER JOIN HARVERSIONINVIEW HVIV ON HV.VERSIONOBJID = HVIV.VERSIONOBJID
INNER JOIN HARVIEW HVW ON HVW.VIEWOBJID = HVIV.VIEWOBJID
INNER JOIN HARENVIRONMENT HE ON HE.ENVOBJID = HVW.ENVOBJID
LEFT JOIN HARPACKAGE ON HARPACKAGE.PACKAGEOBJID = HV.PACKAGEOBJID
WHERE HE.ENVOBJID > 0
AND HVD.DATASIZE = (SELECT MAX(HARVERSIONDATA.DATASIZE) FROM HARVERSIONDATA)
------------------------------
Melinda Skelton
------------------------------