HXT Time Management to Project Accounting Retrieval

Description
Categories: BI Publisher
Columns: Date Worked, Date Otl Hours, Date Transferred Hours, Date Interface Hours, Otl Hours, Transferred Hours, Interface Hours, Element Name, Project Name, Task Number ...
Application: Time and Labor
Source: OTL: Time Management to Project Accounting Retrieval Report
Short Name: HXTPATRAN
DB package: HXT_TRAN_PA_RPT
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