SIMACMOBILE.AXR_CONTACTOS

Base de datos origen: ORCLSMM

Tipo de objeto: MATERIALIZED VIEW

SQL

  CREATE MATERIALIZED VIEW "SIMACMOBILE"."AXR_CONTACTOS" ("CODSOCIEDAD", "CODCLIENTE", "CODCONTACTO", "NOMBRE", "NIF", "TCONTACTO", "CODDIRECCION", "TLFFIJO", "TLFMOVIL", "FAX", "EMAIL", "IND1", "IND2", "IND3", "FCHMODIF", "FCHCREACION")
  SEGMENT CREATION IMMEDIATE
  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS NOLOGGING
  BUILD IMMEDIATE
  USING INDEX 
  REFRESH COMPLETE 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,
  '0' AS CODCONTACTO,
  CLIE.PARTY_SITE_NAME AS NOMBRE,
  CAST (NULL AS VARCHAR(32)) AS NIF,
  '0' AS TCONTACTO,
  '0' AS CODDIRECCION,
  '0' AS TLFFIJO,
  CAST (NULL AS VARCHAR(32)) AS TLFMOVIL,
  CAST (NULL AS VARCHAR(32)) AS FAX,
  CLIE.CORREO AS EMAIL,
  CAST (NULL AS VARCHAR(255)) AS IND1,
  CAST (NULL AS VARCHAR(255)) AS IND2,
  CAST (NULL AS VARCHAR(255)) AS IND3,
  CLIE.FECHA_MODIFICACION AS FCHMODIF,
  CLIE.FECHA_CREACION AS FCHCREACION
  FROM SIMACMOBILE.CLIENTE_ERP CLIE where CLIE.tipo_cliente_venta NOT LIKE 'Contado'
  AND CLIE.SITE not like '%9__'
  AND CLIE.CORREO IS NOT NULL 
  --AND CLIE.NIT = '890301886';

← Volver al esquema SIMACMOBILE

🏠 Volver al menú principal