Oracle Fusion · Data dictionary
WIE_WO_ASSETS
SharedUsed in 12 subject areas7 reporting columns
Work in Process (WIE).
Primary key: not yet catalogued for WIE_WO_ASSETS, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSET_ID | ● | Identifier for the asset. | |
| MATCH_TO_TXN_CODE_FLAG | ● | Indicator (Y/N) for the match to transaction code. | |
| MNT_COMPLETE_FLAG | ● | Indicator (Y/N) for the mnt complete. | |
| ROUTE_ASSET_FLAG | ● | Indicator (Y/N) for the route asset. | |
| ROUTE_COMPLETE_FLAG | ● | Indicator (Y/N) for the route complete. | |
| ROUTE_SKIPPED_FLAG | ● | Indicator (Y/N) for the route skipped. | |
| WARRANTY_REPAIR_FLAG | ● | Indicator (Y/N) for the warranty repair. |
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
- 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
- Supplier Warranty - Asset Real Time
Need the extract + dbt staging for WIE_WO_ASSETS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table