CREATE TYPE PROD_NAO_CMP_PART_TYPE AS OBJECT (
   CDFILIAL       VARCHAR2(4),
   NMFILIAL       VARCHAR2(30),
   SGESTADO       VARCHAR2(2),       
   DTINICIAL      DATE,
   DTFINAL        DATE,
   CDOPERADOR     VARCHAR2(12),
   NMOPERADOR     VARCHAR2(40),
   CDARVPROD      VARCHAR2(20),
   NMPRODUTO      VARCHAR2(50),
   CDREGIAO       VARCHAR2(3),
   NMREGIAO       VARCHAR2(30),
   IDSITUCOLETA   CHAR(1),
   REFORFIL       CHAR(1),
   IDAPRMARPRO    CHAR(1),
   CDQUALIF       CHAR(1),
   QFOPRODFORN    CHAR(1),
   PRCMPFILI      CHAR(1),
   PRNCMP         CHAR(1),
   REFOREG        CHAR(1),
   COTADO         CHAR(1),
   PARTFILI       VARCHAR2(8000),
   CDMARCA        VARCHAR2(8000),
   CDFORNECED     VARCHAR2(8000),
   DTINICOT       DATE,
   DTFINCOT       DATE,
   DESCPARTIC     VARCHAR2(8000),
   DESCINCONSIST  VARCHAR2(8000),
   NRORG          NUMBER)
/