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）限制的操作单元。 4CC295CF3B127FF2E0530100007F22A4 select x.operating_unit, x.approval_group, x.description, x.object, initcap(x.rule_type_code) type, x.amount_limit, case x.object_code when 'LOCATION' then (select hl.location_code from hr_locations hl where x.location_id=hl.location_id) else trim (fifs.concatenated_segment_delimiter from x.segment1_low||fifs.concatenated_segment_delimiter|| x.segment2_low||fifs.concatenated_segment_delimiter|| x.segment3_low||fifs.concatenated_segment_delimiter|| x.segment4_low||fifs.concatenated_segment_delimiter|| x.segment5_low||fifs.concatenated_segment_delimiter|| x.segment6_low||fifs.concatenated_segment_delimiter|| x.segment7_low||fifs.concatenated_segment_delimiter|| x.segment8_low||fifs.concatenated_segment_delimiter|| x.segment9_low||fifs.concatenated_segment_delimiter|| x.segment10_low||fifs.concatenated_segment_delimiter|| x.segment11_low||fifs.concatenated_segment_delimiter|| x.segment12_low||fifs.concatenated_segment_delimiter|| x.segment13_low) end low_value, trim (fifs.concatenated_segment_delimiter from x.segment1_high||fifs.concatenated_segment_delimiter|| x.segment2_high||fifs.concatenated_segment_delimiter|| x.segment3_high||fifs.concatenated_segment_delimiter|| x.segment4_high||fifs.concatenated_segment_delimiter|| x.segment5_high||fifs.concatenated_segment_delimiter|| x.segment6_high||fifs.concatenated_segment_delimiter|| x.segment7_high||fifs.concatenated_segment_delimiter|| x.segment8_high||fifs.concatenated_segment_delimiter|| x.segment9_high||fifs.concatenated_segment_delimiter|| x.segment10_high||fifs.concatenated_segment_delimiter|| x.segment11_high||fifs.concatenated_segment_delimiter|| x.segment12_high||fifs.concatenated_segment_delimiter|| x.segment13_high) high_value from ( select haouv.name operating_unit, pcga.control_group_name approval_group, pcga.description, xxen_util.meaning(pcr.object_code,'CONTROLLED_OBJECT',201) object, decode(pcr.object_code, 'ACCOUNT_RANGE',101, 'ITEM_CATEGORY_RANGE',401, 'ITEM_RANGE',401 ) application_id, decode(pcr.object_code, 'ACCOUNT_RANGE','GL#', 'ITEM_CATEGORY_RANGE','MCAT', 'ITEM_RANGE','MSTK' ) id_flex_code, decode(pcr.object_code, 'ACCOUNT_RANGE',(select gl.chart_of_accounts_id from financials_system_params_all fspa, gl_ledgers gl where pcga.org_id=fspa.org_id and fspa.set_of_books_id=gl.ledger_id), 'ITEM_CATEGORY_RANGE',(select mcsb.structure_id from mtl_default_category_sets mdcs, mtl_category_sets_b mcsb where mdcs.functional_area_id=2 and mdcs.category_set_id=mcsb.category_set_id), 'ITEM_RANGE',101 ) id_flex_num, pcr.* from hr_all_organization_units_vl haouv, po_control_groups_all pcga, po_control_rules pcr where 1=1 and haouv.organization_id=pcga.org_id and pcga.control_group_id=pcr.control_group_id ) x, fnd_id_flex_structures fifs where x.application_id=fifs.application_id(+) and x.id_flex_code=fifs.id_flex_code(+) and x.id_flex_num=fifs.id_flex_num(+) order by x.operating_unit, x.approval_group, x.object, x.rule_type_code Y AR PO Approval Groups مجموعات الموافقة على أوامر الشراء وقواعد الموافقة على سبيل المثال حدود المبلغ أو نطاقات الحساب D PO Approval Groups Bestellgenehmigungsgruppen und Genehmigungsregeln z. B. Betragsgrenzen oder Kontobereiche E PO Approval Groups Grupos de aprobación de pedidos y reglas de aprobación, por ejemplo, límites de importe o rangos de cuentas F PO Approval Groups les groupes d'approbation des OP et les règles d'approbation, par exemple les limites de montant ou les fourchettes de comptes I PO Approval Groups Gruppi di approvazione degli OP e regole di approvazione, ad esempio limiti di importo o intervalli di conto JA PO Approval Groups PO承認グループと承認ルール（限度額や口座範囲など KO PO Approval Groups PO 승인 그룹 및 승인 규칙 (예 : 금액 한도 또는 계정 범위 PTB PO Approval Groups Grupos de aprovação de PO e regras de aprovação, por exemplo, limites de quantidade ou faixas de conta RU PO Approval Groups группы утверждения ПО и правила утверждения, например, лимиты сумм или диапазоны счетов S PO Approval Groups PO-godkännandegrupper och godkännandebestämmelser, t.ex. beloppsgränser eller kontointervall TR PO Approval Groups PO onay grupları ve onay kuralları, ör. miktar limitleri veya hesap aralıkları US PO Approval Groups PO approval groups and approval rules e.g. amount limits or account ranges ZHS PO Approval Groups 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 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 :$flex$.operating_unit Operating Unit Approval Group