HXT Time Management to Project Accounting Retrieval
Description
Categories: BI Publisher
Application: Time and Labor
Source: OTL: Time Management to Project Accounting Retrieval Report
Short Name: HXTPATRAN
DB package: HXT_TRAN_PA_RPT
Source: OTL: Time Management to Project Accounting Retrieval Report
Short Name: HXTPATRAN
DB package: HXT_TRAN_PA_RPT
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 ) |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Payroll |
|
LOV Oracle | |
Time Period |
|
LOV Oracle |