ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4813869E053B46B63588994Y SELECT cbb.bank_name, ac.bank_account_name, cep.payment_document_name, ac.check_number, TO_CHAR(ac.check_date,'DD-MON-YY') check_date,TO_CHAR(ac.future_pay_due_date,'DD-MON-YY') future_pay_due_date, cba.currency_code account_currency, nvl(decode(ac.currency_code, cba.currency_code, ac.amount, ap_utilities_pkg.ap_round_currency((ac.amount * ac.exchange_rate), asp.base_currency_code)), 0) payment_amount, ac.amount trans_amount, ac.currency_code trans_curr, hzp.party_name, ac.vendor_site_code, ac.exchange_rate FROM ce_bank_branches_v cbb, ce_bank_accounts cba, ce_bank_acct_uses_all cbau, ce_payment_documents cep, ap_checks ac, ap_system_parameters asp, hz_parties hzp WHERE cbb.branch_party_id = cba.bank_branch_id AND cba.bank_account_id = cbau.bank_account_id AND cbau.bank_acct_use_id = ac.ce_bank_acct_use_id AND cep.payment_document_id (+) = ac.payment_document_id AND ac.status_lookup_code = 'ISSUED' AND ac.future_pay_due_date <= nvl(:P_maturity_date, ac.future_pay_due_date) AND ac.ce_bank_acct_use_id = nvl(:P_ce_bank_acct_use_id, ac.ce_bank_acct_use_id) AND ac.party_id = nvl(:P_party_id, ac.party_id) AND ac.party_id = hzp.party_id AND (:P_vendor_site_id is NULL OR (:P_vendor_site_id IS NOT NULL and ac.vendor_site_id = :P_vendor_site_id) ) ORDER BY cbb.bank_name, cba.bank_account_name, ac.future_pay_due_date, cba.currency_code, cep.payment_document_name, ac.check_number SQLAP APXFPMDR_XML AR AP تقرير تاريخ استحقاق أوراق الدفع (بتنسيق XML) Application: المدفوعات Source: تقرير تاريخ استحقاق أوراق الدفع (بتنسيق XML) Short Name: APXFPMDR_XML DB package: AP_APXFPMDR_XMLP_PKG D AP Wechselverbindlichkeiten - Fälligkeit Application: Kreditoren Source: Wechselverbindlichkeiten - Fälligkeit (XML) Short Name: APXFPMDR_XML DB package: AP_APXFPMDR_XMLP_PKG F AP Etat des dates d'exigibilité des effets à payer Application: Payables Source: Etat des dates d'exigibilité des effets à payer (XML) Short Name: APXFPMDR_XML DB package: AP_APXFPMDR_XMLP_PKG US AP Bills Payable Maturity Date Application: Payables Source: Bills Payable Maturity Date Report (XML) Short Name: APXFPMDR_XML DB package: AP_APXFPMDR_XMLP_PKG ZHS AP 应付票据到期日报表 Application: 应付帐款 Source: 应付票据到期日报表 (XML) Short Name: APXFPMDR_XML DB package: AP_APXFPMDR_XMLP_PKG BI Publisher :c_bank_account_name :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_yes :c_report_start_date :c_supplier_name :c_supplier_site :currency_check :operating_unit :p_ce_bank_acct_use_id :p_conc_request_id :p_debug_switch :p_flexdata :p_maturity_date :p_maturity_date_lp :p_min_precision :p_party_id :p_trace_switch :p_vendor_site_id 1 10 :p_ce_bank_acct_use_id LOV Oracle AP_CE_SRS_BANK_ACCOUNTS Y select cbau.bank_acct_use_id id, cba.bank_account_name value, null description from ce_bank_acct_uses cbau,ce_bank_accounts cba where cba.bank_account_id=cbau.bank_account_id and nvl(cba.end_date,sysdate+1)>sysdate and cba.account_classification='INTERNAL' order by bank_account_name AR حساب البنك D Bankkonto F Compte bancaire US Bank Account ZHS 银行帐户 2 20 :p_maturity_date Date AR تاريخ الاستحقاق D Fällig am F Date d'exigibilité US Maturity Date ZHS 到期日 3 30 :p_party_id LOV Oracle AP_SRS_PAYEE_NAME Y select payee_party_id id, payee_name value, null description from ap_srs_payee_v order by value,description AR المدفوع له D Zahlungsempfänger F Bénéficiaire US Payee ZHS 收款人 4 40 :p_vendor_site_id LOV Oracle AP_SRS_PAYEE_SITES Y select asps.vendor_site_id id, asps.vendor_site_code value, null description from ap_supplier_sites asps,ap_suppliers aps where asps.vendor_id=aps.vendor_id and aps.party_id=:$flex$.ap_srs_payee_name order by asps.vendor_site_code AR موقع المورد D Lieferantenadresse F Site fournisseur US Supplier Site ZHS 供应商地点