Search Results gr_item_general




Overview
Explore in AI Chat

Overview

The GR_ITEM_GENERAL table is a core data repository within the Oracle E-Business Suite Process Manufacturing Regulatory Management (GR) module. It serves as the primary table for storing regulatory metadata that further identifies an item beyond its basic inventory definition. Its central role is to govern the compilation and presentation of Material Safety Data Sheet (MSDS) documents by storing flags that control which specific regulatory data elements are displayed. This table is fundamental for maintaining compliance with health, safety, and environmental regulations by linking an item's physical and chemical properties to its regulatory classifications and disclosure requirements.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's description and foreign key relationships indicate it holds critical regulatory identifiers and control flags. The primary key is the ITEM_CODE, which links to the inventory item. Based on standard GR module design and the foreign key references, the table typically stores fields such as the PRODUCT_CLASS (linking to GR_PRODUCT_CLASSES), ITEM_GROUP_CODE (linking to GR_ITEM_GROUPS_B), and USER_ID (linking to FND_USER for auditing). Crucially, it contains numerous Boolean or list-based flags that determine the inclusion of data from related tables (like toxicity, exposure, concentrations, and disclosures) on the generated MSDS, effectively acting as a master control point for document assembly.

Common Use Cases and Queries

A primary use case is the generation of compliant MSDS reports. A system process or a regulatory analyst would query this table to determine the regulatory profile of an item and which related data sets to include. Common SQL patterns involve joining to the numerous child tables to assemble a complete regulatory dossier. For example, to retrieve the core regulatory control flags for an item, a query would be: SELECT * FROM GR.GR_ITEM_GENERAL WHERE item_code = :p_item_code;. For reporting, a more complex join retrieves all associated data: SELECT gig.*, gid.disclosure_text, gip.property_value FROM gr_item_general gig LEFT JOIN gr_item_disclosures gid ON gig.item_code = gid.item_code LEFT JOIN gr_item_properties gip ON gig.item_code = gip.item_code WHERE gig.item_code = :p_item_code;. This enables validation of item setups and troubleshooting MSDS output.

Related Objects

The GR_ITEM_GENERAL table has extensive relationships, acting as a parent to many detail tables. Key documented relationships include:

This network of relationships underscores its position as the central hub for an item's regulatory information.