Home » SQL & PL/SQL » SQL & PL/SQL » Oracle R12 query to retrieve a list of AP invoices and the corresponding file name/path (Oracle R12)
Oracle R12 query to retrieve a list of AP invoices and the corresponding file name/path [message #684881] Mon, 20 September 2021 19:16 Go to next message
kjnf505
Messages: 1
Registered: September 2021
Junior Member
I have a list of filenames/document id that I need to rename to the invoice number reference.

In order to do that I need two things: Filename & invoice number. The queries that I found would retrieve either AP invoices number or file name.

What would be the simplest query to use to retrieve the file name in a column and the corresponding AP invoice ID in another column, output to a .txt? is it possible?
  • Attachment: Capture.PNG
    (Size: 17.46KB, Downloaded 343 times)

Report message to a moderator

Re: Oracle R12 query to retrieve a list of AP invoices and the corresponding file name/path [message #684889 is a reply to message #684881] Tue, 21 September 2021 20:12 Go to previous message
EdStevens
Messages: 1375
Registered: September 2013
Senior Member
Can you write a query without knowing the definition of the tables or or the meaning of the data?

Many people will refuse to open links from strangers on the internet. Nothing prevents pasting whatever you have directly into your postings here.

Report message to a moderator

Previous Topic: member and collection type
Next Topic: Extract string between 2 text
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 01 09:10:09 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.