Analytics Catalog/Data dictionary/MNT_PROGRAMS_B
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
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

ColumnKeyIn reportsDescription (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.

Need the extract + dbt staging for MNT_PROGRAMS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us