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 ...
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