DROP TYPE APURCONS_ROP_TABLE
/

DROP TYPE APURCONS_ROP_TYPE
/

CREATE TYPE APURCONS_ROP_TYPE AS
OBJECT (NRAPURCONS_ROP      NUMBER,
        DSDESCCONS          VARCHAR2(50),
        CDGRUPPROD          VARCHAR2(10),
        NMGRUPPROD          VARCHAR2(40),
        CDSUBGRUPPROD       VARCHAR2(10),
        NMSUBGRPROD         VARCHAR2(100),
        VRESTOQINI          FLOAT(126),
        VRIMPLAEST          FLOAT(126),
        VRENTRCOMP          FLOAT(126),
        VROUTRENTR          FLOAT(126),
        VRCONTRANS          FLOAT(126),
        VRAJUSTES           FLOAT(126),
        VRSAIDDEVO          FLOAT(126),
        VROUTRSAID          FLOAT(126),
        VRRETIAJUS          FLOAT(126),
        VRESTOQFIN          FLOAT(126),
        VRCMV               FLOAT(126),        
        VRCONSUMO           FLOAT(126),
        VRBAIXESTO          FLOAT(126),
        VRDIFCMVCONS        FLOAT(126),        
        NRORG               NUMBER)
/

CREATE TYPE APURCONS_ROP_TABLE AS
TABLE OF APURCONS_ROP_TYPE
/