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）限制的操作单元。 C6E085D4722851A9E05362FB09050512 SELECT i.vendor_id C_SMRY_VENDOR_ID, upper(v1.vendor_name) C_SMRY_UPPR_VENDOR_NAME, v1.vendor_name C_SMRY_VENDOR_NAME, v2.vendor_site_code C_SMRY_VENDOR_SITE_CODE, segment1 C_SMRY_VENDOR_NUM, SUM(DECODE(f.minimum_accountable_unit, NULL, round((p.amount / nvl(i.amount_paid,1) * i.invoice_amount) , f.precision), round((p.amount / nvl(i.amount_paid,1) * i.invoice_amount) / f.minimum_accountable_unit) * f.minimum_accountable_unit) ) C_SMRY_INVOICE_AMOUNT , SUM(DECODE(f.minimum_accountable_unit, NULL, round((nvl(p.discount_taken,0)/nvl(i.payment_cross_rate,1)) , f.precision), round((nvl(p.discount_taken,0)/nvl(i.payment_cross_rate,1)) / f.minimum_accountable_unit) * f.minimum_accountable_unit) ) C_SMRY_DSCNT_AMT_TAKEN, decode((sign(SUM(DECODE(f.minimum_accountable_unit, NULL, round((nvl(p.discount_lost,0)/nvl(i.payment_cross_rate,1)) , f.precision), round((nvl(p.discount_lost,0)/nvl(i.payment_cross_rate,1)) / f.minimum_accountable_unit) * f.minimum_accountable_unit) ))*sign(invoice_amount)),-1,0, SUM(DECODE(f.minimum_accountable_unit, NULL, round((nvl(p.discount_lost,0)/nvl(i.payment_cross_rate,1)) , f.precision), round((nvl(p.discount_lost,0)/nvl(i.payment_cross_rate,1)) / f.minimum_accountable_unit) * f.minimum_accountable_unit) ))C_SMRY_DSCNT_AMT_LOST, i.invoice_currency_code C_SMRY_CURRENCY, sum(decode (p.exchange_rate,null,1,0)) C_SMRY_NO_RATE_COUNT, SUM(DECODE(f2.minimum_accountable_unit, NULL, round((p.amount / nvl(i.amount_paid,1) * i.base_amount) , f2.precision), round((p.amount / nvl(i.amount_paid,1) * i.base_amount) / f2.minimum_accountable_unit) * f2.minimum_accountable_unit) ) C_SMRY_BASE_CURR_AMT , SUM(DECODE(f2.minimum_accountable_unit, NULL, round((nvl(i.exchange_rate,1)* (nvl(p.discount_taken,0)/nvl(i.payment_cross_rate,1)) ), f2.precision), round((nvl(i.exchange_rate,1)* (nvl(p.discount_taken,0)/nvl(i.payment_cross_rate,1)) ) / f2.minimum_accountable_unit) * f2.minimum_accountable_unit) ) C_SMRY_BASE_CURR_DTKN, decode ((sign(SUM(DECODE(f2.minimum_accountable_unit, NULL, round((nvl(i.exchange_rate,1)* (nvl(p.discount_lost,0)/nvl(i.payment_cross_rate,1)) ), f2.precision), round((nvl(i.exchange_rate,1)* (nvl(p.discount_lost,0)/nvl(i.payment_cross_rate,1)) ) / f2.minimum_accountable_unit) * f2.minimum_accountable_unit) ))*sign(invoice_amount)),-1,0, SUM(DECODE(f2.minimum_accountable_unit, NULL, round((nvl(i.exchange_rate,1)* (nvl(p.discount_lost,0)/nvl(i.payment_cross_rate,1)) ), f2.precision), round((nvl(i.exchange_rate,1)* (nvl(p.discount_lost,0)/nvl(i.payment_cross_rate,1)) ) / f2.minimum_accountable_unit) * f2.minimum_accountable_unit) ))C_SMRY_BASE_CURR_DLST FROM po_vendors v1, po_vendor_sites v2, ap_invoices i, ap_invoice_payments p, ap_checks c, fnd_currencies_vl F, fnd_currencies_vl f2 WHERE v1.vendor_id = i.vendor_id AND v2.vendor_site_id = i.vendor_site_id AND c.check_id = p.check_id AND i.invoice_id = p.invoice_id AND i.invoice_currency_code = F.currency_code AND (c.check_date BETWEEN :P_start_date AND :P_end_date) AND c.void_date IS NULL AND i.payment_status_flag != 'N' AND i.invoice_amount != 0 AND i.amount_paid != 0 AND nvl(v1.vendor_type_lookup_code, '-1') = DECODE(:P_vendor_type_lookup_code, NULL, nvl(v1.vendor_type_lookup_code, '-1'), 'All', nvl(v1.vendor_type_lookup_code, '-1'), :P_vendor_type_lookup_code) AND f2.currency_code = :C_base_currency_code &C_VENDOR_ID_PRED AND (nvl(p.discount_taken,0) != 0 or nvl(discount_lost,0) != 0) GROUP BY i.invoice_currency_code, i.vendor_id, v1.vendor_name, segment1, v2.vendor_site_code, f2.precision, f2.minimum_accountable_unit ,invoice_amount ORDER BY i.invoice_currency_code, upper(v1.vendor_name), v2.vendor_site_code Y SQLAP APXINDTL_XML AR AP تقرير الخصم المأخوذ وغير المأخوذ (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير الخصم المأخوذ وغير المأخوذ Application: المدفوعات Source: تقرير الخصم المأخوذ وغير المأخوذ (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG D AP Zahlungen - beanspruchte/nicht beanspruchte Skonti- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Zahlungen - beanspruchte/nicht beanspruchte Skonti Application: Kreditoren Source: Zahlungen - beanspruchte/nicht beanspruchte Skonti (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG E AP Informe Descuentos Aprovechados y Perdidos: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de descuentos aprovechados y perdidos Application: Payables Source: Informe Descuentos Aprovechados y Perdidos (XML): No Admitido, Reservado para Uso Futuro Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG F AP Etat des escomptes pris et perdus- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Etat des escomptes pris et perdus Application: Payables Source: Etat des escomptes pris et perdus (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG I AP Rapporto Sconti ottenuti/perduti- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Sconti ottenuti/perduti Application: Payables Source: Rapporto Sconti ottenuti/perduti (XML) - non supportato: riservato per usi futuri Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG JA AP 仕入割引および仕入割引逸失損レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 仕入割引および仕入割引逸失損レポート Application: Payables Source: 仕入割引および仕入割引逸失損レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG KO AP 할인 손익 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 할인 손익 보고서 Application: Payables Source: 할인 손익 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG PTB AP Relatório dos Descontos Perdidos e Praticados- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório dos Descontos Perdidos e Praticados Application: Payables Source: Relatório dos Descontos Perdidos e Praticados (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG RU AP Отчет об учтенных и потерянных скидках- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет об учтенных и потерянных скидках Application: Кредиторы Source: Отчет об учтенных и потерянных скидках (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG S AP Utnyttjade/missade - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Rabatter: Utnyttjade/missade - rapport Application: Payables Source: Rabatter: Utnyttjade/missade - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG TR AP Alınan ve Kaybedilen İndirimler Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Alınan İndirim ve Kaybedilen İndirim Raporu Application: Borçlar Muhasebesi Source: Alınan ve Kaybedilen İndirimler Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG US AP Discounts Taken and Lost Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Discounts Taken and Lost Report Application: Payables Source: Discounts Taken and Lost Report (XML) - Not Supported: Reserved For Future Use Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG ZHS AP 应得和未得折扣报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 应得和未得折扣报表 Application: 应付帐款 Source: 应得和未得折扣报表 (XML) - 不支持：已保留供将来使用 Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG BI Publisher &c_vendor_id_pred :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_no :c_nls_no_data_exists :c_nls_vndr_type_lkup_code :c_nls_yes :c_no_rate_count_same_curr :c_report_run_time :c_report_start_date :c_vendor_id_pred :operating_unit :p_conc_request_id :p_debug_switch :p_end_date :p_end_date1 :p_min_precision :p_set_of_books_id :p_start_date :p_start_date1 :p_summary_option :p_vendor_id :p_vendor_type_lookup_code :p_vendor_type_lookup_code_1 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 Zahlungsdatum Von Zahlungsdatum E De Fecha de Pago de fecha de pago F Date début règlement Date début règlement I Data pagamento iniziale Data del pagamento iniziale JA 開始支払日 開始支払日 KO 지급 시작 일자 지급 시작 일자 PTB Data de Pgto. Inicial data pagamento inicial RU Начальная дата платежа Начальная дата платежа S Startdatum för betalning från betalningsdatum TR İlk Ödeme Tarihi ilk ödeme tarihi US Start Payment Date start payment date ZHS 起始付款日期 起始付款日期 4 20 :p_end_date Date Y AR تاريخ نهاية السداد تاريخ نهاية السداد D Bis Zahlungsdatum Bis Zahlungsdatum E A Fecha de Pago End Payment Date F Date fin règlement date fin règlement I Data pagamento finale Data del pagamento finale JA 最終支払日 最終支払日 KO 지급 종료 일자 지급 종료 일자 PTB Data de Pgto. Final data de pagamento final RU Конечная дата платежа Конечная дата платежа S Slutbetalningsdatum sista betalningsdatum TR Son Ödeme Tarihi son ödeme tarihi US End Payment Date end payment 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 是否按地点汇总发票？ 是否按地点汇总发票？