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_EURO_DEFAULT_CONCS

Object Details

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

Contains European Default Hazard Classification information.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_EURO_DEFAULT_CONCS_PK	NORMAL	UNIQUE	APPS_TS_SEED	CONCENTRATION_SEQNO
GR_EURO_DEFAULT_CONCS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	CALCULATION_NAME_ID
GR_EURO_DEFAULT_CONCS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	CALCULATION_ID
GR_EURO_DEFAULT_CONCS_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	HAZARD_CLASSIFICATION_CODE
GR_EURO_DEFAULT_CONCS_N4	NORMAL	NONUNIQUE	APPS_TS_SEED	APPLY_HAZARD_CLASSN

Columns

Name	Datatype	Length	Mandatory	Comments
CONCENTRATION_SEQNO	NUMBER	(8)	Yes	Surrogate key for the item.
CALCULATION_NAME_ID	VARCHAR2	(10)		The Calculation Name ID associated with the health hazard and its Risk Phrases.
CALCULATION_ID	VARCHAR2	(2)		The ID number associated with the calculation.
HAZARD_CLASSIFICATION_CODE	VARCHAR2	(2)		The European Hazard Classification code.
APPLY_HAZARD_CLASSN	VARCHAR2	(2)		Apply hazard classification flag. Valid values are Y or N.
CONCENTRATION_HIGH	NUMBER	(15)	Yes	The highest value of the Concentration Range for which information should be displayed or printed on the document.
CONCENTRATION_LOW	NUMBER	(15)	Yes	The lowest value of the Concentration Range for which information should be displayed or printed on the document.
GAS_OR_NOT_GAS_FLAG	VARCHAR2	(1)	Yes	Y to indicate that the Concentration is a Gas or N to indicate that it is a liquid or solid.
ASSIGN_SOURCE_RISKS_FLAG	VARCHAR2	(1)	Yes	Y or N for the Calculation routines to determine if Source Risk Phrases should be assigned with the classification.
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 CONCENTRATION_SEQNO
,      CALCULATION_NAME_ID
,      CALCULATION_ID
,      HAZARD_CLASSIFICATION_CODE
,      APPLY_HAZARD_CLASSN
,      CONCENTRATION_HIGH
,      CONCENTRATION_LOW
,      GAS_OR_NOT_GAS_FLAG
,      ASSIGN_SOURCE_RISKS_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GR.GR_EURO_DEFAULT_CONCS;

Dependencies

[top of page]

GR.GR_EURO_DEFAULT_CONCS does not reference any database object

GR.GR_EURO_DEFAULT_CONCS is referenced by following:

GR: GR_EURO_DEFAULT_CONCS#