Tables involved to find the status of the invoices

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
komirelli
Posts: 1
Joined: Thu Aug 14, 2008 12:32 pm
Location: USA

Tables involved to find the status of the invoices

Post by komirelli »

What are the tables involved to find the status of invoices generated by auto invoice program....idea is to write a view from all the tables the hold invoice details and build a report on it to find the status of all invoices generated.....



thanks,

csrk
Top
siva sankar
Posts: 130
Joined: Sun Mar 11, 2007 1:47 am
Location: India

Post by siva sankar »

Hi,

In every invoice it should come to following tables.

AP_INVOICES_ALL ---->Invoice Header level details
AP_INVOICE_DISTRIBUTIONS_ALL ---->invoice Distribution details
AP_HOLDS_ALL ----->Inovoice Hold Details


Thanks & regards,

Siva
Top
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:
Contact karthikeyanp1981

Post by karthikeyanp1981 »

Please be more clear komirelli, when framing questions...
U said invoices which often resembles Payables module.
U said Autoinvoice, which is run in receivables module for importing AR transactions from Order management or any external systems...
Have you got the answer required ?
Top
Post Reply

Return to “Financials (GL, AP, AR, FA & CM)”



Who is online

Users browsing this forum: Google [Bot], Semrush [Bot] and 9 guests