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

TABLE: GR.GR_ITEM_RISK_PHRASES

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


Contains the Standard European Risk Phrase for the item. Multiple rows of Risk Phrase information can exist for each item.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GR_ITEM_RISK_PHRASES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_CODE
ColumnRISK_PHRASE_CODE
GR_ITEM_RISK_PHRASES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRISK_PHRASE_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.
RISK_PHRASE_CODE VARCHAR2 (15) Yes The risk phrase code that is assigned to the risk phrase text.
TEMPERATURE NUMBER (15)
The storage or usage temperature for the item when using the specified Risk Phrase.
TEMPERATURE_SCALE VARCHAR2 (1)
The allowable values for the temperature scale. Valid values are: C - CentigradeF - FahrenheitK - Kelvin
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
PHRASE_CODE VARCHAR2 (10)
Code assigned to the phrase for additional risk phrase info.
Query Text

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


SELECT ITEM_CODE
,      RISK_PHRASE_CODE
,      TEMPERATURE
,      TEMPERATURE_SCALE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PHRASE_CODE
FROM GR.GR_ITEM_RISK_PHRASES;

Dependencies

[top of page]

GR.GR_ITEM_RISK_PHRASES does not reference any database object

GR.GR_ITEM_RISK_PHRASES is referenced by following:

SchemaAPPS
SynonymGR_ITEM_RISK_PHRASES