[Home] [Help] [Dependency Information]
Object Name: | SO_AGREEMENTS_TL |
---|---|
Object Type: | TABLE |
Owner: | OE |
FND Design Data: | OE.SO_AGREEMENTS_TL |
Subobject Name: | |
Status: | VALID |
SO_AGREEMENTS_TL stores translated information about all the agreements. Each row includes the language the row is translated to, the name and description of the agreement. You need one row for each agreement in each of the installed languages.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SO_AGREEMENTS_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
AGREEMENT_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGREEMENT_ID | NUMBER | Yes | ||
LANGUAGE | VARCHAR2 | (4) | Yes | |
SOURCE_LANG | VARCHAR2 | (4) | Yes | |
NAME | VARCHAR2 | (30) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER |
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
FROM OE.SO_AGREEMENTS_TL;
OE.SO_AGREEMENTS_TL does not reference any database object
OE.SO_AGREEMENTS_TL is referenced by following:
|
|
|