Oracle EBS/Supply Chain/Order Management

OE_ORDER_HEADERS_ALL

Sales order headers (EBS) — customer, order type, currency and workflow status for an order. Fusion uses DOO_HEADERS_ALL.

HEADER_IDORDER_NUMBERORG_IDSOLD_TO_ORG_IDORDER_TYPE_IDTRANSACTIONAL_CURR_CODEFLOW_STATUS_CODEBOOKED_FLAG

OE_ORDER_LINES_ALL

Sales order lines (EBS) — item, ordered quantity, ship-from org, pricing and per-line workflow status.

OE_PRICE_ADJUSTMENTS

Price adjustments (EBS) — discounts, surcharges and promotions applied to an order or line by the pricing engine.

The order's lines.

The ordering customer account.

Order ManagementShippingAR

FLOW_STATUS_CODE tracks the order header workflow — BOOKED, CLOSED, CANCELLED.