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）限制的操作单元。 C6E085D4722E51A9E05362FB09050512 SELECT inv.vendor_id C_VENDOR_ID, inv.vendor_site_id C_VENDOR_SITE_ID, vendor_name C_VENDOR_NAME, decode(:SORT_BY_ALTERNATE, 'Y', upper(vendor_name_alt), upper(vendor_name)) C_SORT_VENDOR_NAME, vendor_site_code C_VENDOR_SITE_CODE, decode(:SORT_BY_ALTERNATE, 'Y', upper(vendor_site_code_alt), upper(vendor_site_code)) C_SORT_VENDOR_SITE_CODE, inv.PAYMENT_CURRENCY_CODE C_CURRENCY_CODE, upper(inv.PAYMENT_CURRENCY_CODE) C_SORT_CURRENCY_CODE, segment1 C_VENDOR_NUMBER, Nvl(SUM(C_TOTAL_INVOICE_AMT_TEMP),0) C_TOTAL_INVOICE_AMT, Nvl(SUM(C_TOTAL_AMOUNT_PAID_TEMP),0) C_TOTAL_AMOUNT_PAID, Nvl(SUM(C_TOTAL_PREPAID_AMT_TEMP),0) C_TOTAL_PREPAID_AMT, Nvl(SUM(C_TOTAL_DISC_AMT_TAKEN_TEMP),0) C_TOTAL_DISC_AMT_TAKEN, Nvl(SUM(C_TOTAL_AMT_REMAINING_TEMP),0) C_TOTAL_AMT_REMAINING FROM (select i.vendor_id, i.vendor_site_id, i.payment_currency_code PAYMENT_CURRENCY_CODE, i.invoice_id, Nvl(I.pay_curr_invoice_amount, I.invoice_amount) C_TOTAL_INVOICE_AMT_TEMP, Abs(NVL(amount_paid,0) - ap_utilities_pkg.ap_round_currency(Abs(Nvl(ap_invoices_utility_pkg.get_prepaid_amount(i.invoice_id),0)) * Nvl(i.payment_cross_rate, 1), i.payment_currency_code)) C_TOTAL_AMOUNT_PAID_TEMP, ap_utilities_pkg.ap_round_currency(Nvl(Abs(ap_invoices_utility_pkg.get_prepaid_amount(i.invoice_id)),0) * Nvl(i.payment_cross_rate,1), i.payment_currency_code) C_TOTAL_PREPAID_AMT_TEMP, NVL(discount_amount_taken, 0) + ap_utilities_pkg.ap_round_currency(Nvl(Abs(ap_invoices_pkg.get_amount_withheld(i.invoice_id)),0) * Nvl(i.payment_cross_rate, 1), i.payment_currency_code) C_TOTAL_DISC_AMT_TAKEN_TEMP, nvl(I.pay_curr_invoice_amount,I.invoice_amount) - NVL(amount_paid, 0) - NVL(discount_amount_taken, 0) - ap_utilities_pkg.ap_round_currency(Nvl(Abs(ap_invoices_pkg.get_amount_withheld(i.invoice_id)),0) * Nvl(i.payment_cross_rate, 1), i.payment_currency_code) C_TOTAL_AMT_REMAINING_TEMP from ap_invoices i, ap_invoice_distributions id where i.invoice_id = id.invoice_id(+) and id.line_type_lookup_code(+)='AWT' and payment_status_flag != 'N' and i.invoice_date BETWEEN :LP_START_DATE AND :LP_END_DATE and i.invoice_amount >= nvl(:P_MIN_AMOUNT,0) ) inv, po_vendors v, po_vendor_sites s WHERE v.vendor_id = inv.vendor_id AND s.vendor_site_id = inv.vendor_site_id AND (:P_VENDOR_TYPE_LOOKUP_CODE is null OR (v.vendor_type_lookup_code = :P_VENDOR_TYPE_LOOKUP_CODE)) &P_VENDOR_ID_SQL GROUP BY inv.vendor_id, inv.vendor_site_id, vendor_name, decode(:SORT_BY_ALTERNATE, 'Y', upper(vendor_name_alt), upper(vendor_name)), inv.PAYMENT_CURRENCY_CODE, segment1, vendor_site_code, decode(:SORT_BY_ALTERNATE, 'Y', upper(vendor_site_code_alt), upper(vendor_site_code)) ORDER BY decode(:SORT_BY_ALTERNATE, 'Y', UPPER(vendor_name_alt), UPPER(vendor_name)), decode(:SORT_BY_ALTERNATE, 'Y', UPPER(vendor_site_code_alt), UPPER(vendor_site_code)), UPPER(inv.PAYMENT_CURRENCY_CODE) Y SQLAP APXINVPH_XML AR AP تاريخ الفاتورة المدفوعة للمورِّد (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: (قديم) تاريخ سداد المورد Application: المدفوعات Source: تاريخ الفاتورة المدفوعة للمورِّد (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG D AP Lieferantenzahlungen- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Lieferanten - Zahlungshistorie (alt) Application: Kreditoren Source: Lieferantenzahlungen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG E AP Historial de Facturas Pagadas a Proveedores: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Historial de Pagos a Proveedores (Antiguo) Application: Payables Source: Historial de Facturas Pagadas a Proveedores (XML): No Admitido, Reservado para Uso Futuro Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG F AP Historique des factures payées aux fournisseurs- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Historique des règlements à un fournisseur (ancien) Application: Payables Source: Historique des factures payées aux fournisseurs (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG I AP Cronologia fatture pagate fornitore- non supportato: riservato per usi futuri Imported from BI Publisher Description: (Precedente) Cronologia dei pagamenti al fornitore Application: Payables Source: Cronologia fatture pagate fornitore (XML) - non supportato: riservato per usi futuri Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG JA AP 仕入先支払済請求履歴- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: (旧) 仕入先支払履歴 Application: Payables Source: 仕入先支払済請求履歴(XML) - 未サポート: 将来の使用のために予約 Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG KO AP 공급자 지급완료 송장 내역- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: (구) 공급자 지급 내역 Application: Payables Source: 공급자 지급완료 송장 내역(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG PTB AP Histórico de NFF Paga do Fornecedor- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Histórico de Pagamento do Fornecedor (Antigo) Application: Payables Source: Histórico de NFF Paga do Fornecedor (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG RU AP История оплаченных счетов-фактур поставщика- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: История платежей поставщика (старая версия) Application: Кредиторы Source: История оплаченных счетов-фактур поставщика (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG S AP Historik över betalda leverantörsfakturor- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Historik över (tidigare) leverarantörsbetalningar Application: Payables Source: Historik över betalda leverantörsfakturor (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG TR AP Tedarikçi Tarafından Ödenen Fatura Tarihçesi- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: (Eski) Tedarikçi Ödeme Tarihçesi Application: Borçlar Muhasebesi Source: Tedarikçi Tarafından Ödenen Fatura Tarihçesi (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG US AP Supplier Paid Invoice History- Not Supported: Reserved For Future Use Imported from BI Publisher Description: (Old) Supplier Payment History Application: Payables Source: Supplier Paid Invoice History (XML) - Not Supported: Reserved For Future Use Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG ZHS AP 供应商已付发票历史记录- 不支持：已保留供将来使用 Imported from BI Publisher Description: （旧）供应商付款历史记录 Application: 应付帐款 Source: 供应商已付发票历史记录 (XML) - 不支持：已保留供将来使用 Short Name: APXINVPH_XML DB package: AP_APXINVPH_XMLP_PKG BI Publisher &p_vendor_id_sql :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_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_vendor_type :c_nls_void :c_nls_yes :c_report_run_time :c_report_start_date :lp_end_date :lp_start_date :operating_unit :p_conc_request_id :p_debug_switch :p_end_date :p_flexdata :p_min_amount :p_min_precision :p_order_by :p_set_of_books_id :p_start_date :p_summary_option :p_vendor_id :p_vendor_id_sql :p_vendor_type_lookup_code :sort_by_alternate :sort_by_alternate_m 1 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') AR دفتر الأستاذ معرف دفتر الأستاذ D Buch Buchkennung E Libro Mayor Identificador de libro mayor F Livre ID livre I Libro contabile Id del libro contabile JA 元帳 元帳ID KO 원장 원장 ID PTB Razão Id do Razão RU Книга Идентификатор книги S Huvudbok Huvudboks-id TR Defter Defter No US Ledger 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_date Date Y AR تاريخ بداية الفاتورة تاريخ بداية الفاتورة D Von Rechnungsdatum Von Rechnungsdatum E De Fecha de Factura de fecha de factura F Date de début facture Date début facture I Data fattura iniziale Data della fattura iniziale JA 開始請求書日付 開始請求書日付 KO 송장 시작 일자 송장 시작 일자 PTB Data Inicial da NFF data da NFF inicial RU Начальная дата счета-фактуры Начальная дата счета-фактуры S Första fakturadatum från fakturadatum TR İlk Fatura Tarihi ilk fatura tarihi US Start Invoice Date start invoice date ZHS 起始发票日期 起始发票日期 4 20 :p_end_date Date Y AR تاريخ نهاية الفاتورة تاريخ نهاية الفاتورة D Bis Rechnungsdatum Bis Rechnungsdatum E A Fecha de Factura a fecha de factura F Date de fin facture Date fin facture I Data fattura finale Data della fattura finale JA 終了請求書日付 最終請求書日付 KO 송장 종료 일자 송장 종료 일자 PTB Data da NFF Final data da NFF final RU Конечная дата счета-фактуры Конечная дата счета-фактуры S Sista fakturadatum sista fakturadatum TR Son Fatura Tarihi son fatura tarihi US End Invoice Date end invoice date ZHS 终止发票日期 终止发票日期 5 30 :p_vendor_type_lookup_code LOV Oracle AP_SRS_VENDOR_TYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='VENDOR TYPE' order by value,description AR نوع المورد (تخطي للكل) نوع المورد D Lieferantenart Lieferantenart E Tipo de Proveedor (Omitir=Todos) tipo de proveedor F Type de fournisseur (Sauter si Tous) Type de fournisseur I Tipo fornitore (ignora Tuttol) Tipo di fornitore JA 仕入先タイプ (全て処理対象外) 仕入先タイプ KO 공급자 유형 (전부 생략) 공급자 유형 PTB Tipo de Fornecedor (saltar Todos) tipo de fornecedor RU Тип поставщика (пропуск = Все) Тип поставщика S Lev.typ (hoppa över vid Alla) Leverantörstyp TR Tedarikçi Tipi (Tümü ise atlayın) tedarikçi tipi US Supplier Type (skip for All) supplier type ZHS 供应商类型（忽略则为全部） 供应商类型 6 40 :p_vendor_id 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 Nombre del Proveedor (Omitir=Todos) Nombre del proveedor F Nom du fournisseur (Sauter si Tous) Nom du fournisseur I Nome fornitore (ignora Tutto) Nome del fornitore JA 仕入先名 (全て処理対象外) 仕入先名 KO 공급자명 (전부 생략) 공급자명 PTB Nome do Fornecedor (saltar Todos) nome do fornecedor RU Имя поставщика (пропуск = Все) Имя поставщика S Leverantörsnamn (hoppa över vid Alla) Leverantör TR Tedarikçi Adı (Tümü ise atlayın) tedarikçi adı US Supplier Name (skip for All) supplier name ZHS 供应商名称（忽略则为全部） 供应商名称 7 50 :p_summary_option LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR إجمالي الفواتير بواسطة الموقع؟ إجمالي الفواتير بواسطة الموقع؟ D Rechnungen nach Adresse zusammenfassen? Rechnungen nach Adresse zusammenfassen? E ¿Resumir Facturas por Dirección? ¿resumir facturas por dirección? F Synthèse des factures par site ? Synthèse des factures par site ? I Sintetizzare fatture per sede? Sintetizzare fatture per sede? JA サイトで請求書の要約? サイトで請求書の要約? KO 지점별로 송장 요약? 지점별로 송장을 요약? PTB Sumariar NFFs por Local? sumariar NFFs por local? RU Сводка счетов-фактур по отделениям? Сводка счетов-фактур по отделениям? S Summera fakturor per plats? summera fakturor per plats? TR Faturalar İşletme bazında Özetlensin mi? faturalar işletme bazında özetlensin mi? US Summarize Invoices by Site? summarize invoices by site? ZHS 是否按地点汇总发票？ 是否按地点汇总发票？ 8 60 :p_min_amount Number 0 AR الحد الأدنى لقيمة الفاتورة الحد الأدنى لمبلغ الفواتير D Mindest-Rechnungsbetrag Mindest-Rechnungsbetrag E Importe Mínimo de Factura Importe mínimo de factura F Montant minimum de facture Montant minimum de facture I Importo minimo fattura Importo minimo fatture JA 最小請求額 最小請求書金額 KO 최소 송장 금액 최소 송장 금액 PTB Quantia Mínima da NFF Quantia mínima das NFFs RU Минимальная сумма по счету-фактуре Минимальная сумма по счету-фактуре S Lägsta fakturabelopp Lägsta fakturabelopp TR Minimum Fatura Tutarı Minimum faturalar tutarı US Minimum Invoice Amount Minimum invoices amount ZHS 最小发票额 最小发票额 9 70 :p_order_by LOV Oracle AP_SRS_ASC_DESC Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='vendor_payment_orderby' order by value,description Y AR طلب الفاتورة ترتيب قيمة الفاتورة - تصاعدي أو تنازلي D Reihenfolge Rechnung Sortieroption für die Rechnungsbeträge - aufsteigend oder absteigend E Orden de Factura orden de importe de factura - ascendente o descendente F Tri factures Tri montants factures - ordre croissant ou décroissant I Ordine fattura Ordine importi fatture (crescente o decrescente) JA 請求書順 請求書金額順 - 昇順または降順 KO 송장주문 송장 금액 순서 - 오름차순 또는 내림차순 PTB Ordem da NFF ordem de quantia da NFF - crescente ou decrescente RU Порядок счетов-фактур Порядок счетов-фактур - по возрастанию или убыванию S Fakturaordning fakturabeloppsordning - stigande eller fallande TR Fatura Sırası fatura tutar siparişi - artan veya azalan US Invoice Order invoice amount order - ascending or descending ZHS 发票顺序 发票额顺序 - 升序或降序