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

TABLE: GR.GR_RISK_PHRASES_B

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


Stores the code and name of acceptable phrases in multiple languages.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GR_RISK_PHRASES_B_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnRISK_PHRASE_CODE
Columns
Name Datatype Length Mandatory Comments
RISK_PHRASE_CODE VARCHAR2 (15) Yes The risk phrase code that is assigned to the risk phrase text.
ADDITIONAL_TEXT_INDICATOR VARCHAR2 (1) Yes The additional text flag is used where item specific text needs to be substituted in the phrase. One example is the safety phrase S28 -- 'After contact with skin, wash immediately with plenty of ...'. The options are:'N' -- No additional text is required. This is the default.'P' -- Phrase. An additional sentence or block of text is required.'T' -- Temperature. The additional information is a storage temperature.'B' -- The additional information requires both a phrase and a temperature.
LOOKUP_TYPE VARCHAR2 (30)
Not Used
LOOKUP_CODE VARCHAR2 (30)
Not Used
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flex Field
ATTRIBUTE1 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE2 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE3 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE4 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE5 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE6 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE7 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE8 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE9 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE10 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE11 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE12 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE13 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE14 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE15 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE16 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE17 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE18 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE19 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE20 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE21 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE22 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE23 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE24 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE25 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE26 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE27 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE28 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE29 VARCHAR2 (240)
Standard Flex Field
ATTRIBUTE30 VARCHAR2 (240)
Standard Flex Field
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 RISK_PHRASE_CODE
,      ADDITIONAL_TEXT_INDICATOR
,      LOOKUP_TYPE
,      LOOKUP_CODE
,      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_RISK_PHRASES_B;

Dependencies

[top of page]

GR.GR_RISK_PHRASES_B does not reference any database object

GR.GR_RISK_PHRASES_B is referenced by following:

SchemaAPPS
SynonymGR_RISK_PHRASES_B