ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 4DADBA9F28E25278E0630100007F12DE select haouv.name operating_unit, ppx.employee_number, ppx.full_name employee_name, (select pj.name from per_jobs pj where pj.job_id=paf.job_id) job, haouv2.name organization, (select ppx2.full_name from per_people_x ppx2 where ppx2.person_id=paf.supervisor_id) supervisor, ppx.email_address from per_people_x ppx, per_assignments_f paf, hr_all_organization_units_vl haouv, hr_all_organization_units_vl haouv2 where 1=1 and ppx.person_id=paf.person_id and paf.primary_flag='Y' and paf.assignment_type='E' and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date and paf.business_group_id=haouv.organization_id and paf.organization_id=haouv2.organization_id and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and not exists ( select null from pa_expenditures_all pea where pea.incurred_by_person_id=ppx.person_id and pea.expenditure_ending_date=:week_ending_date ) order by haouv.name, haouv2.name, ppx.full_name Y PA AR PA بطاقات قيد الوقت المفقودة (بتنسيق XML) Application: المشروعات Source: AUD: بطاقات قيد الوقت المفقودة (بتنسيق XML) Short Name: PAXAUMTC_XML DB package: PA_PAXAUMTC_XMLP_PKG D PA Fehlende Stundennachweise Application: Projects Source: PA: Fehlende Stundennachweise (XML) Short Name: PAXAUMTC_XML DB package: PA_PAXAUMTC_XMLP_PKG F PA Feuilles de temps manquantes Application: Projects Source: AUD : Feuilles de temps manquantes (XML) Short Name: PAXAUMTC_XML DB package: PA_PAXAUMTC_XMLP_PKG US PA Missing Timecards Active employees who have not submitted timecards for a given week ending date, showing employee details, job, organization, and supervisor. ZHS PA AUD：缺少工时记录卡 Application: 项目 Source: AUD：缺少工时记录卡 (XML) Short Name: PAXAUMTC_XML DB package: PA_PAXAUMTC_XMLP_PKG Enginatics 1=1 :week_ending_date 1 10 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) AR من تاريخ نهاية الأسبوع D Von KW Ende F Date de fin de semaine - Du US Operating Unit ZHS 自周末日期 2 20 :week_ending_date Date Y AR إلى تاريخ نهاية الأسبوع D Bis KW Ende F Date de fin de semaine - Au US Week Ending Date ZHS 至周末日期 3 30 1=1 haouv2.name=:organization LOV custom Y Y select haouv2.name value, null description from hr_all_organization_units_vl haouv2 order by haouv2.name AR اسم التنظيم D Organisationsbezeichnung F Nom de l'organisation US Organization ZHS 组织名