You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!