Search Results gr_item_document_dtls




Overview
Explore in AI Chat

Overview

The GR_ITEM_DOCUMENT_DTLS 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 structured regulatory or compliance text associated with items on specific documents. The table stores the defined phrases, such as safety warnings, handling instructions, or regulatory declarations, that must be printed on documents like labels, safety data sheets, or certificates of analysis for manufactured items. It acts as a junction table, linking an item-document combination to the precise regulatory phrases and their organizational headings, thereby enabling the automated generation of compliant documentation critical for industries with stringent regulatory requirements.

Key Information Stored

The table's structure is designed to define the precise composition of item-related document text. Its primary key is a composite of four columns, ensuring a unique definition for each phrase on a document for an item. The key columns are ITEM_CODE and DOCUMENT_CODE, which identify the specific item and document type. The PHRASE_CODE points to the exact regulatory text from the GR_PHRASES_B table, and DISPLAY_ORDER dictates the sequence in which multiple phrases appear. Furthermore, the table includes foreign key columns like MAIN_HEADING_CODE and SUB_HEADING_CODE to categorize the phrase under a logical document section, and PHRASE_GROUP_CODE for broader grouping, providing a hierarchical and organized presentation of regulatory content.

Common Use Cases and Queries

A primary use case is the runtime generation of item labels or safety sheets, where the application queries this table to fetch all mandated phrases for a given item and document. For example, a report to audit all regulatory phrases assigned to an item across documents would use a query joining to GR_PHRASES_B for the phrase text. Data maintenance involves inserting or updating records to comply with new regulations. A typical SQL pattern to retrieve the full phrase definition for an item's document would be:

  • SELECT gid.document_code, gid.display_order, gp.phrase_text, gmh.heading_name FROM gr_item_document_dtls gid JOIN gr_phrases_b gp ON gid.phrase_code = gp.phrase_code LEFT JOIN gr_main_headings_b gmh ON gid.main_heading_code = gmh.main_heading_code WHERE gid.item_code = '<ITEM>' ORDER BY gid.document_code, gid.display_order;

Related Objects

The GR_ITEM_DOCUMENT_DTLS table is central to the Regulatory Management schema, with defined foreign key relationships to several key master tables. It references the GR_ITEM_DOC_STATUSES table via ITEM_CODE and DOCUMENT_CODE, linking phrase details to the overall status of an item's documentation. The core regulatory text is sourced from GR_PHRASES_B via PHRASE_CODE. For document structure, it relates to GR_MAIN_HEADINGS_B and GR_SUB_HEADINGS_B. It also connects to GR_PHRASE_GROUP_CODES for categorical grouping. These relationships ensure data integrity and enable comprehensive regulatory content management from a single item-document record.