Search Results eam_wo_req_po_lite_v




Overview
Explore in AI Chat

Overview

EAM_WO_REQ_PO_LITE_V is an APPS-owned, VALID database view in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Enterprise Asset Management (EAM) product family and is documented as a lightweight version of EAM_WORK_ORDER_REQ_PO_V. Its purpose is to expose work order demand alongside its associated requisition and purchase order supply chain data — requisition headers and lines, purchase order headers, lines, and line locations, plus delivery and receipt quantities — in a single flattened result set. Because the heavyweight variant joins additional work-in-process and resource data, the lite view is preferred where query performance matters, such as EAM work order execution dashboards, maintenance procurement reports, and integration extracts that reconcile work order requirements to purchase orders.

Underlying Base Objects

The view is defined over the following documented base objects (all exposed through APPS synonyms): PO_DISTRIBUTIONS_ALL, PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_LINE_TYPES, PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL, and MTL_UNITS_OF_MEASURE. The join topology links the EAM work order identifiers (WIP_ENTITY_ID, WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM) to requisition lines, which in turn connect to purchase order distributions, lines, headers, and scheduled line locations. MTL_UNITS_OF_MEASURE supplies the UOM_CODE column. Because several columns are sourced from both the requisition and the PO side, the view text uses NVL and DECODE to prefer PO values when present and fall back to requisition values otherwise — for example, item description, unit price, currency, category, need-by date, and vendor.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling work order material demand to requisition and PO commitments, reporting delivered value and received quantities per work order, and feeding maintenance dashboards. To retrieve delivered amounts for a specific work order:

  • SELECT wip_entity_id, req_number, po_number, quantity_received, amount_delivered, currency_code FROM apps.eam_wo_req_po_lite_v WHERE wip_entity_id = :wip_entity_id;
  • SELECT po_number, SUM(amount_delivered) total_delivered FROM apps.eam_wo_req_po_lite_v GROUP BY po_number HAVING SUM(amount_delivered) > 0;
  • SELECT wip_entity_id, req_number, po_number, amount_delivered FROM apps.eam_wo_req_po_lite_v WHERE amount_delivered IS NULL OR amount_delivered = 0; — identifies demand with no receipt activity.

All queries should be qualified with APPS, and access should be granted through the standard EAM responsibility or a custom read-only grant on the synonym.