Oracle Fusion · Data dictionary
MNT_FORECAST_LINES
SharedUsed in 1 subject areas20 reporting columns
Maintenance (MNT), line table, one row per line item under the header.
Primary key: not declared here, see Oracle's Tables and Views page for MNT_FORECAST_LINES
Joins (inferred from key columns): FORECAST_ID → MNT_FORECASTS · METER_ID → CSE_METERS · ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V · WORK_DEFINITION_ID → WIS_WORK_DEFINITIONS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSET_ID | ● | Identifier for the asset. | |
| CONDITION_EVENT_CODE_ID | ● | Identifier for the condition event code. | |
| CYCLE_INTERVAL | ● | Cycle interval. | |
| DAY_INTERVAL_VALUE | ● | Day interval value. | |
| FORECAST_DATE | ● | Forecast date. | |
| FORECAST_ID | ● | Identifier for the forecast. | |
| FORECAST_LINE_ID | ● | Identifier for the forecast line. | |
| FORECAST_MTR_READING_VALUE | ● | Forecast mtr reading value. | |
| FORECAST_SEQUENCE | ● | Forecast sequence. | |
| METER_DEFINITION_ID | ● | Identifier for the meter definition. | |
| METER_ID | ● | Identifier for the meter. | |
| METER_INTERVAL_VALUE | ● | Meter interval value. | |
| METER_UTILIZATION_RATE | ● | Meter utilization rate. | |
| NEXT_WORK_ORDER_ONLY_FLAG | ● | Indicator (Y/N) for the next work order only. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| REQUIREMENT_ID | ● | Identifier for the requirement. | |
| SCHEDULE_PATTERN_ID | ● | Identifier for the schedule pattern. | |
| SUPPRESSED_FLAG | ● | Indicator (Y/N) for the suppressed. | |
| WORK_DEFINITION_ID | ● | Identifier for the work definition. | |
| WORK_DEFINITION_VERSION_ID | ● | Identifier for the work definition version. |
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_FORECAST_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table