AP Invoice Attachments Extraction

select distinct
aia.invoice_id,
aia.Voucher_Number,
d.file_name,
d.url
from fnd_attached_documents fad,
ap_invoices_all aia,
fnd_documents d
where 1=1
and aia.invoice_id = fad.pk1_value
and fad.entity_name = ‘AP_INVOICES’
and fad.document_id = d.document_id;