Oracle Fusion · Data dictionary
INV_TRANSACTION_LOT_NUMBERS
InventoryUsed in 3 subject areas6 reporting columns
Inventory (INV).
Primary key: not yet catalogued for INV_TRANSACTION_LOT_NUMBERS, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| LOT_NUMBER | ● | Lot number. | |
| PRIMARY_QUANTITY | ● | Primary quantity. | |
| PRODUCT_CODE | ● | Code identifying the product. | |
| PRODUCT_TRANSACTION_ID | ● | Identifier for the product transaction. | |
| SECONDARY_TRANSACTION_QUANTITY | ● | Secondary transaction quantity. | |
| TRANSACTION_QUANTITY | ● | Transaction quantity. |
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.
- Inventory - Inventory Transactions Real Time
- Manufacturing - Purchased Item Usage Real Time
- Receiving - Transactions Real Time
Need the extract + dbt staging for INV_TRANSACTION_LOT_NUMBERS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table