Search Results rebuild_item_id




Overview
Explore in AI Chat

Overview

APPS.WIP_EAM_WO_SRV_ASSOC_V is a reporting view in Oracle E-Business Suite (12.1.1 and 12.2.2) that consolidates Enterprise Asset Management (EAM) work order information with the service requests associated with those work orders. It joins the work order definition in WIP_DISCRETE_JOBS and WIP_ENTITIES to the maintenance asset, activity, department, priority, and instance data, and it links each work order to an external service request through EAM_WO_SERVICE_ASSOCIATION. The view is commonly used in maintenance dashboards, work order status reports, and integrations that require the relationship between a work order and its originating service request.

The view is read-only and is not a substitute for the base maintenance tables. It is intended for query, reporting, and interface extraction, not for transactional inserts or updates.

Underlying Base Objects

The view is defined over the following documented base objects:

  • WIP_DISCRETE_JOBS — the core work order record, supplying scheduling, status, priority, asset, and completion data.
  • WIP_ENTITIES — provides the work order name and organization context.
  • EAM_WO_SERVICE_ASSOCIATION — the link table between the work order and its external service request; only rows with a null or 'Y' enable_flag are included.
  • EAM_WORK_ORDER_DETAILS_V — supplies the user-defined work order status and status identifier.
  • MTL_SYSTEM_ITEMS_B_KFV — joined twice, once for the asset group (nvl(asset_group_id, rebuild_item_id)) and once for the activity item.
  • MTL_PARAMETERS — joined for the work order organization and the maintenance organization.
  • CSI_ITEM_INSTANCES — supplies the installed asset instance number.
  • BOM_DEPARTMENTS — supplies the department code for the owning department.
  • MFG_LOOKUPS — used three times for priority meaning, asset type meaning, and status lookup context.

The view also references the FND_MESSAGE package in its full definition. Because the join to the asset group uses nvl(asset_group_id, rebuild_item_id), the rebuild_item_id column from WIP_DISCRETE_JOBS is a first-class component of the view's key join predicate. This is the column most often sought when users search for "rebuild_item_id" against this view.

Key Columns

  • work_order_name — the WIP entity name of the work order.
  • status — the displayed work order status.
  • inventory_item_id — defined as nvl(wdj.asset_group_id, rebuild_item_id); when the asset group is null, the rebuild item is returned. This is the column most directly tied to "rebuild_item_id".
  • activity_id — the primary item of the work order.
  • asset_group, asset_number, asset_type — the maintenance asset grouping, instance number, and asset type meaning.
  • firm_flag — decoded from firm_planned_flag as 'Y' or 'N'.
  • priority — the priority lookup meaning.
  • department_id, department_code — the owning department.
  • service_request_id — the associated external service request.
  • requested_start_date, due_date, scheduled_start_date, scheduled_completion_date, actual_start_date, actual_end_date, date_completed, date_closed, date_released — the scheduling and completion timeline.
  • duration — elapsed scheduled hours, computed as scheduled_completion_date minus scheduled_start_date multiplied by 24, truncated to two decimals.
  • organization_code, organization_id, wip_entity_id, status_id, priority_id — identifiers used for filtering and joining.

Common Use Cases and Queries

The view is typically queried to report on open EAM work orders, to reconcile work orders with service requests, or to extract work order details for downstream systems. Because inventory_item_id resolves to rebuild_item_id when no asset group is assigned, queries involving rebuild items can be written against the view without inspecting WIP_DISCRETE_JOBS directly.

A representative query retrieving work orders that resolve to a rebuild item is:

SELECT work_order_name, status, asset_group, asset_number, activity, priority, firm_flag, scheduled_start_date, scheduled_completion_date, duration FROM apps.wip_eam_wo_srv_assoc_v WHERE inventory_item_id = :rebuild_item_id AND organization_code = :org;

To report work orders linked to service requests:

SELECT work_order_name, service_request_id, status, due_date FROM apps.wip_eam_wo_srv_assoc_v WHERE service_request_id IS NOT NULL ORDER BY due_date;

Because the view applies ONLY the enable_flag filter on EAM_WO_SERVICE_ASSOCIATION and performs several outer joins, callers should apply their own organization and date predicates for performance, and should not assume that every work order has a service request, asset group, or department.