CREATE OR REPLACE FORCE VIEW "AB03B"."AB03B14V00" ("ID014", "FACTU014", "USUA014", "FREGSAL014", "NREGSAL014", "FNOTIF014", "FEXPIR014", "FTRAMITACION014", "ID010NUMEXP", "IDANO010", "ID001FASE", "ID002TRAMITE", "IDPROV010", "TRAMITEES", "TRAMITEEU", "TIPOTRAMITE", "FASEES", "FASEEU", "IDESTADO", "ESTADOES", "ESTADOEU", "OBSERVACIONES014") AS 
  SELECT t1.ID_014 ID014, t1.F_ACTU_014 FACTU014, t1.USUA_014 USUA014, t1.F_REG_SAL_014 FREGSAL014, t1.N_REG_SAL_014 NREGSAL014, 
t1.F_NOTIF_014 FNOTIF014, t1.F_EXPIR_014 FEXPIR014, 
t1.F_TRAMITACION_014 FTRAMITACION014, 
t1.ID_010_NUM_EXP ID010NUMEXP, t1.ID_ANO_010 IDANO010, 
t1.ID_001_FASE ID001FASE, t1.ID_002_TRAMITE ID002TRAMITE,t1.ID_PROV_010 IDPROV010, 
TRAMITES.DESC_ES_002 TRAMITEES, TRAMITES.DESC_EU_002 TRAMITEEU, TRAMITES.ENT_SAL_002 TIPOTRAMITE,
FASES.DESC_ES_001 FASEES, FASES.DESC_EU_001 FASEEU, ESTADOS.ID_034 IDESTADO, 
ESTADOS.DESC_ES_034 ESTADOES, ESTADOS.DESC_EU_034 ESTADOEU, t1.OBSERVACIONES_014 
FROM AB03B14T00 t1 
INNER JOIN AB03B01T00 FASES ON FASES.ID_001 = t1.ID_001_FASE 
INNER JOIN AB03B02T00 TRAMITES ON TRAMITES.ID_001_FASE = t1.ID_001_FASE AND TRAMITES.ID_002 = t1.ID_002_TRAMITE
INNER JOIN AB03B34T00 ESTADOS ON ESTADOS.ID_034 = t1.ID_034_ESTADO
ORDER BY t1.ID_014 DESC;