ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4A23869E053B46B63588994 select pv.vendor_name C_vendor_name, pvs.address_line1 C_address_line1, pvs.address_line2 C_address_line2, pvs.address_line3 C_address_line3, decode(pvs.city, '', '', pvs.city || ', ') || decode(pvs.state, '', '', pvs.state || ' ') || pvs.zip C_city_state_zip, pvs.country C_country, aipp.last_update_date C_application_date, aipp.prepayment_amount_applied C_amount_applied, inv1.invoice_currency_code C_currency_code, pp.invoice_num C_prepay_num, inv1.invoice_num C_invoice_num, nvl(inv1.invoice_amount,0)- GL_Currency_API.Convert_Amount(inv1.payment_currency_code, inv1.invoice_currency_code, inv1.payment_cross_rate_date, inv1.payment_cross_rate_type, nvl(inv1.amount_paid, 0)) C_amt_remaining from po_vendors pv, po_vendor_sites pvs, ap_invoices inv1, ap_invoices pp, ap_invoice_prepays aipp where aipp.invoice_id = inv1.invoice_id and aipp.prepay_id = pp.invoice_id and inv1.vendor_id = pp.vendor_id and inv1.vendor_id = pv.vendor_id and pv.vendor_id = pvs.vendor_id and pvs.vendor_site_id = inv1.vendor_site_id &LP_LANGUAGE_WHERE &C_VENDOR_ID_PREDICATE &C_INVOICE_ID_PREDICATE &C_PREPAY_ID_PREDICATE &C_START_DATE_PREDICATE &C_END_DATE_PREDICATE UNION select pv.vendor_name C_vendor_name, pvs.address_line1 C_address_line1, pvs.address_line2 C_address_line2, pvs.address_line3 C_address_line3, decode(pvs.city, '', '', pvs.city || ', ') || decode(pvs.state, '', '', pvs.state || ' ') || pvs.zip C_city_state_zip, pvs.country C_country, aid2.last_update_date C_application_date, nvl(ap_prepay_utils_pkg.get_pp_amt_applied_on_date(inv1.invoice_id, pp.invoice_id,aid2.last_update_date),0) C_amount_applied, inv1.invoice_currency_code C_currency_code, pp.invoice_num C_prepay_num, inv1.invoice_num C_invoice_num, nvl(inv1.invoice_amount,0)- GL_Currency_API.Convert_Amount(inv1.payment_currency_code, inv1.invoice_currency_code, inv1.payment_cross_rate_date, inv1.payment_cross_rate_type, nvl(inv1.amount_paid, 0)) C_amt_remaining from po_vendors pv, po_vendor_sites_all pvs, ap_invoices inv1, ap_invoices_all pp, ap_invoice_distributions_all aid1, ap_invoice_distributions_all aid2 where aid1.invoice_id = inv1.invoice_id and aid2.invoice_id = pp.invoice_id and aid2.invoice_distribution_id = aid1.prepay_distribution_id and aid1.line_type_lookup_code = 'PREPAY' and inv1.vendor_id = pp.vendor_id and inv1.vendor_id = pv.vendor_id and pv.vendor_id = pvs.vendor_id and pvs.vendor_site_id = inv1.vendor_site_id and nvl(aid1.reversal_flag,'N') != 'Y' &LP_LANGUAGE_WHERE &C_VENDOR_ID_PREDICATE &C_INVOICE_ID_PREDICATE &C_PREPAY_ID_PREDICATE &C_START_INVOICE_DATE_PREDICATE &C_END_INVOICE_DATE_PREDICATE Y SQLAP APXPPREM_XML AR AP إشعار التحويل النقدي للدفعة المقدمة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: المدفوعات Source: إشعار التحويل النقدي للدفعة المقدمة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXPPREM_XML DB package: AP_APXPPREM_XMLP_PKG D AP Vorauszahlungen - Benachrichtigung- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Kreditoren Source: Vorauszahlungen - Benachrichtigung (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXPPREM_XML DB package: AP_APXPPREM_XMLP_PKG F AP Avis de rapprochement des acomptes par fournisseur- Non pris en charge : réservé pour une utilisation future Application: Payables Source: Avis de rapprochement des acomptes par fournisseur (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXPPREM_XML DB package: AP_APXPPREM_XMLP_PKG US AP Prepayment Remittance Notice - draft Application: Payables Source: Prepayment Remittance Notice (XML) - Not Supported: Reserved For Future Use Short Name: APXPPREM_XML DB package: AP_APXPPREM_XMLP_PKG ZHS AP 预付款汇款通知单- 不支持：已保留供将来使用 Application: 应付帐款 Source: 预付款汇款通知单 (XML) - 不支持：已保留供将来使用 Short Name: APXPPREM_XML DB package: AP_APXPPREM_XMLP_PKG BI Publisher &c_end_date_predicate &c_end_invoice_date_predicate &c_invoice_id_predicate &c_prepay_id_predicate &c_start_date_predicate &c_start_invoice_date_predicate &c_vendor_id_predicate &lp_language_where :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_end_date_predicate :c_end_invoice_date_predicate :c_invoice_id_predicate :c_nls_all :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_prepay_id_predicate :c_report_run_time :c_report_start_date :c_start_date_predicate :c_start_invoice_date_predicate :c_vendor_id_predicate :lp_language_where :operating_unit :p_conc_request_id :p_debug_switch :p_end_date :p_invoice_id :p_min_precision :p_name_exec :p_name_srs :p_phone_exec :p_phone_srs :p_prepay_id :p_start_date :p_title_exec :p_title_srs :p_vendor_id 1 10 :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 F Nom du fournisseur (Sauter si Tous) US Supplier Name (skip for All) ZHS 供应商名称（忽略则为全部） 2 20 :p_invoice_id LOV Oracle AP_SRS_INVOICE_NUMBER Y select invoice_id id, invoice_num value, description description from ap_invoices where invoice_id in (select invoice_id from ap_invoice_distributions_all where prepay_distribution_id is not null) and vendor_id= nvl(:$flex$.ap_srs_vendor_name,vendor_id) order by value,description AR رقم الفاتورة (تخطي للكل) D Rechnungsnummer F Numéro de facture (Sauter si Tous) US Invoice Number (skip for All) ZHS 发票编号（忽略则为全部） 3 30 :p_prepay_id LOV Oracle AP_SRS_PREPAYMENT_NUM Y select invoice_id id, invoice_num value, description description from ap_invoices where invoice_id in (select prepay_id from ap_invoice_prepays where invoice_id= nvl(:$flex$.ap_srs_invoice_number,invoice_id)) and vendor_id= nvl(:$flex$.ap_srs_vendor_name,vendor_id) order by value,description AR رقم الدفعة المقدمة (تخطي للكل) D Vorauszahlungsnummer F Numéro d'acompte (Sauter si Tous) US Prepayment Number (skip for All) ZHS 预付款编号（忽略则为全部） 4 40 :p_start_date Date AR من D Von F Du US From ZHS 自 5 50 :p_end_date Date AR إلى D Bis F Au US To ZHS 至 6 60 :p_name_srs Char AR اسم المرسل D Absendername F Nom de l'expéditeur US Name of Sender ZHS 发送者姓名 7 70 :p_title_srs Char AR لقب المرسل D Titel des Absenders F Fonction de l'expéditeur US Title of Sender ZHS 发送者称呼 8 80 :p_phone_srs Char AR هاتف المرسل D Telefonnummer des Absenders F Téléphone de l'expéditeur US Phone of Sender ZHS 发送者电话