ECC Project Manufacturing, Tasks

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Ecc Last Update Date, Project Id, Project Number, Org Id, Task Id, Task Number, Task Name, Task Description, Task Start Date ...
Imported from Enterprise Command Center
Description: Project Manufacturing Tasks
Dataset Key: pjm-tasks
Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
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('','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
Parameter Name SQL text Validation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV