View: ADI_WEB_FILES_VL

Product:	FRM - Report Manager
Description:	Obsoleted view
Implementation/DBA Data:	APPS.ADI_WEB_FILES_VL

View Text

SELECT D.DOCUMENT_ID || '_' || D.FILE_NAME NAME
, D.DESCRIPTION MIME_TYPE
, D.PROGRAM_ID DOC_SIZE
, LR.LONG_RAW CONTENT
FROM FND_DOCUMENTS_VL D
, FND_DOCUMENT_CATEGORIES_VL CL
, FND_DOCUMENTS_LONG_RAW LR
WHERE D.MEDIA_ID = LR.MEDIA_ID
AND D.CATEGORY_ID = CL.CATEGORY_ID
AND CL.NAME IN ('ADI_KIOSK_IMAGE'
, 'ADI_KIOSK_DEFAULT_LOGO')

Columns