Results for “alternate_resource_id”

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

Overview

The AHL_ALTERNATE_RESOURCES_V view is a reporting and integration artifact within the Oracle E-Business Suite (EBS) Complex Maintenance Repair and Overhaul (AHL) product family, owned by the APPS schema. It exposes alternate resource definitions maintained for maintenance and repair operations, joining the base alternate-resource records to the master resource catalog so that descriptive attributes such as resource name and description are available without an additional lookup. In EBS 12.1.1 and 12.2.2 the view is created as a standard APPS-owned, VALID database object and is typically consumed by concurrent programs, OBIEE/BIP extracts, forms, and custom reporting rather than being maintained directly. Its role is to flatten the parent-child relationship between an operational resource assignment and the alternative resources that may substitute for it, thereby simplifying SQL for downstream consumers.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, the view is defined over two referenced objects, both exposed as synonyms to the APPS schema:

• AHL_ALTERNATE_RESOURCES (aliased R) — the driving table holding one row per alternate resource assignment, including the priority ordering and the DFF attribute columns.
• AHL_RESOURCES (aliased AR) — the master resource catalog supplying RESOURCE_TYPE_ID, NAME, and DESCRIPTION.

The join condition is R.ASO_RESOURCE_ID = AR.RESOURCE_ID, linking each alternate-resource row to its corresponding catalog resource. The view performs a simple inner join and does not restrict rows by date or status, so all defined alternates are returned.

Key Columns

• ALTERNATE_RESOURCE_ID — primary key of the alternate resource record.
• OBJECT_VERSION_NUMBER — optimistic locking version, used by the AHL forms framework.
• RT_OPER_RESOURCE_ID — the operational resource (from the routing/operations context) for which alternatives are defined.
• ASO_RESOURCE_ID — foreign key to the resource in AHL_RESOURCES.RESOURCE_ID.
• RESOURCE_TYPE_ID, NAME, DESCRIPTION — descriptive attributes sourced from the resource master, providing human-readable identification.
• PRIORITY — the ordering applied when substituting alternates, determining which resource is selected first.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle descriptive flexfield columns for customer-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard WHO audit columns.

Common Use Cases and Queries

Typical uses include reporting available alternate resources for a given operational resource, driving substitution logic in scheduling, and feeding integration extracts. A representative query follows:

• SELECT aso_resource_id, name, description, priority FROM apps.ahl_alternate_resources_v WHERE rt_oper_resource_id = :oper_res_id ORDER BY priority;
• SELECT v.name, v.priority, v.attribute1 FROM apps.ahl_alternate_resources_v v WHERE v.resource_type_id = :type_id AND NVL(v.priority, 0) > 0;
• SELECT v.alternate_resource_id, v.name FROM apps.ahl_alternate_resources_v v WHERE v.last_update_date >= :since;

Because the view is read-only and owned by APPS, customizations should be limited to queries and integrations; business rule changes belong in the underlying AHL_ALTERNATE_RESOURCES table through supported AHL functionality. Accessing the view avoids duplicating the join to AHL_RESOURCES and ensures name and description remain consistent with the resource catalog.