DROP TYPE RESUMO_GOP_TABLE
/

DROP TYPE RESUMO_GOP_TYPE
/

CREATE TYPE RESUMO_GOP_TYPE AS
OBJECT (NRRESUMO_GOP        NUMBER,
        DSDESCRICAO         VARCHAR2(100),
        NRTOPICO            VARCHAR2(10),
        DSDESCRICAOTOP      VARCHAR2(50),
        DTORCAMENTO         DATE,
        VRORCADO            FLOAT(126),
        VRPERORCADO         FLOAT(126),
        VRREALIZADO         FLOAT(126),
        VRPERREALIZADO      FLOAT(126),
        VRSALDO             FLOAT(126),
        VRPERSALDO          FLOAT(126),
        VRACUMULADO         FLOAT(126),
        NRORDEM             NUMBER,
        IDSTATUS            VARCHAR2(30),
        NRORG               NUMBER)
/

CREATE TYPE RESUMO_GOP_TABLE AS
TABLE OF RESUMO_GOP_TYPE
/