[Home] [Help] [Dependency Information]
Object Name: | GR_EUROHAZARDS_TL |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_EUROHAZARDS_TL |
Subobject Name: | |
Status: | VALID |
This entity stores the hazard description information in multiple languages
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_EUROHAZARDS_TL_PK | NORMAL | UNIQUE | APPS_TS_SEED |
HAZARD_CLASSIFICATION_CODE
LANGUAGE ZD_EDITION_NAME |
GR_EUROHAZARDS_TL_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | LANGUAGE |
GR_EUROHAZARDS_TL_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | SOURCE_LANG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HAZARD_CLASSIFICATION_CODE | VARCHAR2 | (2) | Yes | The Hazard Classification Code. |
LANGUAGE | VARCHAR2 | (4) | Yes | The two character code which is assigned for each language in which the data sheets will be created. |
HAZARD_DESCRIPTION | VARCHAR2 | (240) | Yes | The description for the Hazard Classification 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. |
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. | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT HAZARD_CLASSIFICATION_CODE
, LANGUAGE
, HAZARD_DESCRIPTION
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM GR.GR_EUROHAZARDS_TL;
GR.GR_EUROHAZARDS_TL does not reference any database object
GR.GR_EUROHAZARDS_TL is referenced by following:
|
|
|