Oracle Fusion · Data dictionary
CSE_ASSETS_B
SharedUsed in 11 subject areas33 reporting columns
base table, language-neutral data (paired with _TL labels and the _VL view).
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. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENT_LOCATION_CONTEXT | ● | Current location context. | |
| CURRENT_LOCATION_ID | ● | Identifier for the current location. | |
| CUSTOMER_ASSET_END_DATE | ● | Customer asset end date. | |
| CUSTOMER_ASSET_START_DATE | ● | Customer asset start date. | |
| INSTALLED_DATE | ● | Installed date. | |
| IN_SERVICE_DATE | ● | In service date. | |
| ITEM_ID | ● | Identifier for the item. | |
| ITEM_ORGANIZATION_ID | ● | Identifier for the item organization. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LOGICAL_FLAG | ● | Indicator (Y/N) for the logical. | |
| LOT_NUMBER | ● | Lot number. | |
| PARENT_ORDER_LINE_ID | ● | Identifier for the parent order line. | |
| PARENT_ORDER_LINE_NUMBER | ● | Parent order line number. | |
| PURCHASE_DATE | ● | Purchase date. | |
| QUANTITY | ● | Quantity. | |
| REGISTRATION_DATE | ● | Registration date. | |
| SALES_ORDER_ID | ● | Identifier for the sales order. | |
| SALES_ORDER_LINE_ID | ● | Identifier for the sales order line. | |
| SALES_ORDER_LINE_NUMBER | ● | Sales order line number. | |
| SALES_ORDER_NUMBER | ● | Sales order number. | |
| SALES_ORDER_SOURCE_SYSTEM | ● | Sales order source system. | |
| SECONDARY_QUANTITY | ● | Secondary quantity. | |
| SECONDARY_UOM_CODE | ● | Code identifying the secondary unit of measure. | |
| SERIAL_NUMBER | ● | Serial number. | |
| SHIPMENT_DATE | ● | Shipment date. | |
| 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.
- Installed Base - Customer Asset History Real Time
- Installed Base - Customer Asset Real Time
- Installed Base - Customer Asset Structure Real Time
- Maintenance Management - Asset Failure Analysis Real Time
- Maintenance Management - Asset History Real Time
- Product Genealogy - Genealogy Instance Real Time
- Product Genealogy - Genealogy Object Composition Real Time
- Product Genealogy - Genealogy Object Where Used Real Time
- Product Genealogy - Genealogy Structure Real Time
- Product Genealogy - Genealogy Transaction Real Time
- Quality Inspection Results Real Time
Need the extract + dbt staging for CSE_ASSETS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table