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

Report message to a moderator

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)

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 18 20:56:14 CDT 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.