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: PRP.PRP_COMP_STYLE_CTNTVERS

Object Details

Object Name:	PRP_COMP_STYLE_CTNTVERS
Object Type:	TABLE
Owner:	PRP
FND Design Data:	PRP.PRP_COMP_STYLE_CTNTVERS
Subobject Name:
Status:	VALID

This table contains the associations between component style and physical document file in a given language.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PRP_COMP_STYLE_CTNTVERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMP_STYLE_CTNTVER_ID
PRP_COMP_STYLE_CTNTVERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPONENT_STYLE_ID LANGUAGE VERSION_NUMBER
PRP_COMP_STYLE_CTNTVERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPONENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COMP_STYLE_CTNTVER_ID	NUMBER		Yes	Component style content version identifier. This is a primary key column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
COMPONENT_STYLE_ID	NUMBER		Yes	Component style identifier
LANGUAGE	VARCHAR2	(4)	Yes	Language
FILE_ID	NUMBER		Yes	File identifier. This column is a foreign key to FND_LOBS table that stores the physical document for the component style.
FILE_NAME	VARCHAR2	(256)		Obsoleted column. Use FILE_NAME column from FND_LOBS table. File name of the physical document
VERSION_NUMBER	NUMBER		Yes	Version number of the physical document file for the component style in the language
MAX_VERSION_FLAG	VARCHAR2	(1)	Yes	Indicates if the physical document file for the component style has the maximum version number for the language
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
COMPONENT_ID	NUMBER			Component identifier for the component style
CITEM_VERSION_ID	NUMBER			Content Item Version Identifier

Query Text

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


SELECT COMP_STYLE_CTNTVER_ID
,      OBJECT_VERSION_NUMBER
,      COMPONENT_STYLE_ID
,      LANGUAGE
,      FILE_ID
,      FILE_NAME
,      VERSION_NUMBER
,      MAX_VERSION_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      COMPONENT_ID
,      CITEM_VERSION_ID
FROM PRP.PRP_COMP_STYLE_CTNTVERS;

Dependencies

[top of page]

PRP.PRP_COMP_STYLE_CTNTVERS does not reference any database object

PRP.PRP_COMP_STYLE_CTNTVERS is referenced by following:

PRP: PRP_COMP_STYLE_CTNTVERS#