Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle AP Query
Oracle AP Query [message #223028] Wed, 07 March 2007 04:36 Go to next message
rudivdm
Messages: 2
Registered: March 2007
Junior Member
Hi,

I'm looking to do a query in AP, which will select all unpaid invoices and their amounts, for specific currencies.
I have no idea where to look for guidance on this.

We are also looking for a query to select payment for a given period and currency.

We need this in Sql.

Would appreciate any help.

Thanks
Re: Oracle AP Query [message #223033 is a reply to message #223028] Wed, 07 March 2007 05:07 Go to previous messageGo to next message
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
Senior Member
I am not a SQL expert, but I would start by running the standard report "Invoice Aging Report" (or whichever standard report your users think is appropriate) with a trace. If you look at the log file, you will find all of the SQL that makes up the report. You can then copy and customise this to meet your requirements.

HTH

David
Re: Oracle AP Query [message #223120 is a reply to message #223033] Wed, 07 March 2007 12:00 Go to previous message
fakhar55
Messages: 99
Registered: September 2005
Location: UAE
Member
hi,
Query 'AP_INVOICES_ALL' table and you will get the desired results from that single table. Query and view its columns.
Regards
Fakhar
Previous Topic: PRINTED PO REPORT ERROR ORA-01722
Next Topic: Adjusting agreements in Oracle Projects
Goto Forum:
  


Current Time: Fri Dec 09 15:58:21 CST 2016

Total time taken to generate the page: 0.20192 seconds