DROP TYPE SELECTPEDCOLETA_TABLE
/

DROP TYPE SELECTPEDCOLETA_TYPE
/

CREATE TYPE SELECTPEDCOLETA_TYPE AS OBJECT
(
    IDORDPLCOT       VARCHAR2(1),
    IDPRODINCLFOR    VARCHAR2(1),
    CDFILIAL         VARCHAR2(4),
    VRPRECREN        FLOAT,
    NRPEDIDOCOL      VARCHAR2(10),
    QTDISPPRODMARC   FLOAT,
    VRPRECUNIPRMARC  FLOAT,
    VRULTPRECPRMARC  FLOAT,
    VRPRECOOBJETIVO  FLOAT,
    DSOBSRENEGOCIA   VARCHAR2(2000),
    IDITPEDPRIONEG   VARCHAR2(1),
    NRORG            NUMBER,
    CDPRODUTO        VARCHAR2(10),
    CDARVPROD        VARCHAR2(20),
    NMPRODUTO        VARCHAR2(200),
    CDPRODESTO       VARCHAR2(10),
    SGUNIDADE        VARCHAR2(10),
    DSOBSNUTR        VARCHAR2(500),
    CDMARCA          VARCHAR2(5),
    NMMARCA          VARCHAR2(200),
    VRPERVARPREPRFO  FLOAT,
    VRPERVARDESCPRFO FLOAT,
    QTPRODPEDCOL     FLOAT,
    IDITEMPEDCOLALT  VARCHAR2(1),
    VRPERDESPEDCOL   FLOAT,
    IDRENEGOCIAPCOL  VARCHAR2(1),
    QTDIASPRAZOEXPED FLOAT,
    VRMINFORNREG     FLOAT,
    QTMINFORNREG     FLOAT,
    CDARVPRODOL      VARCHAR2(20),
    NMPRODUTOOL      VARCHAR2(200)
)
/

CREATE TYPE SELECTPEDCOLETA_TABLE AS TABLE OF SELECTPEDCOLETA_TYPE
/