VIEW: APPS.ADI_WEB_FILES_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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