PA Employee Activity By Organization
Description
Categories: BI Publisher
Columns: Prj Org Id, Assigned To Organization Name, Incurred By Name, Incurred By Employee Num 1, Job Name 1, Project Number, Project Name, Total Hours, Billable Hours, Non Billable Hours ...
Columns: Prj Org Id, Assigned To Organization Name, Incurred By Name, Incurred By Employee Num 1, Job Name 1, Project Number, Project Name, Total Hours, Billable Hours, Non Billable Hours ...
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
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 |