CREATE OR REPLACE FORCE VIEW "AB03B"."AB03B15V00" ("ID015", "IDPIF015", "ID010NUMEXP", "IDANO010", "IDPROV010", "ID013TIPODOCG", "DESCDOCEXP013", "DESEDOCEXP013", "ID014HISTOTRAM", "OID015", "OBSERVACIONESES015", "OBSERVACIONESEU015", "CONDICESPECIF015", "TIPOAPORTACION015", "ORGDOCENTREGADO015", "NOMDOCENTREGADO015", "FECDOCENTREGADO015", "ID001FASE", "ID002TRAMITE", "ID004FIRMANTE") AS 
  SELECT t15.ID_015 ID015, 
        t15.ID_PIF_015 IDPIF015,
				t15.ID_010_NUM_EXP ID010NUMEXP, 
        t15.ID_ANO_010 IDANO010, 
        t15.ID_PROV_010 IDPROV010,
				t15.ID_013_TIPO_DOC_G ID013TIPODOCG,
        T13.Desc_Es_013 DESCDOCEXP013, 
        T13.Desc_Eu_013 DESEDOCEXP013,
        t15.ID_014_HISTO_TRAM ID014HISTOTRAM,
				t15.OID_015 OID015,
        t15.OBSERVACIONES_ES_015 OBSERVACIONESES015, 
        t15.OBSERVACIONES_EU_015 OBSERVACIONESEU015, 
				t15.CONDIC_ESPECIF_015 CONDICESPECIF015, 
				t15.TIPO_APORTACION_015 TIPOAPORTACION015, 
        t15.ORG_DOC_ENTREGADO_015 ORGDOCENTREGADO015,
				t15.NOM_DOC_ENTREGADO_015 NOMDOCENTREGADO015, 
        t15.FEC_DOC_ENTREGADO_015 FECDOCENTREGADO015,
        t13.ID_001_FASE ID001FASE,
        t13.ID_002_TRAMITE ID002TRAMITE,
        t15.ID_004_FIRMANTE ID004FIRMANTE
FROM AB03B15T00 t15 
INNER JOIN AB03B13T00 t13 ON T15.Id_013_Tipo_Doc_G = t13.id_013 
UNION 
SELECT t15.ID_015 ID015, 
        t15.ID_PIF_015 IDPIF015,
				t15.ID_010_NUM_EXP ID010NUMEXP, 
        t15.ID_ANO_010 IDANO010, 
        t15.ID_PROV_010 IDPROV010,
				t15.ID_013_TIPO_DOC_G ID013TIPODOCG,
        T11.Desc_Es_011 DESCDOCEXP013, 
        T11.Desc_Eu_011 DESEDOCEXP013,
        t15.ID_014_HISTO_TRAM ID014HISTOTRAM,
				t15.OID_015 OID015,
        t15.OBSERVACIONES_ES_015 OBSERVACIONESES015, 
        t15.OBSERVACIONES_EU_015 OBSERVACIONESEU015, 
				t15.CONDIC_ESPECIF_015 CONDICESPECIF015, 
				t15.TIPO_APORTACION_015 TIPOAPORTACION015, 
        t15.ORG_DOC_ENTREGADO_015 ORGDOCENTREGADO015,
				t15.NOM_DOC_ENTREGADO_015 NOMDOCENTREGADO015, 
        t15.FEC_DOC_ENTREGADO_015 FECDOCENTREGADO015,
        t11.ID_001_FASE ID001FASE,
        t11.ID_002_TRAMITE ID002TRAMITE,
        t15.ID_004_FIRMANTE ID004FIRMANTE
FROM AB03B15T00 t15 
INNER JOIN AB03B11T00 t11 ON T15.ID_011_DOCENTRADA = t11.id_011;
/
