 CREATE OR REPLACE FORCE VIEW "AB03B"."ESTADISTICAS_INDICADORES" ("ANYO", "ID", "FECREG", "MES", "IDPROVINCIA", "DS_O", "ESTADO", "EXPEDIENTE", "FECHAVISITA", "INCUMPLIMIENTO") AS  
 SELECT t10.ID_ANO_010 anyo,
    t10.ID_010 id,
    t10.FEC_REG_010 FECREG,
    EXTRACT( MONTH FROM t10.FEC_REG_010)MES,
    t10.ID_PROV_010 IDPROVINCIA,
    NORAPROV.DS_O,
    t10.ESTADO_EXP_010 estado,
    t10.ID_PROV_010
    ||'/'
    ||t10.ID_ANO_010
    ||'/'
    || lpad(T10.ID_010,5,'0') expediente,
    T58.FECHA_HORA_058,
    T58.INCUMPLIMIENTO_058
  FROM AB03B10T00 t10
  INNER JOIN T17I.T17_PROVINCIA NORAPROV
  ON NORAPROV.ID = t10.ID_PROV_010
  INNER JOIN AB03B14T00 T14
  ON T14.ID_ANO_010     =t10.ID_ANO_010
  AND T14.ID_PROV_010   =t10.ID_PROV_010
  AND T14.ID_010_NUM_EXP=t10.ID_010
  INNER JOIN AB03B58T00 T58
  ON T58.ID_014=T14.ID_014;