ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F00E3869E053B46B63588994Y 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 ) HXT HXTPATRAN AR HXT تقرير استرجاع محاسبة مشروعات إدارة الوقت Application: الوقت والعمالة Source: OTL: تقرير استرجاع محاسبة مشروعات إدارة الوقت Short Name: HXTPATRAN DB package: HXT_TRAN_PA_RPT D HXT Abruf aus Zeit-Management in Projects Application: Time and Labor Source: OTL: Abruf aus Zeit-Management in Projects Short Name: HXTPATRAN DB package: HXT_TRAN_PA_RPT F HXT Etat d'extraction de Time Management vers Project Accounting Application: Time and Labor Source: OTL : Etat d'extraction de Time Management vers Project Accounting Short Name: HXTPATRAN DB package: HXT_TRAN_PA_RPT US HXT Time Management to Project Accounting Retrieval Application: Time and Labor Source: OTL: Time Management to Project Accounting Retrieval Report Short Name: HXTPATRAN DB package: HXT_TRAN_PA_RPT ZHS HXT OTL：项目会计的时间管理检索报表 Application: 时间和人工管理系统 Source: OTL：项目会计的时间管理检索报表 Short Name: HXTPATRAN DB package: HXT_TRAN_PA_RPT BI Publisher :lp_payroll_id :lp_payroll_name :lp_person_id :lp_person_name :lp_sysdate :lp_time_period_id :lp_time_period_name :lp_user :p_debug_flag :p_payroll_id :p_person_id :p_time_period_id :tim_id 1 10 :p_payroll_id LOV Oracle PY_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay,fnd_sessions fnd where pay.business_group_id= fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name Y AR كشف الرواتب D Lohn- und Gehaltsabrechnung F Paie US Payroll ZHS 工资单 2 20 :p_time_period_id LOV Oracle HXT_TIME_PERIOD Y select ptp.time_period_id id, ptp.period_name value, null description from per_time_periods ptp where ptp.payroll_id=:$flex$.py_srs_payroll order by ptp.start_date Y AR الفترة الزمنية D Zeitperiode F Période US Time Period ZHS 时间期