 CREATE OR REPLACE FORCE VIEW "AB03B"."AB03B28V00" ("ID028", "FACTU028", "USUA028", "FREGSAL028", "NREGSAL028", "FNOTIF028", "FEXPIR028", "FTRAMITACION028", "ID024NUMEXP", "ID017FASE", "ID018TRAMITE", "IDPROV024", "IDANO024", "OBSERVACIONES028", "TRAMITEES", "TRAMITEEU", "TIPOTRAMITE", "FASEES", "FASEEU", "IDESTADO", "ESTADOES", "ESTADOEU") AS 
  SELECT t1.ID_028 ID028,
    t1.F_ACTU_028 FACTU028,
    t1.USUA_028 USUA028,
    t1.F_REG_SAL_028 FREGSAL028,
    t1.N_REG_SAL_028 NREGSAL028,
    t1.F_NOTIF_028 FNOTIF028,
    t1.F_EXPIR_028 FEXPIR028,
    t1.F_TRAMITACION_028 FTRAMITACION028,
    t1.ID_024_NUM_EXP ID024NUMEXP,
    t1.ID_017_FASE ID017FASE,
    t1.ID_018_TRAMITE ID018TRAMITE,
    t1.ID_PROV_024 IDPROV024,
	t1.ID_ANO_024 IDANO024,
	t1.OBSERVACIONES_028 OBSERVACIONES028,
    TRAMITES.DESC_ES_018 TRAMITEES,
    TRAMITES.DESC_EU_018 TRAMITEEU,
    TRAMITES.ENT_SAL_018 TIPOTRAMITE,
    FASES.DESC_ES_017 FASEES,
    FASES.DESC_EU_017 FASEEU,
    ESTADOS.ID_035 IDESTADO,
    ESTADOS.DESC_ES_035 ESTADOES,
    ESTADOS.DESC_EU_035 ESTADOEU
  FROM AB03B28T00 t1
  INNER JOIN AB03B17T00 FASES
  ON FASES.ID_017 = t1.ID_017_FASE
  INNER JOIN AB03B18T00 TRAMITES
  ON TRAMITES.ID_017_FASE = t1.ID_017_FASE
  AND TRAMITES.ID_018     = t1.ID_018_TRAMITE
  INNER JOIN AB03B35T00 ESTADOS
  ON ESTADOS.ID_035 = t1.ID_035_ESTADO
  ORDER BY t1.ID_028 DESC;