ECC Project Manufacturing, Tasks

select
x.*
from
(
select * from ( SELECT  /*+ leading(pppa) index(pp PA_PROJECTS_U1) */    'PROJ_TASK-' || pt.project_id || '-' || pt.task_id AS ecc_spec_id,  GREATEST( pp.last_update_date, pt.last_update_date, NVL( ptm.last_update_date, pp.last_update_date ) ) AS ecc_last_update_date,  pp.project_id AS project_id, pp.segment1 AS project_number, pp.org_id AS org_id, pt.task_id AS task_id,  pt.task_number AS task_number, pt.task_name AS task_name, pt.description AS task_description,  pt.start_date AS task_start_date, pt.completion_date AS task_completion_date, ptm.full_name AS task_manager  FROM      pa_projects_all pp, pa_tasks pt, per_all_people_f ptm,      (SELECT DISTINCT project_id FROM pjm_project_parameters) pppa     WHERE pp.start_date >= NVL(to_date('2021/12/12','RRRR/MM/DD HH24:MI:SS'), pp.start_date) AND pp.project_type <> 'AWARD_PROJECT'  AND pp.template_flag = 'N'  AND pp.project_id = pppa.project_id  AND pp.project_id = pt.project_id  AND ptm.person_id(+) = pt.task_manager_person_id  AND TRUNC(SYSDATE) BETWEEN ptm.effective_start_date (+) AND ptm.effective_end_date (+)  )  
) x
where
2=2