Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle payables invoice status (Oracle Database 11g Enterprise Edition Release - 64bit Production)
Oracle payables invoice status [message #583445] Wed, 01 May 2013 01:44 Go to next message
Messages: 66
Registered: March 2013
Location: delhi
Has anyone developed a simple sql query that captures Oracle AP Invoice
Status (e.g. Validated Cancelled)?
I noticed that this is not available through the AP_INVOICES_ALL table.
The AP_INVOICES_V calls for a package Ap_Invoices_Pkg which I currently don't have
access to.
How can i know about the package and how can i use it in my query

Re: Oracle payables invoice status [message #583613 is a reply to message #583445] Thu, 02 May 2013 05:48 Go to previous message
Messages: 18
Registered: May 2013
Location: Bangalore
Junior Member


What is your exact Requirement?.
There is no seperate table to track status of the Invoice.
It should be taken from Ap_Invoices_V only.

Previous Topic: Oracle Payables
Next Topic: Want to know the procedure which updates the table AP_TRIAL_BAL_GT in Accounts Payable TrialBalance.
Goto Forum:

Current Time: Sun Dec 05 18:32:35 CST 2021