Results for “gl_lookups_avg_amount_types_v”

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

Overview

GL_LOOKUPS_AVG_AMOUNT_TYPES_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, residing within the General Ledger (GL) product family. As documented in the ETRM metadata for releases 12.1.1 and 12.2.2, the view carries the description "10SC ONLY," indicating that it is scoped for a specific localization or deployment context rather than serving as a broadly used core dictionary object. Its function is to expose a filtered, denormalized representation of lookup codes that describe average amount types — that is, the categorization of balances expressed as period-to-date (PTD) or year-to-date (YTD) averages.

The view is not a data-entry or transaction object. Its role is reporting and integration: it presents a stable, purpose-built set of columns that simplifies the lookup codes stored in the underlying GL_LOOKUPS dictionary. Because it references a lookup type list rather than maintaining its own persistent storage, all values are drawn dynamically from the General Ledger lookup infrastructure.

Underlying Base Objects

The documented base object is GL_LOOKUPS, itself a view within the APPS schema rather than a physical table. GL_LOOKUPS normalizes lookup data — mapping lookup types to their codes, meanings, descriptions, and related attributes — and is the standard EBS dictionary source for General Ledger lookup values.

GL_LOOKUPS_AVG_AMOUNT_TYPES_V filters GL_LOOKUPS to two specific lookup types: PATD_EOD and PTD_YTD. The OR predicate on these two lookup types defines the membership of the result set. Any record in GL_LOOKUPS whose LOOKUP_TYPE matches one of these two values is surfaced by the view; all other lookup rows are excluded. The view performs no joins beyond this single-source selection and adds no aggregation or computed columns.

Key Columns

• AMOUNT_TYPE — sourced from GL_LOOKUPS.LOOKUP_CODE. This is the stored, machine-facing identifier for the average amount type. Typical values correspond to period-average-to-date and year-average-to-date codes.
• SHOW_AMOUNT_TYPE — sourced from GL_LOOKUPS.MEANING. This is the user-facing display string for the amount type, suitable for labels, list-of-values rendering, and report output.
• DESCRIPTION — sourced from GL_LOOKUPS.DESCRIPTION. Provides the extended explanatory text associated with the lookup code.

The view exposes exactly three columns, delivering a minimal projection of the lookup dictionary and concentrating only on the average amount type domain.

Common Use Cases and Queries

Because the view encapsulates the PATD_EOD and PTD_YTD filter, it is convenient for populating lookup lists, validating amount-type codes, and joining reporting queries to obtain display meanings without embedding the lookup-type filter repeatedly. A typical retrieval is:

• SELECT AMOUNT_TYPE, SHOW_AMOUNT_TYPE, DESCRIPTION FROM APPS.GL_LOOKUPS_AVG_AMOUNT_TYPES_V ORDER BY AMOUNT_TYPE;

A common integration pattern joins the view to a balances or averages query so that codes are resolved to their meanings:

• SELECT b.amount_type, v.show_amount_type, b.amount FROM ... b, APPS.GL_LOOKUPS_AVG_AMOUNT_TYPES_V v WHERE b.amount_type = v.amount_type;

Underlying data is consistent with the standard GL_LOOKUPS dictionary, so the view reflects lookup maintenance changes in real time. Given the "10SC ONLY" designation, implementers should confirm applicability for their specific localization before relying on it, and should treat it as a read-only integration and reporting convenience rather than a seeded configuration source.