[Home] [Help] [Dependency Information]
Object Name: | OE_AGREEMENTS_TL |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.OE_AGREEMENTS_TL |
Subobject Name: | |
Status: | VALID |
OE_AGREEMENTS_TL stores the translatable column, i.e. name of the agreement, in each of the available languages in the database.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OE_AGREEMENTS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AGREEMENT_ID
LANGUAGE |
OE_AGREEMENTS_TL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
AGREEMENT_SOURCE_CODE REVISION LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGREEMENT_ID | NUMBER | Yes | References primary key of OE_AGREEMENTS_B | |
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. |
NAME | VARCHAR2 | (240) | Yes | Agreement name |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
REVISION | VARCHAR2 | (50) | Revision reference for pricing agreement. | |
AGREEMENT_SOURCE_CODE | VARCHAR2 | (30) | Indicates the source system that created the agreement - possible values are 'PAGR' and 'MCTR'. |
Cut, paste (and edit) the following text to query this object:
SELECT AGREEMENT_ID
, LANGUAGE
, SOURCE_LANG
, NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REVISION
, AGREEMENT_SOURCE_CODE
FROM QP.OE_AGREEMENTS_TL;
QP.OE_AGREEMENTS_TL does not reference any database object
QP.OE_AGREEMENTS_TL is referenced by following:
|
|
|