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


TABLE: GR.GR_WORK_ADDITIVES

Object Details
Object Name: GR_WORK_ADDITIVES
Object Type: TABLE
Owner: GR
FND Design Data: TableGR.GR_WORK_ADDITIVES
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_ADDITIVES_PK NORMAL UNIQUE TablespaceAPPS_TS_NOLOGGING ColumnSESSION_ID
ColumnITEM_CODE
ColumnSEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Yes Surrogate key
SEQUENCE_NUMBER NUMBER (8) Yes The display order
CALCULATION_ID VARCHAR2 (2) Yes ID Number associated with the calculation
HAZARD_CLASSIFICATION_CODE VARCHAR2 (2) Yes The European Hazard Classification code.
RATIO_COMPARISON NUMBER (8) Yes The Regulatory module adds all ingredients within the same Calculation ID, and if the total is greater than the ratio comparison, the total is then used to assign the hazard classification.
ITEM_CODE VARCHAR2 (32) Yes item_code used as the primary constraint
Query Text

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


SELECT SESSION_ID
,      SEQUENCE_NUMBER
,      CALCULATION_ID
,      HAZARD_CLASSIFICATION_CODE
,      RATIO_COMPARISON
,      ITEM_CODE
FROM GR.GR_WORK_ADDITIVES;

Dependencies

[top of page]

GR.GR_WORK_ADDITIVES does not reference any database object

GR.GR_WORK_ADDITIVES is referenced by following:

SchemaGR
ViewGR_WORK_ADDITIVES#