View: IBC_CITEM_DOWNLOAD_V

Product:	IBC - Content Manager
Description:
Implementation/DBA Data:	APPS.IBC_CITEM_DOWNLOAD_V

View Text

SELECT APPLICATION_SHORT_NAME
, CITEM_VERSION_ID
, ATTRIBUTE_FILE_ID FILE_ID
, 'ATTRIB' FILE_TYPE
, SUBSTR(FILE_NAME
, INSTR(FILE_NAME
, '/'
, -1
, 1)+1) FILE_NAME
, FILE_CONTENT_TYPE
, LANGUAGE
FROM IBC_CONTENT_ITEMS CI
, IBC_CITEM_VERSIONS_VL CIV
, FND_APPLICATION_VL FA
, FND_LOBS AT
WHERE CI.CONTENT_ITEM_ID = CIV.CONTENT_ITEM_ID
AND FA.APPLICATION_ID = CI.APPLICATION_ID
AND AT.FILE_ID = ATTRIBUTE_FILE_ID UNION SELECT APPLICATION_SHORT_NAME
, CITEM_VERSION_ID
, ATTACHMENT_FILE_ID FILE_ID
, 'ATTACH' FILE_TYPE
, SUBSTR(FILE_NAME
, INSTR(FILE_NAME
, '/'
, -1
, 1)+1) FILE_NAME
, FILE_CONTENT_TYPE
, LANGUAGE
FROM IBC_CONTENT_ITEMS CI
, IBC_CITEM_VERSIONS_VL CIV
, FND_APPLICATION_VL FA
, FND_LOBS AH
WHERE CI.CONTENT_ITEM_ID = CIV.CONTENT_ITEM_ID
AND FA.APPLICATION_ID = CI.APPLICATION_ID
AND AH.FILE_ID = ATTACHMENT_FILE_ID

Columns