CREATE TYPE QRY_ITEMSOLI_CMP06900_W_TYPE AS
OBJECT(CALC            VARCHAR2(1),
       CDFILSOLI       VARCHAR2(4),
       CDFILLAN        VARCHAR2(4),
       NRSOLICMP       VARCHAR2(10),
       CDPRODUTO       VARCHAR2(10),
       CDARVPROD       VARCHAR2(20),
       NMPRODUTO       VARCHAR2(50),
       SGUNIDADE       VARCHAR2(10),
       NRSEQUCONSOL    VARCHAR2(10),
       IDUTPRORIGOBRIG VARCHAR2(1),
       IDTIPLAN        VARCHAR2(1),
       SOLICITANTE     VARCHAR2(100),
       LANCAMENTO      VARCHAR2(100),
       PRODUTO         VARCHAR2(100),
       STATUS          VARCHAR2(4),
       IDUTILCONSSOLIOL VARCHAR2(1),
       DSJUSTOPER      VARCHAR2(100),
       IDFUNCAOFILI    VARCHAR2(1),
       NMMARCA         VARCHAR2(20),
       ALTERADO        VARCHAR2(1),
       IDUTAPROVSOL    VARCHAR2(1),
       IDPERALTSAPR    VARCHAR2(3),
       IDSOLIAPROV     VARCHAR2(1),
       TXOBSITMSOL     VARCHAR2(2000),
       CDPRODORIG      VARCHAR2(10),
       CDFILIOPELOG    VARCHAR2(4),
       CDMARCA         VARCHAR2(5),
       DTCMPANTERIOR   DATE,
       DTUTILIZA       DATE,
       DTPROGENTR      DATE,
       DTSOLCMP        DATE,
       QTSOLIORIG      FLOAT,
       QTSOLIPROD      FLOAT,
       QTSOLIPRODBKP   FLOAT,
       CDRASTRITM      NUMERIC,
       NRORG           NUMERIC,
       VRCMPANTERIOR   FLOAT,
       QTVOLUITEMSO    FLOAT);
/