Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a vistas materializadas |
SIMACMOBILE.VM_INFO_CLIENTE_SOS
Base de datos origen: ORCLSMM
Tipo de objeto: MATERIALIZED VIEW
SQL
CREATE MATERIALIZED VIEW "SIMACMOBILE"."VM_INFO_CLIENTE_SOS" ("NIT", "ID_PECOERP", "FECHA_CREACION", "FECHA_MODIFICACION", "META_MINIMA", "ID_TICLSO", "ESTADO_CLIENTE", "ESTADO_REGISTRO", "RN")
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 WITH CLIENTE_SOS_PRINCIPAL AS (
SELECT cs.nit, cs.ID_PECOERP, cs.FECHA_CREACION, cs.FECHA_MODIFICACION, cs.META_MINIMA, cs.ID_TICLSO, cs.estado_cliente,cs.estado_registro, 0 AS rn
FROM SIMACMOBILE.CLIENTE_SOS cs
),
CLIENTE_SOS_HISTORICO AS (
SELECT chs.nit, chs.ID_PECOERP, chs.FECHA_CREACION, chs.FECHA_MODIFICACION, chs.META_MINIMA, chs.ID_TICLSO, chs.estado_cliente, chs.estado_registro,
ROW_NUMBER() OVER (PARTITION BY chs.nit, chs.ID_PECOERP ORDER BY chs.FECHA_CREACION desc) AS rn
FROM SIMACMOBILE.CLIENTE_HISTORICO_SOS chs
)
SELECT "NIT","ID_PECOERP","FECHA_CREACION","FECHA_MODIFICACION","META_MINIMA","ID_TICLSO","ESTADO_CLIENTE", "ESTADO_REGISTRO","RN" FROM (
SELECT * FROM CLIENTE_SOS_PRINCIPAL
UNION ALL
SELECT * FROM CLIENTE_SOS_HISTORICO
) csd
;