Results for “ahl_pp_resource_type”

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

Overview

APPS.AHL_PP_RESRC_REQ_ASG_V is a reporting view in the Oracle E-Business Suite Enterprise Asset Management (EAM) and Discrete Manufacturing (BOM) schemas. It presents the resource assignments required at the operation level of an enterprise work order. The view reconciles ordered manufacturing resources held in BOM_RESOURCES and BOM_DEPARTMENT_RESOURCES with the resource mapping and operation-resource associations maintained in the AHL (Complex Maintenance, Repair, and Overhaul) tables. Its principal role is to expose, in a single relational structure, which resources are required for a given work order and operation, whether those resources are primary or alternate, the priority in which they should be consumed, and the associated units of measure.

The name of the view reflects the underlying AHL lookup type AHL_PP_RESOURCE_TYPE, which the view references through the FND_LOOKUP_VALUES_VL base object. This lookup is the mechanism by which a resource is classified as PRIMARY within the resource-requirement model, and the view uses it to derive the ALT_PRIM_TYPE column shown in the output.

Underlying Base Objects

The documented base objects underlying the view include the following synonyms, views, and packages referenced in the documented metadata: AHL_ALTERNATE_RESOURCES, AHL_RESOURCE_MAPPINGS, AHL_RT_OPER_RESOURCES, AHL_WORKORDERS_V, AHL_WORKORDER_OPERATIONS_V, BOM_DEPARTMENT_RESOURCES, BOM_RESOURCES, FND_LOOKUP_VALUES_VL, MFG_LOOKUPS, and MTL_UNITS_OF_MEASURE. The view is owned by APPS.

In the view text, the core join path links BOM_RESOURCES to BOM_DEPARTMENT_RESOURCES on RESOURCE_ID, then to AHL_RESOURCE_MAPPINGS (BOM_RESOURCE_ID), and from there either directly to AHL_RT_OPER_RESOURCES (for primary resources) or through AHL_ALTERNATE_RESOURCES to AHL_RT_OPER_RESOURCES (for alternates). The work order and operation context is supplied by AHL_WORKORDER_OPERATIONS_V and AHL_WORKORDERS_V, joined on OPERATION_ID and WORKORDER_ID respectively. Lookups are resolved through outer joins to FND_LOOKUP_VALUES_VL and MFG_LOOKUPS, and unit-of-measure descriptors are resolved through MTL_UNITS_OF_MEASURE. The two branches of the view are combined with a UNION ALL to present primary and alternate resource assignments on a single row-per-resource basis.

Key Columns

• RESOURCE_CODE — the BOM resource code (from BOM_RESOURCES), the primary human-readable identifier of the resource.
• ALT_PRIM_TYPE — the meaning derived from the AHL_PP_RESOURCE_TYPE lookup, typically PRIMARY or the alternate classification.
• PRIORITY — a numeric priority for the resource assignment. The primary branch emits a constant 1; the alternate branch emits the priority value from AHL_ALTERNATE_RESOURCES.
• RESOURCE_ID — the surrogate key of the BOM resource, used to relate the view back to BOM base tables.
• DESCRIPTION — the descriptive text of the resource.
• DEPARTMENT_ID — the owning department of the resource assignment (from BOM_DEPARTMENT_RESOURCES).
• WORKORDER_ID / OPERATION_ID / OPERATION_SEQUENCE_NUM — the work order, operation, and sequence context in which the resource is required.
• RESOURCE_TYPE_CODE / RESOURCE_TYPE_NAME — the BOM resource type lookup code and its meaning (from MFG_LOOKUPS, type BOM_RESOURCE_TYPE).
• UOM_CODE / UOM_NAME — the unit of measure and its descriptive name.

Common Use Cases and Queries

The view is typically used to report the resource requirements associated with work order operations, to distinguish primary from alternate resources, and to feed integration or scheduling logic that must know which resource applies to a given operation. A representative query to list the resources assigned to a specific work order operation follows:

SELECT RESOURCE_CODE, ALT_PRIM_TYPE, PRIORITY, RESOURCE_TYPE_NAME, UOM_NAME
FROM APPS.AHL_PP_RESRC_REQ_ASG_V
WHERE WORKORDER_ID = :p_workorder_id
AND OPERATION_ID = :p_operation_id
ORDER BY PRIORITY, OPERATION_SEQUENCE_NUM;

A second common pattern identifies alternate resources available for a work order so that substitutions can be evaluated:

SELECT RESOURCE_CODE, ALT_PRIM_TYPE, PRIORITY, DEPARTMENT_ID
FROM APPS.AHL_PP_RESRC_REQ_ASG_V
WHERE WORKORDER_ID = :p_workorder_id
AND ALT_PRIM_TYPE = 'PRIMARY';

Because the view references HR security, MO_GLOBAL, and related packages through its underlying views, query results are subject to the same organizational and security filters as other EAM and BOM reporting views. Queries should consistently bind WORKORDER_ID and OPERATION_ID to constrain the result set, since the view spans all work orders and operations visible to the querying user.