PA Employee Activity By Organization
Description
Categories: BI Publisher
Application: Projects
Source: MGT: Employee Activity By Organization (XML)
Short Name: PAXEMRAO_XML
DB package: PA_PAXEMRAO_XMLP_PKG
Source: MGT: Employee Activity By Organization (XML)
Short Name: PAXEMRAO_XML
DB package: PA_PAXEMRAO_XMLP_PKG
Run
PA Employee Activity By Organization and other Oracle EBS reports with Blitz Report™ on our demo environment
select v.assigned_to_organization_id prj_org_id , substr(v.assigned_to_organization_name,1,60) assigned_to_organization_name , v.incurred_by_name , v.incurred_by_employee_num incurred_by_employee_num_1 , v.job_name job_name_1 , v.project_number , v.project_name , sum(v.total_hours) total_hours , sum(v.billable_hours) billable_hours , sum(v.non_billable_hours) non_billable_hours, --PA_PAXEMRAO_XMLP_PKG.c_org_utilizationformula(:c_org_tot_hours, :c_org_tot_billable) c_org_utilization, PA_PAXEMRAO_XMLP_PKG.c_utilizationformula(sum(v.total_hours), sum(v.billable_hours)) c_utilization --PA_PAXEMRAO_XMLP_PKG.c_project_utilizationformula(:C_pr_tot_ho,:C_p_tot_bi) c_project_utilization from pa_labor_expenditures_view v WHERE v.incurred_by_person_id = nvl(:p_person_id, v.incurred_by_person_id) and v.expenditure_item_date between :date_lo and :date_hi and v.assigned_to_organization_id=:organization_id Group by v.assigned_to_organization_id, v.assigned_to_organization_name, v.incurred_by_name, v.incurred_by_employee_num, v.job_name, v.project_number, v.project_name /*Order by v.assigned_to_organization_name, v.incurred_by_name, v.project_number */ Order by v.assigned_to_organization_id,v.incurred_by_name,v.incurred_by_employee_num,v.job_name, v.project_number,v.project_name |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Start Organization |
|
LOV Oracle | |
Employee Name |
|
LOV Oracle | |
From Date |
|
Date | |
To Date |
|
Date | |
Display Details |
|
LOV Oracle |