DROP TYPE MYM_QTDE_REPOSTAS_TABLE
/

DROP TYPE MYM_QTDE_REPOSTAS_TYPE
/


CREATE TYPE MYM_QTDE_REPOSTAS_TYPE AS OBJECT
  (CDFILIAL           VARCHAR(4),
   NMFILIAL           VARCHAR2(2000),
   NRLOCALPESQ        NUMBER,
   NMLOCALPESQ        VARCHAR(2000),
   NRTURNOLOCALPESQ   NUMBER,
   IDAPLICATIVO       VARCHAR2(30),
   NRQUESTIONARIO     NUMBER,
   NMQUESTIONARIO     VARCHAR2(2000),
   DATARESPOSTA       DATE,
   NRQUESTAOANTERIOR  NUMBER,
   TXQUESTAOANTERIOR  VARCHAR2(2000),
   NRRESPOSTAANTERIOR NUMBER,
   DSRESPOSTAANTERIOR VARCHAR2(2000),
   NRORDEM            NUMBER,
   NRORDEMQUESTAO     VARCHAR2(2000),   
   NRQUESTAO          NUMBER,
   TXQUESTAO          VARCHAR2(2000),
   VRPESOQUESTAO      NUMBER,
   NRORDENARESPOST    NUMBER,
   NRRESPOSTA         NUMBER,
   DSRESPOSTA         VARCHAR2(2000),
   VRPESORESPOSTA     NUMBER,
   NRPROXIMAQUESTAO   NUMBER,
   QTDE_EXECUCAO      NUMBER,
   QTDE_QUESTAO       NUMBER,
   QTDE_RESPOSTA      NUMBER,
   IDTIPORESPOSTA     VARCHAR2(30)
  )
/

CREATE TYPE MYM_QTDE_REPOSTAS_TABLE AS TABLE OF MYM_QTDE_REPOSTAS_TYPE
/
