ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFF53869E053B46B63588994Y SELECT TO_CHAR(TIME_ENTRY_DATE,'dd-MON-yyyy') ENTRY_DATE, ATTRIBUTE_INFO, NVL(start_stop_time,hours) HOURS, ACTION, TO_CHAR(ACTION_DATE,'dd-MON-yy HH24:MI:SS') ACTION_BY_DATE, ACTION_BY, COMMENTS, CLA_REASON, RESOURCE_NAME, TO_CHAR(TC_START_TIME,'dd-MON-yyyy') START_TIME, TO_CHAR(TC_STOP_TIME,'dd-MON-yyyy') STOP_TIME, SUBSTR(ACTION_TYPE,1,1) ACTION_ON FROM hxc_rpt_tc_audit ORDER BY resource_name, tc_start_time, transaction_id, TRUNC(time_entry_date), action_type, action_date HXC HXCRPTAUD AR HXC تقرير مسار تدقيق بطاقة قيد الوقت Application: محرك الوقت والعمالة Source: OTL: تقرير مسار تدقيق بطاقة قيد الوقت Short Name: HXCRPTAUD DB package: HXC_RPT_TC_AUDIT_TRAIL D HXC Stundennachweise - Prüfprotokoll Application: Time & Labor-Engine Source: OTL: Stundennachweise - Prüfprotokoll Short Name: HXCRPTAUD DB package: HXC_RPT_TC_AUDIT_TRAIL F HXC Etat de piste d'audit des feuilles de temps Application: Moteur Time and Labor Source: OTL : Etat de piste d'audit des feuilles de temps Short Name: HXCRPTAUD DB package: HXC_RPT_TC_AUDIT_TRAIL US HXC Timecard Audit Trail Application: Time and Labor Engine Source: OTL: Timecard Audit Trail Report Short Name: HXCRPTAUD DB package: HXC_RPT_TC_AUDIT_TRAIL ZHS HXC OTL：工时记录卡跟踪线索报表 Application: 时间和人工引擎 Source: OTL：工时记录卡跟踪线索报表 Short Name: HXCRPTAUD DB package: HXC_RPT_TC_AUDIT_TRAIL BI Publisher :lp_dat_regen :lp_from_date :lp_location :lp_no_parm :lp_org :lp_payroll :lp_person :lp_record_save :lp_supervisor :lp_sysdate :lp_to_date :lp_user :p_dat_regen :p_from_date :p_locn_id :p_org_id :p_payroll_id :p_person_id :p_record_save :p_supervisor_id :p_to_date 1 10 :p_from_date Date Y AR من تاريخ D Von Datum F Date - Du US From Date ZHS 自日期 2 20 :p_to_date Date Y AR إلى تاريخ D Bis Datum F Date - Au US To Date ZHS 至日期 3 30 :p_dat_regen LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description Y AR هل تريد حذف البيانات وإعادة تكوينها؟ D Daten löschen und erneut generieren? F Supprimer et regénérer les données ? US Delete and Regenerate Data? ZHS 删除并重新生成数据？ 4 40 :p_record_save LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description Y AR هل تريد عرض السجلات مع حالة العمل؟ D Datensätze mit Status "In Bearbeitung" anzeigen? F Afficher les enregistrements ayant le statut En cours ? US Display Records with Working Status? ZHS 显示状态为“正在处理”的记录？ 5 50 :p_org_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 组织 6 60 :p_locn_id LOV Oracle HR_US_LOCATIONS Y select hl.location_id id, hl.location_code value, null description from hr_locations hl where location_use='HR' order by location_code AR الموقع D Standort F Lieu US Location ZHS 地点 7 70 :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 工资单 8 80 :p_supervisor_id LOV Oracle HXC_RPT_SUPERVISORS Y select person_id id, full_name value, null description from per_all_people_f ppf where business_group_id=fnd_profile.value('per_business_group_id') and exists (select 1 from per_all_assignments_f paf where paf.business_group_id=fnd_profile.value('per_business_group_id') and paf.supervisor_id=ppf.person_id) and sysdate between ppf.effective_start_date and ppf.effective_end_date order by value,description AR المشرف D Vorgesetzter F Supérieur hiérarchique US Supervisor ZHS 主管 9 90 :p_person_id LOV Oracle HR_OTC_EMPLOYEE_NAME Y select peo.person_id id, peo.full_name value, null description from per_all_people_f peo where peo.business_group_id+0= fnd_global.per_business_group_id and peo.effective_end_date= (select max(peo1.effective_end_date) from per_all_people_f peo1 where peo1.person_id=peo.person_id) and exists (select 'Y' from hxc_time_building_blocks htbb where peo.person_id=htbb.resource_id and htbb.resource_type='PERSON') order by peo.last_name,peo.first_name AR الشخص F Personne US Person ZHS 人员