Search Results gr_item_disclosures




Overview
Explore in AI Chat

Overview

The GR_ITEM_DISCLOSURES table is a core data object within Oracle E-Business Suite Process Manufacturing Regulatory Management (GR). It serves as a junction table that establishes and manages the relationship between regulated items and their associated regulatory disclosures. Its primary role is to enforce compliance by defining which specific disclosure statements, warnings, or regulatory information are mandated for a given item within the manufacturing or supply chain context. This table is essential for generating compliant product labels, safety data sheets (SDS), and other regulatory documentation required in process manufacturing industries such as chemicals, food, and pharmaceuticals.

Key Information Stored

The table's structure is defined by a composite primary key, ensuring a unique relationship between an item and a disclosure. The key columns are ITEM_CODE and DISCLOSURE_CODE. The ITEM_CODE references a specific item master record, while the DISCLOSURE_CODE references a defined disclosure entity from the GR_DISCLOSURES table. Beyond these key columns, the table may store additional attributes to qualify the relationship, such as effective dates, jurisdictions, or sequence numbers for ordering disclosures on output documents. The exact supplemental columns are not detailed in the provided metadata, but the core function is to link these two critical entities.

Common Use Cases and Queries

A primary use case is the batch generation of regulatory documents. For instance, when printing a label for a finished good, the application queries this table to fetch all disclosures linked to the item's code. Another common scenario is compliance reporting, where auditors may need a list of all items associated with a specific hazardous material disclosure. A typical SQL query to retrieve all disclosures for an item would be:

  • SELECT d.disclosure_text FROM gr_item_disclosures i, gr_disclosures d WHERE i.disclosure_code = d.disclosure_code AND i.item_code = :p_item_code;

Conversely, to find all items requiring a particular disclosure, one would query:

  • SELECT ig.item_name FROM gr_item_disclosures id, gr_item_general ig WHERE id.item_code = ig.item_code AND id.disclosure_code = :p_disclosure_code;

Related Objects

The GR_ITEM_DISCLOSURES table maintains defined foreign key relationships with two primary master tables, as documented in the ETRM metadata:

  • GR_ITEM_GENERAL: The foreign key on GR_ITEM_DISCLOSURES.ITEM_CODE references GR_ITEM_GENERAL. This table holds the general definition and attributes of the item itself.
  • GR_DISCLOSURES: The foreign key on GR_ITEM_DISCLOSURES.DISCLOSURE_CODE references GR_DISCLOSURES. This table is the master repository for the text and details of each regulatory disclosure statement.

The table's primary key constraint, GR_ITEM_DISCLOSURES_PK, enforces uniqueness on the combination of ITEM_CODE and DISCLOSURE_CODE. This object is central to the regulatory reporting and labeling functions of the GR module.