🏠 Menú principal

← Volver a vistas materializadas

---

SIMACMOBILE.AXR_CLIENTES_CLASIFCRITERIOS

Base de datos origen: ORCLSMM

Tipo de objeto: MATERIALIZED VIEW

SQL

  CREATE MATERIALIZED VIEW "SIMACMOBILE"."AXR_CLIENTES_CLASIFCRITERIOS" ("CODSOCIEDAD", "CODCLI", "CODELEM", "CODCRIT", "FCHMODIF", "FCHCREACION")
  SEGMENT CREATION IMMEDIATE
  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  BUILD DEFERRED
  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 CODCLI,
CLCR.COD AS CODELEM,
6200 CODCRIT,
CLIE.FECHA_MODIFICACION AS FCHMODIF,
CLIE.FECHA_CREACION AS FCHCREACION
FROM SIMACMOBILE.CLIENTE_ERP CLIE
JOIN SIMACMOBILE.AXR_CLASIFCRITERIOS CLCR ON 1=1;

---

← Volver al esquema SIMACMOBILE

🏠 Volver al menú principal