DROP TYPE QUERY_FILIAL_DFS48000_TABLE
/

DROP TYPE QUERY_FILIAL_DFS48000_TYPE
/

CREATE TYPE QUERY_FILIAL_DFS48000_TYPE AS
OBJECT(IDCHECK          VARCHAR2(1),
       CDFILIAL         VARCHAR2(21),
       DSFILIAL         VARCHAR2(50),
       CDEMPRESA        VARCHAR2(2),
       CDSERIE          VARCHAR2(5),
       IDSTATUS         VARCHAR2(1),
       NRAUTOFORN       VARCHAR2(10),
       USR_NRPEDIDO     VARCHAR2(10),
       CDFILDEST        VARCHAR2(4),
       CDFILLANC        VARCHAR2(4),
       IDSTATUSE        VARCHAR2(1),
       IDPGTOFRETE      VARCHAR2(1),
       IDTPIJURTRAN     VARCHAR2(1),
       NRINSJURTRAN     VARCHAR2(20),
       USR_NMROTATRANS  VARCHAR2(50),
       CDLOTENVITOL     VARCHAR2(10),
       COUNT_IDSTATUSE  FLOAT,
       COUNT_IDSTATUS   FLOAT);
/

CREATE TYPE QUERY_FILIAL_DFS48000_TABLE AS TABLE OF QUERY_FILIAL_DFS48000_TYPE
/