ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4843869E053B46B63588994 SELECT ai.invoice_id C_INVOICE_ID, ai.invoice_amount C_INVOICE_AMOUNT, sum(ail.amount) C_DIST_SUM, ai.invoice_num C_INVOICE_NUM, ai.invoice_currency_code C_INVOICE_CURR, ai.approval_iteration C_ITERATION, AP_APXIAWRE_XMLP_PKG.cf_raise_eventformula(ai.approval_iteration, ai.invoice_id) CF_Raise_Event FROM ap_invoices ai, ap_invoice_lines_all ail WHERE ai.invoice_id = ail.invoice_id AND ai.approval_ready_flag = 'Y' AND ap_invoices_pkg.get_wfapproval_status(ai.invoice_id,ai.org_id) in ('REQUIRED','NEEDS WFREAPPROVAL',' STOPPED') AND ail.line_type_lookup_code not in ('PREPAY','AWT') &LP_VENDOR_ID &LP_INVOICES_NUMBER &LP_INVOICE_DATE_FROM &LP_INVOICE_DATE_TO &LP_APPROVAL_TIMING HAVING sum(ail.amount) = ai.invoice_amount GROUP BY ai.invoice_id, ai.invoice_amount, ai.invoice_num, ai.invoice_currency_code, ai.approval_iteration SQLAP APXIAWRE_XML AR AP دفق أعمال اعتماد الفاتورة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: المدفوعات Source: دفق أعمال اعتماد الفاتورة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXIAWRE_XML DB package: AP_APXIAWRE_XMLP_PKG D AP Workflow Rechnungsgenehmigung- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Kreditoren Source: Workflow Rechnungsgenehmigung (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXIAWRE_XML DB package: AP_APXIAWRE_XMLP_PKG F AP Workflow d'approbation de facture- Non pris en charge : réservé pour une utilisation future Application: Payables Source: Workflow d'approbation de facture (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXIAWRE_XML DB package: AP_APXIAWRE_XMLP_PKG US AP Invoice Approval Workflow - draft Application: Payables Source: Invoice Approval Workflow (XML) - Not Supported: Reserved For Future Use Short Name: APXIAWRE_XML DB package: AP_APXIAWRE_XMLP_PKG ZHS AP 发票审批工作流- 不支持：已保留供将来使用 Application: 应付帐款 Source: 发票审批工作流 (XML) - 不支持：已保留供将来使用 Short Name: APXIAWRE_XML DB package: AP_APXIAWRE_XMLP_PKG BI Publisher &lp_approval_timing &lp_invoice_date_from &lp_invoice_date_to &lp_invoices_number &lp_vendor_id :applications_template_report :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_na :c_nls_no :c_nls_no_data_exists :c_nls_void :c_nls_yes :c_report_start_date :lp_approval_timing :lp_invoice_date_from :lp_invoice_date_to :lp_invoices_number :lp_vendor_id :operating_unit :p_approval_timing :p_conc_request_id :p_debug_switch :p_flexdata :p_from_invoice_date :p_from_invoice_date_v :p_invoice_num :p_min_precision :p_org_id :p_set_of_books_id :p_to_invoice_date :p_to_invoice_date_v :p_trace_switch :p_vendor_id :p_vendor_name 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 Lieferantenname F Nom du fournisseur US Supplier Name ZHS 供应商名称 2 20 :p_invoice_num LOV Oracle AP_SRS_APXIAWRE_INVOICE_NUM Y select invoice_num id, invoice_num value, description description from ap_invoices order by value,description AR رقم الفاتورة D Rechnungsnummer F Numéro de facture US Invoice Number ZHS 发票编号 3 30 :p_from_invoice_date Date AR من تاريخ الفاتورة D Von Rechnungsdatum F Date de facture - Du US From Invoice Date ZHS 自发票日期 4 40 :p_to_invoice_date Date AR إلى تاريخ الفاتورة D Bis Rechnungsdatum F Date de facture - Au US To Invoice Date ZHS 至发票日期