Search Results gr_phrase_group_assoc




Overview
Explore in AI Chat

Overview

The GR_PHRASE_GROUP_ASSOC table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Regulatory Management (GR) module. It functions as a junction or association table, establishing a many-to-many relationship between phrase groups and the individual regulatory phrases that constitute them. Its primary role is to manage the membership and sequence ordering of phrases within predefined groups, which are essential for constructing compliant regulatory documents, labels, and reports in regulated manufacturing environments such as chemicals, pharmaceuticals, and food.

Key Information Stored

The table's structure is intentionally minimal, designed solely for managing associations. The primary key is a composite of two columns, which also serve as foreign keys to related master tables. The key columns are:

  • PHRASE_GROUP_CODE: A foreign key referencing the GR_PHRASE_GROUP_CODES table. This identifies the specific regulatory phrase group to which a phrase belongs.
  • PHRASE_CODE: A foreign key referencing the GR_PHRASES_TL table. This identifies the specific regulatory phrase that is a member of the group.
  • SEQUENCE_NUMBER: As indicated in the description, this column stores the ordinal position of the phrase within its group. This sequence is critical for ensuring phrases appear in the correct, often legally mandated, order in generated documentation.

Common Use Cases and Queries

This table is central to queries that retrieve all phrases for a given group in the proper sequence for report generation or UI display. A typical use case involves generating a regulatory substance label where hazard statements (PHRASE_CODEs) must be listed in a specific order under a standard heading (PHRASE_GROUP_CODE). A common SQL pattern would be:

SELECT pgc.PHRASE_GROUP_CODE, ptl.PHRASE_TEXT, assoc.SEQUENCE_NUMBER
FROM GR_PHRASE_GROUP_ASSOC assoc,
GR_PHRASE_GROUP_CODES pgc,
GR_PHRASES_TL ptl
WHERE assoc.PHRASE_GROUP_CODE = pgc.PHRASE_GROUP_CODE
AND assoc.PHRASE_CODE = ptl.PHRASE_CODE
AND ptl.LANGUAGE = USERENV('LANG')
AND assoc.PHRASE_GROUP_CODE = :1
ORDER BY assoc.SEQUENCE_NUMBER;

Administrative use cases include maintaining phrase groups through custom interfaces or data loads, where operations involve inserting, updating sequence numbers, or deleting records from this association table.

Related Objects

The GR_PHRASE_GROUP_ASSOC table is a dependent object that sits between two key master tables, enforcing referential integrity through documented foreign key constraints.

  • GR_PHRASE_GROUP_CODES: This table defines the valid phrase groups. The association table references it via the foreign key on GR_PHRASE_GROUP_ASSOC.PHRASE_GROUP_CODE.
  • GR_PHRASES_TL: This is the translated phrases table containing the actual regulatory text in multiple languages. The association table references it via the foreign key on the composite columns GR_PHRASE_GROUP_ASSOC.PHRASE_CODE and GR_PHRASE_GROUP_ASSOC.LANGUAGE_CODE.

The primary key constraint GR_PHRASE_GROUP_ASSOC_PK on (PHRASE_GROUP_CODE, PHRASE_CODE) ensures that a single phrase cannot be added to the same group more than once.