Oracle Fusion · Data dictionary
CSE_AS_BUILT_STRUCTURES_V
SharedUsed in 2 subject areas14 reporting columns
denormalized view.
Primary key: not yet catalogued for CSE_AS_BUILT_STRUCTURES_V, reference Oracle Tables & Views guide.
Joins (inferred from key columns): RELATIONSHIP_TYPE_CODE → HZ_RELATIONSHIP_TYPES
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVE_END_DATE | ● | Active end date. | |
| ACTIVE_START_DATE | ● | Active start date. | |
| CHILD_ASSET_ID | ● | Identifier for the child asset. | |
| CHILD_ASSET_LOT_NUMBER | ● | Child asset lot number. | |
| CHILD_ASSET_NUMBER | ● | Child asset number. | |
| CHILD_ASSET_SERIAL_NUMBER | ● | Child asset serial number. | |
| CHILD_LEVEL | ● | Child level. | |
| PARENT_ASSET_ID | ● | Identifier for the parent asset. | |
| PARENT_ASSET_LOT_NUMBER | ● | Parent asset lot number. | |
| PARENT_ASSET_NUMBER | ● | Parent asset number. | |
| PARENT_ASSET_SERIAL_NUMBER | ● | Parent asset serial number. | |
| RELATIONSHIP_TYPE_CODE | ● | Code identifying the relationship type. | |
| ROOT_ASSET_ID | ● | Identifier for the root asset. | |
| ROOT_ASSET_NUMBER | ● | Root asset number. |
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 Structure Real Time
- Product Genealogy - Genealogy Structure Real Time
Need the extract + dbt staging for CSE_AS_BUILT_STRUCTURES_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table