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）限制的操作单元。 B4E3DF78097FFB27E0530100007F704C PER Job Y select pjv.name value, haouv.name description from per_jobs_vl pjv, hr_all_organization_units_vl haouv where (:$flex$.operating_unit is null or pjv.business_group_id in (select haouv.business_group_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and pjv.business_group_id=haouv.organization_id and sysdate between pjv.date_from and nvl (pjv.date_to, sysdate) order by pjv.name US B4E3DF780980FB27E0530100007F704C PER Position Y select pp.name value, pjv.name description from per_positions pp, per_jobs_vl pjv where (:$flex$.operating_unit is null or pp.business_group_id in (select haouv.business_group_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and sysdate between pp.date_effective and nvl(pp.date_end,sysdate) and pp.job_id=pjv.job_id order by pp.name US 4CC23A21470F6D5FE0530100007F9913 select haouv.name operating_unit, haouv2.name hr_organization, pp.name position, pjv.name job, pcf.control_function_name document_type, pcga.control_group_name approval_group, pcga.description approval_group_description, ppca.start_date, xxen_util.user_name(ppca.created_by) created_by, xxen_util.client_time(ppca.creation_date) creation_date, xxen_util.user_name(ppca.last_updated_by) last_updated_by, xxen_util.client_time(ppca.last_update_date) last_update_date, xxen_util.meaning(pcf.document_type_code,'DOCUMENT TYPE',201) document_type_, xxen_util.meaning(pcf.document_subtype,'NTN_DOC_TYPE',0) document_subtype from po_position_controls_all ppca, hr_all_organization_units_vl haouv, hr_all_organization_units_vl haouv2, (select pjv.* from per_jobs_vl pjv where sysdate between pjv.date_from and nvl (pjv.date_to, sysdate)) pjv, (select pp.* from per_positions pp where sysdate between pp.date_effective and nvl (pp.date_end, sysdate)) pp, po_control_groups_all pcga, po_control_functions pcf where 1=1 and sysdate between ppca.start_date and nvl(ppca.end_date,sysdate) and ppca.org_id=haouv.organization_id and ppca.organization_id=haouv2.organization_id(+) and ppca.job_id=pjv.job_id(+) and ppca.position_id=pp.position_id(+) and ppca.control_group_id=pcga.control_group_id(+) and ppca.control_function_id=pcf.control_function_id(+) order by haouv.name, pjv.name, pp.name, pcga.control_group_name, pcf.control_function_name Y AR PO Approval Assignments تعيينات مجموعة الموافقة على مستندات PO النشطة مع وظائف أو مناصب الموارد البشرية D PO Approval Assignments Aktive Genehmigungsgruppenzuordnungen für Bestellbelege mit HR-Stellen oder -Planstellen E PO Approval Assignments Asignaciones de grupos de aprobación de documentos de pedido activos con puestos de trabajo o posiciones de RRHH F PO Approval Assignments Affectations de groupes d'approbation de documents de PO actifs avec des emplois ou des postes de RH I PO Approval Assignments Assegnazioni di gruppi di approvazione di documenti PO attivi con lavori o posizioni HR JA PO Approval Assignments 人事の仕事やポジションを持つアクティブなPO文書承認グループの割り当て KO PO Approval Assignments HR Job 또는 Position이있는 활성 PO 문서 승인 그룹 지정 PTB PO Approval Assignments Aprovação ativa de grupos de aprovação de documentos PO com cargos ou posições de RH RU PO Approval Assignments Активные групповые задания по утверждению документов PO с заданиями или должностями в области HR S PO Approval Assignments Aktivt PO-godkännande gruppuppdrag med HR-jobb eller befattningar TR PO Approval Assignments İK işleri veya pozisyonları ile aktif PO belge onay grubu atamaları US PO Approval Assignments Active PO document approval group assignments with HR jobs or positions ZHS PO Approval Assignments 主动将PO单据审批组的任务与人力资源工作或岗位挂钩 Enginatics 1=1 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)) Y F Unité d'exploitation US Operating Unit 2 20 1=1 pcf.control_function_name=:document_type LOV custom Y select pcf.control_function_name value, flvv.meaning description from po_control_functions pcf, fnd_lookup_values_vl flvv where pcf.document_type_code=flvv.lookup_code(+) and flvv.lookup_type(+)='DOCUMENT TYPE' and flvv.view_application_id(+)=201 and flvv.security_group_id(+)=0 order by flvv.meaning, pcf.control_function_name F Type de document US Document Type 3 30 1=1 pcga.control_group_name=:approval_group LOV custom Y select pcga.control_group_name value, pcga.description from po_control_groups_all pcga where pcga.org_id is null or pcga.org_id in (select hou.organization_id from hr_operating_units hou where hou.name=:$flex$.operating_unit) order by pcga.control_group_name F Groupe d'approbation US Approval Group 4 40 1=1 pjv.name=:job LOV PER Job B4E3DF78097FFB27E0530100007F704C Y select pjv.name value, haouv.name description from per_jobs_vl pjv, hr_all_organization_units_vl haouv where (:$flex$.operating_unit is null or pjv.business_group_id in (select haouv.business_group_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and pjv.business_group_id=haouv.organization_id and sysdate between pjv.date_from and nvl (pjv.date_to, sysdate) order by pjv.name F Emploi US Job 5 50 1=1 pp.name=:position LOV PER Position B4E3DF780980FB27E0530100007F704C Y select pp.name value, pjv.name description from per_positions pp, per_jobs_vl pjv where (:$flex$.operating_unit is null or pp.business_group_id in (select haouv.business_group_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and sysdate between pp.date_effective and nvl(pp.date_end,sysdate) and pp.job_id=pjv.job_id order by pp.name US Position :$flex$.operating_unit Operating Unit Approval Group :$flex$.operating_unit Operating Unit Job :$flex$.operating_unit Operating Unit Position