Search Results concentration_low




Overview
Explore in AI Chat

Overview

The GR_EIN_ASL_CONCS table is a core data structure within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Process Manufacturing Regulatory Management (GR) module. It serves as the central repository for storing concentration information associated with EINECS (European Inventory of Existing Chemical Substances) numbers. This table is critical for managing regulatory compliance data related to chemical substances in the European market, enabling organizations to track and report on the concentration ranges and associated hazard classifications for components within their products.

Key Information Stored

The table's primary purpose is to define concentration thresholds for a given substance. Its key columns include the SEQUENCE_NUMBER, which acts as the unique primary identifier. The EUROPEAN_INDEX_NUMBER is a foreign key linking to the GR_EIN_NUMBERS_B table, identifying the specific EINECS substance. The CONCENTRATION_LOW and CONCENTRATION_HIGH columns define the permissible or reported concentration range for that substance. Furthermore, the HAZARD_CLASSIFICATION_CODE links to the GR_EUROHAZARDS_B table to associate a specific regulatory hazard code with the concentration record. The CALCULATION_ID column provides a link to the GR_ADDITIVE_CALCS table, indicating the regulatory calculation from which this concentration data may have been derived.

Common Use Cases and Queries

This table is primarily accessed for regulatory reporting, substance compliance checks, and product safety assessments. A common use case involves generating a report of all substances in a product formulation that exceed a specific concentration threshold for a given hazard class. A typical query would join GR_EIN_ASL_CONCS to the EINECS master and hazard tables to retrieve a comprehensive view.

  • Sample Query for Substance Concentration Review:
    SELECT conc.EUROPEAN_INDEX_NUMBER,
    ein.SUBSTANCE_NAME,
    conc.CONCENTRATION_LOW,
    conc.CONCENTRATION_HIGH,
    haz.HAZARD_DESCRIPTION
    FROM GR.GR_EIN_ASL_CONCS conc,
    GR.GR_EIN_NUMBERS_B ein,
    GR.GR_EUROHAZARDS_B haz
    WHERE conc.EUROPEAN_INDEX_NUMBER = ein.EUROPEAN_INDEX_NUMBER
    AND conc.HAZARD_CLASSIFICATION_CODE = haz.HAZARD_CLASSIFICATION_CODE
    AND conc.CONCENTRATION_HIGH > 10; -- Example threshold

Related Objects

The GR_EIN_ASL_CONCS table is integral to the regulatory data model, with defined relationships to several key tables. It references three parent tables via foreign keys: GR_ADDITIVE_CALCS (via CALCULATION_ID), GR_EUROHAZARDS_B (via HAZARD_CLASSIFICATION_CODE), and GR_EIN_NUMBERS_B (via EUROPEAN_INDEX_NUMBER). Conversely, it is referenced as a parent table by GR_EIN_ASL_RISKS, which links via the SEQUENCE_NUMBER column to store associated risk assessments. These relationships ensure data integrity and enable comprehensive regulatory tracing from the base substance to its calculated concentrations and related risks.