Search Results gr_eurohazards_b




Overview
Explore in AI Chat

Overview

The GR_EUROHAZARDS_B table is a core data structure within the Oracle E-Business Suite (EBS) Process Manufacturing Regulatory Management (GR) module. It serves as the master repository for European Hazard Classification descriptions, which are critical for regulatory compliance in the manufacturing and distribution of chemical substances and mixtures. This table is central to managing and applying the standardized hazard codes and classifications mandated by European regulations, such as the CLP (Classification, Labelling and Packaging) Regulation. Its role is to provide the foundational reference data that other transactional and calculation tables within the GR module utilize to determine product safety, generate safety data sheets (SDS), and ensure accurate labeling.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented primary and foreign key relationships define its essential structure. The primary key column, HAZARD_CLASSIFICATION_CODE, uniquely identifies each European hazard classification entry. Another critical column is HAZARD_GROUP_CODE, which establishes a foreign key relationship to the GR_HAZARD_GROUPS table, logically grouping related hazard classifications. The table's description indicates it stores descriptive information for these classifications, which likely includes fields for the official classification text, internal identifiers, and potentially active/inactive status flags to control their use in business processes.

Common Use Cases and Queries

This table is primarily accessed for reference and validation during regulatory configuration and reporting. Common operational scenarios include setting up hazard classifications for new raw materials or finished goods, and generating regulatory reports for compliance audits. A frequent query pattern involves joining this table to its translated descriptions (GR_EUROHAZARDS_TL) to retrieve classifications in a specific language. For instance, to list all active hazard classifications with their group codes and English descriptions, a query might resemble:

  • SELECT b.HAZARD_CLASSIFICATION_CODE, b.HAZARD_GROUP_CODE, tl.DESCRIPTION FROM GR.GR_EUROHAZARDS_B b, GR.GR_EUROHAZARDS_TL tl WHERE b.HAZARD_CLASSIFICATION_CODE = tl.HAZARD_CLASSIFICATION_CODE AND tl.LANGUAGE = 'US';

Another critical use case is within additive calculation logic, where the system references this table via GR_ADDITIVE_CALCS to determine the overall hazard of a mixture based on its components.

Related Objects

The GR_EUROHAZARDS_B table is a central hub within the GR module's data model, with extensive relationships to key transactional tables. As per the documented metadata:

  • Referenced Table (Parent): GR_HAZARD_GROUPS, via the column GR_EUROHAZARDS_B.HAZARD_GROUP_CODE.
  • Referencing Tables (Children):

These relationships demonstrate the table's integral role in calculations (GR_ADDITIVE_CALCS, GR_EURO_DEFAULT_CONCS), item-specific classifications (GR_ITEM_CLASSNS), and risk management (GR_SOURCE_RISKS).