Oracle Fusion/Supply Chain/Order Management

DOO_LINES_ALL

Sales order line — item, quantity, and requested schedule for a header.

Key Columns

LINE_IDHEADER_IDINVENTORY_ITEM_IDORDERED_QUANTITY

Parent Table

DOO_HEADERS_ALL

Sales order header — customer, order type, business unit, order status.

Child Tables

DOO_FULFILL_LINES_ALL

Fulfillment line tracking the orchestration/fulfillment status of a sales order line (scheduling, reservation, shipping, invoicing).

Common Joins

DOO_HEADERS_ALLvia HEADER_ID

The order header this line belongs to — customer, order type, business unit.

DOO_FULFILL_LINES_ALLvia LINE_ID

The fulfillment line tracking this order line's orchestration status (scheduling, reservation, shipping, invoicing).

EGP_SYSTEM_ITEMS_Bvia INVENTORY_ITEM_ID

The item master record for what's being ordered on this line.

Used In

Order Management

Tracing a sales order

A sales order flows DOO_HEADERS_ALL → DOO_LINES_ALL → DOO_FULFILL_LINES_ALL. A fulfillment line's status (FULFILLMENT_LINE_STATUS_CODE) progresses through a common lifecycle: Draft → Submitted → Scheduled → Reserved → Awaiting Shipping → Shipped → Invoiced → Closed — each label is the plain-English display value, not the literal internal status code.