Oracle Fusion · Data dictionary
INV_LICENSE_PLATE_NUMBERS
InventoryUsed in 11 subject areas23 reporting columns
Inventory (INV).
Likely primary key: INVENTORY_ITEM_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) |
|---|---|---|---|
| CONTAINER_VOLUME | ● | Container volume. | |
| CONTAINER_VOLUME_UOM | ● | Container volume unit of measure. | |
| CONTENT_VOLUME | ● | Content volume. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| FILL_PERCENT | ● | Fill percentage. | |
| GROSS_WEIGHT | ● | Gross weight. | |
| GROSS_WEIGHT_UOM_CODE | ● | Code identifying the gross weight unit of measure. | |
| HOMOGENEOUS_CONTAINER | ● | Homogeneous container. | |
| INVENTORY_ITEM_ID | PK? | ● | Identifier for the inventory item. |
| LICENSE_PLATE_NUMBER | ● | License plate number. | |
| LPN_CONTEXT | ● | Lpn context. | |
| LPN_ID | ● | Identifier for the lpn. | |
| LPN_REUSABILITY | ● | Lpn reusability. | |
| MASTER_SERIAL_NUMBER | ● | Master serial number. | |
| MAXIMUM_LOAD_WEIGHT | ● | Maximum load weight. | |
| MAXIMUM_VOLUME | ● | Maximum volume. | |
| MINIMUM_FILL_PERCENT | ● | Minimum fill percentage. | |
| NET_WEIGHT | ● | Net weight. | |
| NET_WEIGHT_UOM_CODE | ● | Code identifying the net weight unit of measure. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| SEAL_CODE | ● | Code identifying the seal. | |
| TARE_WEIGHT | ● | Tare weight. |
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 Cycle Count Real Time
- Inventory - Inventory Transactions 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
- Shipping Real Time
Need the extract + dbt staging for INV_LICENSE_PLATE_NUMBERS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table