SELECT 
R.projectId, 
R.corId, R.csId, R.coId, 
T.totalAllotment, T.totalAtIssue, T.totalInitiations, T.totalObligations, T.totalCosts, 
E1.lastName as lastName1, E2.lastName as lastName2, E3.lastName as lastName3, E4.lastName as lastName4, 
O1.orgName as orgName1, O2.orgName as orgName2, O3.orgName as orgName3, O4.orgName as orgName4 
FROM 
project R, 
Totals_from_amount T, 
Person E1, Person E2, Person E3, Person E4, 
Organization O1, Organization O2, Organization O3, Organization O4 
WHERE 
(R.projectId = T.projectId) 
AND (T.totalInitiations > 200000000) 
AND (R.corId = E1.personId(+) AND E1.orgId = O1.orgId(+)) 
AND (R.csId = E2.personId(+) AND E2.orgId = O2.orgId(+)) 
AND (R.coId = E3.personId(+) AND E3.orgId = O3.orgId(+)) 
AND (R.doeOrganizationId = O4.orgId(+)) 
ORDER BY T.totalAllotment;

SELECT   r.ProjectId,
         r.cOrId,
         r.csId,
         r.coId,
         t.TotalAllotment,
         t.TotalAtIssue,
         t.TotalInitiations,
         t.TotalObligations,
         t.TotalCosts,
         e1.LastName AS LastName1,
         e2.LastName AS LastName2,
         e3.LastName AS LastName3,
         e4.LastName AS LastName4,
         o1.OrgName AS OrgName1,
         o2.OrgName AS OrgName2,
         o3.OrgName AS OrgName3,
         o4.OrgName AS OrgName4
FROM     Project r,
         Totals_From_Amount t,
         Person e1,
         Person e2,
         Person e3,
         Person e4,
         Organization o1,
         Organization o2,
         Organization o3,
         Organization o4
WHERE    (r.ProjectId = t.ProjectId)
         AND (t.TotalInitiations > 200000000)
         AND (r.cOrId = e1.PersonId (+) 
              AND e1.OrGid = o1.OrGid (+) )
         AND (r.csId = e2.PersonId (+) 
              AND e2.OrGid = o2.OrGid (+) )
         AND (r.coId = e3.PersonId (+) 
              AND e3.OrGid = o3.OrGid (+) )
         AND (r.DoeOrganizationId = o4.OrGid (+) )
ORDER BY t.TotalAllotment;