ECC Project Manufacturing, Tasks

Description
Categories: Enterprise Command Center
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
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