Results for “ahl_resources_v”

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

Overview

AHL_RESOURCES_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It belongs to the AHL product family, Complex Maintenance Repair and Overhaul (CMRO), and is documented in the ETRM reference for both release 12.1.1 and 12.2.2. The view presents a denormalized, report-friendly projection of the AHL_RESOURCES base entity. In CMRO, a resource represents a maintainable asset, tool, or piece of equipment that can be associated with maintenance work, work orders, and routings. The base table stores resource rows with raw lookup codes for resource type, while the view resolves those codes into human-readable meanings.

Because the view exposes a stable, well-formed column list, it is the preferred source for concurrent programs, Oracle Reports, BI Publisher data models, and inbound/outbound integration interfaces that need descriptive resource data without performing their own lookup joins. Its status is VALID, indicating it is a supported and compiled object in the APPS schema.

Underlying Base Objects

Per the documented view text, AHL_RESOURCES_V is defined over exactly two referenced objects. The first is AHL_RESOURCES, exposed in the database as a SYNONYM under the APPS schema. This is the primary or driving table and supplies all resource attributes, including identifier, name, description, audit columns, and the eleven or more descriptive flexfield attribute columns. The second is MFG_LOOKUPS, referenced as a VIEW. This is the Oracle Manufacturing common lookup view that the application uses across Oracle Bills of Material and related products.

The join is an equi-join restricted by two predicates: MFG.LOOKUP_TYPE = 'BOM_RESOURCE_TYPE' and MFG.LOOKUP_CODE = R.RESOURCE_TYPE_ID. In other words, the view joins the resource record to the BOM_RESOURCE_TYPE lookup set to translate the stored lookup code into its meaning. Because the join is written as an inner join in the WHERE clause, resources whose RESOURCE_TYPE_ID does not resolve to an enabled, matching BOM_RESOURCE_TYPE lookup row will not appear in the view result set.

Key Columns

• RESOURCE_ID — Primary identifier of the resource; the key used by downstream CMRO maintenance and work order entities.
• OBJECT_VERSION_NUMBER — Optimistic locking token used by the Applications Framework (OAF) and concurrent update control.
• NAME — Business name of the resource.
• RESOURCE_TYPE_ID — Stored lookup code for the resource type, carried through from the base table.
• RESOURCE_TYPE — The lookup meaning derived from MFG_LOOKUPS.MEANING, providing the readable resource type label.
• DESCRIPTION — Free-text description of the resource.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield (DFF) context and segment columns.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit and "who" columns for row-level traceability.

Common Use Cases and Queries

Typical uses include listing maintainable resources by type for a maintenance planner, validating resource references during data migration, and driving drop-down lists in custom forms. The following query returns all active resource records with their resolved type meaning:

• SELECT resource_id, name, resource_type, description FROM apps.ahl_resources_v ORDER BY name;
• SELECT resource_type, COUNT(*) FROM apps.ahl_resources_v GROUP BY resource_type;
• SELECT resource_id, name FROM apps.ahl_resources_v WHERE resource_type = :p_type AND name LIKE :p_name;

For integrations, the view should be accessed from the APPS schema context. Note that a LEFT OUTER JOIN to AHL_RESOURCES directly may be required if orphaned resources lacking a matching BOM_RESOURCE_TYPE lookup must be reported.