You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!