[Home] [Help] [Dependency Information]
Object Name: | GR_LABELS_TL |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_LABELS_TL |
Subobject Name: | |
Status: | VALID |
Contains the Label Description that will be displayed or printed on the document. One row displays for each language for each label code.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_LABELS_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LABEL_CODE
LANGUAGE ZD_EDITION_NAME |
GR_LABELS_TL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LANGUAGE |
GR_LABELS_TL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_LANG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LABEL_CODE | VARCHAR2 | (5) | Yes | The Code that will be used in the Regulatory module to reference the label information for the Item. Label Codes such as Boiling and Flash Points and PH are prepopulated in the Regulatory module. Additional label codes can also be typed. |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code. |
LABEL_DESCRIPTION | VARCHAR2 | (240) | Yes | The Label Description that will be displayed or printed on the document. One row displays for each language for each label 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 | (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 | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT LABEL_CODE
, LANGUAGE
, LABEL_DESCRIPTION
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM GR.GR_LABELS_TL;
GR.GR_LABELS_TL does not reference any database object
GR.GR_LABELS_TL is referenced by following:
|
|
|