DROP TYPE QUERY_DETALHE_CMP99000_TABLE
/

DROP TYPE QUERY_DETALHE_CMP99000_TYPE
/

CREATE TYPE QUERY_DETALHE_CMP99000_TYPE AS
OBJECT(NRSEQUENCIAL      VARCHAR2(300),
       INSCRICAODEST     VARCHAR2(100),
       DSDESTINATARIO    VARCHAR2(500),
       CDARVPROD         VARCHAR2(20),
       NMPRODUTO         VARCHAR2(50),
       CDMARCA           VARCHAR2(5),
       DSMARCA           VARCHAR2(40),
       STATUS            VARCHAR2(10),
       CHAVE             VARCHAR2(30),
       DTENTREGA         DATE,
       QUANTIDADE        FLOAT,
       PRECO             FLOAT);
/

CREATE TYPE QUERY_DETALHE_CMP99000_TABLE AS TABLE OF QUERY_DETALHE_CMP99000_TYPE
/