XX PA Task Schedule

➜ Back to Library
Description
Summary project report showing operating unit, project, task, scheduled start date, scheduled finish date, created by, and last updated by.
Run XX 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.project_number=:project_number
 LOV
Operating Unit 
haouv.name=:operating_unit
 LOV
Download
Related Blitz Reports
PA Task Schedule ECC G-Invoicing, Projects: G-Invoicing PON Solicitation data template PO Endeca Template PA Implementation Options PA Project Event Upload ECC Project Manufacturing, Exceptions and Overdues, SQL1 ECC Project Manufacturing, Exceptions and Overdues, SQL5 ECC Project Manufacturing, Exceptions and Overdues, SQL3
Blitz Report™

Blitz Report™ provides multiple benefits: