🏠 Menú principal

← Volver a vistas simples

---

SIMACMOBILE.VISTA_WA_PRODUCTOS

Base de datos origen: ORCLSMM

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "SIMACMOBILE"."VISTA_WA_PRODUCTOS" ("CODIGO", "DESCRIPCION", "COMPANIA", "REFERENCIA_AUX", "UNIDAD_MEDIDA", "ESTADO", "MARCA", "CATEGORIA", "FAMILIA", "LINEA", "SUBLINEA", "PESO_BRUTO", "PESO_NETO", "VOLUMEN", "COSTO_PROMEDIO", "ULTIMO_COSTO", "PRECIO_VENTA") AS 
  SELECT DISTINCT 
	re.CODIGO,
	REPLACE(re.DESCRIPCION, ';', ''),
	'CO' AS COMPANIA,
	re.ITEM_CODIGO_SIMAC AS REFERENCIA_AUX,
	re.UNIDAD_MEDIDA,
	CASE
		WHEN re.ESTADO_REGISTRO = 'A' THEN 1
		ELSE 0
	END AS ESTADO,
	re.MARCA,
	ice.CATEGORIA_REFERENCIA AS CATEGORIA,
	re.FAMILIA,
	re.LINEA,
	re.SUBLINEA_COMERCIAL AS SUBLINEA,
	to_number(re.PESO) AS peso_bruto,
	to_number(re.PESO) AS peso_neto,
	to_number(re.VOLUMEN) AS volumen,
	se.TOTAL_COSTO_UNITARIO AS COSTO_PROMEDIO,
	se.TOTAL_COSTO_UNITARIO AS ULTIMO_COSTO,
	se.TOTAL_COSTO_UNITARIO AS PRECIO_VENTA
FROM
	SIMACMOBILE.REFERENCIA_ERP re
LEFT JOIN SIMACMOBILE.ITEM_CATEGORIA_ERP ice ON
	ice.ID_ICERP = re.ID_ICERP
LEFT JOIN SIMACMOBILE.SUBINVENTARIO_ERP se ON
	se.ID_REERP = re.ID_REERP
WHERE
	re.DESCRIPCION NOT LIKE '%GARANTIA%'
	AND re.ESTADO_REGISTRO = 'A'
	AND se.TOTAL_COSTO_UNITARIO IS NOT NULL 
	AND se.TOTAL_COSTO_UNITARIO > 0
	AND re.DESCRIPCION NOT LIKE ('%INACTIVO%')
	--AND se.CODIGO_SUBINVENTARIO = 'RESERVA'
ORDER BY 
	re.CODIGO ASC;

---

← Volver al esquema SIMACMOBILE

🏠 Volver al menú principal