Search Results ordered_quantity_uom2




Overview
Explore in AI Chat

Overview

APPS.WSH_OE_LINES_V1 is an internal Oracle E-Business Suite view that consolidates order-line and delivery information from the Order Management and Shipping execution schemas into a single reporting surface. It is owned by the APPS schema, registered in FND design data as WSH.WSH_OE_LINES_V1, and carries a status of VALID in both Oracle EBS 12.1.1 and 12.2.2. The view joins order header, order line, delivery assignment, delivery detail, and delivery records so that consumers can retrieve the association between a sales order line and the outbound shipment acting on it without traversing the base tables individually.

The view type is documented as Internal, and the metadata explicitly carries an Oracle Internal Use Only warning. Oracle does not support direct access to this object except from standard Oracle Applications programs. Development and integration teams should therefore treat WSH_OE_LINES_V1 as a diagnostic and investigative object rather than a supported public interface, and should confirm the corresponding supported API or public view before building a permanent dependency on it.

Underlying Base Objects

The documented dependencies for WSH_OE_LINES_V1 are as follows:

The view therefore sits at the junction of the Order Management and Shipping schemas, exposing order-line columns enriched with shipment and delivery context through the delivery assignment and delivery detail layers.

Key Columns

The view exposes identifiers, item references, quantities, organizational references, and audit columns.

The search term ordered_quantity_uom2 maps directly to the ORDERED_QUANTITY_UOM2 column, which returns the secondary unit of measure for the ordered quantity.

Common Use Cases and Queries

A frequent scenario is confirming the dual-unit quantity values for an order line, which is exactly the pattern implied by the search term:

  • SELECT ORDER_NUMBER, LINE_NUMBER, ORDERED_ITEM, ORDERED_QUANTITY, ORDER_QUANTITY_UOM, ORDERED_QUANTITY2, ORDERED_QUANTITY_UOM2 FROM APPS.WSH_OE_LINES_V1 WHERE LINE_ID = :line_id;
  • SELECT ORDER_NUMBER, LINE_NUMBER, SHIPPED_QUANTITY, SHIPPED_QUANTITY2, DELIVERY_NAME FROM APPS.WSH_OE_LINES_V1 WHERE DELIVERY_ID = :delivery_id;

Further use cases include reconciling ordered against shipped quantities across the primary and secondary units, and tracing a delivery back to the sales order line that generated it. Given the Internal status and the support restriction, any such query should be validated by Oracle Support before it is embedded in a production integration, and a supported alternative should be used where one exists.