CREATE OR REPLACE FORCE VIEW "AB03B"."AB03B32V00TRABEXP" ("ID_010", "ID_ANO_010", "ID_PROV_010", "ID_EMPRESA_047", "ACTIVO_SN_047", "TIPODOC_032", "NIF_032", "NOMBRE_032", "APELLIDO1_032", "APELLIDO2_032", "ESTADO_032", "NSS_032", "SEXO_032", "FECHA_APTITUD_032", "TITULACIONES_032", "ACTIVO_033", "ID032") AS 
 SELECT t10.Id_010,
    t10.Id_Ano_010,
    t10.Id_Prov_010,
    T32.Id_047_Empresa,
    t47.activo_sn_047,
    t32.tipo_doc_044,
    t32.nif_032,
    t32.nombre_032,
    t32.apellido1_032,
    t32.apellido2_032,
    t32.estado_032,
    t32.nss_032,
    t32.sexo_032,
    t32.fecha_aptitud_032,
    t32.titulaciones_032,
    t33.activo_sn_033,
    t32.ID_032
  FROM ab03b32t00 t32
  INNER JOIN ab03b33t00 t33 ON t32.id_032 = t33.Id_032_Trab
  INNER JOIN ab03b10t00 t10
            ON T33.Id_010_Exp      = T10.Id_010
            AND T33.Id_Ano_010     = T10.Id_Ano_010
            AND T33.Id_Prov_010    = T10.Id_Prov_010
            AND T10.Id_047_Empresa = T32.Id_047_Empresa
  INNER JOIN ab03b47t00 t47 ON T47.Id_047 = T32.Id_047_Empresa
  order by t32.ID_032;