SIMACMOBILE.AXR_VENTAS

Base de datos origen: ORCLSMM

Tipo de objeto: MATERIALIZED VIEW

SQL

  CREATE MATERIALIZED VIEW "SIMACMOBILE"."AXR_VENTAS" ("CODSOCIEDAD", "CODCLI", "ANIO", "MES", "IMPORTE")
  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 
  '890300225' CODSOCIEDAD,
  CLIE.SITE CODCLI,
  TO_CHAR(VEER.FECHA_VENTA,'YYYY') ANIO,
  TO_CHAR(VEER.FECHA_VENTA,'mm') MES,
  --SUM(VEER.MONTO_TOTAL) AS IMPORTE 
  sum(to_number(VEER.MONTO_TOTAL DEFAULT 0 ON conversion error)) as IMPORTE
  FROM SIMACMOBILE.VENTA_HISTORICO_ERP VEER 
  JOIN SIMACMOBILE.SUCURSAL_ERP SUER ON SUER.ID_SUERP = VEER.ID_SUERP
  --JOIN SIMACMOBILE.REFERENCIA_ERP REER ON REER.ID_REERP = VEER.ID_REERP 
  JOIN SIMACMOBILE.CLIENTE_ERP CLIE ON CLIE.NIT = VEER.CLIENTE_NIT  
 	GROUP BY 
 	CLIE.SITE,
 	VEER.FECHA_VENTA;

← Volver al esquema SIMACMOBILE

🏠 Volver al menú principal