Script to get Oracle i-expense Line attachments

Introduction

This Post illustrates steps required to get Oracle i-expense Line attachments in Oracle EBS R12.

SELECT fl.*

FROM apps.fnd_documents_tl        fdtl,

apps.fnd_documents           fd,

apps.fnd_attached_documents  fad,

apps.fnd_lobs                fl

WHERE     fdtl.document_id = fd.document_id

AND fd.document_id = fad.document_id

AND fad.entity_name = ‘OIE_LINE_ATTACHMENTS’

AND fad.pk1_value = ‘:p_report_line_id’  — line_id from expense line

AND fl.file_id = fd.media_id

and fdtl.language=’US’;

Summary

This Post described the script get Oracle i-expense Line attachments in Oracle EBS R12.

Got any queries?

Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.