Search Results gr_phrase_concs




Overview
Explore in AI Chat

Overview

The GR_PHRASE_CONCS table is a core data structure within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is designed to manage the concentration-level specifications associated with regulatory phrases. In the context of product safety and compliance, particularly for chemicals and pharmaceuticals, regulatory phrases often apply differently based on the concentration of a substance in a mixture. This table provides the mechanism to define those concentration thresholds and their hierarchical relationships, enabling precise and compliant hazard communication, labeling, and reporting.

Key Information Stored

The table's primary function is to store concentration ranges linked to specific regulatory phrases. Its structure is defined by a composite primary key and critical foreign key relationships. The essential columns include:

  • PHRASE_CODE: The unique identifier linking to the master regulatory phrase definition in the GR_PHRASES_B table.
  • PHRASE_CONCENTRATION_LOW and PHRASE_CONCENTRATION_HIGH: These columns define the lower and upper bounds of the concentration range (e.g., 10% to 25%) for which the associated phrase is applicable. Together with PHRASE_CODE, they form the table's primary key (GR_PHRASE_CONCS_PK).
  • PHRASE_TYPE_CODE: A code that categorizes the phrase concentration record, linked to the GR_PHRASE_TYPES table. This allows for classifying different types of concentration rules or hierarchies within the regulatory framework.

Common Use Cases and Queries

This table is central to generating accurate safety data sheets (SDS) and product labels. A primary use case is determining the correct hazard or precautionary statement to display based on the calculated concentration of a regulated substance in a finished good. For example, a system process would query this table to find all phrases applicable to a specific substance where the product's concentration falls within the stored low and high range. A typical query pattern would involve joining to the phrase master table to retrieve the phrase text:

SELECT gpc.*, gpb.phrase_text
FROM gr.gr_phrase_concs gpc,
gr.gr_phrases_b gpb
WHERE gpc.phrase_code = gpb.phrase_code
AND gpc.phrase_code = 'H318'
AND :product_concentration BETWEEN gpc.phrase_concentration_low
AND gpc.phrase_concentration_high;

Reporting use cases include auditing concentration rules for compliance with specific regional regulations or analyzing the hierarchy of phrases applied across different concentration tiers.

Related Objects

The GR_PHRASE_CONCS table is a child entity within the GR module's data model, with defined dependencies on two key master tables:

  • GR_PHRASES_B: This is the master table for regulatory phrases. The foreign key relationship (GR_PHRASE_CONCS.PHRASE_CODE → GR_PHRASES_B) ensures that every concentration record is associated with a valid, defined phrase.
  • GR_PHRASE_TYPES: This lookup table provides context for the concentration record type. The foreign key relationship (GR_PHRASE_CONCS.PHRASE_TYPE_CODE → GR_PHRASE_TYPES) maintains data integrity for phrase classification.

These relationships are critical for maintaining referential integrity and for any data extraction or integration involving regulatory phrase concentrations.