DROP TYPE QUERY_VDITEM1_CMP99000_TABLE
/

DROP TYPE QUERY_VDITEM1_CMP99000_TYPE
/

CREATE TYPE QUERY_VDITEM1_CMP99000_TYPE AS
OBJECT(DSFILIAL          VARCHAR2(150),
       CDFILSOLI         VARCHAR2(4),
       CDPRODUTO         VARCHAR2(10),
       NMPRODUTO         VARCHAR2(50),
       CDARVPROD         VARCHAR2(20),
       DSERRO            VARCHAR2(2000),
       CDFORNECED        VARCHAR2(21),
       IDTPIJURFORN      VARCHAR2(1),
       NRINSJURFORN      VARCHAR2(20),
       NMRAZSOCFORN      VARCHAR2(100),
       NMFANTFORN        VARCHAR2(40),
       POSICAO           VARCHAR2(10));

/

CREATE TYPE QUERY_VDITEM1_CMP99000_TABLE AS TABLE OF QUERY_VDITEM1_CMP99000_TYPE
/