Search Results gl_summary_code_combs_v




Overview
Explore in AI Chat

Overview

GL_SUMMARY_CODE_COMBINATIONS_V is an Oracle E-Business Suite General Ledger view owned by the APPS schema. Its metadata description, "10SC ONLY," indicates that the view is intended exclusively for the "10SC" configuration, a restricted usage scope that limits its applicability to specific implementation contexts rather than to all General Ledger deployments. The view exposes summary-account code combinations: those code combinations in GL_CODE_COMBINATIONS that are associated with a summary template defined in GL_SUMMARY_TEMPLATES. In EBS reporting and integration, such a view is typically used to retrieve the set of parent, or summary, accounts belonging to a given ledger so that balances and transactions recorded at the detail level can be rolled up or aggregated correctly.

The view is relevant to the search term summary_flag because that column is the first attribute projected by the view and is exposed to any consumer reading the view. It should not be confused with GL_CODE_COMBINATIONS.SUMMARY_FLAG itself, although the two are directly related.

Underlying Base Objects

The documented metadata for this view references three base objects: the package BUDGET_INQUIRY_PKG, and the synonyms GL_CODE_COMBINATIONS and GL_SUMMARY_TEMPLATES (each resolving to the corresponding GL_ tables in the APPS schema).

The view definition joins GL_CODE_COMBINATIONS (aliased CC) to GL_SUMMARY_TEMPLATES (aliased GST) on TEMPLATE_ID, and filters the result by ledger using the function BUDGET_INQUIRY_PKG.GET_LEDGER_ID. Because the predicate depends on a session or environment-driven function call rather than a bind variable or constant value, the view returns summary code combinations only for the ledger currently in context as determined by that package. This design makes the view sensitive to the active ledger and generally unsuitable for cross-ledger queries, which is consistent with its restricted "10SC ONLY" designation.

The join restricts the result set to code combinations that carry a non-null TEMPLATE_ID matching a defined summary template, effectively selecting the parent accounts of a summary hierarchy for the active ledger.

Key Columns

  • SUMMARY_FLAG — the summary indicator carried forward from GL_CODE_COMBINATIONS, identifying whether the account is a summary (parent) account.
  • ROW_ID — the ROWID of the underlying code combination row, useful for direct row addressing.
  • CODE_COMBINATION_ID — the primary key of the code combination.
  • CHART_OF_ACCOUNTS_ID — the chart of accounts to which the combination belongs.
  • TEMPLATE_ID — the summary template associated with the combination, and the join key to GL_SUMMARY_TEMPLATES.
  • LAST_UPDATE_DATE and LAST_UPDATED_BY — standard audit columns.
  • SEGMENT1 through SEGMENT30 — the individual accounting flexfield segment values comprising the combination.

Common Use Cases and Queries

Typical uses include identifying summary accounts for the active ledger, validating that a code combination is templated, and driving rollup reporting.

SELECT code_combination_id, summary_flag, template_id
FROM   gl_summary_code_combs_v;

A more targeted query retrieves only flagged summary accounts with a specific leading segment:

SELECT code_combination_id, segment1, segment2, summary_flag
FROM   gl_summary_code_combs_v
WHERE  summary_flag = 'Y'
AND    segment1 = :segment1;

Because the view is filtered by BUDGET_INQUIRY_PKG.GET_LEDGER_ID, queries should be executed in a session whose ledger context is initialized before the view is accessed.