[Home] [Help] [Dependency Information]
Object Name: | GR_TOXIC_SPECIES_TL |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_TOXIC_SPECIES_TL |
Subobject Name: | |
Status: | VALID |
This entity stores, by language, the standard codes and descriptions for animal species used in testing. The 3 character code is based on those used in Sax's Properties of Dangerous Goods. The table is seeded with the standard codes.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_TOXIC_SPECIES_TL_PK | NORMAL | UNIQUE | APPS_TS_SEED |
TOXIC_SPECIES_CODE
LANGUAGE |
GR_TOXIC_SPECIES_TL_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | LANGUAGE |
GR_TOXIC_SPECIES_TL_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | SOURCE_LANG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TOXIC_SPECIES_CODE | VARCHAR2 | (3) | Yes | The three character code referring to the species used in the toxicity testing. A typical example would be CHK for Chicken. |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
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. |
TOXIC_SPECIES_DESC | VARCHAR2 | (240) | Yes | The description of the toxic species code. |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT TOXIC_SPECIES_CODE
, LANGUAGE
, SOURCE_LANG
, TOXIC_SPECIES_DESC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM GR.GR_TOXIC_SPECIES_TL;
GR.GR_TOXIC_SPECIES_TL does not reference any database object
GR.GR_TOXIC_SPECIES_TL is referenced by following:
|
|
|