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）限制的操作单元。 C6E085D4710651A9E05362FB09050512 select ht.meaning hold_type, hs.creation_date apply_date, hr1.creation_date release_date, h.name hold_name, hs.hold_entity_code object_type_code, ot.meaning object_type, hs.hold_entity_code2 object_type_code2, ot2.meaning object_type2, hs.hold_entity_id object_id, hs.hold_entity_id2 object_id2, hs.hold_until_date, rr.meaning release_reason, hs.released_flag, ONT_OEXOHHSA_XMLP_PKG.c_entity_value(hs.hold_entity_code, hs.hold_entity_id) C_entity_value, ONT_OEXOHHSA_XMLP_PKG.c_entity_value2(hs.hold_entity_code2, hs.hold_entity_id2) C_entity_value2 from oe_hold_sources hs, oe_hold_releases hr1, oe_hold_definitions h, oe_lookups ht, oe_lookups ot, oe_lookups ot2, oe_lookups rr where hs.hold_id = h.hold_id and hs.hold_entity_code = ot.lookup_code and ot.lookup_type = 'HOLD_ENTITY_TYPE' and hs.hold_entity_code2=ot2.lookup_code (+) and ot2.lookup_type(+)='HOLD_ENTITY_TYPE' and h.type_code = ht.lookup_code and ht.lookup_type = 'HOLD_TYPE' and hs.hold_source_id = hr1.hold_source_id(+) and hr1.release_reason_code = rr.lookup_code(+) and rr.lookup_type(+) = 'RELEASE_REASON' and ( hs.hold_entity_code <> 'O' or ( hs.hold_entity_code = 'O' and exists ( select 'x' from oe_order_lines_all sl where sl.header_id = hs.hold_entity_id and sl.open_flag = 'Y' ) ) ) &lp_hold_type_where &lp_hold_where &lp_activity_date_where &lp_activity_type_where order by ht.meaning, hr1.creation_date,hs.creation_date Y ONT OEXOHHSA_XML AR ONT تقرير نشاط مصدر الإيقاف Imported from BI Publisher Description: تقرير نشاط مصدر الإيقاف Application: إدارة الطلبات Source: تقرير نشاط مصدر الإيقاف (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG D ONT Sperrvorgänge Imported from BI Publisher Description: Auswertung "Sperrvorgänge" Application: Order Management Source: Sperrvorgänge (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG E ONT Informe Actividad de Origen de Retención Imported from BI Publisher Description: Informe Actividad de Origen de Retención Application: Order Management Source: Informe Actividad de Origen de Retención (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG F ONT Etat Blocages Imported from BI Publisher Description: Etat Blocages Application: Order Management Source: Etat Blocages (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG I ONT Rapporto Attività origine blocco Imported from BI Publisher Description: Rapporto Attività origine blocco Application: Order Management Source: Rapporto Attività origine blocco (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG JA ONT 保留条件活動レポート Imported from BI Publisher Description: 保留条件活動レポート Application: Order Management Source: 保留条件活動レポート(XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG KO ONT 보류 출처 활동 보고서 Imported from BI Publisher Description: 보류 출처 활동 보고서 Application: Order Management Source: 보류 출처 활동 보고서(XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG PTB ONT Relatório de Atividade de Origem da Retenção Imported from BI Publisher Description: Relatório de Atividade de Origem da Retenção Application: Gerenciamento de Ordens Source: Relatório de Atividade de Origem da Retenção (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG RU ONT Отчет об источниках блокировок Imported from BI Publisher Description: Отчет об источниках блокировок Application: Управление заказами Source: Отчет об источниках блокировок (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG S ONT Aktivitet för spärrkällor - rapport Imported from BI Publisher Description: Aktivitet för spärrkällor - rapport Application: Order Management Source: Aktivitet för spärrkällor - rapport (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG TR ONT Durdurma Kaynağı Aktivite Raporu Imported from BI Publisher Description: Durdurma Kaynağı Aktivite Raporu Application: Sipariş Yönetimi(1) Source: Durdurma Kaynağı Aktivite Raporu (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG US ONT Hold Source Activity Imported from BI Publisher Description: Hold Source Activity Report Application: Order Management Source: Hold Source Activity Report (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG ZHS ONT 暂挂来源活动报表 Imported from BI Publisher Description: 暂挂来源活动报表 Application: 订单管理 Source: 暂挂来源活动报表 (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG BI Publisher &lp_activity_date_where &lp_activity_type_where &lp_hold_type_where &lp_hold_where :lp_activity_date_where :lp_activity_type_where :lp_hold_type_where :lp_hold_where :operating_unit :p_activity :p_activity_date_hi :p_activity_date_hi_v :p_activity_date_lo :p_activity_date_lo_v :p_conc_request_id :p_hold_name_hi :p_hold_name_lo :p_hold_type_hi :p_hold_type_lo :p_organization_id :p_organization_id_v :p_sob_id 1 -20 :p_sob_id Number select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) from dual Y AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile JA 元帳ID 元帳ID KO 원장 ID 원장 ID PTB Id do Razão ID do Razão RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger ID ZHS 分类帐标识 分类帐标识 2 0 :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 select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_hold_type_lo LOV Oracle ONT_SRS_HOLD_TYPE Y select lookup_code id, meaning value, description description from oe_lookups where lookup_type='HOLD_TYPE' order by meaning AR نوع الإيقاف (من) نوع الإيقاف من D Von Sperrenart Von Sperrenart E Tipo de Retención (De) De Tipo de Retención F Type blocage (De) Type blocage - De I Tipo di blocco - Da Tipo di blocco (minimo) JA 保留タイプ (自) 保留タイプ:自 KO 보류 유형(부터) 보류 유형 하한 PTB Tipo de Retenção (De) Tipo de Retenção - Inferior RU Тип блокировки с Тип блокировки с S Spärrtyp (från) Från spärrtyp TR Durdurma Tipi (İlk) Durdurma Tipi Alt Değeri US Hold Type (From) Hold Type Low ZHS 暂挂类型（自） 暂挂类型下限 4 20 :p_hold_type_hi LOV Oracle ONT_SRS_HOLD_TYPE Y select lookup_code id, meaning value, description description from oe_lookups where lookup_type='HOLD_TYPE' order by meaning :$flex$.hold_type_from AR نوع الإيقاف (إلى) نوع الإيقاف إلى D Bis Sperrenart Bis Sperrenart E Tipo de Retención (A) A Tipo de Retención F Type blocage (A) Type blocage - A I Tipo di blocco - A Tipo di blocco (massimo) JA 保留タイプ (至) 保留タイプ:至 KO 보류 유형(까지) 보류 유형 상한 PTB Tipo de Retenção (Até) Tipo de Retenção - Superior RU Тип блокировки по Тип блокировки по S Spärrtyp (till) Till spärrtyp TR Durdurma Tipi (Son) Durdurma Tipi Üst Değeri US Hold Type (To) Hold Type High ZHS 暂挂类型（至） 暂挂类型上限 5 30 :p_hold_name_lo LOV Oracle ONT_SRS_HOLD_NAME Y select name id, name value, null description from oe_hold_definitions order by name AR اسم الإيقاف (من) اسم الإيقاف من D Von Sperre Von Sperre E Nombre de Retención (De) De Nombre de Retención F Code blocage (Du) Code blocage - De I Nome blocco - Da Nome blocco (minimo) JA 保留名 (自) 保留名:自 KO 보류명(부터) 보류명 하한 PTB Nome da Retenção (De) Nome da Retenção - Inferior RU Имя блокировки с Имя блокировки с S Spärrnamn (från) Från spärrnamn TR Durdurma Adı (İlk) Durdurma Adı Alt Değeri US Hold Name (From) Hold Name Low ZHS 暂挂名（自） 暂挂名下限 6 40 :p_hold_name_hi LOV Oracle ONT_SRS_HOLD_NAME Y select name id, name value, null description from oe_hold_definitions order by name select :$flex$.hold_name_from from DUAL AR اسم الإيقاف (إلى) اسم الإيقاف إلى D Bis Sperre Bis Sperre E Nombre de Retención (A) A Nombre de Retención F Nom blocage (A) Code blocage - A I Nome blocco - A Nome blocco (massimo) JA 保留名 (至) 保留名:至 KO 보류명(까지) 보류명 상한 PTB Nome da Retenção (Até) Nome da Retenção - Superior RU Имя блокировки по Имя блокировки по S Spärrnamn (till) Till spärrnamn TR Durdurma Adı (Son) Durdurma Adı Üst Değeri US Hold Name (To) Hold Name High ZHS 暂挂名（至） 暂挂名上限 7 50 :p_activity_date_lo Date AR تاريخ النشاط (من) تاريخ النشاط من D Von Vorgangsdatum Von Vorgangsdatum E Fecha de Actividad (De) De Fecha de Actividad F Date activité (Du) Date activité - Du I Data attività - Da Data attività (minimo) JA 活動日 (自) 活動日:自 KO 활동 일자(부터) 활동 일자 하한 PTB Data da Atividade (De) Data da Atividade - Inferior RU Дата операции с Дата операции с S Aktivitetsdatum (från) Från aktivitetsdatum TR Aktivite Tarihi (İlk) Aktivite Tarihi Alt Değer US Activity Date (From) Activity Date Low ZHS 活动日期（自） 活动日期下限 8 60 :p_activity_date_hi Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.activity_date_from)) from DUAL AR تاريخ النشاط (إلى) تاريخ النشاط إلى D Bis Vorgangsdatum Bis Vorgangsdatum E Fecha de Actividad (A) A Fecha de Actividad F Date activité (Au) Date activité - Au I Data attività - A Data attività (massimo) JA 活動日 (至) 活動日:至 KO 활동 일자(까지) 활동 일자 상한 PTB Data da Atividade (Até) Data da Atividade - Superior RU Дата операции по Дата операции по S Aktivitetsdatum (till) Till aktivitetsdatum TR Aktivite Tarihi (Son) Aktivite Tarihi Üst Değer US Activity Date (To) Activity Date High ZHS 活动日期（至） 活动日期上限 9 70 :p_activity LOV Oracle ONT_SRS_HOLD_ACTIVITY Y select lookup_code id, meaning value, description description from oe_lookups where lookup_type='AUTHORIZED_ACTION' order by meaning AR نوع النشاط نوع النشاط D Vorgangsart Vorgangsart E Tipo de Actividad Tipo de Actividad F Type d'activité Type d'activité I Tipo di attività Tipo di attività JA 活動タイプ 活動タイプ KO 활동 유형 활동 유형 PTB Tipo de Atividade Tipo de Atividade RU Тип операции Тип операции S Aktivitetstyp Aktivitetstyp TR Aktivite Tipi Aktivite Tipi US Activity Type Activity Type ZHS 活动类型 活动类型 :$flex$.activity_date_from Activity Date (From) Y Activity Date (To) :$flex$.hold_name_from Hold Name (From) Hold Name (To) :$flex$.hold_type_from Hold Type (From) Hold Type (To)