Search Results gr_euro_default_concs




Overview
Explore in AI Chat

Overview

The GR_EURO_DEFAULT_CONCS table is a core data structure within the Oracle E-Business Suite (EBS) Process Manufacturing Regulatory Management module (GR). Its primary role is to store European Default Hazard Classification information, which is critical for regulatory compliance in the European market. This table functions as a central repository for concentration-based hazard classification rules, enabling the system to automatically determine the appropriate hazard classifications for substances and mixtures based on predefined concentration thresholds. It is integral to the product's ability to generate compliant safety data sheets (SDS) and labels according to regulations like CLP (Classification, Labelling and Packaging).

Key Information Stored

While the provided metadata does not list all column names, the documented primary and foreign keys reveal the table's essential structure. The primary key, CONCENTRATION_SEQNO, uniquely identifies each default concentration rule. The table stores links to related regulatory data through foreign keys: CALCULATION_NAME_ID and CALCULATION_ID reference specific regulatory calculation definitions in GR_CALCULATION_NAMES and GR_ADDITIVE_CALCS, respectively. Crucially, the HAZARD_CLASSIFICATION_CODE and APPLY_HAZARD_CLASSN columns link to the GR_EUROHAZARDS_B table, which holds the master list of European hazard classifications. This structure implies the table stores concentration thresholds (likely in dedicated columns not listed) and maps them to the specific hazard codes that apply when those thresholds are met or exceeded.

Common Use Cases and Queries

The primary use case is the automated hazard determination engine within Regulatory Management. When assessing a product's formulation, the system queries this table to find applicable concentration rules for its components and applies the corresponding hazard classifications. A common reporting need is to audit or review all default concentration rules for a specific calculation or hazard. A sample query to retrieve this information would join to the related hazard master table:

  • SELECT edc.*, eh.hazard_description
    FROM gr.gr_euro_default_concs edc,
    gr.gr_eurohazards_b eh
    WHERE edc.hazard_classification_code = eh.hazard_classification_code
    AND edc.calculation_name_id = :p_calc_name_id
    ORDER BY edc.concentration_seqno;

Data maintenance for this table is typically performed through the application's dedicated regulatory setup interfaces, not via direct SQL manipulation.

Related Objects

The GR_EURO_DEFAULT_CONCS table has defined relationships with several key regulatory tables, as per the provided metadata:

  • Referenced By (Foreign Keys from GR_EURO_DEFAULT_CONCS):
    • GR_CALCULATION_NAMES: Via CALCULATION_NAME_ID. Links a rule to a specific regulatory calculation name.
    • GR_ADDITIVE_CALCS: Via CALCULATION_ID. Links a rule to a specific additive calculation definition.
    • GR_EUROHAZARDS_B: Via HAZARD_CLASSIFICATION_CODE and APPLY_HAZARD_CLASSN. Provides the actual hazard code and classification details for the rule.
  • Referenced By Other Tables (Foreign Keys to GR_EURO_DEFAULT_CONCS):
    • GR_EURO_MANDATORY_RISKS: Via CONCENTRATION_SEQNO. Indicates that mandatory risk phrases are defined for specific concentration rules stored in this table.