R12 Projects

/* Formatted on 13-08-2011 15:46:24 (QP5 v5.115.810.9015) */
  SELECT            hou.name Operating_unit,
                    ppa.segment1 Project_No,
                    ppa.NAME Project_Name,
                    ppa.DESCRIPTION,
                    pat.TASK_NAME
    FROM   pa_projects_All ppa, hr_operating_units hou, pa_tasks pat
   WHERE   ppa.org_id = hou.organization_id AND ppa.PROJECT_ID = pat.PROJECT_ID
ORDER BY   hou.ORGANIZATION_ID