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）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A803BC08ACE0530100007FEB91Y select haouv.name operating_unit, count(*) count, count(distinct decode(rila.interface_line_context,'ORDER ENTRY',rila.interface_line_attribute1)) order_count, &lp_columns sum(rila.amount) amount, rila.currency_code, riea.message_text, rila.batch_source_name, rila.interface_line_context, rila.request_id from hr_all_organization_units_vl haouv, ra_interface_lines_all rila, ra_interface_errors_all riea where 1=1 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 haouv.organization_id=rila.org_id and rila.interface_line_id=riea.interface_line_id(+) group by haouv.name, &group_by rila.currency_code, riea.message_text, rila.interface_status, rila.batch_source_name, rila.interface_line_context, rila.request_id order by haouv.name, count(*) desc AR AR Autoinvoice Interface Summary ملخص السجلات في واجهة "الفاتورة التلقائية" ، مرتبة حسب وحدة التشغيل ، بما في ذلك عدد الطلبات وإجمالي قيمة الأوامر ورمز العملة. D AR Autoinvoice Interface Summary Zusammenfassung der Datensätze in der Auto-Rechnungsschnittstelle, sortiert nach Bedieneinheit und einschließlich Auftragsanzahl, Gesamtauftragswert und Währungscode. E AR Autoinvoice Interface Summary Resumen de los registros en la interfaz de autofacturación, ordenados por unidad operativa, e incluyendo el recuento de pedidos, el valor total de los mismos y el código de moneda. F AR Autoinvoice Interface Summary Résumé des enregistrements dans l'interface de facturation automatique, triés par unité opérationnelle, et comprenant le nombre de commandes, la valeur totale des commandes et le code de la devise. I AR Autoinvoice Interface Summary Riepilogo delle registrazioni nell'interfaccia di autofattura, ordinate per unità operativa e comprendenti il conteggio degli ordini, il valore totale degli ordini e il codice della valuta. JA AR Autoinvoice Interface Summary オートインボイスのインターフェイスのレコードを操作単位でソートし、注文数、注文総額、通貨コードを含めてまとめています。 KO AR Autoinvoice Interface Summary 운영 단위별로 정렬되고 주문 수, 총 주문 금액 및 통화 코드를 포함하여 자동 송장 인터페이스의 레코드 요약. PTB AR Autoinvoice Interface Summary Resumo dos registros na interface da nota fiscal automática, classificados por unidade operacional, e incluindo contagem de pedidos, valor total dos pedidos e código da moeda. RU AR Autoinvoice Interface Summary Сводка записей в интерфейсе автосчета, отсортированная по операционной единице, с учетом количества заказов, общей стоимости заказов и кода валюты. S AR Autoinvoice Interface Summary Sammanfattning av poster i autofakturagränssnittet, sorterat efter operativ enhet, inklusive orderantal, totalt ordervärde och valutakod. TR AR Autoinvoice Interface Summary Otomatik fatura arayüzündeki kayıtların özeti, işletim birimine göre sıralanmış ve sipariş sayısı, toplam sipariş değeri ve para birimi kodu dahil. US AR Autoinvoice Interface Summary Summary of records in the autoinvoice interface, sorted by operating unit, and including order count, total orders value and currency code. ZHS AR Autoinvoice Interface Summary 自动发票界面的记录汇总，按操作单位排序，包括订单数、订单总价值和货币代码。 Enginatics &group_by &lp_columns 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)) US Operating Unit 2 20 &lp_columns trunc(sysdate-rila.creation_date) age, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher l'âge US Show Age 3 &group_by trunc(sysdate-rila.creation_date), F Afficher l'âge US Show Age