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

TABLE: PRP.PRP_TOKEN_VALUES_TL

Object Details
Object Name: PRP_TOKEN_VALUES_TL
Object Type: TABLE
Owner: PRP
FND Design Data: TablePRP.PRP_TOKEN_VALUES_TL
Subobject Name:
Status: VALID


This table contains the values for the "User Defined" tokens of type "List of Values". This table stores the list of values for each token in each installed language.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PRP_TOKEN_VALUES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTOKEN_VALUE_ID
ColumnLANGUAGE
PRP_TOKEN_VALUES_TL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTOKEN_ID
ColumnLANGUAGE
ColumnTOKEN_VALUE
Columns
Name Datatype Length Mandatory Comments
TOKEN_VALUE_ID NUMBER
Yes Token value identifier
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number
LANGUAGE VARCHAR2 (4) Yes Language
SOURCE_LANG VARCHAR2 (4) Yes Source language
TOKEN_ID NUMBER
Yes Token identifier
TOKEN_VALUE VARCHAR2 (240) Yes Token value
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
Query Text

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


SELECT TOKEN_VALUE_ID
,      OBJECT_VERSION_NUMBER
,      LANGUAGE
,      SOURCE_LANG
,      TOKEN_ID
,      TOKEN_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM PRP.PRP_TOKEN_VALUES_TL;

Dependencies

[top of page]

PRP.PRP_TOKEN_VALUES_TL does not reference any database object

PRP.PRP_TOKEN_VALUES_TL is referenced by following:

SchemaPRP
ViewPRP_TOKEN_VALUES_TL#