ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F00D3869E053B46B63588994Y SELECT /*+ INDEX(v.det HXT_DET_HOURS_RPT_N1)*/ v.full_name ,v.person_id ,v.organization_id ,to_char (v.date_worked,fnd_profile.value ('ICX_DATE_FORMAT_MASK')) date_worked ,v.hours Hours ,v.time_in ,v.time_out ,v.element_name ,v.sum_time_building_block_id ,(CASE WHEN v.sum_start_time IS NULL THEN to_char (v.sum_measure) ELSE to_char (v.sum_start_time,'HH24:MI')|| ' - '|| to_char (v.sum_stop_time,'HH24:MI') END) time_entered ,v.period_name ,v.earning_policy_name ,v.stage FROM hxt_det_hours_worked_rpt_v v WHERE v.person_id = nvl (:p_person_id,v.person_id) AND v.organization_id = nvl (:p_organization_id,v.organization_id) AND v.payroll_id = nvl (:p_payroll_id,v.payroll_id) AND v.date_worked BETWEEN :p_from_date AND :p_to_date ORDER BY v.full_name ASC ,v.date_worked ASC ,v.sum_time_building_block_id ASC ,v.element_name ASC HXT HXTDETRPT AR HXT تقرير تفاصيل قيد الوقت Application: الوقت والعمالة Source: OTL: تقرير تفاصيل قيد الوقت Short Name: HXTDETRPT DB package: HXT_DET_HRS_WORKED_RPT D HXT Zeiteingabe - Details Application: Time and Labor Source: OTL: Zeiteingabe - Details Short Name: HXTDETRPT DB package: HXT_DET_HRS_WORKED_RPT F HXT Etat détaillé de saisie des heures Application: Time and Labor Source: OTL : Etat détaillé de saisie des heures Short Name: HXTDETRPT DB package: HXT_DET_HRS_WORKED_RPT US HXT Time Entry Detail Application: Time and Labor Source: OTL: Time Entry Detail Report Short Name: HXTDETRPT DB package: HXT_DET_HRS_WORKED_RPT ZHS HXT OTL：时间录入明细报表 Application: 时间和人工管理系统 Source: OTL：时间录入明细报表 Short Name: HXTDETRPT DB package: HXT_DET_HRS_WORKED_RPT BI Publisher :lp_date_worked :lp_element :lp_from_date :lp_hours :lp_job :lp_location :lp_organization :lp_payroll :lp_person :lp_person_id :lp_project :lp_shift :lp_status :lp_sysdate :lp_task :lp_time_in :lp_time_out :lp_to_date :lp_user :p_from_date :p_organization_id :p_payroll_id :p_person_id :p_to_date 1 10 :p_from_date Date Y AR من تاريخ D Von Datum F Date de début US From Date ZHS 起始日期 2 20 :p_to_date Date Y AR إلى تاريخ D Bis Datum F Date de fin US To Date ZHS 终止日期 3 30 :p_person_id LOV Oracle PER_ALL_EMPLOYEES Y select person_id id, full_name value, null description from per_all_people_f where trunc(sysdate) between effective_start_date and effective_end_date and business_group_id=fnd_global.per_business_group_id and employee_number is not null order by value,description AR الشخص F Personne US Person ZHS 人员 4 40 :p_organization_id LOV Oracle HXC_ORGANIZATION_UNITS Y select organization_id id, o.name value, null description from per_organization_units o where business_group_id=fnd_profile.value('PER_BUSINESS_GROUP_ID') and trunc(sysdate) between o.date_from and nvl(o.date_to,to_date('31/12/4712','DD/MM/YYYY')) order by value,description AR المنشأة D Organisation F Organisation US Organization ZHS 组织 5 50 :p_payroll_id LOV Oracle HXC_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay where pay.business_group_id=fnd_profile.value('per_business_group_id') and trunc(sysdate) between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name AR كشف الرواتب D Lohn- und Gehaltsabrechnung F Paie US Payroll ZHS 工资单