Oracle Fusion · Data dictionary
INV_TRANSFER_ORDER_LINES
InventoryUsed in 4 subject areas29 reporting columns
Inventory (INV) — line table — one row per line item under the header.
Likely primary key: TRANSFER_ORDER_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOW_ITEM_SUBSTITUTION_FLAG | ● | Indicator (Y/N) for the allow item substitution. | |
| BACK_TO_BACK_FLAG | ● | Indicator (Y/N) for the back to back. | |
| CHANGE_STATUS_LOOKUP | ● | Change status lookup. | |
| COMMENTS | ● | Comments. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| DELIVERED_QTY | ● | Delivered quantity. | |
| DESTINATION_TYPE_LOOKUP | ● | Destination type lookup. | |
| FIRM_FLAG | ● | Indicator (Y/N) for the firm. | |
| HEADER_ID | ● | Identifier for the header. | |
| INITIAL_REQUESTED_QTY | ● | Initial requested quantity. | |
| INTERFACE_ERR_MSG_TEXT | ● | Interface err msg text. | |
| ITEM_SUBSTITUTED_FLAG | ● | Indicator (Y/N) for the item substituted. | |
| LINE_ID | ● | Identifier for the line. | |
| LINE_NUMBER | PK? | ● | Line number. |
| MATERIAL_RETURN_REQUIRED | ● | Material return required. | |
| NOTE_TO_RECEIVER | ● | Note to receiver. | |
| NOTE_TO_SUPPLIER | ● | Note to supplier. | |
| QTY_UOM_CODE | ● | Code identifying the quantity unit of measure. | |
| RECEIVED_QTY | ● | Received quantity. | |
| REQUESTED_QTY | ● | Requested quantity. | |
| SECONDARY_DELIVERED_QTY | ● | Secondary delivered quantity. | |
| SECONDARY_QTY_UOM_CODE | ● | Code identifying the secondary quantity unit of measure. | |
| SECONDARY_RECEIVED_QTY | ● | Secondary received quantity. | |
| SECONDARY_REQUESTED_QTY | ● | Secondary requested quantity. | |
| SECONDARY_SHIPPED_QTY | ● | Secondary shipped quantity. | |
| SHIPPED_QTY | ● | Shipped quantity. | |
| SOURCE_TYPE_LOOKUP | ● | Source type lookup. | |
| STATUS_LOOKUP | ● | Status lookup. | |
| TRANSFER_ORDER_HEADER_ID | PK? | ○ | Identifier for the transfer order header. |
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 - Transfer Order Receipt Landed Cost Charges Real Time
- Fiscal Document Capture Transactions Real Time
- Inventory - Inventory Transfer Order Real Time
- Inventory - Kanban Activity Real Time
Need the extract + dbt staging for INV_TRANSFER_ORDER_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.