 CREATE OR REPLACE FORCE VIEW "AB03B"."AB03B04V00" ("ID004", "NOMBRE004", "APEL1004", "APEL2004", "ID003CARGO", "DESC003ES", "DESC003EU", "ACTIVOSN004", "ID_PROV_004", "PROV_DO", "TIPO_DOC_044", "DESC_ES_044", "DESC_EU_044", "NIF_FIRMANTE_004", "BUZON_004", "USUARIO_004", "F_VIGENCIA_DS_004", "F_VIGENCIA_HS_004", "FIRMA_ESCANEADA_004") AS 
  SELECT T1.ID_004 ID004,
    T1.NOMBRE_004 NOMBRE004,
    T1.APEL1_004 APEL1004,
    T1.APEL2_004 APEL2004,
    T1.ID_003_CARGO ID003CARGO,
    T3.DESC_ES_003 DESC003ES,
    T3.DESC_EU_003 DESC003EU,
    T1.ACTIVO_SN_004 ACTIVOSN004,
    T1.ID_PROV_004 ID_PROV_004,
    CASE
      WHEN T1.ID_PROV_004 = 99 THEN ''
      ELSE NORAPROV.DS_O
    END PROV_DO,
    T1.TIPO_DOC_044 TIPO_DOC_044,
    T44.DESC_ES_044 DESC_ES_044,
    T44.DESC_EU_044 DESC_EU_044,
    T1.NIF_FIRMANTE_004,
    T1.BUZON_004,
    T1.USUARIO_004,
    T1.F_VIGENCIA_DS_004,
    T1.F_VIGENCIA_HS_004,
    T1.FIRMA_ESCANEADA_004
  FROM AB03B04T00 T1
  INNER JOIN AB03B03T00 T3 ON T3.ID_003 = T1.ID_003_CARGO
  LEFT OUTER JOIN T17I.T17_PROVINCIA NORAPROV ON NORAPROV.ID = T1.ID_PROV_004
  INNER JOIN AB03B44T00 T44 ON T44.ID_044 = T1.TIPO_DOC_044;