AP Invoice Approval Workflow - draft
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
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 |