Results for “workorder_number”

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

Overview

APPS.EAM_WORKORDER_DOWNTIME_V is a reporting view in the Oracle E-Business Suite Enterprise Asset Management (EAM) module that consolidates downtime information at the work order and work order operation level. It is defined in the APPS schema and carries a VALID status in both 12.1.1 and 12.2.2. The view joins discrete job, entity, serial number, and instance data to produce a unified picture of when an asset or production resource was taken out of service, the reason (shutdown type), the maintenance status, and the window in which the downtime occurred.

The view is engineered as a UNION ALL of two complementary queries. The first branch reports downtime recorded at the work order header level, where the operation sequence is returned as a NULL numeric placeholder (OP_SEQ) and the FROM_DATE/TO_DATE are derived from the scheduled start and completion dates of the discrete job. The second branch reports downtime recorded at the operation level, sourcing OP_SEQ from WIP_OPERATIONS.OPERATION_SEQ_NUM and replacing the header dates with the operation's first unit start date and last unit completion date. The two branches are mutually exclusive: the first applies where WDJ.SHUTDOWN_TYPE is in ('2','3'), while the second uses the negation NVL(WDJ.SHUTDOWN_TYPE,'0') NOT IN ('2','3'), ensuring no double counting of a single downtime event.

Underlying Base Objects

The documented base objects referenced by the view are WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_OPERATIONS, MTL_SERIAL_NUMBERS, and CSI_ITEM_INSTANCES, all accessed through APPS synonyms. WIP_DISCRETE_JOBS (aliased WDJ) is the anchor and supplies the maintenance organization, work order identifiers, asset group, shutdown type, status type, firm planned flag, and the scheduled date range used at header level. WIP_ENTITIES (aliased WE) is joined on ORGANIZATION_ID and WIP_ENTITY_ID, restricted to ENTITY_TYPE = 6, to resolve the human-readable WORKORDER_NUMBER. WIP_OPERATIONS (aliased WO) is joined only in the second branch to supply operation-level sequence numbers and dates.

CSI_ITEM_INSTANCES (aliased CII) links the maintenance object to the physical asset instance via MAINTENANCE_OBJECT_ID = CII.INSTANCE_ID, with MAINTENANCE_OBJECT_TYPE = 3 and NETWORK_ASSET_FLAG = 'N' filtering to non-network asset instances. MTL_SERIAL_NUMBERS (aliased MSN) is joined through EQUIPMENT_GEN_OBJECT_ID = MSN.GEN_OBJECT_ID to expose the equipment serial number and its owning production organization.

Key Columns

• MAINT_ORG_ID — Maintenance organization (WDJ.ORGANIZATION_ID).
• PROD_ORG_ID — Production organization from MSN.CURRENT_ORGANIZATION_ID.
• WIP_ENTITY_ID / WORKORDER_NUMBER — Discrete job identifier and its name.
• ASSET_GROUP_ID / ASSET_NUMBER — Asset group and the CSI instance number of the affected asset.
• OP_SEQ — Operation sequence; NULL on header-level rows, populated on operation-level rows.
• FROM_DATE / TO_DATE — Downtime window; header dates on the first branch, operation dates on the second.
• EQUIPMENT_ITEM_ID / EQP_SERIAL_NUMBER — Equipment item and serial number.
• SHUTDOWN_TYPE / STATUS_TYPE — Reason and maintenance status classification of the downtime.
• FIRM_FLAG — Exposes WDJ.FIRM_PLANNED_FLAG, indicating whether the work order is firm planned; this is the column most commonly sought by users searching on "firm_flag".

Common Use Cases and Queries

Typical scenarios include asset downtime reporting, reliability and availability analysis, and feed queries for maintenance dashboards. Because FIRM_FLAG is aliased from FIRM_PLANNED_FLAG, filters on the work order firm status use the view alias:

• SELECT workorder_number, asset_number, op_seq, from_date, to_date, shutdown_type, firm_flag FROM apps.eam_workorder_downtime_v WHERE firm_flag = 'Y';
• SELECT asset_number, SUM(to_date - from_date) downtime FROM apps.eam_workorder_downtime_v WHERE from_date BETWEEN :p_start AND :p_end GROUP BY asset_number;
• SELECT workorder_number, op_seq, shutdown_type FROM apps.eam_workorder_downtime_v WHERE maint_org_id = :org AND firm_flag = 'N';

Consumers should note that header and operation rows are distinguished by the presence or absence of OP_SEQ, and that date arithmetic assumes FROM_DATE and TO_DATE are reliably populated on the contributing WIP records.