Oracle Fusion · Data dictionary
INV_SECONDARY_INVENTORIES_VL
InventoryUsed in 31 subject areas23 reporting columns
Inventory (INV), view layer, joins the base table with translations for the current language.
Primary key: not yet catalogued for INV_SECONDARY_INVENTORIES_VL, reference Oracle Tables & Views guide.
Joins (inferred from key columns): ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSET_INVENTORY | ● | Asset inventory. | |
| AVAILABILITY_TYPE | ● | Type of availability. | |
| COUNT_METHOD | ● | Count method. | |
| DEFAULT_COUNT_TYPE_CODE | ● | Code identifying the default count type. | |
| DEFAULT_LOC_STATUS_ID | ● | Identifier for the default loc status. | |
| DEPRECIABLE_FLAG | ● | Indicator (Y/N) for the depreciable. | |
| DESCRIPTION | ● | Description. | |
| DISABLE_DATE | ● | Disable date. | |
| INVENTORY_ATP_CODE | ● | Code identifying the inventory atp. | |
| LOCATOR_TYPE | ● | Type of locator. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| PLANNING_LEVEL | ● | Planning level. | |
| QUANTITY_TRACKED | ● | Quantity tracked. | |
| RESERVABLE_TYPE | ● | Type of reservable. | |
| SECONDARY_INVENTORY_NAME | ● | Name of the secondary inventory. | |
| SOURCE_ORGANIZATION_ID | ● | Identifier for the source organization. | |
| SOURCE_TYPE | ● | Type of source. | |
| STATUS_ID | ● | Identifier for the status. | |
| SUBINVENTORY_GROUP | ● | Subinventory group. | |
| SUBINVENTORY_ID | ● | Identifier for the subinventory. | |
| SUBINVENTORY_NAME_MLS | ● | Subinventory name mls. | |
| SUBINVENTORY_TYPE | ● | Type of subinventory. | |
| SUBINVENTORY_USAGE | ● | Subinventory usage. |
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 - Period Inventory Valuation Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Inventory - Inventory ABC Real Time
- Inventory - Inventory Balance Real Time
- Inventory - Inventory Cycle Count Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transactions Real Time
- Inventory - Inventory Transfer Order Real Time
- Inventory - Kanban Activity Real Time
- Inventory Organization Real Time
- Manufacturing - Actual Production Real Time
- Manufacturing - Material Usage Real Time
- Procurement - Pending Change Orders Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Product Genealogy - Genealogy Object Composition Real Time
- Product Genealogy - Genealogy Object Where Used Real Time
- Product Genealogy - Genealogy Transaction Real Time
Need the extract + dbt staging for INV_SECONDARY_INVENTORIES_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table