ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F58A3869E053B46B63588994 select paysch.trx_number Invoice_Number, substrb(party.party_name,1,50) Customer_Name , paysch.trx_date Invoice_Date , round (sysdate - paysch.due_date) Days_Overdue , decode( :p_currency_code, NULL, decode( :minimum_accountable_unit, NULL, round( nvl( paysch.exchange_rate, 1) * paysch.tax_original, :precision ), round( nvl( paysch.exchange_rate, 1) * paysch.tax_original / :minimum_accountable_unit ) * :minimum_accountable_unit ), paysch.tax_original ) Original_Amount , decode( :p_currency_code, NULL, decode( :minimum_accountable_unit, NULL, round( nvl( paysch.exchange_rate, 1) * paysch.TAX_REMAINING, :precision), round( nvl( paysch.exchange_rate, 1) * paysch.TAX_REMAINING / :minimum_accountable_unit) * :minimum_accountable_unit), paysch.TAX_REMAINING) Amount_Outstanding, ZX_ZXXATB_XMLP_PKG.C_DATA_NOT_FOUNDFORMULA(paysch.trx_number) C_DATA_NOT_FOUND from ar_payment_schedules_all paysch, hz_cust_accounts_all cust, hz_parties party where paysch.customer_id = cust.cust_account_id and cust.party_id = party.party_id and paysch.invoice_currency_code = decode( :p_currency_code, NULL , paysch.invoice_currency_code, :p_currency_code) &lp_start_trx_date &lp_end_trx_date &LP_REP_CONTEXT_WH and amount_due_remaining <= tax_original and tax_original != 0 and nvl(tax_remaining,0) <> 0 and paysch.status = 'OP' and amount_due_remaining > 0 order by decode( :p_order_by, 'Invoice Number', trx_number, 'Customer', party.party_name, 'Invoice Date', to_char(trx_date, 'J'), party.party_name ) Y ZX ZXXATB_XML AR ZX تقرير الفواتير المفتوحة - الضريبة فقط (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الضرائب في E-Business Source: تقرير الفواتير المفتوحة - الضريبة فقط (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: ZXXATB_XML DB package: ZX_ZXXATB_XMLP_PKG D ZX Rechnungen - nur offene Steuern- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: E-Business Tax Source: Rechnungen - nur offene Steuern (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: ZXXATB_XML DB package: ZX_ZXXATB_XMLP_PKG F ZX Taxe seulement : Etat des factures non soldées- Non pris en charge : réservé pour une utilisation ultérieure Application: E-Business Tax Source: Taxe seulement : Etat des factures non soldées (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: ZXXATB_XML DB package: ZX_ZXXATB_XMLP_PKG US ZX Tax-Only Open Invoices - draft Application: E-Business Tax Source: Tax-Only Open Invoices Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXXATB_XML DB package: ZX_ZXXATB_XMLP_PKG ZHS ZX 仅与税收有关的未结发票报表- 不支持：已保留供将来使用 Application: Oracle E-Business Tax Source: 仅与税收有关的未结发票报表 (XML) - 不支持：已保留供将来使用 Short Name: ZXXATB_XML DB package: ZX_ZXXATB_XMLP_PKG BI Publisher &lp_end_trx_date &lp_rep_context_wh &lp_start_trx_date :lp_end_trx_date :lp_rep_context_wh :lp_start_trx_date :minimum_accountable_unit :p_conc_request_id :p_currency_code :p_end_trx_date :p_order_by :p_reporting_context :p_reporting_level :p_set_of_books_id :p_sob_id :p_start_trx_date :p_tax_invoice_date_high :p_tax_invoice_date_low :precision :rp_company_name :rp_data_found :rp_report_currency :rp_report_name :rp_trx_date :rpd_amount_outstanding 1 10 :p_reporting_level LOV Oracle FND_MO_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' and lookup_code in (1000,3000) order by value,description select meaning from fnd_lookups WHERE LOOKUP_TYPE = 'FND_MO_REPORTING_LEVEL' AND lookup_code = '3000' Y AR مستوى إعداد التقرير D Auswertungsebene F Niveau de reporting US Reporting Level ZHS 申报级别 2 20 :p_reporting_context LOV Oracle FND_MO_REPORTING_ENTITY Y select entity_id id, entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.fnd_mo_reporting_level order by value,description Y AR سياق إعداد التقرير D Auswertungskontext F Contexte de reporting US Reporting Context ZHS 申报环境 3 30 :p_order_by LOV Oracle ZX_TRL_RAXATB_ORDER_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_RAXATB' order by meaning Y AR ترتيب حسب الفواتير المفتوحة D Sortieren nach offenen Rechnungen F Trier par factures non soldées US Order By Open Invoices ZHS 按未结发票排序 4 40 :p_tax_invoice_date_low Date AR تاريخ الفاتورة من D Von Rechnungsdatum F Date facture - Du US Invoice Date Low ZHS 发票日期下限 5 50 :p_tax_invoice_date_high Date AR تاريخ الفاتورة إلى D Bis Rechnungsdatum F Date facture - Au US Invoice Date High ZHS 发票日期上限 6 60 :p_currency_code LOV Oracle AR_SRS_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 F Code devise US Currency Code ZHS 币种代码