Oracle Fusion · Data dictionary
INV_ITEM_LOCATIONS
InventoryUsed in 28 subject areas18 reporting columns
Inventory (INV).
Likely primary key: INVENTORY_LOCATION_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| DEPRECIABLE_FLAG | ● | Indicator (Y/N) for the depreciable. | |
| DESCRIPTION | ● | Description. | |
| DISABLE_DATE | ● | Disable date. | |
| END_DATE_ACTIVE | ● | End date active. | |
| INVENTORY_LOCATION_ID | PK? | ● | Identifier for the inventory location. |
| INVENTORY_LOCATION_TYPE | ● | Type of inventory location. | |
| LOCATOR_STATUS | ● | Status of the locator. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| PHYSICAL_LOCATION_CODE | ● | Code identifying the physical location. | |
| PICKING_ORDER | ● | Picking order. | |
| SEGMENT1 | ● | Segment1. | |
| SEGMENT2 | ● | Segment2. | |
| SEGMENT3 | ● | Segment3. | |
| START_DATE_ACTIVE | ● | Start date active. | |
| STATUS_ID | ● | Identifier for the status. | |
| STRUCTURE_INSTANCE_NUMBER | ● | Structure instance number. | |
| SUBINVENTORY_CODE | ● | Code identifying the subinventory. | |
| SUBINVENTORY_ID | ● | Identifier for the subinventory. |
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.
- Costing - Cost Accounting Period Close Real Time
- Costing - Cost Accounting Real Time
- Costing - Inventory Valuation Real Time
- Costing - Period Inventory Valuation Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Installed Base - Customer Asset History Real Time
- Installed Base - Customer Asset Real Time
- Inventory - Inventory Balance Real Time
- Inventory - Inventory Cycle Count Real Time
- Inventory - Inventory Transactions Real Time
- Inventory - Kanban Activity Real Time
- Inventory Organization Real Time
- Manufacturing - Actual Production Real Time
- Manufacturing - Material Usage Real Time
- Manufacturing - Work Order Performance Real Time
- Manufacturing - Workstation Execution Activities Monitoring Real Time
- Manufacturing - Workstation Supervision Real Time
- Product Genealogy - Genealogy Instance Real Time
- Product Genealogy - Genealogy Object Composition Real Time
- Product Genealogy - Genealogy Object Where Used Real Time
Need the extract + dbt staging for INV_ITEM_LOCATIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table