DROP TYPE INCONSISTENCIA_AF_TABLE
/

DROP TYPE INCONSISTENCIA_AF_TYPE
/

CREATE TYPE INCONSISTENCIA_AF_TYPE AS OBJECT(
   NRORG       NUMBER,
   CDFILDEST   VARCHAR2(4),
   CDFILLANC   VARCHAR2(4),
   NRAUTOFORN  VARCHAR2(10),
   CDPRODUTO   VARCHAR2(10),
   CDMARCA     VARCHAR2(1000),
   DTPROGENTAF DATE,
   CDFORNECED  VARCHAR2(2000),
   CDERRO      VARCHAR2(5),
   VRLIMITE    FLOAT,
   VRERROR     FLOAT
)
/

CREATE TYPE INCONSISTENCIA_AF_TABLE AS TABLE OF INCONSISTENCIA_AF_TYPE
/