Search Results gr_exposure_types_b_pk




Overview
Explore in AI Chat

Overview

The GR_EXPOSURE_TYPES_B table is a core reference data object within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the base table for storing and managing the master list of exposure type codes. These codes are critical for classifying and categorizing the various ways in which substances or products can be exposed to humans or the environment, forming a foundational element for regulatory compliance tracking and reporting within the manufacturing process industry.

Key Information Stored

As a base table, GR_EXPOSURE_TYPES_B primarily stores the unique identifier for each exposure type. The documented primary key column is EXPOSURE_TYPE_CODE. While the ETRM excerpt does not list additional columns, typical Oracle EBS base tables for reference codes often include standard columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and ENABLED_FLAG to support application functionality and auditing. The descriptive, translatable name for each code is stored in the related TL (Translation) table, GR_EXPOSURE_TYPES_TL, which joins using the EXPOSURE_TYPE_CODE.

Common Use Cases and Queries

This table is central to regulatory data management. Common use cases include setting up and maintaining the valid list of exposure types for an organization, assigning these types to specific items or substances, and generating compliance reports that summarize exposure risks. A typical query would join this base table with its translation table to retrieve a user-friendly list of codes and their descriptions for a user interface LOV (List of Values).

SELECT b.EXPOSURE_TYPE_CODE,
       tl.DESCRIPTION,
       b.ENABLED_FLAG
FROM   GR.GR_EXPOSURE_TYPES_B b,
       GR.GR_EXPOSURE_TYPES_TL tl
WHERE  b.EXPOSURE_TYPE_CODE = tl.EXPOSURE_TYPE_CODE
AND    tl.LANGUAGE = USERENV('LANG')
ORDER BY b.EXPOSURE_TYPE_CODE;

Another critical query involves joining with the GR_ITEM_EXPOSURE table to analyze which items are associated with specific exposure types for regulatory assessment.

Related Objects

The GR_EXPOSURE_TYPES_B table maintains defined relationships with several other key objects in the GR module, as documented by its foreign keys:

  • GR_EXPOSURE_TYPES_TL: This translation table references GR_EXPOSURE_TYPES_B via the column GR_EXPOSURE_TYPES_TL.EXPOSURE_TYPE_CODE to store language-specific descriptions for each exposure type code.
  • GR_ITEM_EXPOSURE: This transactional or assignment table references GR_EXPOSURE_TYPES_B via the column GR_ITEM_EXPOSURE.EXPOSURE_TYPE_CODE. This is where specific items or substances are linked to the exposure types defined in the base table, enabling detailed regulatory tracking.

The primary key constraint GR_EXPOSURE_TYPES_B_PK on the EXPOSURE_TYPE_CODE column enforces data integrity for these relationships.