Oracle Fusion · Data dictionary
CSE_ASSETS_VL
SharedUsed in 16 subject areas11 reporting columns
view layer — joins the base table with translations for the current language.
Likely primary key: ASSET_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSET_ID | PK? | ● | Identifier for the asset. |
| ASSET_NUMBER | ● | Asset number. | |
| CURRENT_LOCATION_CONTEXT | ● | Current location context. | |
| DESCRIPTION | ● | Description. | |
| LOT_NUMBER | ● | Lot number. | |
| QUANTITY | ● | Quantity. | |
| SECONDARY_QUANTITY | ● | Secondary quantity. | |
| SECONDARY_UOM_CODE | ● | Code identifying the secondary unit of measure. | |
| SERIAL_NUMBER | ● | Serial number. | |
| SUBINVENTORY_CODE | ● | Code identifying the subinventory. | |
| UOM_CODE | ● | Code identifying the unit of measure. |
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 - Work Order Costs Real Time
- Installed Base - Meter Based Asset Usage Real Time
- Maintenance Management - Asset Equipment Qualification Real Time
- Maintenance Management - Asset Failure Analysis Real Time
- Maintenance Management - Asset History Real Time
- Maintenance Management - Asset Real Time
- Maintenance Management - Forecast Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Maintenance Management - Resource Usage Real Time
- Maintenance Management - Work Order Performance Real Time
- Maintenance Management - Work Requirement Real Time
- Manufacturing - Production Exceptions Real Time
- Manufacturing - Resource Usage Real Time
- Supplier Warranty - Asset Real Time
Need the extract + dbt staging for CSE_ASSETS_VL?
We ship parameterized SQL, BICC config, and dbt models you own.