PA Employee Activity By Organization

➜ Back to Library
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 ...
Application: Projects
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
Download
Related Blitz Reports
PA Project Expenditure Adjustment Activity PA Task Details PA AUD: Expenditure Batch Status PA Project Configuration ECC Projects, Projects Costing: Transactions PA Project Types PA Update Project Summary Amounts for a Single Project PA Refresh Project Summary Amounts PA Update Project Summary Amounts
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: