CREATE TABLE mnt_programs_ext (
    DATA_ROW_ID                   NUMBER(18, 0) ,
    RUN_ID                        NUMBER(18, 0)     NOT NULL,
    ORGANIZATION_ID               NUMBER(18, 0) ,
    ORGANIZATION_CODE             VARCHAR2(72)  ,
    PROGRAM_ID                    NUMBER(18, 0) ,
    PROGRAM_OVN                   NUMBER(9, 0)  ,
    PROGRAM_CODE                  VARCHAR2(120) ,
    PROGRAM_NAME                  VARCHAR2(480) ,
    LAST_FORECAST_DATE            DATE          ,
    REQUIREMENT_ID                NUMBER(18, 0) ,
    REQUIREMENT_OVN               NUMBER(9, 0)  ,
    REQUIREMENT_NAME              VARCHAR2(480) ,
    ASSET_ITEM_ID                 NUMBER(18, 0) ,
    ASSET_ITEM_NUMBER             VARCHAR2(1200),
    ASSET_ID                      NUMBER(18, 0) ,
    ASSET_NUMBER                  VARCHAR2(320) ,
    RELIABILITY_RATE              NUMBER        ,
    FORECAST_USING_CYCLE_FLAG     VARCHAR2(4)   ,
    INTERVALS_IN_THE_CYCLE        NUMBER        ,
    CALENDAR_BASED_FLAG           VARCHAR2(4)   ,
    METER_BASED_FLAG              VARCHAR2(4)   ,
    SCHEDULE_PATTERN_ID           NUMBER(18, 0) ,
    SCHEDULE_PATTERN_NAME         VARCHAR2(480) ,
    SCHEDULE_DURATION             NUMBER        ,
    SCHEDULE_DURATION_UOM_CODE    VARCHAR2(12)  ,
    REQUIREMENT_METER_ID          NUMBER(18, 0) ,
    METER_ID                      NUMBER(18, 0) ,
    METER_NAME                    VARCHAR2(480) ,
    METER_DEFINITION_ID           NUMBER(18, 0) ,
    BASE_INTERVAL                 NUMBER        ,
    BASE_INTERVAL_UOM_CODE        VARCHAR2(12)  ,
    NEXT_FORECAST_DUE_BY_CODE     VARCHAR2(120) ,
    REQUIREMENT_WD_ID             NUMBER(18, 0) ,
    DUE_AT_CYCLE_INTERVAL         NUMBER        ,
    REPEATS_IN_CYCLE_FLAG         VARCHAR2(4)   ,
    WORK_DEFINITION_ID            NUMBER(18, 0) ,
    WORK_DEFINITION_CODE          VARCHAR2(120) ,
    WORK_DEFINITION_NAME          VARCHAR2(480) ,
    WD_OPERATION_ID               NUMBER(18, 0) ,
    WD_OPERATION_NAME             VARCHAR2(480) ,
    WD_OPERATION_SEQ_NUMBER       NUMBER        ,
    WORK_CENTER_ID                NUMBER(18, 0) ,
    WORK_CENTER_CODE              VARCHAR2(120) ,
    WORK_CENTER_NAME              VARCHAR2(480) ,
    WD_OPERATION_MATERIAL_ID      NUMBER(18, 0) ,
    MATERIAL_SEQ_NUMBER           NUMBER        ,
    MATERIAL_ITEM_ID              NUMBER(18, 0) ,
    MATERIAL_ITEM_NUMBER          VARCHAR2(1200),
    MATERIAL_QUANTITY             NUMBER        ,
    MATERIAL_UOM_CODE             VARCHAR2(12)  ,
    UTILIZATION_RATE              NUMBER        ,
    MP_CREATION_DATE              TIMESTAMP(6)  ,
    MP_LAST_UPDATE_DATE           TIMESTAMP(6)  ,
    CREATED_BY                    VARCHAR2(256)     NOT NULL,
    CREATION_DATE                 TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY               VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE              TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN             VARCHAR2(128) ,
    REQUEST_ID                    NUMBER(18, 0) ,
    JOB_DEFINITION_NAME           VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE        VARCHAR2(3600),
    DATA_ROW_ID                   NUMBER(18, 0) ,
    RUN_ID                        NUMBER(18, 0)     NOT NULL,
    ORGANIZATION_ID               NUMBER(18, 0) ,
    ORGANIZATION_CODE             VARCHAR2(72)  ,
    PROGRAM_ID                    NUMBER(18, 0) ,
    PROGRAM_OVN                   NUMBER(9, 0)  ,
    PROGRAM_CODE                  VARCHAR2(120) ,
    PROGRAM_NAME                  VARCHAR2(480) ,
    LAST_FORECAST_DATE            DATE          ,
    REQUIREMENT_ID                NUMBER(18, 0) ,
    REQUIREMENT_OVN               NUMBER(9, 0)  ,
    REQUIREMENT_NAME              VARCHAR2(480) ,
    ASSET_ITEM_ID                 NUMBER(18, 0) ,
    ASSET_ITEM_NUMBER             VARCHAR2(1200),
    ASSET_ID                      NUMBER(18, 0) ,
    ASSET_NUMBER                  VARCHAR2(320) ,
    RELIABILITY_RATE              NUMBER        ,
    FORECAST_USING_CYCLE_FLAG     VARCHAR2(4)   ,
    INTERVALS_IN_THE_CYCLE        NUMBER        ,
    CALENDAR_BASED_FLAG           VARCHAR2(4)   ,
    METER_BASED_FLAG              VARCHAR2(4)   ,
    SCHEDULE_PATTERN_ID           NUMBER(18, 0) ,
    SCHEDULE_PATTERN_NAME         VARCHAR2(480) ,
    SCHEDULE_DURATION             NUMBER        ,
    SCHEDULE_DURATION_UOM_CODE    VARCHAR2(12)  ,
    REQUIREMENT_METER_ID          NUMBER(18, 0) ,
    METER_ID                      NUMBER(18, 0) ,
    METER_NAME                    VARCHAR2(480) ,
    METER_DEFINITION_ID           NUMBER(18, 0) ,
    BASE_INTERVAL                 NUMBER        ,
    BASE_INTERVAL_UOM_CODE        VARCHAR2(12)  ,
    NEXT_FORECAST_DUE_BY_CODE     VARCHAR2(120) ,
    REQUIREMENT_WD_ID             NUMBER(18, 0) ,
    DUE_AT_CYCLE_INTERVAL         NUMBER        ,
    REPEATS_IN_CYCLE_FLAG         VARCHAR2(4)   ,
    WORK_DEFINITION_ID            NUMBER(18, 0) ,
    WORK_DEFINITION_CODE          VARCHAR2(120) ,
    WORK_DEFINITION_NAME          VARCHAR2(480) ,
    WD_OPERATION_ID               NUMBER(18, 0) ,
    WD_OPERATION_NAME             VARCHAR2(480) ,
    WD_OPERATION_SEQ_NUMBER       NUMBER        ,
    WORK_CENTER_ID                NUMBER(18, 0) ,
    WORK_CENTER_CODE              VARCHAR2(120) ,
    WORK_CENTER_NAME              VARCHAR2(480) ,
    WD_OPERATION_MATERIAL_ID      NUMBER(18, 0) ,
    MATERIAL_SEQ_NUMBER           NUMBER        ,
    MATERIAL_ITEM_ID              NUMBER(18, 0) ,
    MATERIAL_ITEM_NUMBER          VARCHAR2(1200),
    MATERIAL_QUANTITY             NUMBER        ,
    MATERIAL_UOM_CODE             VARCHAR2(12)  ,
    UTILIZATION_RATE              NUMBER        ,
    CREATED_BY                    VARCHAR2(256)     NOT NULL,
    CREATION_DATE                 TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY               VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE              TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN             VARCHAR2(128) ,
    REQUEST_ID                    NUMBER(18, 0) ,
    JOB_DEFINITION_NAME           VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE        VARCHAR2(3600),
    MP_CREATION_DATE              TIMESTAMP(6)  ,
    MP_LAST_UPDATE_DATE           TIMESTAMP(6)  ,
    CONSTRAINT pk_mnt_programs_ext PRIMARY KEY (DATA_ROW_ID, DATA_ROW_ID)
);
