Search Results oe_order_lines_all




Overview
Explore in AI Chat

Overview

OE_ORDER_LINES_ALL is the core transactional table in the Oracle Order Management (ONT) module, owned by the ONT schema. It stores information for all order lines across Oracle EBS 12.1.1 and 12.2.2. Every sales order line — whether a standard shippable item, a return, a configured model, an option, or a service line — is persisted here with its pricing, scheduling, fulfillment, shipping, and reference attributes. The table contains 362 documented columns in ETRM 12.2.2, making it one of the widest and most heavily integrated transactional entities in the E-Business Suite.

From a Data Vault modeling perspective, the metadata classifies this object as hub-leaning. This suggests it functions primarily as a durable business-key repository around which satellite tables (such as OE_ORDER_LINES_HISTORY and OE_ORDER_PRICE_ATTRIBS) and link tables capturing hierarchical and cross-module relationships are organized.

Key Information Stored

The surrogate primary key is LINE_ID, enforced by the unique index OE_ORDER_LINES_U1 and the constraint OE_ORDER_LINES_PK. The most operationally significant columns include:

Common Use Cases and Queries

OE_ORDER_LINES_ALL underpins order status reporting, backlog analysis, fulfillment tracking, and integration extracts. A typical query joining lines to headers for open orders is:

  • SELECT h.ORDER_NUMBER, l.LINE_NUMBER, l.ORDERED_ITEM, l.ORDERED_QUANTITY, l.FLOW_STATUS_CODE FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL l WHERE h.HEADER_ID = l.HEADER_ID AND l.OPEN_FLAG = 'Y' AND l.ORG_ID = :org_id;
  • Pricing audits leverage UNIT_SELLING_PRICE and UNIT_LIST_PRICE against PRICE_LIST_ID to compute discount percentages.
  • Configured-item analysis traverses TOP_MODEL_LINE_ID and ATO_LINE_ID to reconstruct model-option hierarchies.
  • Backlog and shipped-not-invoiced reports compare SHIPPED_QUANTITY against INVOICED_QUANTITY.
  • Integration and interface programs commonly filter on FLOW_STATUS_CODE or BOOKED_FLAG to extract new or changed lines.

Related Objects

The table participates in an extensive foreign-key network. Significant related objects include: