[[Category:VISTAS]]
== Descripción ==
Reservorio de productos sumando los generados a partir de los bocetos y que han conformado módulos.
En el caso de la [[TABLA:modulos]] se completan los atributos faltantes que 
== Composición ==
*[[TABLA:productos]]
*[[TABLA:modulos]]
== SQL ==
<pre>
CREATE VIEW productosdisp AS
    SELECT 
        ProductoGen,
        ProductoDflt,
        '1' AS ComponentesUT,
        ProductoID,
        CategoriaID,
        Descripcion,
        ProveedorID,
        Reposicion,
        Magnitud,
        MagnitudIN,
        CoefP00P01,
        CoefP00P02,
        CoefP00P03,
        ProductoPID,
        InsumoIMG,
        MagCmpX,
        MagCmpY,
        MagCmpZ,
        MagCmpW
    FROM
        productos 
    UNION
	SELECT 
        ModuloID AS ProductoGen,
        '1' as ProductoDflt,
        '0' AS ComponentesUT,
        ModuloID AS ProductoID,
        'MOD' AS CategoriaID,
        ModuloDSC AS Descripcion,
        'FAZZ' AS ProveedorID,
        0 AS Reposicion,
        'UN' AS Magnitud,
        'UN' AS MagnitudIN,
        1.35 AS CoefP00P01,
        1.38 AS CoefP00P02,
        1.41 AS CoefP00P03,
        ModuloID AS ProductoPID,
        ModuloIMG AS InsumoIMG,
        ModuloVW AS MagCmpX,
        ModuloVH AS MagCmpY,
        0 AS MagCmpZ,
        0 AS MagCmpW
    FROM
        moduloscab
</pre>
== Bitácora ==
== Uso ==
== URL ==