ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472E051A9E05362FB09050512 SELECT r.tax_rate_code C_TAX_NAME, upper(r.tax_rate_code) C_SORT_TAX_NAME, d.tax_code_id C_INVOICE_TAX_ID, r.percentage_rate C_TAX_RATE, v.vendor_name C_VENDOR_NAME, v.vendor_id C_VENDOR_ID, decode(:P_ORDERBY, 'VENDOR',upper(v.vendor_name)) C_SORT_VENDOR_NAME, vs.vendor_site_code C_SITE_CODE, vs.vendor_site_code C_SITE_CODE2, decode(:P_ORDERBY, 'VENDOR',decode(:P_SUMMARY_FLAG_D, 'Y',upper(vs.vendor_site_code))) C_SORT_SITE_CODE, i.invoice_id C_INVOICE_ID, i.invoice_num C_INVOICE_NUMBER, upper(i.invoice_num) C_SORT_INVOICE_NUMBER, b.batch_name C_BATCH_NAME, i.invoice_date C_INVOICE_DATE, nvl(i.invoice_amount,0) C_INVOICE_AMOUNT, d.line_type_lookup_code C_LINE_TYPE, ZX_ZXXINUTR_XMLP_PKG.C_OLD_VENDOR_ID_p C_OLD_VENDOR_ID, ZX_ZXXINUTR_XMLP_PKG.item_amount(i.invoice_id, r.tax_rate_code, d.tax_code_id) C_TAXABLE_AMOUNT, ZX_ZXXINUTR_XMLP_PKG.tax_amount(:C_TAXABLE_AMOUNT, r.percentage_rate) C_TAX_AMOUNT FROM po_vendors v, po_vendor_sites_all vs, ap_invoices_all i, ap_invoice_distributions_all d, ap_batches_all b, zx_rates_b r, zx_taxes_b t, zx_regimes_b reg WHERE b.batch_id(+) = i.batch_id AND d.tax_code_id = nvl(r.source_id(+),r.tax_rate_id(+)) AND t.tax_regime_code(+) = r.tax_regime_code AND t.tax(+) = r.tax AND NVL(t.effective_from, decode(:P_REPORT_BASIS, 'GL',d.accounting_date,'INVOICE', i.invoice_date,'ENTERED',i.creation_date,sysdate)) <= decode(:P_REPORT_BASIS, 'GL',d.accounting_date,'INVOICE', i.invoice_date,'ENTERED',i.creation_date,sysdate) AND (NVL(t.effective_to, decode(:P_REPORT_BASIS, 'GL',d.accounting_date,'INVOICE', i.invoice_date,'ENTERED',i.creation_date,sysdate)) >= decode(:P_REPORT_BASIS, 'GL',d.accounting_date,'INVOICE', i.invoice_date,'ENTERED',i.creation_date,sysdate) OR t.effective_to IS NULL) AND t.tax_type_code = 'USE' AND i.invoice_id = d.invoice_id + 0 AND (i.tax_amount is null OR i.tax_amount=0) AND i.vendor_id = v.vendor_id AND i.vendor_site_id = vs.vendor_site_id AND i.invoice_currency_code = :P_CURR_CODE AND (:P_REPORT_BASIS='GL' and d.accounting_date= (select d2.accounting_date from ap_invoice_distributions_all d2 where d2.invoice_id = d.invoice_id and d2.tax_code_id = d.tax_code_id and d2.accounting_date between :P_START_DATE and :P_END_DATE and rownum < 2 &p_org_where_d2 ) OR (:P_REPORT_BASIS != 'GL' and decode(:P_REPORT_BASIS, 'ENTERED',trunc(i.creation_date), 'INVOICE',trunc(i.invoice_date)) BETWEEN :P_START_DATE and :P_END_DATE)) AND decode(:P_TAX_PARAM_DISP, 'All',r.tax_rate_code, :P_TAX_PARAM_DISP)=r.tax_rate_code AND decode(:P_INV_STATUS_D, 'PAID',i.payment_status_flag, 'APPROVED',d.match_status_flag, 'POSTED',d.posted_flag, 'All','Y')= decode(:P_INV_STATUS_D, 'PAID','Y', 'APPROVED','A', 'POSTED','Y', 'All','Y') AND ((:P_INV_STATUS_D = 'APPROVED' AND NOT EXISTS (SELECT 'Holds exists' FROM ap_holds_all h WHERE h.invoice_id = i.invoice_id AND h.release_lookup_code is NULL &p_org_where_h )) OR (:P_INV_STATUS_D != 'APPROVED')) &p_org_where_vs &p_org_where_i &p_org_where_d &p_org_where_b ORDER BY r.tax_rate_code, decode(:P_ORDERBY, 'INVOICE',null, 'VENDOR',UPPER(v.vendor_name)), decode(:P_ORDERBY, 'INVOICE',null, 'VENDOR',UPPER(vs.vendor_site_code)), i.invoice_date, upper(i.invoice_num), i.invoice_id ZX ZXXINUTR_XML AR ZX تقرير خصوم ضرائب الاستخدام (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير استخدام خصوم الضرائب Application: الضرائب في E-Business Source: تقرير خصوم ضرائب الاستخدام (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG D ZX Verbrauchsteuer-Verbindlichkeiten- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Verbrauchsteuer-Verbindlichkeiten Application: E-Business Tax Source: Verbrauchsteuer-Verbindlichkeiten (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG E ZX Informe de Deuda Tributaria de Consumo: No Admitidio, Reservado para Uso Futuro Imported from BI Publisher Description: Deuda Tributaria sobre Consumo Application: E-Business Tax Source: Informe de Deuda Tributaria de Consumo (XML): No Admitidio, Reservado para Uso Futuro Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG F ZX Etat des taxes directes dues (USA)- Non pris en charge : réservé pour une utilisation ultérieure Imported from BI Publisher Description: Etat des taxes directes dues (USA) Application: E-Business Tax Source: Etat des taxes directes dues (USA) (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG I ZX Rapporto Passività imposta d'uso- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Passività imposta d'uso Application: E-Business Tax Source: Rapporto Passività imposta d'uso (XML) - non supportato: riservato per usi futuri Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG JA ZX 使用税債務レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 使用税債務レポート Application: E-Business Tax Source: 使用税債務レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG KO ZX 사용세 부채 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 세금 부채 보고서 사용 Application: E-Business Tax Source: 사용세 부채 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG PTB ZX Usar Relatório de Passivo do Imposto- Não Suportado: Reservado para Uso Futuro Imported from BI Publisher Description: Usar Relatório de obrigação fiscal Application: E-Business Tax Source: Usar Relatório de Passivo do Imposto (XML) - Não Suportado: Reservado para Uso Futuro Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG RU ZX Отчет о задолженности по налогу за пользование- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о задолженности по налогу за пользование Application: Налоги для электронного бизнеса Source: Отчет о задолженности по налогу за пользование (XML) - не поддерживается: зарезервировано для будущего использования Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG S ZX Utgående skatteskuld - rapport- stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Utgående skatteskuld - rapport Application: E-Business Tax Source: Utgående skatteskuld - rapport (XML) - stöds inte: Reserverad för framtida bruk Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG TR ZX Tüketim Vergisi Borç Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Vergi Borcu Raporunu Kullan Application: eİş Vergi Yönetimi Source: Tüketim Vergisi Borç Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG US ZX Use Tax Liability Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Use Tax Liability Report Application: E-Business Tax Source: Use Tax Liability Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG ZHS ZX 使用应纳税报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 使用应纳税报表 Application: Oracle E-Business Tax Source: 使用应纳税报表 (XML) - 不支持：已保留供将来使用 Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_XMLP_PKG BI Publisher &p_org_where_b &p_org_where_d &p_org_where_d2 &p_org_where_h &p_org_where_i &p_org_where_vs :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_inv_status :c_nls_no :c_nls_no_data_exists :c_nls_orderby :c_nls_report_basis :c_nls_tax_param :c_nls_yes :c_old_vendor_id :c_report_run_time :c_report_start_date :c_taxable_amount :p_conc_request_id :p_curr_code :p_debug_switch :p_end_date :p_end_date_d :p_entity_name :p_flexdata :p_inv_status :p_inv_status_d :p_level_name :p_min_precision :p_orderby :p_org_where_b :p_org_where_d :p_org_where_d2 :p_org_where_h :p_org_where_i :p_org_where_t :p_org_where_v :p_org_where_vs :p_report_basis :p_reporting_entity_id :p_reporting_level :p_set_of_books_id :p_sql_trace :p_start_date :p_start_date_d :p_summary_flag :p_summary_flag_d :p_tax_param :p_tax_param_disp 1 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') AR دفاتر حسابات معرف دفتر الأستاذ D Buchungsstruktur Buchkennung E Juego de Libros Identificador de libro mayor F Entité comptable ID livre I Set of books Id libro contabile JA 会計帳簿 元帳ID KO SOB 원장 ID PTB SOB ID do Razão RU Набор книг Идентификатор книги S Räkenskaper Huvudboks-id TR YMB Defter No US SOB Ledger ID ZHS SOB 分类帐标识 2 10 :p_reporting_level LOV Oracle XLE_LEGAL_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' order by value,description Y US Reporting_level 3 20 :p_reporting_context LOV Oracle XLE_LEGAL_REPORTING_CONTEXT Y select entity_id id, entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.xle_legal_reporting_level order by value,description Y AR سياق إعداد التقرير D Auswertungskontext E Contexto del Informe F Contexte de reporting I Contesto di dichiarazione JA レポート・コンテキスト KO 신고 컨텍스트 PTB Contexto do Relatório RU Контекст отчетности S Rapporteringssammanhang TR Raporlama İçeriği US Reporting Context ZHS 申报环境 4 30 :p_curr_code LOV Oracle ZX_TRL_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code AR رمز العملة رمز العملة D Währungsschlüssel Währungsschlüssel E Código de Divisa Código de divisa F Code devise Code devise I Codice divisa Codice divisa JA 通貨コード 通貨コード KO 통화 코드 통화 코드 PTB Código da Moeda Código da Moeda RU Код валюты Код валюты S Valutakod Valutakod TR Para Birimi Kodu Para Birimi Kodu US Currency Code Currency Code ZHS 币种代码 币种代码 5 40 :p_report_basis LOV Oracle ZX_TRL_TAX_USE_DATE_BASIS Y select lookup_code id, lookup_code value, null description from fnd_lookups where lookup_type='ZX_TRL_TAX_USE_DATE_BASIS' order by value,description AR أساس تاريخ ضريبة الاستخدام أساس تاريخ التقرير D Basisdatum Verbrauchsteuer Basis Auswertungstermin E Base de Fecha del Uso de Impuestos Base de Fecha de Informe F Base de la date à utiliser pour la taxe Base de date état I Base data uso imposta Base data rapporto JA 税使用日基準 レポート日付基準 KO 세금 사용 일자 기준 보고서 일자 기준 PTB Data Base de Imposto sobre Uso Data-base do Relatório RU Базовая дата налога за пользование Базовая дата отчета S Datumbas för förbrukningsskatt Rapportdatumbas TR Tüketim Vergisi Tarihi Esası Rapor Tarihi Esası US Tax Use Date Basis Report Date Basis ZHS 使用税基准日期 报表基准日期 6 50 :p_inv_status LOV Oracle ZX_TRL_INVOICE_STATUS Y select lookup_code id, lookup_code value, meaning description from fnd_lookups where lookup_type='ZX_TRL_INVOICE_STATUS' order by value,description AR موقف الفاتورة موقف الفاتورة D Rechnungsstatus Rechnungsstatus E Estado de Factura Estado de Factura F Statut de la facture Statut de la facture I Stato fattura Stato fattura JA 請求書ステータス 請求書ステータス KO 송장 상태 송장 상태 PTB Status da NFF Status da NFF RU Статус счета-фактуры Статус счета-фактуры S Fakturastatus Fakturastatus TR Fatura Statüsü Fatura Statüsü US Invoice Status Invoice Status ZHS 发票状态 发票状态 7 60 :p_orderby LOV Oracle ZX_TRL_VENDOR_OR_INVOICE Y select lookup_code id, lookup_code value, meaning description from fnd_lookups where lookup_type='ZX_TRL_VENDOR_OR_INVOICE' order by value,description AR تقرير مرتب حسب D Auswertung sortieren nach E Informe Ordenado por F Etat trié par I Rapporto ordinato per JA レポート・ソート順 KO 보고서 정렬 기준 PTB Relatório Ordenado Por RU Сортировка отчета S Rapportordning TR Rapor Sıralama Bazı US Report Ordered By ZHS 报表排序依据 8 70 :p_start_date Date AR من تاريخ تاريخ البداية D Von Datum Startdatum E De Fecha Fecha de inicio F Date - Du Date de début I Data - Da Data inizio JA 日付: 自 開始日 KO 시작 일자 시작 일자 PTB Data - De Data Inicial RU Начальная дата Начальная дата S Från datum Startdatum TR Başlangıç Tarihi Başlangıç Tarihi US From Date Start Date ZHS 自日期 起始日期 9 80 :p_end_date Date AR إلى تاريخ تاريخ النهاية D Bis Datum Enddatum E A Fecha Fecha de finalización F Date - Au Date de fin I Data - A Data fine JA 日付: 至 終了日 KO 종료 일자 종료 일자 PTB Data - Até Data Final RU Конечная дата Конечная дата S Till datum Slutdatum TR Bitiş Tarihi Bitiş Tarihi US To Date End Date ZHS 至日期 终止日期 10 90 :p_tax_param LOV Oracle ZX_TRL_USE_TAX_RATE Y select rates.tax_rate_code id, rates.tax_rate_code value, rates.tax_rate_name description from zx_mco_rates rates where rates.active_flag='Y' and rates.tax in (select tax from zx_mco_taxes where tax_type_code='USE') order by value,description AR اسم الضريبة اسم الضريبة D Steuerbezeichnung Steuerbezeichnung E Nombre de Impuesto Nombre de Impuesto F Nom de la taxe Nom de la taxe I Nome imposta Nome dell'imposta JA 税金名 税金名 KO 세금명 세금명 PTB Nome do Imposto Nome do Imposto RU Название налога Название налога S Momsnamn Momsnamn TR Vergi Adı Vergi Adı US Tax Name Tax Name ZHS 税名 税名 11 100 :p_summary_flag LOV Oracle ZX_TRL_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='ZX_TRL_YES_NO' order by meaning AR إجمالي إجمالي D Übersicht Übersicht E Resumir Resumir F Synthèse Synthèse I Riepiloga Riepiloga JA 要約 要約 KO 요약 요약 PTB Sumariar Sumariar RU Сводка Сводка S Summera Summera TR Özetle Özetle US Summarize Summarize ZHS 汇总 汇总 :$flex$.xle_legal_reporting_level Reporting_level Reporting Context