
CREATE OR REPLACE FORCE EDITIONABLE VIEW "AB03B"."AB03B56V00" ("ID_014", "ID_001_FASE", "ID_002_TRAMITE", "ID_010_NUM_EXP", "ID_ANO_010", "ID_PROV_010", "ID_056", "PREVISION_MCA_056", "ESTIMACION_MCA_056", "ID_041", "DESC_ES_041", "DESC_EU_041", "ID_054", "DESC_ES_054", "DESC_EU_054", "ID_055", "DESC_ES_055", "DESC_EU_055")
AS
  SELECT t14.id_014,
    T14.Id_001_Fase,
    T14.Id_002_Tramite,
    T14.Id_010_Num_Exp,
    T14.Id_Ano_010,
    T14.Id_Prov_010,
    T56.Id_056,
    T56.Prevision_Mca_056,
    T56.Estimacion_Mca_056,
    T41.Id_041,
    T41.Desc_Es_041,
    T41.Desc_Eu_041,
    T54.Id_054,
    T54.Desc_Es_054,
    T54.Desc_Eu_054,
    T55.Id_055,
    T55.Desc_Es_055,
    T55.Desc_Eu_055
  FROM ab03b14t00 t14
  LEFT OUTER JOIN ab03b56t00 t56
  ON t14.id_014 = T56.Id_014
  LEFT OUTER JOIN ab03b41t00 t41
  ON T56.Id_041_Material = T41.Id_041
  LEFT OUTER JOIN ab03b54t00 t54
  ON T56.Id_054_Actividad = T54.Id_054
  LEFT OUTER JOIN ab03b55t00 t55
  ON T56.Id_055_Sub_Actividad = T55.Id_055;
