Oracle Fusion · Data dictionary
INV_ITEM_SUB_INVENTORIES
InventoryUsed in 3 subject areas18 reporting columns
Inventory (INV).
Primary key: not yet catalogued for INV_ITEM_SUB_INVENTORIES — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| DEFAULT_COUNT_TYPE_CODE | ● | Code identifying the default count type. | |
| FIXED_LOT_MULTIPLE | ● | Fixed lot multiple. | |
| INVENTORY_PLANNING_CODE | ● | Code identifying the inventory planning. | |
| MAXIMUM_ORDER_QUANTITY | ● | Maximum order quantity. | |
| MAX_MINMAX_QUANTITY | ● | Max minmax quantity. | |
| MINIMUM_ORDER_QUANTITY | ● | Minimum order quantity. | |
| MINMAX_QUANTITY_UOM | ● | Minmax quantity unit of measure. | |
| MIN_MINMAX_QUANTITY | ● | Min minmax quantity. | |
| PAR_LEVEL | ● | Par level. | |
| PAR_MAX_QTY | ● | Par max quantity. | |
| PAR_UOM_CODE | ● | Code identifying the par unit of measure. | |
| POSTPROCESSING_LEAD_TIME | ● | Postprocessing lead time. | |
| PREPROCESSING_LEAD_TIME | ● | Preprocessing lead time. | |
| PROCESSING_LEAD_TIME | ● | Processing lead time. | |
| QTY_COUNT_TOLERANCE | ● | Quantity count tolerance. | |
| SECONDARY_INVENTORY | ● | Secondary inventory. | |
| SOURCE_SUBINVENTORY | ● | Source subinventory. | |
| SOURCE_TYPE | ● | Type of source. |
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
- Inventory - Inventory Transactions Real Time
- Inventory Organization Real Time
Need the extract + dbt staging for INV_ITEM_SUB_INVENTORIES?
We ship parameterized SQL, BICC config, and dbt models you own.