ERPstuff - Oracle EBS Community

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

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

Umair,

We have no option to capture the status of the invoice, other than AP_INVOICE_V. To access the same table you should have 'owner APPS'


begin
fnd_client_info.set_org_context('org_id');
end;