VIEW: APPS.IBC_CITEM_DOWNLOAD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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