DROP TYPE RESUMO_ROP_TABLE
/

DROP TYPE RESUMO_ROP_TYPE
/

CREATE TYPE RESUMO_ROP_TYPE AS
OBJECT (NRRESUMO_ROP        NUMBER,
        DSFILIAL            VARCHAR2(40),
        DSMODELO            VARCHAR2(03),
        NRTOPICO            FLOAT,
        DSDESCRICAOTOP      VARCHAR2(50),
        VRREAL              FLOAT(126),
        VRPERREAL           FLOAT(126),
        VRPROJECAO          FLOAT(126),
        VRPERPROJECAO       FLOAT(126),
        VRPROJMANUAL        FLOAT(126),
        VRPERPROJMANUAL     FLOAT(126),
        VRORCADO            FLOAT(126),
        VRPERORCADO         FLOAT(126),
        NRORDEM             NUMBER,
        NRORG               NUMBER,
        NRPROJECAOMANUALROP NUMBER)
/

CREATE TYPE RESUMO_ROP_TABLE AS
TABLE OF RESUMO_ROP_TYPE
/
