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


TABLE: GR.GR_WORK_ADDITIVE_RISKS

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


Contains a temporary table used during the document build process.


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GR_WORK_ADDITIVE_RISKS_PK NORMAL UNIQUE TablespaceAPPS_TS_NOLOGGING ColumnSESSION_ID
ColumnITEM_CODE
ColumnRISK_PHRASE_CODE
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Yes Surrogate key
RISK_PHRASE_CODE VARCHAR2 (15) Yes The risk phrase code that is assigned to the risk phrase text.
ITEM_CODE VARCHAR2 (32) Yes Item code assigned as part of the Primary Key
Query Text

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


SELECT SESSION_ID
,      RISK_PHRASE_CODE
,      ITEM_CODE
FROM GR.GR_WORK_ADDITIVE_RISKS;

Dependencies

[top of page]

GR.GR_WORK_ADDITIVE_RISKS does not reference any database object

GR.GR_WORK_ADDITIVE_RISKS is referenced by following:

SchemaAPPS
SynonymGR_WORK_ADDITIVE_RISKS