Results for “rg_report_displays_v”

20 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

RG_REPORT_DISPLAYS_V is a view owned by the APPS schema within the Application Report Generator (RG) product family of Oracle E-Business Suite. The ETRM metadata designates this object with the description "10SC ONLY," indicating that it is specific to the 10SC (Applications Report Generator / related reporting framework) context rather than a general-purpose published interface. The view presents a denormalized, display-oriented projection of report display definitions, joining each report display record to its associated row group, column group, and the axis sets that govern those groups.

Its role is chiefly internal and referential. It supports the RG report definition subsystem, where a "report display" defines which slices of rows and columns are rendered for a given report display set. Because the view resolves foreign-key identifiers such as ROW_GROUP_ID and COLUMN_GROUP_ID into descriptive names (ROW_GROUP, COLUMN_GROUP) and into the underlying row/column set names (ROW_SET, COLUMN_SET), it provides a convenient, readable layer for querying how report displays are laid out without manually joining the display groups and axis sets.

Underlying Base Objects

The view is defined over the following documented base objects, exposed through APPS synonyms: RG_REPORT_DISPLAYS, RG_REPORT_DISPLAY_GROUPS (referenced twice, as the row group alias RG and the column group alias CG), and RG_REPORT_AXIS_SETS (referenced twice, as the row set alias RS and the column set alias CS).

  • RG_REPORT_DISPLAYS (DS) — the driving table; supplies the display key columns and descriptive attributes.
  • RG_REPORT_DISPLAY_GROUPS RG — joined on DS.ROW_GROUP_ID = RG.REPORT_DISPLAY_GROUP_ID(+).
  • RG_REPORT_DISPLAY_GROUPS CG — joined on DS.COLUMN_GROUP_ID = CG.REPORT_DISPLAY_GROUP_ID(+).
  • RG_REPORT_AXIS_SETS RS — joined on RG.ROW_SET_ID = RS.AXIS_SET_ID(+).
  • RG_REPORT_AXIS_SETS CS — joined on CG.COLUMN_SET_ID = CS.AXIS_SET_ID(+).

Every join is an outer join (denoted by the (+) operator), so a display record is returned even when its row group, column group, or the associated axis sets are absent. The view therefore behaves as a left-preserving master-detail projection rooted at RG_REPORT_DISPLAYS.

Key Columns

Because the user searched on column_group_id, that column is central. It is the foreign key in RG_REPORT_DISPLAYS that references RG_REPORT_DISPLAY_GROUPS.REPORT_DISPLAY_GROUP_ID and, through the CG alias, drives the resolution of the column-side attributes.

Common Use Cases and Queries

Typical usage is diagnostic or integration-oriented: confirming which column group is bound to a report display, or enumerating the row and column bounds applied to each display. A representative query locating displays by column group identifier is:

  • SELECT report_display_id, report_display_set_id, column_group_id, column_group, column_set, display_flag FROM apps.rg_report_displays_v WHERE column_group_id = :p_column_group_id;
  • SELECT row_group, row_set, column_group, column_set FROM apps.rg_report_displays_v WHERE report_display_set_id = :p_set_id ORDER BY sequence;

Because the view is documented as "10SC ONLY," it should be treated as an internal reporting object rather than a supported public API. Querying it read-only is appropriate for investigation and validation; modifications must target the underlying base tables. As with any APPS view, the caller requires appropriate grants or should query through a synonym in the APPS schema.