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）限制的操作单元。 C6E085D46FF051A9E05362FB09050512 SELECT g.group_name, f.user_name, emp.full_name, d.start_date_active, d.end_date_active, d.approver_id, g.group_id FROM igi_sap_group g, igi_sap_department_approvers d, fnd_user f, hr_employees emp WHERE g.group_id = d.group_id AND g.group_id = nvl(:p_approval_group,g.group_id) AND f.user_id = d.approver_id AND d.approver_id = nvl(:p_approver,d.approver_id) AND f.employee_id = emp.employee_id (+) AND exists (select 1 from igi_sap_app_ranges p1 where p1.approver_id = d.approver_id and p1.group_id = g.group_id and &P_WHERES) order by 1,2 Y IGI IGIPSIAP_XML AR IGI اعتماد الفاتورة الثانوي: تخصيصات الحقل المرن (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: اعتماد الفاتورة الثانوي: تخصيصات حقل مرن Application: الماليات الدولية للقطاع العام Source: اعتماد الفاتورة الثانوي: تخصيصات الحقل المرن (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: IGIPSIAP_XML DB package: IGI_IGIPSIAP_XMLP_PKG D IGI Mehrfache Rechnungsprüfung: FlexFeld-Zuordnungen- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Mehrfache Rechnungsprüfung: FlexFeld-Zuordnungen Application: Public Sector Financials International Source: Mehrfache Rechnungsprüfung: FlexFeld-Zuordnungen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: IGIPSIAP_XML DB package: IGI_IGIPSIAP_XMLP_PKG E IGI Aprobación de Facturas Secundarias: Asignaciones de Estructuras: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Aprobación de Facturas Secundaria : Asignaciones de Estructuras Application: Public Sector Financials International Source: Aprobación de Facturas Secundarias: Asignaciones de Estructuras (XML): No Admitido, Reservado para Uso Futuro Short Name: IGIPSIAP_XML DB package: IGI_IGIPSIAP_XMLP_PKG F IGI Approbation secondaire des factures : Affectations de champs flexibles- Non pris en charge : réservé pour une utilisation ultérieure Imported from BI Publisher Description: Approbation secondaire des factures : Affectations de champs flexibles Application: Public Sector Financials International Source: Approbation secondaire des factures : Affectations de champs flexibles (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: IGIPSIAP_XML DB package: IGI_IGIPSIAP_XMLP_PKG I IGI Approvazione secondaria fatture: assegnazioni flexfield- non supportato: riservato per usi futuri Imported from BI Publisher Description: Approvazione secondaria fatture: Assegnazioni flexfield Application: Public Sector Financials International Source: Approvazione secondaria fatture: assegnazioni flexfield (XML) - non supportato: riservato per usi futuri Short Name: IGIPSIAP_XML DB package: IGI_IGIPSIAP_XMLP_PKG KO IGI 2차 송장 승인: 가변필드 지정- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 2차 송장 승인: 가변필드 지정 Application: Public Sector Financials International Source: 2차 송장 승인: 가변필드 지정(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: IGIPSIAP_XML DB package: IGI_IGIPSIAP_XMLP_PKG RU IGI Вторичное утверждение счета-фактуры: назначения ГП- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Вторичное утверждение счета-фактуры: назначения ГП Application: Государственный сектор: международные финансы Source: Вторичное утверждение счета-фактуры: назначения ГП (XML) - не поддерживается: зарезервировано для будущего использования Short Name: IGIPSIAP_XML DB package: IGI_IGIPSIAP_XMLP_PKG S IGI Sekundärt fakturagodkännande: Flexfältstilldelningar- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Sekundärt fakturagodkännande: Flexfältstilldelningar Application: Public Sector Financials International Source: Sekundärt fakturagodkännande: Flexfältstilldelningar (XML) - Stöds inte: Reserverad för framtida bruk Short Name: IGIPSIAP_XML DB package: IGI_IGIPSIAP_XMLP_PKG US IGI Secondary Invoice Approval : Flexfield Assignments- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Secondary Invoice Approval : Flexfield Assignments Application: Public Sector Financials International Source: Secondary Invoice Approval : Flexfield Assignments (XML) - Not Supported: Reserved For Future Use Short Name: IGIPSIAP_XML DB package: IGI_IGIPSIAP_XMLP_PKG ZHS IGI 辅助发票审批：弹性域分配- 不支持：已保留供将来使用 Imported from BI Publisher Description: 辅助发票审批：弹性域分配 Application: Public Sector Financials International Source: 辅助发票审批：弹性域分配 (XML) - 不支持：已保留供将来使用 Short Name: IGIPSIAP_XML DB package: IGI_IGIPSIAP_XMLP_PKG BI Publisher &p_wheres :operating_unit :p_approval_group :p_approver :p_conc_request_id :p_flexdata :p_flexdata_to :p_flexfield_from :p_flexfield_to :p_operand1 :p_set_of_books :p_struct_num :p_where :p_where1 :p_wheres 1 -30 :p_set_of_books Number select ledger_id from igi_gcc_ledger_v Y US GL_SRS_NULL_NUM 2 -20 :p_struct_num LOV Oracle IGI_SRS_COA_ID_BYSOB Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_sets_of_books where set_of_books_id=:$flex$.gl_srs_null_num order by value,description select chart_of_accounts_id from gl_sets_of_books where set_of_books_id = :$FLEX$.GL_SRS_NULL_NUM Y AR جدول تصنيف الحسابات D Kontenplan E Plan de Cuentas F Plan de comptes I Piano dei conti KO 계정코드집 RU План счетов S Kontoplan US Chart of Accounts ZHS 科目表 3 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 4 10 :p_approval_group LOV Oracle IGI_SIA_GROUPS Y select group_id id, group_name value, null description from igi_sap_group order by group_name AR مجموعة الاعتماد D Genehmigungsgruppe E Grupo de Aprobación F Groupe d'approbation I Gruppo di approvazione KO 승인 그룹 RU Группа утверждения S Godkännandegrupp US Approval Group ZHS 审批组 5 20 :p_approver LOV Oracle IGI_SIA_APPROVERS Y select user_id id, user_name value, null description from fnd_user where user_id in (select approver_id from igi_sap_department_approvers where group_id=nvl(:$flex$.igi_sia_groups,group_id) ) order by value,description AR المعتمد D Genehmigungsberechtigter E Aprobador F Responsable hiérarchique I Approvatore KO 승인자 RU Утвержд. S Godkännare US Approver ZHS 审批人 6 30 :p_flexfield_from Char Y AR الحقل المرن من D Von FlexFeld E De Estructura F Clé flexible - De I Flexfield - Da KO 가변필드 From RU Гибкое поле с S Från flexfält US Flexfield From ZHS 弹性域自 7 40 :p_flexfield_to Char Y AR الحقل المرن إلى D Bis FlexFeld E A Estructura F Clé flexible - A I Flexfield - A KO 가변필드 To RU Гибкое поле по S Till flexfält US Flexfield To ZHS 弹性域至