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）限制的操作单元。 C6E085D4722F51A9E05362FB09050512 select AI.INVOICE_ID C_INVOICE_ID, AI.LAST_UPDATE_DATE C_LAST_UPDATE_DATE, pv1.SEGMENT1 C_SUPPLIER_CODE, decode(:h_sort_by_alternate, 'Y', pv1.VENDOR_NAME_ALT, 'N', pv1.VENDOR_NAME) C_SUPPLIER_NAME, decode(:h_sort_by_alternate, 'Y', PVS.VENDOR_SITE_CODE_ALT, 'N', PVS.VENDOR_SITE_CODE) C_SUPPLIER_SITE, pv1.VENDOR_NAME C_SUPPLIER_NAME_DISP, PVS.VENDOR_SITE_CODE C_SUPPLIER_SITE_CODE_DISP, AI.INVOICE_NUM C_INVOICE_NUMBER, AI.INVOICE_DATE C_INVOICE_DATE, AI.INVOICE_CURRENCY_CODE C_CURRENCY, AI.INVOICE_AMOUNT C_AMOUNT, AI.EXCHANGE_RATE C_EXCHANGE_RATE, rpad( &H_ACCT_SEGS ,600) C_INVOICE_ACCT_SEGS, FU.USER_NAME C_UPDATED_BY, ALC2.DISPLAYED_FIELD C_INVOICE_TYPE, FDS.NAME C_SEQUENCE_NAME, AI.DOC_SEQUENCE_VALUE C_VOUCHER_NUMBER, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_lia_acct_flex', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_LIA_ACCT_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_lia_acct_desc', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'FULL_DESCRIPTION') C_LIA_ACCT_DESC from AP_INVOICES AI, PO_VENDORS pv1, PO_VENDOR_SITES PVS, FND_USER FU, AP_LOOKUP_CODES ALC2, FND_DOCUMENT_SEQUENCES FDS, GL_CODE_COMBINATIONS GCC where &H_INVOICE_WHERE trunc(AI.LAST_UPDATE_DATE) between trunc(:P_START_UPDATE_DATE) and trunc(:P_END_UPDATE_DATE) and AI.SET_OF_BOOKS_ID = :P_SET_OF_BOOKS_ID and AI.VENDOR_ID = pv1.VENDOR_ID and AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID and AI.LAST_UPDATED_BY = FU.USER_ID and AI.INVOICE_TYPE_LOOKUP_CODE = ALC2.LOOKUP_CODE and ALC2.LOOKUP_TYPE = 'INVOICE TYPE' and AI.ACCTS_PAY_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID and AI.DOC_SEQUENCE_ID = FDS.DOC_SEQUENCE_ID (+) order by AI.LAST_UPDATE_DATE, decode(:h_sort_by_alternate, 'Y', pv1.VENDOR_NAME_ALT, 'N', pv1.VENDOR_NAME), decode(:h_sort_by_alternate, 'Y', PVS.VENDOR_SITE_CODE_ALT, 'N', PVS.VENDOR_SITE_CODE), AI.INVOICE_NUM Y SQLAP APXINVTC_XML AR AP تقرير شيك حركة الفاتورة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير شيك حركة الفاتورة لليابان Application: المدفوعات Source: تقرير شيك حركة الفاتورة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG D AP Rechnungstransaktionskontrolle- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Japan - Rechnungstransaktionskontrolle Application: Kreditoren Source: Rechnungstransaktionskontrolle (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG E AP Informe Cheques de Transacción de Facturas: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Japón - Informe Cheques de Transacciones de Facturas Application: Payables Source: Informe Cheques de Transacción de Facturas (XML): No Admitido, Reservado para Uso Futuro Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG F AP Etat de contrôle des mouvements de facturation- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Etat de contrôle des mouvements de facturation (Japon) Application: Payables Source: Etat de contrôle des mouvements de facturation (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG I AP Rapporto Controllo transazioni fatture- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Controllo transazioni fatture giapponesi Application: Payables Source: Rapporto Controllo transazioni fatture (XML) - non supportato: riservato per usi futuri Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG JA AP 請求書取引チェック・レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 請求書取引チェック・レポート (日本) Application: Payables Source: 請求書取引チェック・レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG KO AP 송장 거래 체크 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 일본 송장 거래 체크 보고서 Application: Payables Source: 송장 거래 체크 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG PTB AP Relatório de Verificação de Transações de NFFs- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Verificação de Transação de NFF - Japão Application: Payables Source: Relatório de Verificação de Transações de NFFs (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG RU AP Отчет о проверке транзакций со счетами-фактурами- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о проверке транзакций со счетами-фактурами (Япония) Application: Кредиторы Source: Отчет о проверке транзакций со счетами-фактурами (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG S AP Kontroll av fakturatransaktioner - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Japansk fakturatransaktionskontroll - rapport Application: Payables Source: Kontroll av fakturatransaktioner - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG TR AP Fatura İşlem Kontrolü Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Japonya Fatura İşlem Kontrol Raporu Application: Borçlar Muhasebesi Source: Fatura İşlem Kontrolü Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG US AP Invoice Transaction Check Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Japanese Invoice Transaction Check Report Application: Payables Source: Invoice Transaction Check Report (XML) - Not Supported: Reserved For Future Use Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG ZHS AP 发票事务处理检查报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 日本发票事务处理检查报表 Application: 应付帐款 Source: 发票事务处理检查报表 (XML) - 不支持：已保留供将来使用 Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG BI Publisher &h_acct_segs &h_invoice_where :applications_template_report :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_expense_acct_segs_copy :c_invoice_acct_segs_copy :c_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_void :c_nls_yes :c_report_start_date :cp_end_update_date :cp_start_update_date :h_acct_segs :h_chart_of_accounts_id :h_currency :h_currency_dist :h_currency_dist_precision :h_currency_pay :h_currency_pay_precision :h_currency_precision :h_dateformat :h_invoice_where :h_set_of_books_name :h_sort_by_alternate :operating_unit :p_conc_request_id :p_debug_switch :p_end_update_date :p_flexdata :p_invoice_type :p_min_precision :p_set_of_books_id :p_start_update_date :p_supplier_name :p_trace_switch :p_updated_by 1 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') 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_start_update_date Date Y AR تاريخ بداية التحديث تاريخ بداية التحديث D Von Aktualisierungsdatum Von Aktualisierungsdatum E De Fecha de Actualización De Fecha de Actualización F Date de début de la mise à jour Date de début de la mise à jour I Data aggiornamento iniziale Data aggiornamento iniziale JA 開始更新日 開始更新日 KO 갱신 시작 일자 갱신 시작 일자 PTB Data Inicial da Atualização Data Inicial da Atualização RU Дата начала обновления Дата начала обновления S Startdatum för uppdatering Startdatum för uppdatering TR İlk Güncelleme Tarihi İlk Güncelleme Tarihi US Start Update Date Start Update Date ZHS 起始更新日期 起始更新日期 4 20 :p_end_update_date Date Y AR تاريخ نهاية التحديث تاريخ نهاية التحديث D Bis Aktualisierungsdatum Bis Aktualisierungsdatum E A Fecha de Actualización A Fecha de Actualización F Date de fin de la mise à jour Date de fin de la mise à jour I Data aggiornamento finale Data aggiornamento finale JA 最終更新日 最終更新日 KO 갱신 종료 일자 갱신 종료 일자 PTB Data Final da Atualização Data Final da Atualização RU Дата окончания обновления Дата окончания обновления S Slutdatum för uppdatering Slutdatum för uppdatering TR Son Güncelleme Tarihi Son Güncelleme Tarihi US End Update Date End Update Date ZHS 终止更新日期 终止更新日期 5 30 :p_invoice_type LOV Oracle AP_SRS_INVOICE_TYPE Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='INVOICE TYPE' and lookup_code not in ('QUICKMATCH','QUICKDEFAULT') order by value,description AR نوع الفاتورة نوع الفاتورة D Rechnungsart Rechnungsart E Tipo de Factura Tipo de Factura F Type de facture Type de facture I Tipo di fattura Tipo di fattura JA 請求書タイプ 請求書タイプ KO 송장 유형 송장 유형 PTB Tipo de NFF Tipo de NFF RU Тип счета-фактуры Тип счета-фактуры S Fakturatyp Fakturatyp TR Fatura Tipi Fatura Tipi US Invoice Type Invoice Type ZHS 发票类型 发票类型 6 40 :p_supplier_name LOV Oracle AP_SRS_VENDOR_NAME Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR المُورَّد اسم المورد D Lieferant Lieferantenname E Proveedor Nombre de Proveedor F Fournisseur Nom du fournisseur I Fornitore Nome del fornitore JA 仕入先 仕入先名 KO 공급자 공급자명 PTB Fornecedor Nome do Fornecedor RU Поставщик Имя поставщика S Leverantör Leverantör TR Tedarikçi Tedarikçi Adı US Supplier Supplier Name ZHS 供应商 供应商名称 7 50 :p_updated_by LOV Oracle AP_SRS_USER_NAME Y select user_name id, user_name value, null description from fnd_user order by value,description AR تحديث بواسطة تحديث بواسطة D Aktualisiert von Aktualisiert von E Actualizado por Actualizado por F Mis à jour par Mis à jour par I Aggiornato da Aggiornato da JA 更新者 更新者 KO 갱신자 갱신자 PTB Atualizado por Atualizado por RU Обновлено Обновлено S Uppdaterad av Uppdaterad av TR Güncelleyen Güncelleyen US Updated by Updated by ZHS 更新者 更新者