It looks like it's a denormalized copy of every status report with one record per status report per user in the system.
Is that right? Why would you do that?
Instead of using this view, check out odf_cop_prj_statusrpt_v2 and see if it helps in your requirement.
That table is used in the out of the box Project Status Detail report.
FROM inv_investments i
INNER JOIN inv_projects p ON i.id = p.prID
INNER JOIN odf_project_v2 pv ON i.id = pv.odf_pk
INNER JOIN cop_inv_days_late_v dl ON i.id = dl.investment_id
INNER JOIN cmn_sec_users u ON i.manager_id = u.id
LEFT OUTER JOIN cop_prj_statusrpt_latest_v r1 ON i.id = r1.investment_id AND r1.report_order = 1
LEFT OUTER JOIN odf_cop_prj_statusrpt_v sr1 ON r1.report_id = sr1.odf_pk
AND sr1.odf_user_id =
Retrieving data ...