Query to get all item attachments in OTBI
Summary:
I need a query to get all item attachments (images and documents) in OTBI. Also it's necessary to show item number associated to the attachments.
I ask which it's the table for item attachments in my Oracle support and they gave me these tables.
fusion.fnd_documents_vl
fusion.fnd_attached_documents
For this reason, I need to know how to relate these tables with table EGP_SYSTEM_ITEMS_B and with this information build this query.
Content (please ensure you mask any confidential information):
It is not confidential.
Version (include the version you are using, if applicable):
Oracle Fusion Cloud Applications 24B
Tagged:
1