Results for “ahl_user_statuses_v”
22 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The AHL_USER_STATUSES_V view is a denormalized reporting object owned by the APPS schema within the Oracle E-Business Suite (EBS) environment, specifically supporting the AHL product — Complex Maintenance Repair and Overhaul. Its primary function is to store and present user status information alongside the associated lookup type and meaning. While user status definitions are persisted in base tables, this view enriches those records by resolving human-readable descriptions for the underlying lookup codes, which is essential for operational reporting and integration.
In EBS 12.1.1 and 12.2.2, the view is documented as VALID and serves as a critical data source for front-end forms, concurrent programs, and custom reports. Because many of the view's columns derive from foundational lookup tables, it promotes consistency in how status codes are displayed across different AHL modules.
Underlying Base Objects
The view is defined over three referenced base views, as documented in the ETRM metadata:
- AHL_USER_STATUSES_VL — Supplies the core user status attributes such as USER_STATUS_ID, NAME, DESCRIPTION, and date ranges. The "VL" suffix indicates it is a validated view, likely providing translated columns as well.
- FND_LOOKUP_TYPES_VL — Joined on the SYSTEM_STATUS_TYPE column to provide the MEANING of the lookup type.
- FND_LOOKUP_VALUES_VL — Joined on both SYSTEM_STATUS_TYPE and SYSTEM_STATUS_CODE to provide the CODE_MEANING of the lookup code.
These joins hinge on the condition that the SYSTEM_STATUS_TYPE equals both the LOOKUP_TYPE in the lookup types view and the LOOKUP_TYPE in the lookup values view, while SYSTEM_STATUS_CODE matches the LOOKUP_CODE. This effectively maps internal status codes to their descriptive meanings.
Key Columns
The view exposes a comprehensive set of columns:
- USER_STATUS_ID — Primary identifier for the user status record.
- OBJECT_VERSION_NUMBER — Used for optimistic locking and concurrency control.
- SYSTEM_STATUS_TYPE — The lookup type that categorizes the status.
- SYSTEM_STATUS_CODE — The actual lookup code representing the status.
- ACTIVE_FLAG, DEFAULT_FLAG, SEEDED_FLAG — Flags indicating whether the status is active, the default for its type, or seeded by Oracle.
- START_DATE_ACTIVE, END_DATE_ACTIVE — Effective date range for the status.
- NAME, DESCRIPTION — User-facing name and description of the status.
- MEANING — The meaning of the system status type (from FND_LOOKUP_TYPES_VL).
- CODE_MEANING — The meaning of the system status code (from FND_LOOKUP_VALUES_VL). This column is particularly relevant for the search term "code_meaning" and provides a translated, user-friendly label for the status code.
Common Use Cases and Queries
This view is typically queried to populate LOVs (List of Values), report headers, or integration payloads where the lookup code alone is insufficient. For example, a query to retrieve all active user statuses with their meanings:
SELECT user_status_id, name, system_status_type, code_meaning FROM ahl_user_statuses_v WHERE active_flag = 'Y';
Another scenario involves filtering by a specific status type to display valid statuses in a custom form:
SELECT code_meaning, name FROM ahl_user_statuses_v WHERE system_status_type = 'AHL_STATUS_TYPE' AND active_flag = 'Y' ORDER BY code_meaning;
Because the view joins to FND lookup tables, it automatically respects language translations for the MEANING and CODE_MEANING columns, making it suitable for multilingual deployments. Database administrators and developers should note that the view is read-only and inherits the performance characteristics of its underlying views; appropriate indexes on the base tables are essential for high-volume queries.
-
View: AHL_USER_STATUSES_V 12.2.2
This view stores user status information along with lookup type and meaning
APPS.AHL_USER_STATUSES_V·↳ AHL_USER_STATUSES_VL·↳ FND_LOOKUP_TYPES_VL·↳ FND_LOOKUP_VALUES_VL·Explore AHL module →
-
View: AHL_USER_STATUSES_V 12.1.1
This view stores user status information along with lookup type and meaning
APPS.AHL_USER_STATUSES_V·↳ AHL_USER_STATUSES_VL·↳ FND_LOOKUP_TYPES_VL·↳ FND_LOOKUP_VALUES_VL·Explore AHL module →
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - AHL Tables and Views 12.1.1
Ahl Production Workorder Operations Information stored in this table
-
eTRM - AHL Tables and Views 12.2.2
Ahl Production Workorder Operations Information stored in this table
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - FND Tables and Views 12.1.1
No longer used
-
eTRM - AHL Tables and Views 12.1.1
Ahl Production Workorder Operations Information stored in this table
-
eTRM - AHL Tables and Views 12.2.2
Ahl Production Workorder Operations Information stored in this table
-
eTRM - FND Tables and Views 12.1.1
No longer used