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')