Project Events

SELECT ppa.segment1

     , ppa.name

     , pe.creation_date

     , fu.description created_by

     , haou.name hr_org

     , pps.project_status_name status

     , pt.task_number task

     , pt.task_name

     , pe.event_type

     , pe.completion_date

     , pe.bill_trans_bill_amount bill_amt

     , pe.bill_trans_rev_amount rev_amt

     , pe.revenue_distributed_flag

  FROM pa.pa_events pe

     , pa.pa_projects_all ppa

     , pa.pa_project_statuses pps

     , pa.pa_tasks pt

     , applsys.fnd_user fu

     , hr.hr_all_organization_units haou

 WHERE pe.project_id = ppa.project_id

   AND pe.task_id = pt.task_id

   and pe.created_by = fu.user_id

   AND ppa.project_status_code = pps.project_status_code

   AND ppa.carrying_out_organization_id = haou.organization_id

   AND ppa.segment1 = :projectnum

ORDER BY pe.creation_date desc;