Search Results res_code

Overview

EAM_RESOURCES_V is a read-only Oracle EBS view owned by the APPS schema in the Enterprise Asset Management (EAM) module. It presents all resources associated with a work order, deriving its data from the work order estimate detail table CST_EAM_WO_ESTIMATE_DETAILS. The view is used primarily for reporting, cost analysis, and integration queries that require a consolidated, human-readable list of the labor and equipment resources estimated against an EAM work order. Because it resolves surrogate identifiers into descriptive codes, it is well suited for operational reporting and for feeding downstream systems without requiring callers to reconstruct the joins themselves.

The view is particularly relevant to users searching on the resource code, exposed as the column RES_CODE, which returns the value of the underlying BOM_RESOURCES.RESOURCE_CODE. This makes EAM_RESOURCES_V a natural entry point for enquiries that start from a known resource and work back to the affected work orders and departments.

Underlying Base Objects

The view is defined over several base objects documented in the ETRM metadata. The driving table is CST_EAM_WO_ESTIMATE_DETAILS (EED), which holds the estimated resource usage, rate, and unit of measure for each work order operation. It is joined to BOM_RESOURCES (BR) on RESOURCE_ID, supplying the resource code, and to BOM_DEPARTMENTS (BD) on ORGANIZATION_ID and DEPARTMENT_ID, supplying the department code. The remaining joins differ between the two UNION branches.

The first branch joins BOM_RESOURCE_EMPLOYEES (BRE) using an outer join on both RESOURCE_ID and RESOURCE_INSTANCE_ID, and filters BR.RESOURCE_TYPE = 2, thereby restricting the result to employee-type resources. The second branch substitutes BOM_RESOURCE_EQUIPMENTS (BRE) with the same outer-join pattern and filters BR.RESOURCE_TYPE = 1, restricting results to equipment-type resources. The use of outer joins on the employee and equipment tables ensures that resources without an assigned instance are still returned. The ETRM documentation also lists MFG_LOOKUPS and WIP_OPERATION_RESOURCES among the referenced base objects for the 12.2.2 release.

Key Columns

• WIP_ENTITY_ID — Identifier of the work order with which the estimated resource is associated.
• ORGANIZATION_ID — Inventory organization in which the work order and department reside.
• OPERATIONS_DEPT_ID and OPERATION_DEPT_CODE — Identifier and descriptive code of the department performing the operation.
• OPERATIONS_SEQ_NUM — Sequence number of the operation on the work order routing.
• RES_CODE — The resource code from BOM_RESOURCES; distinguishes individual employees or pieces of equipment used on the operation.
• RESOURCE_RATE — Cost rate applied to the resource for estimation purposes.
• UOM — Unit of measure in which the resource usage is expressed, such as hours.
• RESOURCE_USAGE — Quantity of the resource estimated for the operation.
• TOTAL_RESOURCE_COST — Computed as RESOURCE_RATE multiplied by RESOURCE_USAGE, giving the extended estimated cost of the resource.

Common Use Cases and Queries

Typical uses include reviewing estimated labour and equipment costs for a work order, reconciling estimates against actual resource charges, and reporting resource consumption by department. A frequent pattern is to search by resource code, for example:

SELECT wip_entity_id, organization_id, operation_dept_code, operations_seq_num, res_code, resource_rate, uom, resource_usage, total_resource_cost FROM apps.eam_resources_v WHERE res_code = :res_code ORDER BY wip_entity_id, operations_seq_num;

To summarise estimated cost by work order:

SELECT wip_entity_id, SUM(total_resource_cost) estimated_cost FROM apps.eam_resources_v GROUP BY wip_entity_id;

Because the view resolves department and resource identifiers into codes, it can also be used directly in custom concurrent programs and interfaces without additional lookups. Note that it exposes only estimated resources from CST_EAM_WO_ESTIMATE_DETAILS and does not include actual transaction charges; those must be sourced from the work in process and costing tables.