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

DOO_FULFILL_LINES_ALL

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

Key Columns

FULFILL_LINE_IDLINE_IDHEADER_IDFULFILLMENT_LINE_STATUS_CODE

Parent Table

DOO_LINES_ALL

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

Common Joins

DOO_LINES_ALLvia LINE_ID

The order line this fulfillment record is tracking.

WSH_DELIVERY_DETAILSvia source line reference (Shipping)

The shipping delivery line created once this fulfillment line reaches pick release.

Used In

Order ManagementShippingOrder-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_FULFILL_LINES_ALL