Search Results gr_item_groups_b_pk




Overview
Explore in AI Chat

Overview

The GR_ITEM_GROUPS_B table is a core master data table within Oracle E-Business Suite Process Manufacturing Regulatory Management (GR). It serves as the foundational repository for defining and managing item groups, which are logical collections of items (e.g., raw materials, intermediates, finished goods) used for regulatory compliance analysis. Its primary role is to establish a standardized grouping mechanism, enabling the consolidation and assessment of toxicity and exposure data at the group level, which is critical for regulatory reporting and safety evaluations in process manufacturing industries such as chemicals and pharmaceuticals.

Key Information Stored

The table stores the essential attributes for each unique item group. As defined by its primary key, the central column is ITEM_GROUP_CODE, which holds the unique identifier for the group. A corresponding DESCRIPTION column stores the descriptive name. Crucially, the table is designed to contain consolidated toxicity and exposure data fields for the group, though the specific column names for this data are not detailed in the provided excerpt. These consolidated values are typically derived from the individual items within the group and are used for high-level regulatory hazard assessments.

Common Use Cases and Queries

This table is central to regulatory reporting and compliance workflows. A common use case is generating a master list of all defined item groups for maintenance or audit purposes. Another critical scenario involves querying the consolidated toxicity data for a specific group to support the creation of regulatory submission documents like safety data sheet (SDS) summaries. For example, to retrieve all groups with their descriptions, a basic query would be: SELECT item_group_code, description FROM gr.gr_item_groups_b ORDER BY 1;. To analyze which items belong to a specific group for data validation, one would join to the GR_ITEM_GENERAL table using the ITEM_GROUP_CODE.

Related Objects

The GR_ITEM_GROUPS_B table has defined relationships with several key objects in the GR schema, forming a central hub for item group data.

  • Primary Key: GR_ITEM_GROUPS_B_PK on the ITEM_GROUP_CODE column.
  • Referenced by (Foreign Keys):
    • GR_ITEM_GENERAL: The ITEM_GROUP_CODE in GR_ITEM_GENERAL references this table, linking individual items to their assigned regulatory group.
    • GR_ITEM_GROUPS_TL: The ITEM_GROUP_CODE in GR_ITEM_GROUPS_TL references this table. This is the Translation table that stores multilingual descriptions for the item groups defined in the base (_B) table.