PA Task Schedule

Description
Categories: Enginatics, Toolkit - Operations
Repository: Github Columns: Operating Unit, Project, Task, Scheduled Start Date, Scheduled Finish Date, Created By, Last Updated By ...
Summary project report showing operating unit, project, task, scheduled start date, scheduled finish date, created by, and last updated by.
select
haouv.name operating_unit,
ppa.segment1 project,
ppe.name task,
ppevs.scheduled_start_date,
ppevs.scheduled_finish_date,
xxen_util.user_name(ppevs.created_by) created_by,
case when ppevs.creation_date<>ppevs.last_update_date or ppevs.created_by<>ppevs.last_updated_by then xxen_util.user_name(ppevs.last_updated_by) end last_updated_by
from
hr_all_organization_units haouv,
pa_projects_all ppa,
pa_proj_elements ppe,
pa_proj_elem_ver_schedule ppevs
where
1=1 and
haouv.organization_id=ppa.org_id and
ppa.project_id=ppe.project_id and
ppe.object_type='PA_TASKS' and
ppe.baseline_finish_date is not null and
ppe.project_id=ppevs.project_id and
ppe.proj_element_id=ppevs.proj_element_id
order by
haouv.name,
ppa.segment1,
ppe.name
Parameter Name SQL text Validation
Operating Unit
haouv.name=:operating_unit
LOV
Project
ppa.project_number=:project_number
LOV