View: IBC_CITEMS_V

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

View Text

SELECT IBC_CONTENT_ITEMS.CONTENT_ITEM_ID CITEM_ID
, IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE REF_CODE
, IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE CTYPE_CODE
, IBC_CONTENT_ITEMS.DIRECTORY_NODE_ID DIR_NODE_ID
, IBC_CONTENT_ITEMS.PARENT_ITEM_ID PARENT_ID
, IBC_CONTENT_ITEMS.LOCKED_BY_USER_ID LOCKED_BY
, IBC_CONTENT_ITEMS.WD_RESTRICTED_FLAG WD_RESTRICTED
, IBC_CONTENT_ITEMS.TRANSLATION_REQUIRED_FLAG TRANS_REQUIRED
, IBC_CONTENT_ITEMS.OWNER_RESOURCE_ID OWNER
, IBC_CONTENT_ITEMS.OWNER_RESOURCE_TYPE OWNER_TYPE
, IBC_CONTENT_ITEMS.CONTENT_ITEM_STATUS ITEM_STATUS
, IBC_CONTENT_ITEMS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IBC_CONTENT_TYPES_TL.CONTENT_TYPE_NAME CTYPE_NAME
, IBC_DIRECTORY_NODES_B.DIRECTORY_NODE_CODE DIR_NODE_CODE
, IBC_DIRECTORY_NODES_TL.DIRECTORY_NODE_NAME DIR_NODE_NAME
, IBC_CITEM_VERSIONS_B.CITEM_VERSION_ID CITEM_VER_ID
, IBC_CITEM_VERSIONS_B.VERSION_NUMBER VERSION
, IBC_CITEM_VERSIONS_B.CITEM_VERSION_STATUS VERSION_STATUS
, IBC_CITEM_VERSIONS_B.START_DATE START_DATE
, IBC_CITEM_VERSIONS_B.END_DATE END_DATE
, IBC_CITEM_VERSIONS_TL.LANGUAGE LANGUAGE
, IBC_CITEM_VERSIONS_TL.ATTRIBUTE_FILE_ID ATTRIB_FID
, IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_ID ATTACH_FID
, IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME NAME
, IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME ATTACH_FILE_NAME
, IBC_CITEM_VERSIONS_TL.DESCRIPTION DESCRIPTION
, IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE DEFAULT_RENDITION_MIME_TYPE
, IBC_CITEM_VERSIONS_TL.SOURCE_LANG SOURCE_LANG
, IBC_CITEM_VERSIONS_TL.CREATED_BY CREATED_BY
, IBC_CITEM_VERSIONS_TL.CREATION_DATE CREATION_DATE
, IBC_CITEM_VERSIONS_TL.LAST_UPDATED_BY LAST_UPDATED_BY
, IBC_CITEM_VERSIONS_TL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IBC_CITEM_VERSIONS_TL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IBC_CONTENT_ITEMS
, IBC_CONTENT_TYPES_TL
, IBC_CITEM_VERSIONS_B
, IBC_CITEM_VERSIONS_TL
, IBC_DIRECTORY_NODES_B
, IBC_DIRECTORY_NODES_TL
WHERE IBC_CONTENT_ITEMS.CONTENT_ITEM_ID = IBC_CITEM_VERSIONS_B.CONTENT_ITEM_ID
AND IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE = IBC_CONTENT_TYPES_TL.CONTENT_TYPE_CODE
AND IBC_CONTENT_ITEMS.DIRECTORY_NODE_ID = IBC_DIRECTORY_NODES_B.DIRECTORY_NODE_ID
AND IBC_CONTENT_ITEMS.DIRECTORY_NODE_ID = IBC_DIRECTORY_NODES_TL.DIRECTORY_NODE_ID
AND IBC_CITEM_VERSIONS_B.CITEM_VERSION_ID = IBC_CITEM_VERSIONS_TL.CITEM_VERSION_ID
AND IBC_CITEM_VERSIONS_TL.LANGUAGE = IBC_DIRECTORY_NODES_TL.LANGUAGE(+)
AND IBC_CITEM_VERSIONS_TL.LANGUAGE = IBC_CONTENT_TYPES_TL.LANGUAGE(+)

Columns