OracleOps AI
← All tables
Oracle Fusion/Supply Chain/Order Management

DOO_HEADERS_ALL

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

Key Columns

HEADER_IDORDER_NUMBERBUSINESS_UNIT_IDSOURCE_ORDER_SYSTEM

Child Tables

DOO_LINES_ALL

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

Common Joins

DOO_LINES_ALLvia HEADER_ID

The individual item lines on this sales order.

Used In

Order ManagementOrder-to-Cash

Related

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.

DOO_FULFILL_LINES_ALL

DOO_FULFILL_LINES_ALL is the fulfillment-line-level record in Order Management/Global Order Promising orchestration, tracking a line's progress through scheduling, reservation, shipping and invoicing.

Ask Oracle AI about DOO_HEADERS_ALL