What is the primary key of INV_TRANSFER_ORDER_LINES?

LINE_NUMBER, TRANSFER_ORDER_HEADER_ID (likely, inferred from column markers)

Where is INV_TRANSFER_ORDER_LINES used in reporting?

It appears in 4 OTBI subject areas.

Oracle Fusion · Data dictionary

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)

Joins (inferred from key columns): HEADER_ID → DOO_HEADERS_ALL · TRANSFER_ORDER_HEADER_ID → INV_TRANSFER_ORDER_HEADERS

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.

No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.

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.

Need the extract + dbt staging for INV_TRANSFER_ORDER_LINES?

We ship parameterized SQL, BICC config, and dbt models you own.

Problems that run through this table