PA Task Schedule

Description
Categories: Enginatics, Toolkit - Operations
Repository: Github
Summary project report showing operating unit, project, task, scheduled start date, scheduled finish date, created by, and last updated by.
Run PA Task Schedule and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Project
ppa.segment1=:project_number
LOV
Operating Unit
haouv.name=:operating_unit
LOV