ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F47E3869E053B46B63588994 SELECT po1.vendor_name C_VENDOR_NAME, segment1 C_VENDOR_NUMBER, i.invoice_num C_MEMO_NUM, i.invoice_date C_MEMO_DATE, id.distribution_line_number C_DISTRIBUTION_LINE_NUM, decode(id.parent_invoice_id, NULL, 'not matched',i2.invoice_num) C_INV_NUM_APPLIED, i2.invoice_date C_INVOICE_DATE, i.invoice_currency_code C_INV_CURRENCY_CODE, nvl(id.amount,0) C_DISTRIBUTION_AMOUNT, id.accounting_date C_GL_DATE, id.exchange_date C_EXCHANGE_DATE, id.exchange_rate C_EXCHANGE_RATE, id.exchange_rate_type C_EXCHANGE_RATE_TYPE, nvl(nvl(id.base_amount,id.amount),0) C_DIST_FUNC_AMOUNT1, id.base_amount C_DIST_FUNC_AMOUNT2 -- ,&C_INV_CURRENCY_CODE C_INV_CURRENCY_CODE2 FROM po_vendors po1, ap_invoices i, ap_invoices i2, ap_invoice_distributions id WHERE i.invoice_type_lookup_code IN ('DEBIT', 'CREDIT') and id.invoice_id(+) = i.invoice_id and i.vendor_id = po1.vendor_id and id.parent_invoice_id = i2.invoice_id(+) and i.set_of_books_id = :P_SET_OF_BOOKS_ID &C_VENDOR &C_DATE ORDER BY 1,2,3,4,5,6,7 Y SQLAP APXCMINV_XML AR AP تقرير مطابقة الإشعار الدائن (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: المدفوعات Source: تقرير مطابقة الإشعار الدائن (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXCMINV_XML DB package: AP_APXCMINV_XMLP_PKG D AP Gutschriften abgleichen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Kreditoren Source: Gutschriften abgleichen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXCMINV_XML DB package: AP_APXCMINV_XMLP_PKG F AP Etat du rapprochement des avoirs- Non pris en charge : réservé pour une utilisation future Application: Payables Source: Etat du rapprochement des avoirs (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXCMINV_XML DB package: AP_APXCMINV_XMLP_PKG US AP Credit Memo Matching - draft Application: Payables Source: Credit Memo Matching Report (XML) - Not Supported: Reserved For Future Use Short Name: APXCMINV_XML DB package: AP_APXCMINV_XMLP_PKG ZHS AP 贷项通知单匹配报表- 不支持：已保留供将来使用 Application: 应付帐款 Source: 贷项通知单匹配报表 (XML) - 不支持：已保留供将来使用 Short Name: APXCMINV_XML DB package: AP_APXCMINV_XMLP_PKG BI Publisher &c_date &c_inv_currency_code &c_vendor :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_date :c_vendor :lp_date_from :lp_date_to :operating_unit :p_chart_of_accounts_id :p_conc_request_id :p_date_from :p_date_to :p_debug_switch :p_min_precision :p_name :p_set_of_books_id :p_trace_switch :p_vendor_from :p_vendor_to 1 10 :p_vendor_from LOV Oracle AP_SRS_VENDOR_NAME_CHAR Y select po.vendor_name id, po.vendor_name value, null description from po_vendors po where po.vendor_id= (select max(po2.vendor_id) from po_vendors po2 where po2.vendor_name=po.vendor_name) order by po.vendor_name AR مورد من D Von Lieferant F Fournisseur - De US Supplier From ZHS 起始供应商 2 20 :p_vendor_to LOV Oracle AP_SRS_VENDOR_NAME_CHAR Y select po.vendor_name id, po.vendor_name value, null description from po_vendors po where po.vendor_id= (select max(po2.vendor_id) from po_vendors po2 where po2.vendor_name=po.vendor_name) order by po.vendor_name AR مورد إلى D Bis Lieferant F Fournisseur - A US Supplier To ZHS 供应商至 3 30 :p_date_from Date AR تاريخ بدء الإشعار الدائن D Startdatum Gutschrift F Date de début de l'avoir US Begin Credit Memo Date ZHS 贷项通知单起始日期 4 40 :p_date_to Date AR تاريخ انتهاء الإشعار الدائن D Enddatum Gutschrift F Date de fin de l'avoir US End Credit Memo Date ZHS 贷项通知单日期至