SIMACMOBILE.INT_CAT_CARATULAS_ERP

Base de datos origen: ORCLSMM

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "SIMACMOBILE"."INT_CAT_CARATULAS_ERP" ("ID", "NIT", "ALMACEN", "CEDI", "FECHA_ACTUALIZACION", "CODIGO_VENDEDOR", "CEDULA", "NOMBRES", "APELLIDOS", "EMAIL", "TELEFONO_1") AS 
  SELECT CLVE.ID_CLIVERP AS ID,
TO_NUMBER(CLIE.NIT) AS NIT,
CLIE.SITE AS ALMACEN,
SUER.CODIGO AS CEDI,
CLVE.FECHA_MODIFICACION AS FECHA_ACTUALIZACION,
VEER.CODIGO AS CODIGO_VENDEDOR,
TO_NUMBER(VEER.IDENTIFICACION) AS CEDULA,
VEER.PRIMER_NOMBRE  || 
CASE WHEN VEER.SEGUNDO_NOMBRE IS NULL OR VEER.SEGUNDO_NOMBRE = 'null' THEN 
	'' ELSE ' ' || VEER.SEGUNDO_NOMBRE END AS NOMBRES,
--VEER.APELLIDOS,
CASE WHEN VEER.APELLIDOS IS NULL OR VEER.APELLIDOS = 'null' THEN 
	'' ELSE VEER.APELLIDOS END AS APELLIDOS,
VEER.CORREO AS EMAIL,
' ' AS telefono_1
FROM 
CLIENTE_VENDEDOR_ERP CLVE
JOIN CLIENTE_ERP CLIE ON CLIE.ID_CLERP = CLVE.ID_CLERP 
JOIN VENDEDOR_ERP VEER ON VEER.ID_VERP = CLVE.ID_VERP 
--JOIN SUCURSAL_ERP SUER ON SUER.ID_SUERP = VEER.ID_SUERP
JOIN SUCURSAL_ERP SUER ON SUER.ID_SUERP = CLIE.ID_SUERP 
;

← Volver al esquema SIMACMOBILE

🏠 Volver al menú principal