Oracle Fusion AI Data Platform

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to fetch the line level attachment description present as attachment text?

Received Response
9
Views
1
Comments
Yashdeep
Yashdeep Rank 2 - Community Beginner
edited Aug 13, 2024 7:27PM in Oracle Fusion AI Data Platform

Using this query I am getting the attachment text:

SELECT * FROM FND_DOCUMENTS_TL WHERE DESCRIPTION LIKE '%Esti%' ORDER BY CREATION_DATE DESC

Now, what will the joining condition to get the details at invoice level.

Capture.PNG


Tagged:

Answers