Oracle Fusion · Data dictionary
INV_ONHAND_QUANTITIES_DETAIL
InventoryUsed in 6 subject areas9 reporting columns
Inventory (INV), detail-level data.
Primary key: not yet catalogued for INV_ONHAND_QUANTITIES_DETAIL, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AGING_EXPIRATION_DATE | ● | Aging expiration date. | |
| AGING_ONSET_DATE | ● | Aging onset date. | |
| ONHAND_QUANTITIES_ID | ● | Identifier for the onhand quantities. | |
| OWNING_TYPE | ● | Type of owning. | |
| PRIMARY_TRANSACTION_QUANTITY | ● | Primary transaction quantity. | |
| SECONDARY_TRANSACTION_QUANTITY | ● | Secondary transaction quantity. | |
| SECONDARY_UOM_CODE | ● | Code identifying the secondary unit of measure. | |
| TRANSACTION_QUANTITY | ● | Transaction quantity. | |
| TRANSACTION_UOM_CODE | ● | Code identifying the transaction unit of measure. |
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 Balance Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Material Usage Real Time
- Manufacturing - Actual Production Real Time
- Manufacturing - Material Usage Real Time
- Manufacturing - Production Exceptions Real Time
Need the extract + dbt staging for INV_ONHAND_QUANTITIES_DETAIL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table