[Home] [Help] [Dependency Information]
Object Name: | QP_CURRENCY_LISTS_TL |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_CURRENCY_LISTS_TL |
Subobject Name: | |
Status: | VALID |
QP_CURRENCY_LISTS_TL stores the translatable columns, name and description of the
multi-currency list, in each of the available languages in the database.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_CURRENCY_LISTS_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENCY_HEADER_ID | NUMBER | Yes | References primary key of QP_CURRENCY_LISTS_B | |
NAME | VARCHAR2 | (240) | Yes | Multi-Currency list name |
DESCRIPTION | VARCHAR2 | (2000) | Multi-Currency list description | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
SOURCE_LANG | VARCHAR2 | (4) | Yes | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT CURRENCY_HEADER_ID
, NAME
, DESCRIPTION
, LANGUAGE
, SOURCE_LANG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM QP.QP_CURRENCY_LISTS_TL;
QP.QP_CURRENCY_LISTS_TL does not reference any database object
QP.QP_CURRENCY_LISTS_TL is referenced by following:
|
|
|