Results for “status_code”

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

Overview

GL_ENTITY_BUDGETS_V is an APPS-owned database view in Oracle E-Business Suite, classified under the General Ledger (GL) product family. The ETRM metadata identifies its description as "10SC ONLY," indicating that the object was introduced or is functionally relevant only under a specific localization or statutory context (the "10SC" designation). The view exposes budget entity and budget version information drawn from the underlying GL budget entity tables, presenting a denormalized, read-optimized projection that joins entity-level budget rows to their parent budget entity definitions.

Its role in EBS reporting and integration is to provide a stable, queryable interface for consumers that need budget entity metadata without directly joining the base tables. By filtering out deleted budget entities in its defining SQL, the view presents only active definitions, which simplifies downstream reporting logic. The view is defined in schema APPS and carries a STATUS of VALID in the ETRM registry.

Underlying Base Objects

The view is defined over two documented base objects, both accessed through APPS synonyms:

• GL_ENTITY_BUDGETS — aliased as EB; supplies the frozen flag, budget entity and version identifiers, audit columns, and ROWID. This is the primary detail table for budget entity records.
• GL_BUDGET_ENTITIES — aliased as BE; supplies the entity name and status code.

The two objects are joined on BUDGET_ENTITY_ID. The WHERE clause additionally constrains BE.STATUS_CODE <> 'D', so entities marked as deleted are excluded from the result set. The view text carries a standard EBS header comment ($HEADER) referencing the source file GLGVWREG.LDT and a version recorded as 120.16.12010000.5 dated 2009/02/11, consistent with a 12.1.1-era build and carried forward into 12.2.2.

Key Columns

• FROZEN_FLAG — Indicates whether the budget entity is frozen; this is the column most directly associated with the "frozen_flag" search term and governs whether budget activity is locked.
• NAME — The descriptive name of the budget entity from GL_BUDGET_ENTITIES.
• BUDGET_ENTITY_ID — Primary join key linking budget entities to their budget rows.
• BUDGET_VERSION_ID — Identifies the budget version associated with the entity budget record.
• STATUS_CODE — Lifecycle status of the budget entity, with 'D' denoting deletion.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.
• ROW_ID — The ROWID of the base GL_ENTITY_BUDGETS row, exposed for tooling that requires row-level addressing.

Common Use Cases and Queries

Typical scenarios include confirming whether a budget entity is frozen before permitting budget entry, and reporting on active budget entities per version. The following query lists non-frozen entities for a given version:

SELECT name, budget_version_id, frozen_flag
FROM   apps.gl_entity_budgets_v
WHERE  budget_version_id = :version_id
AND    NVL(frozen_flag, 'N') = 'N';

A second common pattern audits frozen entities alongside their status and last update information, supporting governance review of who froze a budget and when. Because the view already excludes deleted entities, queries can omit an explicit deletion filter when querying through the view.