Search Results eam_cfr_issued_serials_v




Overview
Explore in AI Chat

Overview

EAM_CFR_ISSUED_SERIALS_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, classified under the Enterprise Asset Management (EAM) product family. Its documented description is "Work Order Completion Issued Serials." The view consolidates serialized asset issuance data generated when a work order completes and material is issued to or from a work order, joining unit transaction history to item instance records, item master descriptions, and EAM counter (meter) definitions. It is a reporting and integration object rather than a transaction-entry object; it exposes a denormalized, read-consistent projection that downstream reports, dashboards, and interfaces can query without reconstructing the multi-table join themselves.

The name prefix "CFR" reflects its use within the EAM work order completion flow ("Completion / Field Reporting"), where issued unit-tracked (serialized) items must be reconciled against the asset instance registry. The view returns one row per relevant unit transaction, enriched with serial, item, and meter context.

Underlying Base Objects

The view is defined over five referenced base objects, per the ETRM 12.2.2 metadata:

  • MTL_UNIT_TRANSACTIONS (SYNONYM) — the driving transaction table, filtered to TRANSACTION_SOURCE_TYPE_ID = 5 (work in process / WIP work order transactions).
  • CSI_ITEM_INSTANCES (SYNONYM) — supplier of instance-level identity (instance number, serial number, description), joined by serial number, inventory item, and last valid organization.
  • MTL_SYSTEM_ITEMS_KFV (SYNONYM) — the key flexfield value view of the item master, providing concatenated segment identifiers and item descriptions.
  • EAM_COUNTERS_V (VIEW) — the EAM counters (meters) view, joined through the counter association to supply meter name/details; the join is outer ((+)) and restricted to non-template meters (TMPL_FLAG = 'N').
  • CSI_COUNTER_ASSOCIATIONS (SYNONYM) — links an instance to a counter across a validity window, evaluated with SYSDATE BETWEEN NVL(START_DATE_ACTIVE,...) AND NVL(END_DATE_ACTIVE,...) and an outer join ((+)) to the instance.

The two outer joins ensure serials without an active counter association or meter still appear in the result set.

Key Columns

Common Use Cases and Queries

Typical use is to list issued serials per work order, or to report serials against their associated meters for an organization.

  • Issued serials for a work order: SELECT INSTANCE_NUMBER, SERIAL_NUMBER, CONCATENATED_SEGMENTS FROM APPS.EAM_CFR_ISSUED_SERIALS_V WHERE WIP_ENTITY_ID = :wip_entity_id;
  • Meter association report: filter on METER_ID IS NOT NULL and group by ORGANIZATION_ID.
  • Asset history lookups by serial: query on SERIAL_NUMBER or INSTANCE_ID to trace work order issuances for a serialized asset.

Because the view resolves the counter validity window against SYSDATE, results depend on query execution time; historical re-runs may differ if counter association dates change.