DROP TYPE QRY_PROD_FILIAL_OL_TABLE
/

DROP TYPE QRY_PROD_FILIAL_OL_TYPE
/

CREATE TYPE QRY_PROD_FILIAL_OL_TYPE AS OBJECT
  (CDFILIOPELOG   VARCHAR2(4),
   NMFILIALOL     VARCHAR2(30),
   CDFILIAL       VARCHAR2(4),
   NMFILIAL       VARCHAR2(30),
   CDPRODUTO      VARCHAR2(10),
   CDARVPROD      VARCHAR2(20),
   NMPRODUTO      VARCHAR2(50),
   SGUNIDADE      VARCHAR2(10),
   CDGRUPPROD     VARCHAR2(10),
   CDSUBGRPROD    VARCHAR2(10),
   CDFILISUBGR    VARCHAR2(1),
   NMSUBGRPROD    VARCHAR2(40),
   NRORG          NUMBER
  )
/

CREATE TYPE QRY_PROD_FILIAL_OL_TABLE AS TABLE OF QRY_PROD_FILIAL_OL_TYPE
/
