Results for “rebuild_serial_number”

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

Overview

APPS.EAM_REBUILD_COMPLETION_JOBS_V is a reporting view in the Oracle E-Business Suite Enterprise Asset Management module. It presents rebuild work order completion data for discrete rebuild jobs — that is, work orders created to refurbish or rebuild a rotable or repairable asset item back into serviceable condition. The view exposes the rebuild work order alongside its parent work order, rebuild item, serial number, scheduling dates, completion inventory details, and project/task references, allowing users to report on rebuild activity without joining the underlying Work in Process tables manually.

Because rebuild jobs are modeled as discrete jobs with a rebuild-specific item reference and a parent WIP entity, this view is the standard access point for questions involving "parent_wip_entity_id" — the foreign key relationship linking a rebuild work order to the parent repair or refurbishment work order. The view filters to rebuild jobs only, so consumers do not need to apply the same predicates themselves.

The view is owned by APPS, has a status of VALID, and is documented in ETRM for both 12.1.1 and 12.2.2. It is read-only and intended for query and reporting use rather than transactional updates.

Underlying Base Objects

The view is defined over two synonyms to base objects:

• WIP_DISCRETE_JOBS (WDJ) — the driving table. It supplies rebuild-specific attributes (REBUILD_ITEM_ID, REBUILD_SERIAL_NUMBER, ASSET_NUMBER, ASSET_GROUP_ID, MANUAL_REBUILD_FLAG, PARENT_WIP_ENTITY_ID, and completion inventory fields).
• WIP_ENTITIES (WE1) — joined on WDJ.WIP_ENTITY_ID = WE1.WIP_ENTITY_ID to retrieve the rebuild work order name.
• WIP_ENTITIES (WE2) — an outer join on WDJ.PARENT_WIP_ENTITY_ID = WE2.WIP_ENTITY_ID(+) to retrieve the parent work order name.

Two filter predicates are applied in the view definition: WE1.ENTITY_TYPE = 6 (the EAM rebuild entity type) and WDJ.REBUILD_ITEM_ID IS NOT NULL, with STATUS_TYPE restricted to values 3 and 4 (released/unreleased discrete job statuses). The outer join on WE2 means a rebuild job with no parent still appears, with PARENT_WORK_ORDER as NULL.

Key Columns

• WORK_ORDER — the WIP_ENTITY_NAME of the rebuild job.
• WIP_ENTITY_ID — unique identifier of the rebuild discrete job.
• PARENT_WIP_ENTITY_ID — identifier of the parent work order; the key link for hierarchical rebuild reporting.
• PARENT_WORK_ORDER — the name of the parent entity, resolved from WIP_ENTITIES via the outer join.
• REBUILD_ITEM_ID / REBUILD_SERIAL_NUMBER — the asset item being rebuilt and its serial number.
• REBUILD_ACTIVITY_ID — aliases WDJ.PRIMARY_ITEM_ID.
• SCHEDULED_START_DATE / SCHEDULED_COMPLETION_DATE / DURATION1 — scheduling information, with DURATION1 computed as the difference between the two dates.
• ASSET_NUMBER, ASSET_GROUP_ID, ACTIVITY_TYPE, MANUAL_REBUILD_FLAG, STATUS_TYPE — asset and control attributes of the rebuild.
• COMPLETION_SUBINVENTORY, COMPLETION_LOCATOR_ID, LOT_NUMBER — where completed rebuilt material is received.
• PROJECT_ID, TASK_ID, ORGANIZATION_ID — project accounting and inventory organization context.

Common Use Cases and Queries

Typical scenarios include listing all rebuild work orders for a parent, monitoring scheduled versus actual completion windows, and reporting completed rebuilds by asset or organization.

• Find all rebuild jobs belonging to a given parent: SELECT work_order, parent_work_order, rebuild_serial_number FROM eam_rebuild_completion_jobs_v WHERE parent_wip_entity_id = :parent_id;
• List rebuilt assets in an organization: SELECT work_order, asset_number, rebuild_item_id, scheduled_completion_date FROM eam_rebuild_completion_jobs_v WHERE organization_id = :org_id;
• Report rebuild duration by project: SELECT work_order, duration1, project_id, task_id FROM eam_rebuild_completion_jobs_v WHERE project_id IS NOT NULL;
• Identify rebuild jobs with completion inventory targets: SELECT work_order, completion_subinventory, completion_locator_id FROM eam_rebuild_completion_jobs_v WHERE completion_subinventory IS NOT NULL;

By joining on PARENT_WIP_ENTITY_ID, users can reconstruct the rebuild hierarchy and reconcile child rebuild activities against parent work orders without writing the WIP_DISCRETE_JOBS join logic themselves.