Search Results sup_repeating_group_cd

Overview

The IGS_CO_LTR_RPT_GRP view is a critical data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for the Correspondence functionality. It serves as a security-filtered view of the underlying base table, IGS_CO_LTR_RPT_GRP_ALL, enforcing Multi-Org Access Control (MOAC) to present data specific to the user's operating unit context. Its primary role is to define and manage repeating parameter groups used within correspondence letters. These groups are logical constructs that link repeating parameters, enabling the generation of dynamic, structured content in formal communications, such as listing multiple course enrollments or financial details within a single student letter.

Key Information Stored

The view exposes columns essential for defining, identifying, and tracking these repeating letter groups. The key columns include:

• CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, LETTER_REPEATING_GROUP_CD: Together, these three columns form the primary key (IGS_CO_LTR_RPT_GRP_PK), uniquely identifying a repeating group within a specific letter template.
• DESCRIPTION: Provides a human-readable explanation of the group's purpose.
• SUP_REPEATING_GROUP_CD: Indicates a hierarchical relationship, potentially pointing to a parent or superior repeating group code, allowing for nested group structures.
• ORG_ID: The operating unit identifier, central to the MOAC filter in the view's WHERE clause which restricts data visibility.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each record.

Common Use Cases and Queries

This view is primarily accessed during the setup and execution of correspondence processes. A common use case is querying all repeating groups defined for a particular letter template to understand its data structure or to troubleshoot letter generation. For instance, a developer or functional consultant might run a query to audit groups for a specific correspondence type. The view is also integral to backend processes that assemble letter data, where the repeating group codes dictate how parameter data is organized and iterated upon during output generation. A typical analytical query would join this view to the letter definition (IGS_CO_S_LTR) to get a comprehensive view of a template's components.

SELECT lrg.letter_repeating_group_cd,
       lrg.description,
       lrg.sup_repeating_group_cd
FROM   apps.igs_co_ltr_rpt_grp lrg
WHERE  lrg.correspondence_type = 'ENRL_CONFIRM'
       AND lrg.letter_reference_number = 1001
ORDER BY lrg.letter_repeating_group_cd;

Related Objects

The view maintains defined relationships with several other key objects in the Correspondence subsystem, as documented by its foreign key constraints:

• Referenced By (Child Objects): The table IGS_CO_LTR_PR_RPT_GR references this view, linking letter parameters to their respective repeating groups.
• References (Parent Objects): The view references the IGS_CO_S_LTR table (letter definition) and also has a self-referential foreign key to itself (IGS_CO_LTR_RPT_GRP), which enforces the hierarchical relationship indicated by the SUP_REPEATING_GROUP_CD column.

The primary join path for this object typically involves the composite key of CORRESPONDENCE_TYPE and LETTER_REFERENCE_NUMBER to the IGS_CO_S_LTR table, and the LETTER_REPEATING_GROUP_CD to child parameter tables or for hierarchical traversal.