AP Invoice Approval Workflow - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Payables
Source: Invoice Approval Workflow (XML) - Not Supported: Reserved For Future Use
Short Name: APXIAWRE_XML
DB package: AP_APXIAWRE_XMLP_PKG
Run AP Invoice Approval Workflow - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Supplier Name 
 
 LOV Oracle
Invoice Number 
 
 LOV Oracle
From Invoice Date 
 
 Date
To Invoice Date 
 
 Date
Download
Related Blitz Reports
JA Third Party Detail Trial Balance with Contra Accounts ECC Payables, AP Closing, SQL1 RK: AP Invoices and Lines AP Open Balances Revaluation (1) JE Israeli Summary VAT to Tax Authorities PA Supplier Cost Audit AP Invoice History Report- Not Supported: Reserved For Future Use JA India - Creditors Ledger- Not Supported: Reserved For Future Use XXSJ Report VAT Register AP Invoice Errors
Blitz Report™

Blitz Report™ provides multiple benefits: