Query to get all item attachments in OTBI
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.
Tagged:
0