HXT Time Management to Project Accounting Retrieval

select TO_CHAR(date_worked,'DD-MON-YYYY') date_worked,
       sum(otl_hours) over (partition by date_worked) date_otl_hours,
       sum(transferred_hours) over (partition by date_worked) date_transferred_hours,
       sum(interface_hours) over (partition by date_worked) date_interface_hours,
       otl_hours,
       transferred_hours,
       interface_hours,
       element_name,
       project_name,
       task_number,
       expenditure_type,
       system_linkage_function,
       job_name,
       location_code,
       work_type_name
from (
select date_worked,
       sum(otl_hours) otl_hours,
       sum(transferred_hours) transferred_hours,
       sum(interface_hours) interface_hours,
       element_name,
       project_name,
       task_number,
       expenditure_type,
       system_linkage_function,
       job_name,
       location_code,
       work_type_name
  from hxt_det_pa_comparison
 WHERE tim_id = :tim_id
        group by date_worked,element_name,project_name,task_number,expenditure_type,system_linkage_function,job_name,location_code,work_type_name
)