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_PROPOSAL_TOKENS

Object Details

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

This table contains the tokens that are used in proposal and their corresponding values. The tokens stored in this table are only "User Defined" tokens that are of type "Text" or "List of Values".

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PRP_PROPOSAL_TOKENS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROPOSAL_TOKEN_ID
PRP_PROPOSAL_TOKENS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROPOSAL_ID TOKEN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROPOSAL_TOKEN_ID	NUMBER		Yes	Proposal token identifier. This is a primary key column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
PROPOSAL_ID	NUMBER		Yes	Proposal identifier
TOKEN_ID	NUMBER		Yes	Token identifier
TOKEN_VALUE	VARCHAR2	(2000)		This column stores the value of the token, if the token is of type "Text"
TOKEN_VALUE_ID	NUMBER			This column stores the token value identifier for the token, if the token is of type "List of Values"
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
CITEM_VERSION_ID	NUMBER			This column stores the content item version identifier for the token, if the token is of type "Image"

Query Text

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


SELECT PROPOSAL_TOKEN_ID
,      OBJECT_VERSION_NUMBER
,      PROPOSAL_ID
,      TOKEN_ID
,      TOKEN_VALUE
,      TOKEN_VALUE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CITEM_VERSION_ID
FROM PRP.PRP_PROPOSAL_TOKENS;

Dependencies

[top of page]

PRP.PRP_PROPOSAL_TOKENS does not reference any database object

PRP.PRP_PROPOSAL_TOKENS is referenced by following:

APPS: PRP_PROPOSAL_TOKENS