Search Results purchasing_category




Overview
Explore in AI Chat

Overview

APPS.EAM_DIRECT_ITEMS_RECS_LITE_V is a supplementary Oracle E-Business Suite view owned by the APPS schema and defined over Enterprise Asset Management (EAM) work order direct item data. Oracle classifies it as a "lite" supplementary view used to simplify forms coding within the EAM module, and the standard Oracle warning applies: this view is not intended as a public data access point, and Oracle does not recommend querying or altering data through it because its definition may change dramatically across minor or major releases. Despite that guidance, the view is widely referenced in reporting and diagnostics because it exposes direct-item procurement and receipt activity in a flattened, forms-friendly shape.

The view is particularly significant for users searching on the column PO_QUANTITY_CANCELLED. That column surfaces the cancelled quantity against direct-item purchase order lines associated with EAM work orders, allowing planners and buyers to reconcile ordered, received, and cancelled quantities without drilling into the underlying requisition and purchasing tables.

Underlying Base Objects

Per the documented 12.2.2 metadata, EAM_DIRECT_ITEMS_RECS_LITE_V is defined over the following referenced objects:

The view therefore sits at the intersection of EAM work order execution and Oracle Purchasing activity, joining direct-item definition data to requisition and PO fulfilment data.

Key Columns

Common Use Cases and Queries

The view is most useful for reconciling direct-item demand against purchasing outcomes on EAM work orders. A typical query filters on PO_QUANTITY_CANCELLED to identify cancelled commitments:

SELECT wip_entity_id, organization_id, item_description,
       po_quantity_ordered, po_quantity_cancelled, quantity_received
FROM   apps.eam_direct_items_recs_lite_v
WHERE  po_quantity_cancelled > 0
ORDER  BY wip_entity_id;

Other practical scenarios include auditing open versus received direct items per work order, reporting spend against requisition and PO amounts, and validating that cancelled quantities are excluded from expected receipts. Because Oracle explicitly discourages production queries against this view, organizations requiring stable reporting should treat these results as diagnostic and validate against the underlying EAM and Purchasing tables prior to operational use.