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）限制的操作单元。 C6E085D46FF951A9E05362FB09050512 SELECT gsob.NAME book_name , party.PARTY_NAME , cust.ACCOUNT_NUMBER , trx.TRX_NUMBER invoice_num , aud.CREATION_DATE date_changed , fnd.USER_NAME approver , fnd2.USER_NAME use_r , ter.NAME ter_ms , aud.START_DATE FROM RA_TERMS ter , FND_USER fnd , FND_USER fnd2 , IGI_INSTALMENT_AUDIT_V aud , RA_CUSTOMER_TRX trx , HZ_PARTIES party , HZ_CUST_ACCOUNTS cust , GL_SETS_OF_BOOKS gsob WHERE gsob.SET_OF_BOOKS_ID = :P_SOB_ID AND trx.SET_OF_BOOKS_ID = gsob.SET_OF_BOOKS_ID AND cust.CUST_ACCOUNT_ID = trx.BILL_TO_CUSTOMER_ID AND party.party_id = cust.party_id AND trx.BILL_TO_CUSTOMER_ID LIKE nvl(:P_CUST_ID, '%') AND aud.RA_CUSTOMER_TRX_ID = trx.CUSTOMER_TRX_ID AND to_date(to_char(aud.CREATION_DATE), 'DD-MON-RR') BETWEEN to_date(to_char(:CP_DATE_LOW), 'DD-MON-RR') AND to_date(to_char(:CP_DATE_HIGH), 'DD-MON-RR') AND aud.RA_TERM_ID = ter.TERM_ID AND fnd.USER_ID = aud.FND_USER_ID AND fnd2.USER_ID = aud.CREATED_BY ORDER BY party.PARTY_NAME , invoice_num , to_number(to_char(date_changed,'J')) , ter_ms Y IGI IGIRTAUD_XML AR IGI شروط القسط: تقرير تدقيق القسط (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: شروط القسط: تقرير تدقيق الأقساط Application: الماليات الدولية للقطاع العام Source: شروط القسط: تقرير تدقيق القسط (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: IGIRTAUD_XML DB package: IGI_IGIRTAUD_XMLP_PKG D IGI Protokoll Ratenzahlungen- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Ratenzahlungsbedingungen: Protokoll Ratenzahlungen Application: Public Sector Financials International Source: Ratenzahlungsbedingungen: Protokoll Ratenzahlungen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: IGIRTAUD_XML DB package: IGI_IGIRTAUD_XMLP_PKG E IGI Condiciones de Plazos: Informe de Auditoría de Plazos: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Condiciones de Plazos: Auditoría de Plazo Application: Public Sector Financials International Source: Condiciones de Plazos: Informe de Auditoría de Plazos (XML): No Admitido, Reservado para Uso Futuro Short Name: IGIRTAUD_XML DB package: IGI_IGIRTAUD_XMLP_PKG F IGI Conditions d'échéance : Etat d'audit des échéances- Non pris en charge : réservé pour une utilisation ultérieure Imported from BI Publisher Description: Conditions d'échéance: Etat d'audit des échéances Application: Public Sector Financials International Source: Conditions d'échéance : Etat d'audit des échéances (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: IGIRTAUD_XML DB package: IGI_IGIRTAUD_XMLP_PKG I IGI Condizioni di rateizzazione: rapporto Audit rate- non supportato: riservato per usi futuri Imported from BI Publisher Description: Condizioni di rateizzazione: Rapporto Audit rate Application: Public Sector Financials International Source: Condizioni di rateizzazione: rapporto Audit rate (XML) - non supportato: riservato per usi futuri Short Name: IGIRTAUD_XML DB package: IGI_IGIRTAUD_XMLP_PKG KO IGI 할부 조건: 할부 감사 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 할부 조건: 할부 감사 보고서 Application: Public Sector Financials International Source: 할부 조건: 할부 감사 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: IGIRTAUD_XML DB package: IGI_IGIRTAUD_XMLP_PKG RU IGI Условия выплат: отчет об аудите выплат- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Условия выплат: отчет об аудите выплат Application: Государственный сектор: международные финансы Source: Условия выплат: отчет об аудите выплат (XML) - не поддерживается: зарезервировано для будущего использования Short Name: IGIRTAUD_XML DB package: IGI_IGIRTAUD_XMLP_PKG S IGI Kontrollrapport för avbetalning- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Avbetalningsvillkor: Kontrollrapport för avbetalning Application: Public Sector Financials International Source: Avbetalningsvillkor: Kontrollrapport för avbetalning (XML) - Stöds inte: Reserverad för framtida bruk Short Name: IGIRTAUD_XML DB package: IGI_IGIRTAUD_XMLP_PKG US IGI Installment Terms: Installment Audit Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Installment Terms: Installment Audit Report Application: Public Sector Financials International Source: Installment Terms: Installment Audit Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIRTAUD_XML DB package: IGI_IGIRTAUD_XMLP_PKG ZHS IGI 分期付款条款：分期付款审核报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 分期付款条款：分期付款审核报表 Application: Public Sector Financials International Source: 分期付款条款：分期付款审核报表 (XML) - 不支持：已保留供将来使用 Short Name: IGIRTAUD_XML DB package: IGI_IGIRTAUD_XMLP_PKG BI Publisher :cp_date_high :cp_date_low :operating_unit :p_conc_request_id :p_cust_id :p_date_high :p_date_low :p_debug_switch :p_sob_id 1 -20 :p_sob_id Number select set_of_books_id from ar_system_parameters Y AR معرف دفاتر الحسابات معرف دفتر الأستاذ D Kennung Buchungsstruktur Buchkennung E Id Juego de Libros Identificador de libro mayor F ID entité comptable ID livre I ID set of books Id del libro contabile KO SOB ID 원장 ID RU Идент. набора книг Идентификатор книги S Räkenskaps-id Huvudboks-id US SOB Id Ledger Id ZHS SOB 标识 分类帐标识 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_date_low Date Y AR من تاريخ من تاريخ D Von Datum Von Datum E De Fecha De Fecha F Du Du I Data - Da Data - Da KO 일자: 부터 일자: 부터 RU Дата с Дата с S Från datum Från datum US From Date From Date ZHS 起始日期 起始日期 4 20 :p_date_high Date Y AR إلى التاريخ إلى التاريخ D Bis Datum Bis Datum E A Fecha A Fecha F Au Au I Data - A Data - A KO 일자: 까지 일자: 까지 RU Дата по Дата по S Till datum Till datum US To Date To Date ZHS 终止日期 终止日期 5 30 :p_cust_id LOV Oracle IGI_AR_INS_CUSTOMER_NAME_ID Y select hz_cust_accounts.cust_account_id id, party_name||' ('||account_number||')' value, null description from hz_cust_accounts,hz_parties where hz_cust_accounts.party_id=hz_parties.party_id and exists (select 1 from hz_cust_acct_sites where hz_cust_acct_sites.cust_account_id=hz_cust_accounts.cust_account_id) order by party_name,account_number,cust_account_id AR اسم العميل اسم العميل D Kundenname Kundenname E Nombre del Cliente Nombre del Cliente F Nom du client Nom du client I Nome cliente Nome cliente KO 고객명 고객명 RU Имя заказчика Имя заказчика S Kund Kund US Customer Name Customer Name ZHS 客户名称 客户名称