ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9E79D2E0530100007F1FF2 FND Responsibility Name Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name US 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 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）限制的操作单元。 82288223F2443869E053B46B63588994 select haouv.name operating_unit, oaadv.order_number, case when oaadv.entity_id in (2,7,8) then ( select case when oola.service_number is not null then case when oola.option_number is not null then case when oola.component_number is not null then oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'.'||oola.component_number||'.'||oola.service_number else oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'..'||oola.service_number end else case when oola.component_number is not null then oola.line_number||'.'||oola.shipment_number||'..'||oola.component_number||'.'||oola.service_number else oola.line_number||'.'||oola.shipment_number||'...'||oola.service_number end end when oola.option_number is not null then case when oola.component_number is not null then oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'.'||oola.component_number else oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number end when oola.component_number is not null then oola.line_number||'.'||oola.shipment_number||'..'||oola.component_number when oola.line_number is not null or oola.shipment_number is not null then oola.line_number||'.'||oola.shipment_number end from oe_order_lines_all oola where oola.line_id=case oaadv.entity_id when 2 then oaadv.entity_number when 7 then (select osc.line_id from oe_sales_credits osc where osc.sales_credit_id=oaadv.entity_number and rownum=1) when 8 then (select opa.line_id from oe_price_adjustments opa where opa.price_adjustment_id=oaadv.entity_number and rownum=1) end and rownum=1 ) end line_number, oaadv.entity_display_name entity, oaadv.attribute_display_name attribute, oaadv.old_display_value old_value, oaadv.new_display_value new_value, oaadv.reason, oaadv.hist_comments comments, oaadv.user_name, oaadv.responsibility_name responsibility, oaadv.hist_creation_date history_date, oaadv.entity_id, oaadv.entity_number from hr_all_organization_units_vl haouv, oe_audit_attr_desc_v oaadv where 1=1 and oaadv.org_id=haouv.organization_id and oaadv.org_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 oaadv.hist_creation_date desc, oaadv.entity_id Converted from Oracle BIP report OEXAUDHR_XML. Inlined CF_1FORMULA line number calculation, replaced MO_GLOBAL restriction with Operating Unit parameter, converted lexical/bind parameters to 1=1 anchor style. Y AR ONT تقرير تاريخ التدقيق Application: إدارة الطلبات Source: تقرير تاريخ التدقيق (XML) Short Name: OEXAUDHR_XML DB package: ONT_OEXAUDHR_XMLP_PKG D ONT Historie Application: Order Management Source: Historie (XML) Short Name: OEXAUDHR_XML DB package: ONT_OEXAUDHR_XMLP_PKG F ONT Etat Historique d'audit Application: Order Management Source: Etat Historique d'audit (XML) Short Name: OEXAUDHR_XML DB package: ONT_OEXAUDHR_XMLP_PKG US ONT Audit History Order Management audit history report showing changes to order headers, lines, sales credits, and price adjustments with old/new values, change reasons, and the user who made the change. Based on Oracle standard report OEXAUDHR_XML (Audit History Report). ZHS ONT 跟踪历史记录报表 Application: 订单管理 Source: 跟踪历史记录报表 (XML) Short Name: OEXAUDHR_XML DB package: ONT_OEXAUDHR_XMLP_PKG 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)) AR تاريخ التأريخ (من) D Startdatum Historie F Date d'historique (Du) US Operating Unit ZHS 历史记录日期（自） 2 20 1=1 oaadv.hist_creation_date>=:history_date_from Date Y AR تاريخ التأريخ (إلى) D Enddatum Historie F Date d'historique (Au) US History Date From ZHS 历史记录日期（至） 3 30 1=1 oaadv.hist_creation_date<:history_date_to+1 Date last_day(:$flex$.history_date_from) AR اسم الكيان D Objektbezeichnung F Nom de l'entité US History Date To ZHS 实体名称 4 40 1=1 oaadv.entity_id=:entity_id LOV custom Y select oepev.entity_id id, oepev.entity_display_name value, null description from oe_pc_entities_v oepev order by oepev.entity_display_name AR اسم السمة D Attributbezeichnung F Nom de l'attribut US Entity ZHS 属性名称 5 50 1=1 oaadv.attribute_id=:attribute_id LOV custom Y select oepav.attribute_id id, oepav.attribute_display_name value, null description from oe_pc_attributes_v oepav where oepav.application_id=660 and (:$flex$.Entity is null or oepav.entity_id=:$flex$.Entity) order by oepav.attribute_display_name AR رقم الطلب (من) D Von Auftragsnummer F Numéro commande (De) US Attribute ZHS 订单编号（自） 6 60 1=1 oaadv.order_number>=:order_number_from Number AR رقم الطلب (إلى) D Bis Auftragsnummer F Numéro commande (A) US Order Number From ZHS 订单编号（至） 7 70 1=1 oaadv.order_number<=:order_number_to Number AR اسم المستخدم D Benutzername F Nom utilisateur US Order Number To ZHS 用户名 8 80 1=1 oaadv.user_name=:user_name LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name AR اسم المسئولية D Zuständigkeitsbezeichnung F Nom de la responsabilité US User Name ZHS 责任名 9 90 1=1 oaadv.responsibility_name=:responsibility LOV FND Responsibility Name 8E2FF36EDE9E79D2E0530100007F1FF2 Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name US Responsibility