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
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