[Home] [Help] [Dependency Information]
Object Name: | GR_GENERIC_ML_NAME_TL |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_GENERIC_ML_NAME_TL |
Subobject Name: | |
Status: | VALID |
Contains the Generic Names for the item, by language.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_GENERIC_ML_NAME_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ITEM_CODE
ITEM_NO LANGUAGE |
GR_GENERIC_ML_NAME_TL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LANGUAGE |
GR_GENERIC_ML_NAME_TL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LABEL_CODE |
GR_GENERIC_ML_NAME_TL_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_LANG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_CODE | VARCHAR2 | (32) | Yes | The Item Code for the substance used in or produced by the process. |
ITEM_NO | VARCHAR2 | (32) | Yes | Name of the item. |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code. |
LABEL_CODE | VARCHAR2 | (5) | 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. | |
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_DESCRIPTION | VARCHAR2 | (240) | Yes | The Generic Names for the item, by language. |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
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 ITEM_CODE
, ITEM_NO
, LANGUAGE
, LABEL_CODE
, SOURCE_LANG
, NAME_DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM GR.GR_GENERIC_ML_NAME_TL;
GR.GR_GENERIC_ML_NAME_TL does not reference any database object
GR.GR_GENERIC_ML_NAME_TL is referenced by following:
|
|
|