Search Results ahl_space_unavabl_v




Overview
Explore in AI Chat

Overview

The AHL_SPACE_UNAVABL_V view is an Oracle E-Business Suite application view owned by the APPS schema and defined within the AHL – Complex Maintenance Repair and Overhaul product family. Its purpose, as documented in the ETRM metadata, is to store the query that relates to space restriction information. In practical terms, the view exposes a denormalized, report-ready listing of maintenance spaces together with the specific unavailability (blocked or restricted) periods recorded against them.

The view joins space definitions to their unavailability records, resolves department and organization names from Human Resources and Bills of Material tables, and decodes two lookup-driven attributes into their display meanings. This makes it suitable for operational reporting, availability dashboards, and integration extracts where consumers need to know when a space cannot be used and what category of space it is.

The column STATUS_MEAN — the term frequently searched alongside this object — is the translated meaning of the space status lookup, resolved through FND_LOOKUP_VALUES_VL using the lookup type AHL_LTP_SPACE_STATUS. Rather than reporting the raw stored code, the view delivers a user-readable status label, which is a principal reason the object is queried directly by reporting tools instead of through the base tables.

Underlying Base Objects

The view is defined over five documented base objects, combined through both inner and outer joins:

  • AHL_SPACES_VL (VIEW) — supplies the space definition, including space identifier, name, category, owning department and organization, and the inactive flag used as the status code.
  • AHL_SPACE_UNAVAILABLE_VL (VIEW) — supplies the unavailability record, including the unavailability identifier, start and end dates, and description.
  • BOM_DEPARTMENTS (SYNONYM) — supplies the department description for the owning department.
  • HR_ALL_ORGANIZATION_UNITS (SYNONYM) — supplies the organization name.
  • FND_LOOKUP_VALUES_VL (VIEW) — referenced twice, once for the space category lookup (AHL_LTP_SPACE_CATEGORY) and once for the space status lookup (AHL_LTP_SPACE_STATUS).

The space-to-unavailability relationship is an equi-join on SPACE_ID, so a space appears once for each unavailability record it carries. Department and organization joins link on BOM_DEPARTMENT_ID and ORGANIZATION_ID respectively. Both lookup joins are outer joins, so spaces whose category or status codes have no active lookup value are still returned, with null meanings.

Key Columns

Common Use Cases and Queries

Typical uses include identifying spaces currently unavailable, auditing restriction history per department or organization, and feeding scheduling logic that must exclude blocked spaces. A simple listing of active restrictions by status meaning:

SELECT space_name, status_mean, start_date, end_date
FROM apps.ahl_space_unavabl_v
WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date
ORDER BY org_name, space_name;

A category-based summary demonstrating the STATUS_MEAN decode:

SELECT org_name, space_category_mean, status_mean, COUNT(*)
FROM apps.ahl_space_unavabl_v
GROUP BY org_name, space_category_mean, status_mean;

Because the view already resolves lookup meanings, reports avoid replicating the FND_LOOKUP_VALUES join logic. Consumers should note that multiple rows are returned per space when more than one unavailability record exists, and that the outer lookup joins may yield null meanings for obsolete or unmapped codes.