Results for “ahl_spaces_vl”

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

Overview

AHL_SPACES_VL is a translation-enabled (VL) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AHL product family — Complex Maintenance Repair and Overhaul (CMRO). The view presents space definitions used within the AHL simulation and maintenance planning model, exposing the descriptive, translatable attributes of a space alongside its non-translatable definitional attributes. It follows the standard Oracle EBS multilingual ("_VL") view pattern: a join between a "base" table holding language-independent columns and a "translation" table holding the language-dependent descriptive column, filtered by the session language.

The view is documented as VALID in both the 12.1.1 and 12.2.2 releases and appears in the ETRM (E-Business Suite Technical Reference Manual) metadata for the AHL module. Its role in the EBS architecture is that of a reporting and integration surface: it shields report writers, OAF/ADF-based pages, and external integrations from having to perform the base/translation join themselves, and it enforces session-language filtering automatically through USERENV('LANG').

Underlying Base Objects

The view is defined over two documented base objects, exposed to APPS through synonyms:

• AHL_SPACES_B — the base table holding language-independent columns, including the primary key SPACE_ID, WHO/audit columns, the foreign key BOM_DEPARTMENT_ID, the discriminator SPACE_CATEGORY, ORGANIZATION_ID, INACTIVE_FLAG, OBJECT_VERSION_NUMBER, and the 15 developer extensibility (DDF) attribute columns.
• AHL_SPACES_TL — the translation table holding language-dependent columns, principally SPACE_NAME, keyed by SPACE_ID and LANGUAGE.

The join condition is B.SPACE_ID = T.SPACE_ID AND T.LANGUAGE = USERENV('LANG'). Because the base table supplies a ROWID, the view publishes ROW_ID as the first column, enabling row-based identification consistent with other EBS _VL views. The ETRM description for the view text references AHL_SIMULATION_PLANS_B and AHL_SIMULATION_PLANS_TL; this appears to be a documentation artifact in the source metadata, since the actual view definition and referenced base objects are AHL_SPACES_B and AHL_SPACES_TL.

Key Columns

• ROW_ID — ROWID of the underlying AHL_SPACES_B row; useful for row-level identification and for some update operations.
• SPACE_ID — primary key of the space, joining the _B and _TL tables.
• SPACE_NAME — translatable descriptive name of the space, sourced from AHL_SPACES_TL and returned in the session language.
• SPACE_CATEGORY — classification of the space, used to group or filter space types in maintenance planning.
• BOM_DEPARTMENT_ID — foreign key to the department associated with the space for bill-of-material and routing purposes.
• ORGANIZATION_ID — the inventory/operating organization to which the space belongs; critical for multi-org (MOAC) filtering.
• INACTIVE_FLAG — enabled/disabled indicator; inactive spaces should be excluded from active planning queries.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF framework.
• WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) — standard audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — DDF flexfield columns carrying customer-defined attributes.

Common Use Cases and Queries

The view is typically queried to list or validate spaces in AHL maintenance and simulation reporting, and as a lookup source for integration extracts. A representative query returning active spaces in the current language is:

• SELECT space_id, space_name, space_category, organization_id FROM apps.ahl_spaces_vl WHERE inactive_flag = 'N' ORDER BY space_name;
• SELECT s.space_id, s.space_name, s.bom_department_id FROM apps.ahl_spaces_vl s WHERE s.organization_id = :p_org_id AND s.space_category = :p_category;
• SELECT s.space_name, s.object_version_number, s.last_update_date FROM apps.ahl_spaces_vl s WHERE s.space_id = :p_space_id;

Because the view applies USERENV('LANG') filtering, callers must ensure the session language is initialized (as in a standard EBS session) to obtain the correct SPACE_NAME; in tools where NLS_LANG is not set correctly, the translation row may not be returned. For MOAC-aware queries, ORGANIZATION_ID should always be constrained. Additional joins to AHL_SPACES_B can be made directly when language-independent columns not exposed here are required, or when working with DFF attribute values beyond ATTRIBUTE15.