Search Results gr_sub_headings_pk




Overview
Explore in AI Chat

Overview

The GR_SUB_HEADINGS_B table is a core reference data object within the Oracle E-Business Suite Process Manufacturing Regulatory Management (GR) module. It functions as the master repository for sub-heading codes, which are essential for organizing and classifying regulatory documentation and phrases. This table enables structured data management by providing a standardized, code-based framework for categorizing detailed sections of regulatory content. Its role is foundational, as it is referenced by multiple transactional and master data tables to ensure consistency and integrity in how regulatory information is segmented and retrieved across the application.

Key Information Stored

The primary data element stored in this table is the SUB_HEADING_CODE, which serves as the unique identifier and primary key (GR_SUB_HEADINGS_PK). While the provided ETRM metadata does not list additional columns, the table's structure typically includes standard Oracle EBS columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for auditing. The SUB_HEADING_CODE itself is a critical lookup value used to join to related tables. The corresponding translatable text descriptions for these codes are stored in the related translation table, GR_SUB_HEADINGS_TL, which is linked via the SUB_HEADING_CODE column.

Common Use Cases and Queries

This table is primarily used in regulatory reporting, compliance document generation, and data maintenance setups. Common operational scenarios include validating sub-heading codes during the entry of regulatory phrases or document details, and generating reports that list all active sub-headings used within the system. A typical query would involve joining the base table with its translation table to retrieve a user-friendly list. For example:

  • SELECT b.SUB_HEADING_CODE, tl.SUB_HEADING_NAME FROM GR.GR_SUB_HEADINGS_B b, GR.GR_SUB_HEADINGS_TL tl WHERE b.SUB_HEADING_CODE = tl.SUB_HEADING_CODE AND tl.LANGUAGE = USERENV('LANG');
  • Another common pattern is to query which regulatory phrases or document headings are associated with a specific sub-heading, leveraging the foreign key relationships for detailed analysis and impact assessment.

Related Objects

The GR_SUB_HEADINGS_B table maintains integral relationships with several key tables in the Regulatory Management module, as documented by its foreign key constraints. The SUB_HEADING_CODE column is referenced as a foreign key in the following tables:

  • GR_DOCUMENT_HEADINGS: Links sub-headings to broader document heading structures (Join Column: GR_DOCUMENT_HEADINGS.SUB_HEADING_CODE).
  • GR_ITEM_DOCUMENT_DTLS: Associates sub-headings with specific item-level regulatory document details (Join Column: GR_ITEM_DOCUMENT_DTLS.SUB_HEADING_CODE).
  • GR_PHRASES_B: Classifies regulatory phrases under specific sub-headings (Join Column: GR_PHRASES_B.SUB_HEADING_CODE).
  • GR_SUB_HEADINGS_TL: The translation table that provides language-specific descriptions for the codes (Join Column: GR_SUB_HEADINGS_TL.SUB_HEADING_CODE).