Include URL in BI Publisher report to allow viewing of invoice attachments
I am trying to find a way to include a url link to a scanned invoice images stored as pdf attachments in Oracle from a BI Publisher report.
I am trying to find a way to include a link to scanned invoice images stored as pdf attachments in Oracle.
I thought I was making progress when I found this; -
from fnd_documents_vl doc
where doc.document_id in (select document_id from fnd_attached_documents fad where fad.entity_name = 'AP_INVOICES_ALL' and fad.pk1_value in (select to_char(inv.invoice_id) from ap_invoices_all inv where inv.invoice_num = &invoice_num))