Search Results account_category_code




Overview
Explore in AI Chat

Overview

GL_SUMMARY_TEMPLATES_NAMES_V is a General Ledger (GL) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes summary template definitions together with their concatenated account descriptions, and its documented status is VALID. The ETRM metadata describes this object as "10SC ONLY," indicating that it is a restricted or product-line-specific object rather than a general-purpose dictionary view. It is a thin projection over the summary template table, presenting a subset of columns that is convenient for name-oriented lookup and reporting. The view supports reporting and integration scenarios where applications or custom code must resolve a summary template to its descriptive label, associated ledger, and account category without navigating the full underlying table. Because the view is a wrapper and not an independent data store, it contains no data of its own; all content is derived from the base object at query time.

Underlying Base Objects

The view is defined solely over GL_SUMMARY_TEMPLATES, which is referenced through a synonym in the documented metadata. The view text selects directly from that base table, aliased as ST, and projects a defined column list without joins, unions, or aggregations. This design means the row granularity of the view matches the base table exactly: one row per summary template record. There are no additional dependent objects, and no DISTINCT or filtering clauses are applied in the definition, so the view returns all rows present in GL_SUMMARY_TEMPLATES. Performance characteristics therefore mirror those of a direct query against the base table, and any partitioning, indexes, or security rules applied to GL_SUMMARY_TEMPLATES carry through unchanged.

Key Columns

  • TEMPLATE_NAME — the descriptive name of the summary template, the primary human-readable identifier for the record.
  • TEMPLATE_ID — the unique numeric key identifying the summary template.
  • LEDGER_ID — the ledger to which the summary template belongs, tying the template to a specific accounting ledger context.
  • STATUS — the current state of the template definition.
  • CONCATENATED_DESCRIPTION — a combined description string, typically the concatenated account segment values, exposed for display purposes.
  • ACCOUNT_CATEGORY_CODE — the account category associated with the template.
  • MAX_CODE_COMBINATION_ID — the maximum code combination identifier referenced by the template, which corresponds directly to the user search term. This column is significant for consumers that need to identify the highest code combination used by a template.
  • START_ACTUALS_PERIOD_NAME — the starting period name for actuals processing associated with the template.

Common Use Cases and Queries

The view is typically used to retrieve summary template names alongside their concatenated descriptions and ledger assignments for reporting, validation, and integration. A representative query retrieving a single template by identifier is:

SELECT template_name, ledger_id, status, concatenated_description FROM gl_summary_templates_names_v WHERE template_id = :p_template_id;

Because the user searched for MAX_CODE_COMBINATION_ID, a common pattern is to inspect the code combination ceiling for one or more templates, for example:

SELECT template_id, template_name, max_code_combination_id FROM gl_summary_templates_names_v WHERE ledger_id = :p_ledger_id ORDER BY max_code_combination_id;

Additional scenarios include listing all active templates for a ledger, joining the view to ledger or code combination queries through LEDGER_ID and MAX_CODE_COMBINATION_ID, and using CONCATENATED_DESCRIPTION to populate user-facing lists. Given the "10SC ONLY" designation, consumers should confirm that the object is supported for their specific configuration before relying on it in production interfaces.