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,
Tagged:
0