ALTER TABLE DE_DOCUMENTOS_SOLICITADOS 
ADD( DE20_FLAG_REPETIDO NUMERIC(1)    DEFAULT 0    NOT NULL)
ALTER TABLE DE_DOCUMENTOS_SOLICITADOS 
MODIFY DE20_FLAG_REPETIDO DEFAULT    NULL

CREATE SEQUENCE DE14_ID_VALOR_TEMP 
  MINVALUE 1 
  INCREMENT BY 1
CREATE TABLE DE_TABLA_VALORES_TEMPORALES ( 
  DE14_ID_VALOR_TEMP NUMERIC(11)    NOT NULL, 
  DE14_ID_EMPRESA    NUMERIC(11)    NOT NULL, 
  DE14_PANTALLA      NVARCHAR2(40)    NOT NULL,
  DE14_USUARIO		 NVARCHAR2(40)    NOT NULL,
  DE14_EXTRA		 NVARCHAR2(200)    NOT NULL,
  DE14_VALOR         NCLOB    NOT NULL, 
     PRIMARY KEY ( DE14_ID_VALOR_TEMP ))
CREATE OR REPLACE TRIGGER AN$175DE14_ID_VALOR_TEMP 
  BEFORE INSERT ON DE_TABLA_VALORES_TEMPORALES 
  FOR EACH ROW 
BEGIN 
  SELECT DE14_ID_VALOR_TEMP.NEXTVAL 
  INTO   :new.DE14_ID_VALOR_TEMP 
  FROM   DUAL; 
END;

CREATE SEQUENCE DE16_ID_PROVEEDOR 
  MINVALUE 1 
  INCREMENT BY 1
CREATE TABLE DE_PROVEEDORES ( 
  DE16_ID_PROVEEDOR NUMERIC(11)    NOT NULL, 
  DE16_DOCUMENTO    NVARCHAR2(40)    NOT NULL, 
  DE16_NOMBRES      NVARCHAR2(100)    NOT NULL, 
  DE16_APELLIDOS    NVARCHAR2(100)    NOT NULL, 
  DE16_CORREO       NVARCHAR2(100)    NOT NULL, 
  DE16_TELEFONO     NVARCHAR2(40)    NOT NULL, 
  DE16_ESTADO       NVARCHAR2(40)    NOT NULL, 
  DE02_ID_EMPRESA   NUMERIC(11)    NOT NULL, 
  DE16_ID_CLIENTE   NUMERIC(11)    NOT NULL, 
  DE16_TARJETA      NVARCHAR2(40)    NOT NULL, 
  DE16_MONTO        NUMERIC(18)    NOT NULL, 
     PRIMARY KEY ( DE16_ID_PROVEEDOR ))
CREATE OR REPLACE TRIGGER AN$180DE16_ID_PROVEEDOR 
  BEFORE INSERT ON DE_PROVEEDORES 
  FOR EACH ROW 
BEGIN 
  SELECT DE16_ID_PROVEEDOR.NEXTVAL 
  INTO   :new.DE16_ID_PROVEEDOR 
  FROM   DUAL; 
END;
CREATE INDEX IDE_PROVEEDORES1 ON DE_PROVEEDORES ( 
      DE02_ID_EMPRESA)