Oracle Fusion · Data dictionary
DOO_LOT_SERIAL_NUMBERS
SharedUsed in 1 subject areas5 reporting columns
Order Management (DOO).
Primary key: not yet catalogued for DOO_LOT_SERIAL_NUMBERS — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ITEM_REVISION_NUMBER | ● | Item revision number. | |
| ITEM_SERIAL_NUMBER_FROM | ● | Item serial number from. | |
| ITEM_SERIAL_NUMBER_TO | ● | Item serial number to. | |
| LOT_NUMBER | ● | Lot number. | |
| QUANTITY | ● | 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.
Need the extract + dbt staging for DOO_LOT_SERIAL_NUMBERS?
We ship parameterized SQL, BICC config, and dbt models you own.