CREATE TYPE CURVA_ABC_PROD_FORN_CMP_TYPE AS
OBJECT(LISTA_REGIAO     VARCHAR2(1000),
       CDREGIAO         VARCHAR2(3),
       NMREGIAO         VARCHAR2(30),
       LISTA_FILIAL     VARCHAR2(1000),
       CDFILIAL         VARCHAR2(4),
       NMFILIAL         VARCHAR2(30),
       LISTA_GRUPFILI   VARCHAR2(1000),
       CDPRODUTO        VARCHAR2(10),
       CDARVPROD        VARCHAR2(20),
       NMPRODUTO        VARCHAR2(50),
       SGUNIDADE        VARCHAR2(10),
       DTENTRINI        DATE,
       DTENTRFIN        DATE,
       DTGERAINI        DATE,
       DTGERAFIN        DATE,
       CDPRODINICIAL    VARCHAR2(20),
       NMDPRODINICIAL   VARCHAR2(50),
       CDPRODFINAL      VARCHAR2(20),
       NMPRODFINAL      VARCHAR2(50),
       CDOPERADOR       VARCHAR2(12),
       NMOPERADOR       VARCHAR2(40),
       CDFORNECED       VARCHAR2(21),
       NRINSJURFORN     VARCHAR2(20),
       IDTPIJURFORN     VARCHAR2(1),
       NMRAZSOCFORN     VARCHAR2(100),
       NMFANTFORN       VARCHAR2(250),
       CDGRUPPROD       VARCHAR2(10),
       NMGRUPPROD       VARCHAR2(40),
       TIPOCURVA        VARCHAR2(1),
       CDOPERGESTOR     VARCHAR2(12),
       NMOPERGESTOR     VARCHAR2(40),
       EXIBE_PROD       VARCHAR2(1),
       RELATORIO        VARCHAR2(1),

       QTTOT            FLOAT,
       VRMED            FLOAT,
       VRTOT            FLOAT,
       VRPERCENTG       FLOAT,
       VRPECURVA        FLOAT,
       VRTOTCURVA       FLOAT,
       VRTOTG           FLOAT,
       VRTOTPROD        FLOAT,
       VRCUSTO          FLOAT)
/