eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IBC.IBC_CONTENT_ITEMS

Object Details

Object Name:	IBC_CONTENT_ITEMS
Object Type:	TABLE
Owner:	IBC
FND Design Data:	IBC.IBC_CONTENT_ITEMS
Subobject Name:
Status:	VALID

IBC_CONTENT_ITEMS stores non version or language specific information about content items.
Each content item belongs to a content type, which defines all the attributes for the content item.
A content item always resides in a directory node called its working directory. Content item status
is any value from lookup type ibc_citem_status

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBC_CONTENT_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTENT_ITEM_ID
IBC_CONTENT_ITEMS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_REFERENCE_CODE
IBC_CONTENT_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTENT_TYPE_CODE
IBC_CONTENT_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DIRECTORY_NODE_ID
IBC_CONTENT_ITEMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIVE_CITEM_VERSION_ID
IBC_CONTENT_ITEMS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTENT_ITEM_STATUS
IBC_CONTENT_ITEMS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_RESOURCE_ID OWNER_RESOURCE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
CONTENT_ITEM_ID	NUMBER		Yes	Content item Unique identifier
ITEM_REFERENCE_CODE	VARCHAR2	(100)		Content item reference code
CONTENT_TYPE_CODE	VARCHAR2	(100)	Yes	Content type code for this content item references IBC_CONTENT_TYPE_B
DIRECTORY_NODE_ID	NUMBER		Yes	Directory node identifier to which this content item belongs
PARENT_ITEM_ID	NUMBER			Parent Item Identifier
LIVE_CITEM_VERSION_ID	NUMBER			Live version of this content item
CONTENT_ITEM_STATUS	VARCHAR2	(30)		Status of this content item
LOCKED_BY_USER_ID	NUMBER	(15)		User who locked this content item for update
WD_RESTRICTED_FLAG	VARCHAR2	(1)	Yes	Whether this content item is private to users who have access to its working directory
BASE_LANGUAGE	VARCHAR2	(4)	Yes	The language in which this content item is created and updated
TRANSLATION_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Whether translation is required for this content item
OWNER_RESOURCE_ID	NUMBER	(15)		JTF Resource identifier who owns this content item
OWNER_RESOURCE_TYPE	VARCHAR2	(11)		JTF Resource type, can be RS_EMPLOYEE, or RS_GROUP
APPLICATION_ID	NUMBER			Application id for decentralized data seeding
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number for locking.
SECURITY_GROUP_ID	NUMBER			Security Group Identifier.
ENCRYPT_FLAG	VARCHAR2	(1)		Content type status. Values are Active, Inactive
ORIG_SYSTEM_REFERENCE_ID	NUMBER			Security Group Identifier.
ORIG_SYSTEM_REFERENCE_CODE	VARCHAR2	(100)		Content item reference code

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONTENT_ITEM_ID
,      ITEM_REFERENCE_CODE
,      CONTENT_TYPE_CODE
,      DIRECTORY_NODE_ID
,      PARENT_ITEM_ID
,      LIVE_CITEM_VERSION_ID
,      CONTENT_ITEM_STATUS
,      LOCKED_BY_USER_ID
,      WD_RESTRICTED_FLAG
,      BASE_LANGUAGE
,      TRANSLATION_REQUIRED_FLAG
,      OWNER_RESOURCE_ID
,      OWNER_RESOURCE_TYPE
,      APPLICATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      ENCRYPT_FLAG
,      ORIG_SYSTEM_REFERENCE_ID
,      ORIG_SYSTEM_REFERENCE_CODE
FROM IBC.IBC_CONTENT_ITEMS;

Dependencies

[top of page]

IBC.IBC_CONTENT_ITEMS does not reference any database object

IBC.IBC_CONTENT_ITEMS is referenced by following:

APPS: IBC_CONTENT_ITEMS