Search Results gr_item_classns_pk

Overview

The GR_ITEM_CLASSNS table is a core data object within Oracle E-Business Suite (EBS) Process Manufacturing Regulatory Management (GR) module. It serves as the central repository for storing and managing the association between items (products or substances) and their regulatory hazard classification codes. This table is fundamental for compliance reporting and safety data sheet (SDS) generation, enabling organizations to accurately document the hazardous properties of materials as mandated by regulations such as the European Union's Classification, Labelling and Packaging (CLP) regulation. Its primary role is to maintain a many-to-many relationship between items and their applicable hazard classifications.

Key Information Stored

The table's structure is designed to enforce data integrity for these critical regulatory associations. The primary key is a composite of two columns: ITEM_CODE and HAZARD_CLASSIFICATION_CODE. The ITEM_CODE uniquely identifies a specific item or substance within the regulatory system. The HAZARD_CLASSIFICATION_CODE stores the specific regulatory code that defines a hazard class, category, and related information (e.g., H226 - Flammable liquid and vapour). Together, these columns define a single, unique classification assignment for an item. The table does not typically store descriptive text for the codes; that information is maintained in the referenced lookup tables.

Common Use Cases and Queries

A primary use case is generating regulatory reports and product labels that list all hazard classifications for a given material. For example, a compliance report for a specific item would join this table to hazard code description tables. Another critical scenario is validating item data during transactions or batch production to ensure handling and storage procedures align with its classified hazards. A common SQL pattern retrieves all classifications for an item:

• SELECT gic.ITEM_CODE, gic.HAZARD_CLASSIFICATION_CODE, geh.DESCRIPTION FROM GR.GR_ITEM_CLASSNS gic JOIN GR.GR_EUROHAZARDS_B geh ON gic.HAZARD_CLASSIFICATION_CODE = geh.HAZARD_CLASSIFICATION_CODE WHERE gic.ITEM_CODE = :p_item_code;

Conversely, finding all items associated with a specific hazard code is essential for risk assessments and inventory segregation reports.

Related Objects

The GR_ITEM_CLASSNS table has defined foreign key relationships that link it to master data tables, ensuring referential integrity. As per the provided metadata, it references the following objects:

• GR_EMEA: The foreign key from GR_ITEM_CLASSNS.ITEM_CODE references this table. GR_EMEA is a master table containing detailed regulatory information about items (substances or products) within the EMEA region.
• GR_EUROHAZARDS_B: The foreign key from GR_ITEM_CLASSNS.HAZARD_CLASSIFICATION_CODE references this table. GR_EUROHAZARDS_B is a lookup table that stores the full definition, description, and regulatory context for each hazard classification code.

The primary key constraint GR_ITEM_CLASSNS_PK ensures no duplicate classification assignments exist for the same item and hazard code combination. This table is a key junction point in the regulatory data model, feeding into downstream compliance documentation processes.