Oracle Fusion · Data dictionary
INV_SECONDARY_INVENTORIES
InventoryUsed in 19 subject areas15 reporting columns
Inventory (INV).
Primary key: not yet catalogued for INV_SECONDARY_INVENTORIES, 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. | |
| DEFAULT_LOC_STATUS_ID | ● | Identifier for the default loc status. | |
| DEPRECIABLE_FLAG | ● | Indicator (Y/N) for the depreciable. | |
| DESCRIPTION | ● | Description. | |
| DISABLE_DATE | ● | Disable date. | |
| LOCATOR_TYPE | ● | Type of locator. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| QUANTITY_TRACKED | ● | Quantity tracked. | |
| RESERVABLE_TYPE | ● | Type of reservable. | |
| SECONDARY_INVENTORY_NAME | ● | Name of the secondary inventory. | |
| STATUS_ID | ● | Identifier for the status. | |
| SUBINVENTORY_ID | ● | Identifier for the subinventory. | |
| 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.
- Budgetary Control - Transactions Real Time
- Costing - Cost Accounting Real Time
- Costing - Inventory Valuation Real Time
- Inventory - Inventory Balance Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transactions Real Time
- Inventory Organization Real Time
- Procurement - Pending Change Orders Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Receiving - In-Transit Advanced Shipment Notifications Real Time
- Receiving - In-Transit Interorganization Inventory Transfers Real Time
- Receiving - In-Transit Shipments Real Time
- Receiving - Interorganization Receipts Real Time
- Receiving - Purchase Receipts Real Time
- Receiving - Receipts Real Time
- Receiving - Transactions Real Time
- Receiving - Unordered Receipts Real Time
- Shipping Real Time
Need the extract + dbt staging for INV_SECONDARY_INVENTORIES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table