Project Task Details in Oracle Apps

  SELECT DISTINCT
         hou.name "Operating Unit",
         ppa.project_id "Project ID",
         ppa.segment1 "Project Number",
         ppa.name "Project Name",
         ppa.project_type "Project Type",
         ppt.project_type_class_code "Project Type class",
         pt.wbs_Level "WBS Level",
         pt.task_id "Task ID",
         pt.task_Number "Task Number",
         pt.task_Name "Task Name",
         pt.top_Task_id "Top Task ID",
         NVL2 (pt.top_task_id, pt1.task_number, NULL) "Top Task",
         pt.parent_task_id "Parent Task ID",
         NVL2 (pt.parent_task_id, pt2.task_number, NULL) "Parent Task ",
         pt.long_task_name "Task Long Name",
         pt.description "Task Description",
         pt.start_date "Task Start Date",
         pt.completion_date "Task End Date",
         NVL2 (pt.carrying_out_organization_id, hou.name, NULL)
            "Task Organization",
         NVL2 (pt.customer_id, ppcv.customer_name, NULL) "Task Customer",
         papf.full_name "Task Manager",
         flv.meaning "Task Service Type",
         pwtv.name "Task Work Type",
         pt.chargeable_flag "Chargeable Task",
         pt.billable_flag "Billable Task",
         pt.ready_to_bill_flag "Ready to Bill Flag"
    FROM pa_projects_all ppa,
         hr_organization_units hou,
         pa_project_types_all ppt,
         pa_tasks pt,
         pa_tasks pt1,
         pa_tasks pt2,
         pa_project_customers_v ppcv,
         fnd_lookup_values flv,
         per_all_people_f papf,
         pa_work_types_vl pwtv
   WHERE     1 = 1
         AND ppa.org_id = hou.organization_id
         AND ppa.project_type = ppt.project_type
         AND ppa.project_status_code = 'APPROVED'
         AND ppt.project_type_class_code = 'CONTRACT'
         AND ppa.project_id = pt.project_id(+)
         AND pt.top_task_id = pt1.task_id(+)
         AND pt.parent_task_id = pt2.task_id(+)
         AND pt.customer_id = ppcv.customer_id(+)
         AND pt.service_type_code = flv.lookup_code
         AND pt.task_manager_person_id = papf.person_id(+)
         AND pt.work_type_id = pwtv.work_type_id(+)
         AND flv.lookup_type = 'SERVICE TYPE'
         AND ppa.project_type LIKE '%O&M%'
         AND (   papf.effective_end_date IS NULL
              OR papf.effective_end_date >= SYSDATE)
ORDER BY hou.name, ppa.segment1, pt.task_number;