Oracle Fusion · Data dictionary
INV_ORGANIZATION_DEFINITIONS_V
InventoryUsed in 10 subject areas4 reporting columns
Inventory (INV) — denormalized view.
Primary key: ORGANIZATION_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| ORGANIZATION_CODE | ● | Code identifying the organization. | |
| ORGANIZATION_ID | PK | ● | Identifier for the organization. |
| ORGANIZATION_NAME | ● | Name of the organization. |
1 report read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to INV_ORGANIZATION_DEFINITIONS_V.
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 - Transfer Order Receipt Landed Cost Charges Real Time
- Inventory - Inventory Supply Real Time
- Project Billing - Funding Real Time
- Project Billing - Invoices Real Time
- Project Billing - Revenue Real Time
- Project Costing - Actual Costs Real Time
- Project Costing - Expenditure Item Performance - Real Time
- Projects - Cross Subject Area Analysis - Real Time
- Projects - Grants Management - Award Funding Real Time
- Supply Chain Collaboration - Supply Planning Real Time
Need the extract + dbt staging for INV_ORGANIZATION_DEFINITIONS_V?
We ship parameterized SQL, BICC config, and dbt models you own.