📄 Vista: [dbo].[v_bodegas_ALL]

Versión: v1.3 Autor: Jimmy Ricardo Sánchez Romero Fecha: 2025-10-09 Dependencias: [SIESA], [dbo].[t150_mc_bodegas],[dbo].[t152_mc_bodega_grupo_bodega],[dbo].[t284_co_ccosto] Estado: Activa ✅

📘 Descripción funcional

Muestra todas la bodegas para manejo de inventario todas las bodegas filtradas por grupo de bodegas incluyendo las de OLA 1

🧮 Estructura SQL

    CREATE OR ALTER VIEW [dbo].[v_bodegas_All]
    AS
    SELECT        
        [f150_rowid] AS [rowBodega],
        CONCAT(RTRIM([f150_id]), '_PDV_LC') AS [CodBodega],
        [f150_descripcion] AS [Descripcion],
        [f150_id_co] AS CO,
        [f284_id] AS [Centro Costo],
        [f284_id_un] AS [Unidad Negocio],
        'LENOS' AS Negocio,
        'LC' AS Cadena
    FROM [LEÑOS].[UnoeeRealLenos].[dbo].[t150_mc_bodegas]
    INNER JOIN [LEÑOS].[UnoeeRealLenos].[dbo].[t152_mc_bodega_grupo_bodega]
        ON [f152_rowid_bodega] = [f150_rowid]
    INNER JOIN [LEÑOS].[UnoeeRealLenos].[dbo].[t284_co_ccosto]
        ON [f284_id_co] = [f150_id_co]
    AND [f150_id_cia] = [f284_id_cia]
    WHERE [f150_id_cia] = 1 
    AND [f152_id_cia] = f150_id_cia
    AND [f152_id_grupo_bodega] = 'RST'
    AND [f284_id_grupo_ccosto] = 'GV'
    AND [f284_id] NOT IN ('S750')
    AND [f284_ind_estado] = 1

    UNION ALL ......

    GO

⚙️ Origen de datos

🧾 Columnas principales

🔄 Historial de cambios

🔍 Observaciones