Oracle Fusion · Data dictionary
MNT_WORK_REQUIREMENTS_B
SharedUsed in 2 subject areas29 reporting columns
Maintenance (MNT) — base table — language-neutral data (paired with _TL labels and the _VL view).
Primary key: not yet catalogued for MNT_WORK_REQUIREMENTS_B — 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_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_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. |
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.
Need the extract + dbt staging for MNT_WORK_REQUIREMENTS_B?
We ship parameterized SQL, BICC config, and dbt models you own.