Oracle Fusion · Data dictionary
DOO_LINES_ALL
SharedUsed in 16 subject areas23 reporting columns
Order Management (DOO), line table, one row per line item under the header.
Likely primary key: LINE_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): HEADER_ID → DOO_HEADERS_ALL · INVENTORY_ITEM_ID → INV_LICENSE_PLATE_NUMBERS · LINE_ID → AR_DISTRIBUTIONS_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUAL_SHIP_DATE | ● | Actual shipment date. | |
| CANCELED_FLAG | ● | Indicator (Y/N) for the canceled. | |
| CANCELED_QTY | ● | Canceled quantity. | |
| CATEGORY_CODE | ● | Code identifying the category. | |
| DISPLAY_LINE_NUMBER | ● | Display line number. | |
| FULFILLED_QTY | ● | Fulfilled quantity. | |
| FULFILLMENT_DATE | ● | Fulfillment date. | |
| HEADER_ID | ● | Identifier for the header. | |
| INVENTORY_ITEM_ID | ● | Identifier for the inventory item. | |
| LINE_ID | PK? | ● | Identifier for the line. |
| LINE_NUMBER | ● | Line number. | |
| ON_HOLD | ● | On hold. | |
| OPEN_FLAG | ● | Indicator (Y/N) for the open. | |
| ORDERED_QTY | ● | Ordered quantity. | |
| ORDERED_UOM | ● | Ordered unit of measure. | |
| RMA_DELIVERED_QTY | ● | Rma delivered quantity. | |
| SCHEDULE_SHIP_DATE | ● | Schedule shipment date. | |
| SHIPPED_QTY | ● | Shipped quantity. | |
| SOURCE_LINE_NUMBER | ● | Source line number. | |
| SOURCE_ORDER_NUMBER | ● | Source order number. | |
| SOURCE_SCHEDULE_NUMBER | ● | Source schedule number. | |
| UNIT_LIST_PRICE | ● | Unit list price. | |
| UNIT_SELLING_PRICE | ● | Unit selling price. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Costing - Cost Accounting Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Headers Real Time
- Distributed Order Orchestration - Order Holds Real Time
- Distributed Order Orchestration - Order Lines Real Time
- Distributed Order Orchestration - Price Adjustments Real Time
- Fiscal Document Capture Transactions Real Time
- Fiscal Document Holds Real Time
- Fiscal Document Item Deliveries Real Time
- Inventory - Inventory Transfer Order Real Time
- Manufacturing - Work Order Performance Real Time
- Manufacturing - Workstation Supervision Real Time
- Product Genealogy - Genealogy Instance Real Time
- Shipping Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for DOO_LINES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table