[Home] [Help] [Dependency Information]
Object Name: | GR_ADDITIVE_CALCS |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_ADDITIVE_CALCS |
Subobject Name: | |
Status: | VALID |
Contains Hazard Class Code and Risk Phrase Code.
The Hazard Class Code is optional and will display on a form as Hazard to Assign. The Risk Phrase Code is optional and will display or print on a form as Apply Risk Phrase.
NOTE: Hazard Class Code and Risk Phrase Code do not have a maintenance form for this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_ADDITIVE_CALCS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CALCULATION_ID |
GR_ADDITIVE_CALCS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | HAZARD_CLASSIFICATION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HAZARD_CLASSIFICATION_CODE | VARCHAR2 | (2) | The European Hazard Classification code. | |
CALCULATION_ID | VARCHAR2 | (2) | Yes | The ID number associated with the calculation. |
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. |
ADD_TO_CALCULATION_ID | VARCHAR2 | (2) | The Regulatory module sums the ingredient concentration for the Calculation ID, and if the sum is less than the Ratio Comparison, then the total is added to the calculation used by this ID to assign the hazard. | |
ASSIGN_SOURCE_RISKS_FLAG | VARCHAR2 | (1) | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT HAZARD_CLASSIFICATION_CODE
, CALCULATION_ID
, RATIO_COMPARISON
, ADD_TO_CALCULATION_ID
, ASSIGN_SOURCE_RISKS_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM GR.GR_ADDITIVE_CALCS;
GR.GR_ADDITIVE_CALCS does not reference any database object
GR.GR_ADDITIVE_CALCS is referenced by following:
|
|
|