How can I get the image of products in report OTBI Query? — Cloud Customer Connect
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

How can I get the image of products in report OTBI Query?

I want to get the images uploaded in the Product Information Management module for a report using a query, I have the following query, but I have not been able to get the product image:

SELECT SI.ITEM_NUMBER,
SI.INVENTORY_ITEM_ID,
ORG.ORGANIZATION_CODE,
DOC.DOCUMENT_ID,
DOC.FILE_NAME,
DOC.DM_VERSION_NUMBER,
DOC.DM_DOCUMENT_ID,
DOC.DM_REPOSITORY,
DOC.DM_TYPE
FROM EGP_SYSTEM_ITEMS_B SI
INNER JOIN FND_ATTACHED_DOCUMENTS FAD ON FAD.PK2_VALUE = SI.INVENTORY_ITEM_ID AND FAD.PK1_VALUE = SI.ORGANIZATION_ID
INNER JOIN FND_DOCUMENTS_TL DOC ON DOC.DOCUMENT_ID = FAD.DOCUMENT_ID AND DOC.LANGUAGE = USERENV('LANG')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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