[Home] [Help] [Dependency Information]
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".
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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" |
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;
PRP.PRP_PROPOSAL_TOKENS does not reference any database object
PRP.PRP_PROPOSAL_TOKENS is referenced by following:
|
|
|