SIMACMOBILE.AXR_DIRECCIONES

Base de datos origen: ORCLSMM

Tipo de objeto: MATERIALIZED VIEW

SQL

  CREATE MATERIALIZED VIEW "SIMACMOBILE"."AXR_DIRECCIONES" ("CODSOCIEDAD", "CODCLIENTE", "CODDIRECCION", "TDIRECCION", "DOMICILIO", "CIUDAD", "PROV", "CP", "PAIS", "IND1", "IND2", "IND3", "FCHMODIF", "FCHCREACION")
  SEGMENT CREATION IMMEDIATE
  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  BUILD IMMEDIATE
  USING INDEX 
  REFRESH FORCE ON DEMAND
  USING DEFAULT LOCAL ROLLBACK SEGMENT
  USING ENFORCED CONSTRAINTS DISABLE ON QUERY COMPUTATION DISABLE QUERY REWRITE
  AS SELECT DISTINCT
'890300225' CODSOCIEDAD,
CLIE.SITE AS CODCLIENTE,
CLIE.DIRECCION AS CODDIRECCION,
3 AS TDIRECCION,
CLIE.DIRECCION AS DOMICILIO,
CIUD.NOMBRE AS CIUDAD,
DPTO.NOMBRE AS PROV,
CAST (NULL AS VARCHAR(32)) AS CP, 
PAIS.NOMBRE AS PAIS, 
CAST (NULL AS VARCHAR(255)) IND1, 
CAST (NULL AS VARCHAR(255)) IND2, 
CAST (NULL AS VARCHAR(255)) IND3,  
CLIE.FECHA_MODIFICACION AS FCHMODIF, 
CLIE.FECHA_CREACION AS FCHCREACION 
FROM SIMACMOBILE.CLIENTE_ERP CLIE
--JOIN SIMACMOBILE.CUPO_DISPONIBLE_ERP CUDI ON CUDI.ACCOUNT_NUMBER = CLIE.ACCOUNT_NUMBER 
JOIN SIMACMOBILE.CARTERA_EDADES_DIARIO_ERP CAED ON CLIE.ID_CLERP = CAED.ID_CLERP
LEFT JOIN SIMACMOBILE.DIVISION_POLITICA CIUD ON CIUD.NOMBRE = UPPER(CLIE.CIUDAD)
LEFT JOIN SIMACMOBILE.DIVISION_POLITICA DPTO ON DPTO.ID_DIPO = CIUD.ID_DIPO1
LEFT JOIN SIMACMOBILE.DIVISION_POLITICA PAIS ON PAIS.ID_DIPO = DPTO.ID_DIPO1;

← Volver al esquema SIMACMOBILE

🏠 Volver al menú principal