[Home] [Help] [Dependency Information]
Object Name: | GR_ITEM_GROUPS_TL |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_ITEM_GROUPS_TL |
Subobject Name: | |
Status: | VALID |
Contains the Item Group Description in multiple languages.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_ITEM_GROUPS_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ITEM_GROUP_CODE
LANGUAGE |
GR_ITEM_GROUPS_TL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LANGUAGE |
GR_ITEM_GROUPS_TL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_LANG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_GROUP_CODE | VARCHAR2 | (10) | Yes | The Group Code for the Item. |
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. |
DESCRIPTION | VARCHAR2 | (240) | Yes | The Item Group Description associated with the Item Group 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 ITEM_GROUP_CODE
, LANGUAGE
, SOURCE_LANG
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM GR.GR_ITEM_GROUPS_TL;
GR.GR_ITEM_GROUPS_TL does not reference any database object
GR.GR_ITEM_GROUPS_TL is referenced by following:
|
|
|