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