CREATE OR REPLACE FORCE VIEW "AB03B"."AB03B29V00" ("ID029", "IDPIF029", "ID024NUMEXP",
"IDPROV024","IDANO024", "ID027TIPODOCG", "DESCDOCEXP027", "DESEDOCEXP027", "ID028HISTOTRAM", "OID029", "OBSERVACIONESES029", "OBSERVACIONESEU029", "TIPOAPORTACION029", "ORGDOCENTREGADO029", "NOMDOCENTREGADO029", "FECDOCENTREGADO029", "ID017FASE", "ID018TRAMITE")
AS
  SELECT t29.ID_029 ID029,
    t29.ID_PIF_029 IDPIF029,
    t29.ID_024_NUM_EXP ID024NUMEXP,
    t29.ID_PROV_024 IDPROV024,
    t29.ID_ANO_024 IDANO024,
    t29.ID_027_TIPO_DOC_G ID027TIPODOCG,
    T27.Desc_Es_027 DESCDOCEXP027,
    T27.Desc_Eu_027 DESEDOCEXP027,
    t29.ID_028_HISTO_TRAM ID028HISTOTRAM,
    t29.OID_029 OID029,
    t29.OBSERVACIONES_ES_029 OBSERVACIONESES029,
    t29.OBSERVACIONES_EU_029 OBSERVACIONESEU029,
    t29.TIPO_APORTACION_029 TIPOAPORTACION029,
    t29.ORG_DOC_ENTREGADO_029 ORGDOCENTREGADO029,
    t29.NOM_DOC_ENTREGADO_029 NOMDOCENTREGADO029,
    t29.FEC_DOC_ENTREGADO_029 FECDOCENTREGADO029,
    t27.ID_017_FASE ID017FASE,
    t27.ID_018_TRAMITE ID018TRAMITE
  FROM AB03B29T00 t29
  INNER JOIN AB03B27T00 t27
  ON T29.Id_027_Tipo_Doc_G = t27.id_027
UNION
SELECT t29.ID_029 ID029,
    t29.ID_PIF_029 IDPIF029,
    t29.ID_024_NUM_EXP ID024NUMEXP,
    t29.ID_PROV_024 IDPROV024,
    t29.ID_ANO_024 IDANO024,
    t29.ID_027_TIPO_DOC_G ID027TIPODOCG,
    T25.Desc_Es_025 DESCDOCEXP027,
    T25.Desc_Eu_025 DESEDOCEXP027,
    t29.ID_028_HISTO_TRAM ID028HISTOTRAM,
    t29.OID_029 OID029,
    t29.OBSERVACIONES_ES_029 OBSERVACIONESES029,
    t29.OBSERVACIONES_EU_029 OBSERVACIONESEU029,
    t29.TIPO_APORTACION_029 TIPOAPORTACION029,
    t29.ORG_DOC_ENTREGADO_029 ORGDOCENTREGADO029,
    t29.NOM_DOC_ENTREGADO_029 NOMDOCENTREGADO029,
    t29.FEC_DOC_ENTREGADO_029 FECDOCENTREGADO029,
    t25.ID_017_FASE ID017FASE,
    t25.ID_018_TRAMITE ID018TRAMITE
  FROM AB03B29T00 t29
  INNER JOIN AB03B25T00 t25
  ON T29.Id_025_DOCENTRADA = t25.id_025;