Need attachment url from AP invoices

Summary:

Need invoice attachment url for approval notification

Content (please ensure you mask any confidential information):

Trying to add the invoice attachment url to the approval notification page. have looked at fnd_documents, fnd_documents_tl and fnd_attached_documents table, but can't fine the actual hyperlink that would produce/download the attachment.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

select

aia.invoice_num,

aia.invoice_id,

'https://'||ask.EXTERNAL_VIRTUAL_HOST||fdt.URI Attachment_URL

from ask_deployed_domains ask,

fnd_attached_documents fad,