Oracle Fusion · Data dictionary
MNT_PROGRAMS_B
SharedUsed in 3 subject areas20 reporting columns
Maintenance (MNT), base table, language-neutral data (paired with _TL labels and the _VL view).
Primary key: not yet catalogued for MNT_PROGRAMS_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. | |
| FORECAST_WINDOW_IN_DAYS | ● | Forecast window in days. | |
| GLOBAL_ASSETS_FLAG | ● | Indicator (Y/N) for the global assets. | |
| IN_PROCESS_FLAG | ● | Indicator (Y/N) for the in process. | |
| LAST_FORECAST_DATE | ● | Last forecast date. | |
| LAST_FORECAST_GEN_REQUEST_ID | ● | Identifier for the last forecast gen request. | |
| LAST_WO_GEN_REQUEST_ID | ● | Identifier for the last wo gen request. | |
| MODIFIED_FLAG | ● | Indicator (Y/N) for the modified. | |
| PROGRAM_CODE | ● | Code identifying the program. | |
| PROGRAM_REFERENCE | ● | Program reference. | |
| PROGRAM_SUB_TYPE_CODE | ● | Code identifying the program sub type. | |
| PROGRAM_TYPE_CODE | ● | Code identifying the program type. | |
| REVIEWED_BY | ● | Reviewed by. | |
| REVIEW_COMMENTS | ● | Review comments. | |
| REVIEW_DATE | ● | Review date. | |
| SUPPRESS_MERGE_CODE | ● | Code identifying the suppress merge. | |
| WORK_ORDER_START_TIME | ● | Work order start time. | |
| WORK_ORDER_TIMEZONE_CODE | ● | Code identifying the work order timezone. | |
| 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.
- Maintenance Management - Asset Equipment Qualification Real Time
- Maintenance Management - Forecast Real Time
- Maintenance Management - Work Requirement Real Time
Need the extract + dbt staging for MNT_PROGRAMS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table