Oracle Fusion · Data dictionary
MNT_WORK_REQUIREMENTS_FACT_V
SharedUsed in 2 subject areas32 reporting columns
Maintenance (MNT), denormalized view.
Primary key: not yet catalogued for MNT_WORK_REQUIREMENTS_FACT_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVE_END_DATE | ● | Active end date. | |
| ACTIVE_START_DATE | ● | Active start date. | |
| ASSET_HISTORY_SERVICE_DATE | ● | Asset history service date. | |
| ASSET_HISTORY_SERVICE_INTERVAL | ● | Asset history service interval. | |
| ASSET_ID_FINAL | ● | Asset id final. | |
| ASSET_INCLUSION_TYPE_CODE | ● | Code identifying the asset inclusion type. | |
| CALENDAR_BASED_FLAG | ● | Indicator (Y/N) for the calendar based. | |
| CONDITION_BASED_FLAG | ● | Indicator (Y/N) for the condition based. | |
| CREATE_WORK_ORDER_OPTION_CODE | ● | Code identifying the create work order option. | |
| DAY_BASED_FLAG | ● | Indicator (Y/N) for the day based. | |
| FIRM_PLANNED_FLAG | ● | Indicator (Y/N) for the firm planned. | |
| FORECAST_USING_CYCLE_FLAG | ● | Indicator (Y/N) for the forecast using cycle. | |
| FORECAST_WINDOW_IN_DAYS | ● | Forecast window in days. | |
| INTERVALS_IN_THE_CYCLE | ● | Intervals in the cycle. | |
| LAST_FORECAST_DATE | ● | Last forecast date. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| METER_BASED_FLAG | ● | Indicator (Y/N) for the meter based. | |
| MODIFIED_FLAG | ● | Indicator (Y/N) for the modified. | |
| NEXT_FORECAST_DUE_BY_CODE | ● | Code identifying the next forecast due by. | |
| NEXT_WORK_ORDER_ONLY_FLAG | ● | Indicator (Y/N) for the next work order only. | |
| NUMBER_OF_DAYS | ● | Number of days. | |
| REQUIREMENT_ID | ● | Identifier for the requirement. | |
| REQUIREMENT_NAME | ● | Name of the requirement. | |
| REQUIREMENT_REFERENCE | ● | Requirement reference. | |
| REQUIREMENT_TYPE_CODE | ● | Code identifying the requirement type. | |
| ROUTE_HIERARCHY_ID | ● | Identifier for the route hierarchy. | |
| STATUS_CODE | ● | Code identifying the status. | |
| SUPPRESS_MERGE_CODE | ● | Code identifying the suppress merge. | |
| SUPPRESS_MERGE_OVERRIDE_FLAG | ● | Indicator (Y/N) for the suppress merge override. | |
| WORK_ORDER_PRIORITY | ● | Work order priority. | |
| WORK_ORDER_WINDOW_IN_DAYS | ● | Work order window in days. | |
| WO_STATUS_NAME | ● | Name of the wo status. |
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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for MNT_WORK_REQUIREMENTS_FACT_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table