CREATE TABLE fnd_views (
    VIEW_ID                   NUMBER(18, 0) ,
    VIEW_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) ,
    DESCRIPTION               VARCHAR2(4000),
    TEXT                      CLOB          ,
    STATUS                    VARCHAR2(120) ,
    SELECT_ALLOWED            VARCHAR2(4)       NOT NULL,
    READ_ALLOWED              VARCHAR2(4)       NOT NULL,
    INSERT_ALLOWED            VARCHAR2(4)       NOT NULL,
    UPDATE_ALLOWED            VARCHAR2(4)       NOT NULL,
    DELETE_ALLOWED            VARCHAR2(4)       NOT NULL,
    FLASHBACK_ALLOWED         VARCHAR2(4)       NOT NULL,
    ORA_EDITION_CONTEXT       VARCHAR2(120) ,
    VIEW_ID                   NUMBER(18, 0) ,
    VIEW_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) ,
    DESCRIPTION               VARCHAR2(4000),
    TEXT                      CLOB          ,
    STATUS                    VARCHAR2(120) ,
    SELECT_ALLOWED            VARCHAR2(4)       NOT NULL,
    INSERT_ALLOWED            VARCHAR2(4)       NOT NULL,
    UPDATE_ALLOWED            VARCHAR2(4)       NOT NULL,
    DELETE_ALLOWED            VARCHAR2(4)       NOT NULL,
    FLASHBACK_ALLOWED         VARCHAR2(4)       NOT NULL,
    ORA_EDITION_CONTEXT       VARCHAR2(120) ,
    READ_ALLOWED              VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_fnd_views PRIMARY KEY (VIEW_ID, ORA_EDITION_CONTEXT, VIEW_ID, ORA_EDITION_CONTEXT)
);
