CREATE OR REPLACE FORCE VIEW "MIS_MACROREGIAO" ("CDMACROREGIAO", "NMMACROREGIAO") AS 
SELECT '100' CDMACROREGIAO, 'INDUSTRIA SERVICOS' NMMACROREGIAO FROM DUAL
UNION 
SELECT '200' CDMACROREGIAO, 'ADM-FINANCEIRO' NMMACROREGIAO FROM DUAL
UNION 
SELECT '300' CDMACROREGIAO, 'DISTRITO NORTE' NMMACROREGIAO FROM DUAL  
UNION 
SELECT '301' CDMACROREGIAO, 'DISTRITO NORDESTE' NMMACROREGIAO FROM DUAL --301/302
UNION 
SELECT '305' CDMACROREGIAO, 'DISTRITO CENTRO-OESTE' NMMACROREGIAO FROM DUAL --305/306
UNION 
SELECT '307' CDMACROREGIAO, 'DISTRITO SUDESTE (ES-MG-RJ)' NMMACROREGIAO FROM DUAL --307/308
UNION 
SELECT '309' CDMACROREGIAO, 'DISTRITO SP CAPITAL' NMMACROREGIAO FROM DUAL --309/310
UNION 
SELECT '311' CDMACROREGIAO, 'DISTRITO SP INTERIOR' NMMACROREGIAO FROM DUAL --311/312
UNION 
SELECT '313' CDMACROREGIAO, 'DISTRITO SUL' NMMACROREGIAO FROM DUAL --313/314
UNION 
SELECT '350' CDMACROREGIAO, 'EXPORTACAO' NMMACROREGIAO FROM DUAL
UNION 
SELECT '380' CDMACROREGIAO, 'CARGA E DESCARGA' NMMACROREGIAO FROM DUAL
UNION 
SELECT '390' CDMACROREGIAO, 'ADM DE VENDAS' NMMACROREGIAO FROM DUAL;
/

-- VERSAO --
BEGIN ATUVEROBJ('MIS_MACROREGIAO','6.35.040'); END;
/
