DROP TYPE QUERY_VDITEM_CMP99000_TABLE
/

DROP TYPE QUERY_VDITEM_CMP99000_TYPE
/

CREATE TYPE QUERY_VDITEM_CMP99000_TYPE AS
OBJECT(DSFILIAL          VARCHAR2(150),
       CDPRODUTO         VARCHAR2(10),
       NMPRODUTO         VARCHAR2(50),
       CDARVPROD         VARCHAR2(20),
       DSERRO            VARCHAR2(2000),
       NRORG             NUMERIC);
/

CREATE TYPE QUERY_VDITEM_CMP99000_TABLE AS TABLE OF QUERY_VDITEM_CMP99000_TYPE
/
