Search Results inactive_flag




Overview
Explore in AI Chat

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:

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.