Search Results gr_generic_items_b




Overview
Explore in AI Chat

Overview

The GR_GENERIC_ITEMS_B table is a core data object within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its primary function is to manage the assignment of generic Material Safety Data Sheets (MSDS) to items. In regulatory compliance, a generic MSDS can be assigned to multiple items that share identical or highly similar hazardous characteristics, streamlining the management of safety documentation. This table serves as the central repository for these assignments, linking generic MSDS definitions to specific inventory items, thereby forming a critical component of the product safety and regulatory reporting infrastructure.

Key Information Stored

The table's structure is defined by a composite primary key, which precisely identifies the relationship between a generic MSDS and an item. The key columns are ITEM_CODE and ITEM_NO. While the provided metadata does not list non-key columns, the primary and foreign key relationships reveal its essential data model. The ITEM_CODE column identifies the specific generic MSDS record, while the ITEM_NO column holds the identifier for the inventory item to which that MSDS is assigned. This pairing ensures that a single generic MSDS (ITEM_CODE) can be associated with many items (ITEM_NO), and an item can be linked to a specific generic MSDS.

Common Use Cases and Queries

The primary use case is regulatory reporting and safety documentation retrieval. For instance, generating a list of all items associated with a particular generic MSDS for a compliance audit, or determining which generic MSDS applies to a specific item used in a production batch. Common SQL queries involve joining to item master and generic MSDS detail tables. A typical pattern is to retrieve the generic MSDS information for a given item:

  • SELECT gi.* FROM gr.gr_generic_items_b gi WHERE gi.item_no = :p_item_id;

Conversely, to find all items linked to a generic MSDS:

  • SELECT gi.* FROM gr.gr_generic_items_b gi WHERE gi.item_code = :p_generic_msds_code;

These queries are foundational for embedded reports within the GR module and for custom regulatory compliance extracts.

Related Objects

GR_GENERIC_ITEMS_B is centrally connected to several key tables via foreign key constraints, as documented in the ETRM metadata. The table references two parent tables to validate its data: GR_ITEM_GENERAL via the ITEM_CODE column, and IC_ITEM_MST_B (the standard Inventory item master) via the ITEM_NO column. This ensures that only valid generic MSDS codes and existing inventory items can be linked. Furthermore, the table is referenced as a parent by the GR_GENERIC_ML_NAME_TL table, which likely stores multilingual names or descriptions for the generic item assignments, using the same composite key (ITEM_CODE, ITEM_NO). This relationship structure underscores its role as a junction table between generic MSDS definitions, inventory items, and their translated labels.

  • Referenced Tables (Parent):
    • GR_ITEM_GENERAL (on GR_GENERIC_ITEMS_B.ITEM_CODE)
    • IC_ITEM_MST_B (on GR_GENERIC_ITEMS_B.ITEM_NO)
  • Referencing Tables (Child):
    • GR_GENERIC_ML_NAME_TL (references GR_GENERIC_ITEMS_B.ITEM_CODE and ITEM_NO)