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

TABLE: GR.GR_TOXIC_ROUTES_TL

Object Details
Object Name: GR_TOXIC_ROUTES_TL
Object Type: TABLE
Owner: GR
FND Design Data: TableGR.GR_TOXIC_ROUTES_TL
Subobject Name:
Status: VALID


This entity stores, by language, the standard observed toxic routes. The 3 character code is based on those used in Sax's Properties of Dangerous Goods. The table is seeded with the standard codes.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GR_TOXIC_ROUTES_TL_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTOXIC_ROUTE_CODE
ColumnLANGUAGE
GR_TOXIC_ROUTES_TL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnLANGUAGE
GR_TOXIC_ROUTES_TL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSOURCE_LANG
Columns
Name Datatype Length Mandatory Comments
TOXIC_ROUTE_CODE VARCHAR2 (3) Yes The code defining the route of administration. It is a 3 character code. A typical example would be IAL for intraaural.
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.
TOXIC_ROUTE_DESC VARCHAR2 (240) Yes Toxic route description
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 TOXIC_ROUTE_CODE
,      LANGUAGE
,      SOURCE_LANG
,      TOXIC_ROUTE_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GR.GR_TOXIC_ROUTES_TL;

Dependencies

[top of page]

GR.GR_TOXIC_ROUTES_TL does not reference any database object

GR.GR_TOXIC_ROUTES_TL is referenced by following:

SchemaGR
ViewGR_TOXIC_ROUTES_TL#