Search Results ahl_spaces_b




Overview
Explore in AI Chat

Overview

The AHL_SPACES_B table is a core data object within the Oracle E-Business Suite (EBS) module for Complex Maintenance, Repair, and Overhaul (AHL). It serves as the primary base table for storing the master definition of physical or logical spaces within a maintenance facility. In the context of MRO operations, a "space" represents a designated area such as a hangar bay, workshop, inspection station, or storage room that is managed for scheduling maintenance tasks, assigning resources, and tracking availability. This table is essential for enabling capacity planning, resource allocation, and constraint management in complex service environments.

Key Information Stored

While the provided metadata does not list specific columns, the structure of Oracle EBS base tables and the existence of a corresponding translation table (AHL_SPACES_TL) allow for inference of key attributes. The primary identifier, SPACE_ID, is the unique key for each space record. Typical columns in such a base table would include descriptive fields like SPACE_NUMBER or NAME, internal identifiers such as ORGANIZATION_ID to link to the inventory organization, and classification codes. It would also contain standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and OBJECT_VERSION_NUMBER for data integrity and concurrency control. The detailed, language-specific description of the space is stored in the related AHL_SPACES_TL table.

Common Use Cases and Queries

This table is central to queries supporting operational and analytical reporting in MRO. Common use cases include generating lists of all available spaces within a specific organization for capacity dashboards, identifying spaces assigned to a particular work order or visit for task scheduling, and determining spaces with specific capabilities for specialized maintenance work. A typical query would join AHL_SPACES_B with its translation table to retrieve user-friendly names and filter based on organizational context.

SELECT aspb.SPACE_ID,
       astl.NAME,
       aspb.SPACE_NUMBER,
       aspb.ORGANIZATION_ID
FROM AHL.AHL_SPACES_B aspb,
     AHL.AHL_SPACES_TL astl
WHERE aspb.SPACE_ID = astl.SPACE_ID
  AND astl.LANGUAGE = USERENV('LANG')
  AND aspb.ORGANIZATION_ID = :p_org_id;

Related Objects

The AHL_SPACES_B table has defined foreign key relationships with several other critical AHL tables, establishing it as a central hub for space-related data. The documented relationships are:

  • AHL_SPACES_TL: Stores translated names and descriptions. Joined via AHL_SPACES_TL.SPACE_ID = AHL_SPACES_B.SPACE_ID.
  • AHL_SPACE_ASSIGNMENTS: Links spaces to specific maintenance work orders, visits, or tasks. Joined via AHL_SPACE_ASSIGNMENTS.SPACE_ID = AHL_SPACES_B.SPACE_ID.
  • AHL_SPACE_CAPABILITIES: Defines the specific functions, equipment, or certifications associated with a space. Joined via AHL_SPACE_CAPABILITIES.SPACE_ID = AHL_SPACES_B.SPACE_ID.
  • AHL_SPACE_UNAVAILABLE_B: Records periods when a space is out of service for maintenance or other reasons, critical for scheduling. Joined via AHL_SPACE_UNAVAILABLE_B.SPACE_ID = AHL_SPACES_B.SPACE_ID.