Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle payables invoice status (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production)
Oracle payables invoice status [message #583445] Wed, 01 May 2013 01:44 Go to next message
bhawnakaamra
Messages: 66
Registered: March 2013
Location: delhi
Member
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


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

Hi,

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.

Cheers
Kamal
(kamal.love@gmail.com)
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: Thu Mar 28 14:15:58 CDT 2024