[Home] [Help] [Dependency Information]
Object Name: | QP_PRC_CONTEXTS_TL |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_PRC_CONTEXTS_TL |
Subobject Name: | |
Status: | VALID |
This table stores context names and descriptions in various languages. This table also preserves the original seeded context names and descriptions, in case they were changed by the user. The user can restore the original values.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_PRC_CONTEXTS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PRC_CONTEXT_ID
LANGUAGE |
QP_PRC_CONTEXTS_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRC_CONTEXT_ID | NUMBER | Yes | Foeign key reference to QP_PRC_CONTEXTS_B.PRC_CONTEXT_ID | |
LANGUAGE | VARCHAR2 | (4) | Yes | The language code of the language which the translatable fields are translated to. |
SOURCE_LANG | VARCHAR2 | (4) | Yes | The language code of the language which the translatable fields were originally translated to. |
SEEDED_PRC_CONTEXT_NAME | VARCHAR2 | (240) | The original name of the seeded contexts. The seeded names remain archived. | |
USER_PRC_CONTEXT_NAME | VARCHAR2 | (240) | Yes | The actual name as entered or modified by the user for user entered or seeded contexts respectively. The user entered name may be same or different for a seeded context. |
SEEDED_DESCRIPTION | VARCHAR2 | (2000) | The original description of the seeded contexts. The seeded descriptions remain archived. | |
USER_DESCRIPTION | VARCHAR2 | (2000) | Yes | The actual description as entered or modified by the user for user entered or seeded context respectively. The user entered description may be same or different for a seeded context. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PRC_CONTEXT_ID
, LANGUAGE
, SOURCE_LANG
, SEEDED_PRC_CONTEXT_NAME
, USER_PRC_CONTEXT_NAME
, SEEDED_DESCRIPTION
, USER_DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM QP.QP_PRC_CONTEXTS_TL;
QP.QP_PRC_CONTEXTS_TL does not reference any database object
QP.QP_PRC_CONTEXTS_TL is referenced by following:
|
|
|