[Home] [Help] [Dependency Information]
Object Name: | PRP_TOKENS_B |
---|---|
Object Type: | TABLE |
Owner: | PRP |
FND Design Data: | PRP.PRP_TOKENS_B |
Subobject Name: | |
Status: | VALID |
This table contains the base information about the tokens.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PRP_TOKENS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TOKEN_ID |
PRP_TOKENS_B_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TOKEN_CODE |
PRP_TOKENS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TOKEN_TYPE
NATIVE_OBJECT_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TOKEN_ID | NUMBER | Yes | Token identifier. This is a primary key column. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object Version Number |
TOKEN_CODE | VARCHAR2 | (30) | Yes | Token code |
TOKEN_TYPE | VARCHAR2 | (30) | Yes | Token type. A token can of type "User Defined" or "Native". |
NATIVE_OBJECT_TYPE | VARCHAR2 | (30) | Native object type. For tokens of type "Native", this coulmn specifies the type of the native object. Currently "QUOTE" native object type is supported. For "User Defined" tokens, the value of this column will be NULL. | |
USER_DEFINED_OPTIONS | VARCHAR2 | (30) | This column specifies the token options for "User Defined" tokens. It can have one of the following values: "Text", "List of Values" or "Java Program". For "Native" tokens, the value of this column will be NULL. | |
JAVA_PROGRAM_NAME | VARCHAR2 | (240) | Java program name. This column stores the concatenated string of package name, class name and method name. | |
DATA_TYPE | VARCHAR2 | (30) | Type of the data for user defined tokens of type "Text". It can have one of the following values: "Character", "Number" and "Date". | |
DISPLAY_LENGTH | NUMBER | Maximum length of the user defined text character tokens. | ||
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 | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
START_DATE_ACTIVE | DATE | Start Date Active | ||
END_DATE_ACTIVE | DATE | End Date Active |
Cut, paste (and edit) the following text to query this object:
SELECT TOKEN_ID
, OBJECT_VERSION_NUMBER
, TOKEN_CODE
, TOKEN_TYPE
, NATIVE_OBJECT_TYPE
, USER_DEFINED_OPTIONS
, JAVA_PROGRAM_NAME
, DATA_TYPE
, DISPLAY_LENGTH
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM PRP.PRP_TOKENS_B;
PRP.PRP_TOKENS_B does not reference any database object
PRP.PRP_TOKENS_B is referenced by following:
|
|
|