CREATE TABLE fnd_mviews (
    MVIEW_ID                  NUMBER(18, 0) ,
    MVIEW_NAME                VARCHAR2(120)     NOT NULL,
    APPLICATION_SHORT_NAME    VARCHAR2(200) ,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128)     NOT NULL,
    DESCRIPTION               VARCHAR2(4000),
    SHORT_NAME                VARCHAR2(120) ,
    TEXT                      CLOB          ,
    STATUS                    VARCHAR2(120) ,
    SELECT_ALLOWED            VARCHAR2(4)       NOT NULL,
    ORA_EDITION_CONTEXT       VARCHAR2(120) ,
    MVIEW_ID                  NUMBER(18, 0) ,
    MVIEW_NAME                VARCHAR2(120)     NOT NULL,
    APPLICATION_SHORT_NAME    VARCHAR2(200) ,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128)     NOT NULL,
    DESCRIPTION               VARCHAR2(4000),
    SHORT_NAME                VARCHAR2(120) ,
    TEXT                      CLOB          ,
    STATUS                    VARCHAR2(120) ,
    SELECT_ALLOWED            VARCHAR2(4)       NOT NULL,
    ORA_EDITION_CONTEXT       VARCHAR2(120) ,
    CONSTRAINT pk_fnd_mviews PRIMARY KEY (MVIEW_ID, ORA_EDITION_CONTEXT, MVIEW_ID, ORA_EDITION_CONTEXT)
);
