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
SQL 15 lines
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 |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Supplier Name | LOV Oracle | |
| Invoice Number | LOV Oracle | |
| From Invoice Date | Date | |
| To Invoice Date | Date |