CREATE TABLE CRM_NOTIFICAPADRAO
(
   NRNOTIFICAPADRAO    NUMBER                 NOT NULL,
   IDNOTIFICAPADRAO    VARCHAR2(3)            NOT NULL
        CONSTRAINT CKC_394 CHECK (IDNOTIFICAPADRAO IN ('A01','A02','A03','A04','A05','A06','A07','A08','A09','A10','A11','A12','S01','S02','S03','S04','S05','S06','S07','S08','S09','S10')),
   DSNOTIFICAPADRAO    VARCHAR2(200)          NOT NULL,
   IDTIPODESTINATARIO  VARCHAR2(1)            NOT NULL
        CONSTRAINT CKC_396 CHECK (IDTIPODESTINATARIO IN ('A','S')),
   DSASNOTIFICAPADRAO  VARCHAR2(2000)         NULL    ,
   DSTXPADRAO          CLOB                   NULL    ,
   DSASPADRAO          VARCHAR2(2000)         NULL    ,
   DSTXNOTIFICAPADRAO  CLOB                   NULL    ,
   IDUSAPADRAO         VARCHAR2(1)            DEFAULT 'S' NOT NULL
        CONSTRAINT CKC_401 CHECK (IDUSAPADRAO IN ('N','S')),
   NRORG                       NUMBER DEFAULT 	 SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
   IDATIVO                    VARCHAR2(1)     DEFAULT 'S' NOT NULL
        CONSTRAINT CKC_IDATIVO_CRM_NOTIFICAPAD CHECK (IDATIVO IN ('S','N')),
   DTINCLUSAO             DATE                   NULL,
   DTULTATU                  DATE                  NULL,
   NRORGINCLUSAO      NUMBER             DEFAULT 1 NULL,
   CDOPERINCLUSAO    VARCHAR2(12)  DEFAULT '1' NULL,
   NRORGULTATU          NUMBER             DEFAULT 1 NULL,
   CDOPERULTATU        VARCHAR2(12)  DEFAULT '1',
        CONSTRAINT CRM_NOTIFICAPADRAO_PK PRIMARY KEY (NRNOTIFICAPADRAO)
)