Results for “asset_serial_number”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
WIP_EAM_CST_HEADER_V is an Oracle EBS Work in Process (WIP) view owned by the APPS schema. It presents cost header information for Enterprise Asset Management (EAM) work orders, consolidating attributes from discrete job records, work order status details, asset instance data, and estimation status lookups into a single reporting interface. The view is defined as a UNION ALL of two query blocks, allowing it to surface both asset-linked work orders and non-asset (rebuild or standalone) work orders within one result set. Because it exposes status, department, estimation, and asset context together, it is well suited to cost estimation reporting, work order dashboards, and downstream integrations that require a normalized EAM cost header row.
Underlying Base Objects
The view is defined over the following documented base objects:
- WIP_DISCRETE_JOBS (SYNONYM) — primary source of the WIP entity, organization, item, estimation, and asset grouping attributes.
- WIP_ENTITIES (SYNONYM) — supplies the WIP entity name, used here as PARENT_WIP_ENTITY_NAME via an outer join on PARENT_WIP_ENTITY_ID and ORGANIZATION_ID.
- BOM_DEPARTMENTS (SYNONYM) — provides DEPARTMENT_CODE as OWNING_DEPARTMENT, joined on the department ID and organization.
- MFG_LOOKUPS (VIEW) — resolves the estimation status code to its meaning using the lookup type CST_EAM_ESTIMATION_STATUS.
- CSI_ITEM_INSTANCES (SYNONYM) — supplies asset instance attributes such as INSTANCE_NUMBER and SERIAL_NUMBER.
- EAM_WORK_ORDER_DETAILS_V (VIEW) — provides the EAM work order status (JOB_STATUS) and user-defined status identifier.
- FND_MESSAGE (PACKAGE) — referenced for message resolution within the view definition context.
The relationships are enforced through outer joins on WIP_ENTITIES and BOM_DEPARTMENTS, and inner joins on MFG_LOOKUPS, CSI_ITEM_INSTANCES, and EAM_WORK_ORDER_DETAILS_V, ensuring consistent cost header rows for maintained EAM work orders.
Key Columns
- WIP_ENTITY_ID / ORGANIZATION_ID — Unique identifier and operating unit context of the work order.
- USER_DEFINED_STATUS_ID / JOB_STATUS — Status identifiers derived from the EAM work order details view.
- PRIMARY_ITEM_ID — The primary assembly item being built.
- SCHEDULED_COMPLETION_DATE — Planned completion date for the work order.
- ASSET_GROUP_ID — Groups work orders by asset, where applicable.
- ESTIMATION_STATUS / ESTIMATION_STATUS_MEANING — Numeric estimation status and its decoded lookup meaning.
- OWNING_DEPARTMENT — Department code responsible for the work order.
- REBUILD_ITEM_ID — Item identifier for rebuild activities.
- PARENT_WIP_ENTITY_NAME — Name of the parent WIP entity.
- LAST_ESTIMATION_REQ_ID / LAST_ESTIMATION_DATE — Most recent estimation request and its date.
- SERIAL_NUMBER / INSTANCE_NUMBER — Asset instance identifiers exposed through CSI_ITEM_INSTANCES.
Common Use Cases and Queries
The view is typically used to report estimation status across EAM work orders or to feed cost estimation processes. A sample query listing open estimations by department is shown below:
SELECT h.wip_entity_id,
h.organization_id,
h.job_status,
h.estimation_status_meaning,
h.owning_department,
h.scheduled_completion_date,
h.serial_number
FROM apps.wip_eam_cst_header_v h
WHERE h.estimation_status IN (1,2,3)
AND h.organization_id = :org_id
ORDER BY h.scheduled_completion_date;
Typical scenarios include tracking work orders pending estimation, reconciling last estimation dates, reporting asset-linked versus rebuild work orders, and driving dashboards that combine WIP cost headers with asset instance details.
-
View: WIP_EAM_CST_HEADER_V 12.2.2
Cost information for EAM work orders
APPS.WIP_EAM_CST_HEADER_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_WORK_ORDER_DETAILS_V·Explore WIP module →
-
APPS.OKL_BPD_CNTR_LVLNG_SUMRY_UV·↳ CS_COUNTERS·↳ OKC_K_HEADERS_B·↳ OKC_K_ITEMS·Explore OKL module →
-
APPS.OKL_BPD_CNTR_LVLNG_SUMRY_UV·↳ CS_COUNTERS·↳ OKC_K_HEADERS_B·↳ OKC_K_ITEMS·Explore OKL module →
-
APPS.OKL_BPD_CNTR_READING_UV·↳ CS_COUNTERS·↳ MTL_UNITS_OF_MEASURE_TL·↳ OKC_K_HEADERS_B·Explore OKL module →
-
View: EAM_CFR_WORK_ORDER_V 12.2.2
This view displays details of all maintenance work orders.This view is used for ERES at the time of work order completion in the XGM.
APPS.EAM_CFR_WORK_ORDER_V·↳ BOM_DEPARTMENTS·↳ CSI_COUNTERS_TL·↳ CSI_ITEM_INSTANCES·Explore EAM module →
-
View: WIP_EAM_CST_HEADER_V 12.1.1
Cost information for EAM work orders
APPS.WIP_EAM_CST_HEADER_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_WORK_ORDER_DETAILS_V·Explore WIP module →
-
View: EAM_WORK_ORDERS_V 12.2.2
View shows all maintenance work orders along with the work requests/service requests associated to them.
APPS.EAM_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ CS_INCIDENTS_B_SEC·Explore EAM module →
-
APPS.OKL_BPD_CNTR_READING_UV·↳ CS_COUNTERS·↳ MTL_UNITS_OF_MEASURE_TL·↳ OKC_K_HEADERS_B·Explore OKL module →
-
View: WIP_EAM_ENTITIES_V 12.2.2
EAM work order information
APPS.WIP_EAM_ENTITIES_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_WORK_ORDER_DETAILS_V·Explore WIP module →
-
View provides details about the operations of a work order
APPS.EAM_OPERATIONS_DETAILS_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCE_EMPLOYEES·↳ CSI_ITEM_INSTANCES·Explore EAM module →
-
This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID.
-
View: WIP_EAM_ENTITIES_V 12.1.1
EAM work order information
APPS.WIP_EAM_ENTITIES_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_WORK_ORDER_DETAILS_V·Explore WIP module →
-
Detailed information for maintenance work orders
APPS.WIP_EAM_WORK_ORDER_DTLS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_COMMON_UTILITIES_PVT·Explore WIP module →
-
Detailed information for maintenance work orders
APPS.WIP_EAM_WORK_ORDER_DTLS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_COMMON_UTILITIES_PVT·Explore WIP module →
-
View: EAM_WORK_ORDERS_V 12.1.1
View shows all maintenance work orders alongwith the service requests associated to them
APPS.EAM_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ CS_INCIDENTS_B_SEC·Explore EAM module →
-
The staging table used by the collection program to validate and process data for table MSC_SUPPLIES.
-
The staging table used by the collection program to validate and process data for table MSC_SUPPLIES.
-
View: WIP_EAM_WORK_ORDERS_V 12.1.1
Maintenance Work Orders
APPS.WIP_EAM_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_COMMON_UTILITIES_PVT·Explore WIP module →
-
View: WIP_EAM_WORK_ORDERS_V 12.2.2
Maintenance Work Orders
APPS.WIP_EAM_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_COMMON_UTILITIES_PVT·Explore WIP module →
-
This table lists all the supplies for this plan. The supplies created by the planning process are added to this table.
-
The staging table used by the collection program to validate and process data for table MSC_DEMANDS.
-
The staging table used by the collection program to validate and process data for table MSC_DEMANDS.
-
This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID.
-
This table lists all the supplies for this plan. The supplies created by the planning process are added to this table.
-
View: CUN_ITEMS_V 12.1.1
This view contains item unit information from the Network Logistics system
Not implemented in this database·Explore CUN module →
-
View: CUN_ITEMS_V 12.2.2
This view contains item unit information from the Network Logistics system
Not implemented in this database·Explore CUN module →
-
Fixed Asset information
Not implemented in this database·Explore CUN module →
-
Fixed Asset information
Not implemented in this database·Explore CUN module →
-
VIEW: MSC.MSC_ST_DEMANDS# 12.2.2
-
VIEW: MSC.MSC_DEMANDS# 12.2.2