SIMACMOBILE.AXR_CLIENTES

Base de datos origen: ORCLSMM
Tipo de objeto: MATERIALIZED VIEW
SQL

  CREATE MATERIALIZED VIEW "SIMACMOBILE"."AXR_CLIENTES" ("CODSOCIEDAD", "COD", "NIF", "RAZONS", "CODCONDP", "LIMITRG", "PROV", "LRCOMP", "CODVP", "CLASIFCONTABLE", "LSEGCREDITO", "FCHCADSEGCRED", "TIPOENTIDAD", "SECTOR", "FCHALTAERP", "FCHINITACT", "IND1", "IND2", "IND3", "IND4", "IND5", "IND6", "IND7", "IND8", "IND9", "TIENEAVAL", "TIPOAVAL", "FCHMODIF", "FCHCREACION")
  SEGMENT CREATION IMMEDIATE
  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING  NO INMEMORY 
  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 
'890300225' CODSOCIEDAD,
CLIE.SITE AS COD,
CLIE.NIT AS NIF,
CASE WHEN CLIE.RAZON_SOCIAL IS NOT NULL THEN CLIE.RAZON_SOCIAL ELSE
(trim (CLIE.PRIMER_NOMBRE)
          || case
            when CLIE.SEGUNDO_NOMBRE is null then ' '
            else ' ' || trim (CLIE.SEGUNDO_NOMBRE) end
             ) || 
(trim (CLIE.PRIMER_APELLIDO)
      	  ||   CASE when CLIE.SEGUNDO_APELLIDO is null then ' '
            else ' ' || trim (CLIE.SEGUNDO_APELLIDO) END
      ) END AS RAZONS,
CAST (NULL AS VARCHAR(64)) AS CODCONDP,
CASE WHEN CUDI.ID_CUPDIS IS NULL THEN 0 ELSE CUDI.LIMITE_CREDITO END AS LIMITRG,
--DPTO.NOMBRE AS PROV,
CLIE.DEPARTAMENTO AS PROV,
1 AS LRCOMP,
CAST (NULL AS VARCHAR(64)) AS CODVP,
CAST (NULL AS VARCHAR(64)) AS CLASIFCONTABLE,
CAST (NULL AS VARCHAR(64)) AS LSEGCREDITO,
CAST (NULL AS VARCHAR(64)) AS FCHCADSEGCRED,
CASE WHEN CLIE.PARTY_TYPE = 'PERSON' THEN 'PERSONA NATURAL' ELSE 'PERSONA JURIDICA' END AS TIPOENTIDAD,
CAST (NULL AS VARCHAR(255)) SECTOR,
CLIE.FECHA_SITIO AS FCHALTAERP,
CAST (NULL AS DATE) FCHINITACT,
CLIE.TERMINO_PAGO           IND1,
CAST (NULL AS VARCHAR(255)) IND2,
CAST (NULL AS VARCHAR(255)) IND3,
CAST (NULL AS VARCHAR(255)) IND4,
CAST (NULL AS VARCHAR(255)) IND5,
CAST (NULL AS VARCHAR(255)) IND6,
CAST (NULL AS VARCHAR(255)) IND7,
CAST (NULL AS VARCHAR(255)) IND8,
CAST (NULL AS VARCHAR(255)) IND9,
CAST (NULL AS VARCHAR(1)) TIENEAVAL,
CAST (NULL AS VARCHAR(255)) TIPOAVAL,
CLIE.FECHA_MODIFICACION AS FCHMODIF,
CLIE.FECHA_CREACION AS FCHCREACION
FROM SIMACMOBILE.CLIENTE_ERP CLIE
LEFT JOIN SIMACMOBILE.CUPO_DISPONIBLE_ERP_2 CUDI ON CUDI.ACCOUNT_NUMBER = CLIE.ACCOUNT_NUMBER;
← Volver al esquema SIMACMOBILE
🏠 Volver al menú principal