eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GR.GR_OTHER_NAMES_TL

Object Details

Object Name:	GR_OTHER_NAMES_TL
Object Type:	TABLE
Owner:	GR
FND Design Data:	GR.GR_OTHER_NAMES_TL
Subobject Name:
Status:	VALID

The synonym entity records alternative names for an item by
language. They will be sequenced in one of two ways, as
determined by the preference SYNONYM STORAGE SEQUENCE.
The values for this are 'A' -- Alphabetically, in which case the
sequence number will always be zero or 'E' -- Entered sequence, in
which case the synonyms will always appear in the order they
were entered.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_OTHER_NAMES_TL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_CODE LANGUAGE ORGN_CODE SYNONYM_SEQUENCE_NUMBER
GR_OTHER_NAMES_TL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANGUAGE
GR_OTHER_NAMES_TL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGN_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_CODE	VARCHAR2	(32)	Yes	The Item Code for the substance used in or produced by the process.
LANGUAGE	VARCHAR2	(4)	Yes	Language code.
ORGN_CODE	VARCHAR2	(4)	Yes	The Organization Code that uses the synonym for the item.
SYNONYM_SEQUENCE_NUMBER	NUMBER	(8)	Yes	The Sequence Number to determine the sequence that will be used for displaying or printing the Synonym on the document.
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.
ITEM_OTHER_NAME	VARCHAR2	(240)	Yes	The synonym for the item.
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ITEM_CODE
,      LANGUAGE
,      ORGN_CODE
,      SYNONYM_SEQUENCE_NUMBER
,      SOURCE_LANG
,      ITEM_OTHER_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GR.GR_OTHER_NAMES_TL;

Dependencies

[top of page]

GR.GR_OTHER_NAMES_TL does not reference any database object

GR.GR_OTHER_NAMES_TL is referenced by following:

APPS: GR_OTHER_NAMES_TL