Results for “eam_cfr_work_order_v”

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

Overview

APPS.EAM_CFR_WORK_ORDER_V is a reporting view in the Oracle E-Business Suite Enterprise Asset Management (EAM) module. It presents a consolidated, denormalized record set describing maintenance work orders, drawing primarily from the EAM work order detail and WIP discrete job structures. The view is documented as a VALID object owned by the APPS schema and is used for ERES (Electronic Records and Electronic Signatures) processing at the time of work order completion in the XGM environment. In practice, this makes the view a controlled read interface: downstream completion and signature workflows depend on its columns to capture the state, classification, and status of a work order at the moment it is closed out.

Underlying Base Objects

The ETRM 12.2.2 metadata lists the following referenced objects for this view: BOM_DEPARTMENTS, CSI_COUNTERS_TL, CSI_ITEM_INSTANCES, EAM_ASSET_STATUS_HISTORY, EAM_COMMON_UTILITIES_PVT, EAM_WORK_ORDER_DETAILS, EAM_WO_STATUSES_V, FND_MESSAGE, MFG_LOOKUPS, MTL_PARAMETERS, MTL_SYSTEM_ITEMS_KFV, PJM_PROJECT, PN_LOCATIONS_ALL, WIP_DISCRETE_JOBS, WIP_ENTITIES, and WIP_SCHEDULE_GROUPS, most resolved through synonyms.

EAM_WORK_ORDER_DETAILS supplies the core work order attributes, while WIP_ENTITIES and WIP_DISCRETE_JOBS provide the WIP entity identity, name, and entity type. Item and asset context arrives through MTL_SYSTEM_ITEMS_KFV and CSI_ITEM_INSTANCES, with CSI_COUNTERS_TL supporting asset numbering. Organizational context is supplied by MTL_PARAMETERS and BOM_DEPARTMENTS, and status history is sourced from EAM_ASSET_STATUS_HISTORY and EAM_WO_STATUSES_V. Notably, MFG_LOOKUPS is referenced as a VIEW and is the lookup source for the numerous meaning columns in the definition, used here for status, type, priority, and flag decoding rather than for transaction validation.

Key Columns

• Identity: WIP_ENTITY_ID, WIP_ENTITY_NAME, ENTITY_TYPE, and ORGANIZATION_ID identify the maintenance work order and its operating organization.
• Asset context: ASSET_GROUP_ID (derived using NVL of ASSET_GROUP_ID and REBUILD_ITEM_ID), ASSET_GROUP, INSTANCE_ID, ASSET_NUMBER, ASSET_SERIAL_NUMBER, EAM_ITEM_TYPE, and ASSET_TYPE_DISP describe the asset or rebuild item being maintained.
• Activity and classification: ASSET_ACTIVITY_ID, ASSET_ACTIVITY, CLASS_CODE, STATUS_TYPE and STATUS_TYPE_DISP, WORK_ORDER_TYPE and WORK_ORDER_TYPE_DISP, ACTIVITY_TYPE, ACTIVITY_CAUSE, and PRIORITY, each with a lookup-driven display column.
• Accounting: MATERIAL_ACCOUNT, RESOURCE_ACCOUNT, OVERHEAD_ACCOUNT, and the corresponding variance and standard cost adjustment accounts.
• Dates and workflow: SCHEDULED_START_DATE, SCHEDULED_COMPLETION_DATE, DATE_RELEASED, DATE_COMPLETED, DATE_CLOSED, REQUESTED_START_DATE, and DUE_DATE, plus ESTIMATION_STATUS, NOTIFICATION_REQUIRED, SHUTDOWN_TYPE, and TAGOUT_REQUIRED flags.

Common Use Cases and Queries

Because the view decodes lookup values into display meanings, it is well suited to work order completion reporting, ERES audit review, and status tracking without requiring joins to MFG_LOOKUPS by the caller.

• List completed work orders for an organization:
  SELECT wip_entity_name, work_order_type_disp, status_type_disp, date_completed FROM eam_cfr_work_order_v WHERE organization_id = :org AND date_completed IS NOT NULL;
• Retrieve work orders still open and past due:
  SELECT wip_entity_name, due_date, priority_disp FROM eam_cfr_work_order_v WHERE date_closed IS NULL AND due_date < SYSDATE;
• Report asset-level activity for a specific instance:
  SELECT asset_number, asset_activity, activity_type_disp FROM eam_cfr_work_order_v WHERE instance_id = :instance_id;

Consumers should treat this view as read-only and avoid relying on undocumented columns or ordering, since its definition is governed by EAM completion and ERES requirements.