CREATE TYPE QUERY_ITEM_GER15900_TYPE AS
OBJECT(CDFILSOLI         VARCHAR2(4),
       CDPRODUTO         VARCHAR2(10),
       NRSOLICMP         VARCHAR2(20),
       CDALMOXARIFE      VARCHAR2(6),
       CDLOCALESTOQ      VARCHAR2(6),
       CDARVPROD         VARCHAR2(20),
       NMPRODUTO         VARCHAR2(50),
       NMFILIAL          VARCHAR2(30),
       SGUNIDADE         VARCHAR2(10),
       CDFILSOLCONS      VARCHAR2(10),
       NRLOTEESTQ        VARCHAR2(40),
       IDASTERISCO       VARCHAR2(1),
       NRSUBLOTE         VARCHAR2(4),
       NMFILIALCONS      VARCHAR2(30),
       CDPRODINI         VARCHAR2(20),
       CDPRODFIN         VARCHAR2(20),
       DTINI             DATE,
       DTFIN             DATE,
       DTPROGENTR        DATE,
       DTVALILOTE        DATE,
       QTSEPARAR         FLOAT,
       QTESTOQDIA        FLOAT,
       QTSOLIPROD        FLOAT,
       QTESTRETIRAR      FLOAT);
/