To expand on what J has provided, this will include the award information also.

select Distinct gaa.award_number, pp.segment1 project_number, pt.task_number, peia.expenditure_type, hou.name Organization
from pa_expenditure_items_all peia, pa_expenditures_all pe, hr_all_organization_units hou, pa_projects_all pp, pa_tasks pt
, gms_award_distributions gad
, gms_awards_all gaa
where peia.project_id = pp.project_id
and peia.task_id = pt.task_id
and hou.organization_id = nvl(override_to_organization_id, incurred_by_organization_id)
and peia.expenditure_id = pe.expenditure_id
and peia.expenditure_item_id = gad.expenditure_item_id
and gad.award_id = gaa.award_id
order by award_number, pp.segment1, pt.task_number;

Regards,
Shane