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_ITEM_TOXIC

Object Details

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

This entity holds the toxicity information recorded for an item. There
can be multiple rows of toxic information for each item.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_ITEM_TOXIC_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TOXIC_EXPOSURE_CODE LABEL_CODE ITEM_CODE TOXIC_ROUTE_CODE TOXIC_SPECIES_CODE
GR_ITEM_TOXIC_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LABEL_CODE
GR_ITEM_TOXIC_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_CODE
GR_ITEM_TOXIC_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOXIC_ROUTE_CODE
GR_ITEM_TOXIC_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOXIC_SPECIES_CODE
GR_ITEM_TOXIC_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOXIC_EFFECT_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
TOXIC_EXPOSURE_CODE	VARCHAR2	(4)	Yes	The type of exposure to which the target species is subjected. Typical values will be LD50 or LC50, meaning Lethal Dosage for 50% of the test population and Lethal Concentration for 50% of the test population.
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 entered.
ITEM_CODE	VARCHAR2	(32)	Yes	The Item Code for the substance used in or produced by the process.
TOXIC_ROUTE_CODE	VARCHAR2	(3)	Yes	The code defining the route of administration. A typical example would be IAL for intraaural.
TOXIC_SPECIES_CODE	VARCHAR2	(3)	Yes	The three character code referring to the species used in the toxicity testing. A typical example would be CHK for Chicken.
TOXIC_EFFECT_CODE	VARCHAR2	(3)		The three character code that links to the description of the toxic effects.
TOXIC_DOSE	NUMBER	(15)	Yes	The dosage, as a numeric, that was given to the test species by the specified route of administration.
TOXIC_UOM	VARCHAR2	(1)	Yes	The recorded unit of measure for the dosage given to the test population.
EXPOSURE_TIME	VARCHAR2	(30)		The amount of time that the target species has been subjected to the Toxic item.
TOXIC_NOTE	VARCHAR2	(240)		Any additional notes about the toxicity testing.
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

Query Text

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


SELECT TOXIC_EXPOSURE_CODE
,      LABEL_CODE
,      ITEM_CODE
,      TOXIC_ROUTE_CODE
,      TOXIC_SPECIES_CODE
,      TOXIC_EFFECT_CODE
,      TOXIC_DOSE
,      TOXIC_UOM
,      EXPOSURE_TIME
,      TOXIC_NOTE
,      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_ITEM_TOXIC;

Dependencies

[top of page]

GR.GR_ITEM_TOXIC does not reference any database object

GR.GR_ITEM_TOXIC is referenced by following:

GR: GR_ITEM_TOXIC#