MNT_WORK_REQUIREMENTS_VL

Details

• Schema: FUSION

• Object owner: MNT

• Object type: VIEW

Columns

Name

REQUIREMENT_ID OBJECT_VERSION_NUMBER REQUIREMENT_NAME ORGANIZATION_ID PROGRAM_ID REQUIREMENT_TYPE_CODE ITEM_ID ASSET_ID STATUS_CODE FORECAST_USING_CYCLE_FLAG INTERVALS_IN_THE_CYCLE CALENDAR_BASED_FLAG METER_BASED_FLAG CONDITION_BASED_FLAG DAY_BASED_FLAG NUMBER_OF_DAYS NEXT_FORECAST_DUE_BY_CODE ASSET_HISTORY_SERVICE_DATE ASSET_HISTORY_SERVICE_INTERVAL ASSET_INCLUSION_TYPE_CODE SCHEDULE_PATTERN_ID ACTIVE_START_DATE ACTIVE_END_DATE SUPPRESS_MERGE_CODE SUPPRESS_MERGE_OVERRIDE_FLAG LAST_FORECAST_DATE MODIFIED_FLAG NEXT_WORK_ORDER_ONLY_FLAG FORECAST_WINDOW_IN_DAYS WORK_ORDER_WINDOW_IN_DAYS REQUIREMENT_REFERENCE REQUIREMENT_REFERENCE_ID CREATE_WORK_ORDER_OPTION_CODE WORK_ORDER_STATUS_ID WORK_ORDER_PRIORITY FIRM_PLANNED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE

Query

SQL_Statement

SELECT MWRB.REQUIREMENT_ID REQUIREMENT_ID, MWRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MWRTL.REQUIREMENT_NAME REQUIREMENT_NAME, MWRB.ORGANIZATION_ID ORGANIZATION_ID, MWRB.PROGRAM_ID PROGRAM_ID, MWRB.REQUIREMENT_TYPE_CODE REQUIREMENT_TYPE_CODE, MWRB.ITEM_ID ITEM_ID, MWRB.ASSET_ID ASSET_ID, MWRB.STATUS_CODE STATUS_CODE, MWRB.FORECAST_USING_CYCLE_FLAG FORECAST_USING_CYCLE_FLAG, MWRB.INTERVALS_IN_THE_CYCLE INTERVALS_IN_THE_CYCLE, MWRB.CALENDAR_BASED_FLAG CALENDAR_BASED_FLAG, MWRB.METER_BASED_FLAG METER_BASED_FLAG, MWRB.CONDITION_BASED_FLAG CONDITION_BASED_FLAG, MWRB.DAY_BASED_FLAG DAY_BASED_FLAG, MWRB.NUMBER_OF_DAYS NUMBER_OF_DAYS, MWRB.NEXT_FORECAST_DUE_BY_CODE NEXT_FORECAST_DUE_BY_CODE, MWRB.ASSET_HISTORY_SERVICE_DATE ASSET_HISTORY_SERVICE_DATE, MWRB.ASSET_HISTORY_SERVICE_INTERVAL ASSET_HISTORY_SERVICE_INTERVAL, MWRB.ASSET_INCLUSION_TYPE_CODE ASSET_INCLUSION_TYPE_CODE, MWRB.SCHEDULE_PATTERN_ID SCHEDULE_PATTERN_ID, MWRB.ACTIVE_START_DATE ACTIVE_START_DATE, MWRB.ACTIVE_END_DATE ACTIVE_END_DATE, MWRB.SUPPRESS_MERGE_CODE SUPPRESS_MERGE_CODE, MWRB.SUPPRESS_MERGE_OVERRIDE_FLAG SUPPRESS_MERGE_OVERRIDE_FLAG, MWRB.LAST_FORECAST_DATE LAST_FORECAST_DATE, MWRB.MODIFIED_FLAG MODIFIED_FLAG, MWRB.NEXT_WORK_ORDER_ONLY_FLAG NEXT_WORK_ORDER_ONLY_FLAG, MWRB.FORECAST_WINDOW_IN_DAYS FORECAST_WINDOW_IN_DAYS, MWRB.WORK_ORDER_WINDOW_IN_DAYS WORK_ORDER_WINDOW_IN_DAYS, MWRB.REQUIREMENT_REFERENCE REQUIREMENT_REFERENCE, MWRB.REQUIREMENT_REFERENCE_ID REQUIREMENT_REFERENCE_ID, MWRB.CREATE_WORK_ORDER_OPTION_CODE CREATE_WORK_ORDER_OPTION_CODE, MWRB.WORK_ORDER_STATUS_ID WORK_ORDER_STATUS_ID, MWRB.WORK_ORDER_PRIORITY WORK_ORDER_PRIORITY, MWRB.FIRM_PLANNED_FLAG FIRM_PLANNED_FLAG, MWRB.CREATED_BY CREATED_BY, MWRB.CREATION_DATE CREATION_DATE, MWRB.LAST_UPDATED_BY LAST_UPDATED_BY, MWRB.LAST_UPDATE_DATE LAST_UPDATE_DATE, MWRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MWRB.REQUEST_ID REQUEST_ID, MWRB.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, MWRB.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE FROM MNT_WORK_REQUIREMENTS_B MWRB, MNT_WORK_REQUIREMENTS_TL MWRTL WHERE MWRTL.REQUIREMENT_ID = MWRB.REQUIREMENT_ID AND MWRTL.LANGUAGE = USERENV('LANG')