Search Results OE_ORDER_LINES_ALL

Overview

The OE_ORDER_LINES_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Order Management module (ONT). It serves as the central transactional table for storing detailed information for every line item on every sales order across all operating units. As a multi-organization enabled table (indicated by the "_ALL" suffix), it contains the data necessary to process, fulfill, price, and invoice individual order lines. Its integrity is maintained by a complex network of foreign key relationships to other master and transactional tables, making it the definitive source for order line details in versions 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is the unique LINE_ID. Beyond this identifier, the table stores a comprehensive set of attributes for each order line. Critical columns include HEADER_ID, linking the line to its parent order in OE_ORDER_HEADERS_ALL, and ORDERED_ITEM to identify the product or service. Key transactional columns capture the LINE_TYPE_ID (e.g., standard, return), pricing details like UNIT_SELLING_PRICE and PRICE_LIST_ID, and shipping information such as SHIPPED_QUANTITY and SHIP_FROM_ORG_ID. For complex orders, columns like ATO_LINE_ID, TOP_MODEL_LINE_ID, and LINK_TO_LINE_ID manage configurations, models, and kit relationships. The table also tracks fulfillment status through FLOW_STATUS_CODE and integration with other modules via references like REFERENCE_CUSTOMER_TRX_LINE_ID for invoicing.

Common Use Cases and Queries

This table is fundamental for operational reporting, data extracts, and custom integrations. Common scenarios include generating open order reports, analyzing line-level profitability, and creating fulfillment documents. A typical query to retrieve key details for active orders might be:

• SELECT ol.line_number, ol.ordered_item, ol.ordered_quantity, ol.unit_selling_price, ol.flow_status_code
• FROM oe_order_lines_all ol, oe_order_headers_all oh
• WHERE ol.header_id = oh.header_id
• AND oh.org_id = :p_org_id
• AND ol.flow_status_code NOT IN ('CLOSED', 'CANCELLED');

Another critical use case involves tracing the lifecycle of a line, from entry through shipping and invoicing, by joining to related tables like WSHR_DELIVERY_DETAILS and RA_CUSTOMER_TRX_LINES_ALL using the LINE_ID or its referenced IDs.

Related Objects

OE_ORDER_LINES_ALL is intricately connected to numerous EBS objects. Its primary parent is OE_ORDER_HEADERS_ALL. Major foreign key relationships, as documented, include OE_TRANSACTION_TYPES_ALL (for line_type_id), MTL_CUSTOMER_ITEMS (for ordered_item_id), QP_LIST_HEADERS_B (for price_list_id), and HR_ALL_ORGANIZATION_UNITS (for ship_from_org_id). It has recursive foreign keys to itself for modeling line splits and configurations. Key dependent interfaces and APIs include the Order Management APIs (e.g., OE_ORDER_PUB) which process and validate data for this table. For reporting, views like OE_ORDER_LINES_V often provide a more accessible layer on top of this base table.