Hi All,
Has anyone developed a simple sql query that captures Oracle AP Invoice
Status (e.g. Validated, Needs Revalidation, Selected for Payment, etc.)?
I noticed that this is not available through the AP_INVOICES_ALL table.
The AP_INVOICES_V calls for a package which I currently don't have
access to.
Regards
Umair
AP AP_INVOICES_ALL TABLE
Hi,
As you said it calls the pacakge to get the status of an invoice.
Let us see what does this pacakge do.
It intially checks whether there is any cancelled date for the given invoice in ap_invoices_all table.
If there is any cancelled date then it will return the status of the invoice as 'Cancelled'.
Then it picks the encumbrance_flag value from financials_system_params_all table and match_status_flag from ap_invoice_distriutions_all table.
Based on these values it gives the various status of the respective invoice.
<font color="blue"><b>Regards,
Arun Reddy [:)],
Oracle Apps Techno Functional Consultant,
Mashreq Bank,
Dubai.
E-Mail:arunapps@gmail.com
Mobile:+971-50-9590966</b></font id="blue">
As you said it calls the pacakge to get the status of an invoice.
Let us see what does this pacakge do.
It intially checks whether there is any cancelled date for the given invoice in ap_invoices_all table.
If there is any cancelled date then it will return the status of the invoice as 'Cancelled'.
Then it picks the encumbrance_flag value from financials_system_params_all table and match_status_flag from ap_invoice_distriutions_all table.
Based on these values it gives the various status of the respective invoice.
<font color="blue"><b>Regards,
Arun Reddy [:)],
Oracle Apps Techno Functional Consultant,
Mashreq Bank,
Dubai.
E-Mail:arunapps@gmail.com
Mobile:+971-50-9590966</b></font id="blue">
Who is online
Users browsing this forum: No registered users and 1 guest