Sales Order Detail in Adempiere

-- select * from vw_detalle_ordenes_ventas dov limit 100;

drop view if exists vw_detalle_ordenes_ventas;

create view vw_detalle_ordenes_ventas
as
select
    ov.*,
    ol.line as linea,
    p.m_product_id as id_producto,
    p.value as cod_producto,
    p.name as producto,
    c.c_charge_id as id_cargo,
    c.name as cargo,
    ia.m_attributesetinstance_id as id_atributos,
    ia.description as atributos,
    u.c_uom_id as id_unidad,
    u.name as unidad_medida,
    ol.qtyentered as cantidad_entrada,
    ol.qtyordered as cantidad_ordenada,
    ol.qtyreserved as cantidad_reservada,
    ol.priceentered as precio_entrada,
    ol.priceactual as precio_actual,
    ol.pricelist as precio_lista,
    ol.linenetamt as neto_linea
from vw_ordenes_ventas ov
    join c_orderline ol
    on ov.id_orden = ol.c_order_id
    left outer join m_product p
    on ol.m_product_id = p.m_product_id
    left outer join c_uom u
    on ol.c_uom_id = u.c_uom_id
    left outer join c_charge c
    on ol.c_charge_id = c.c_charge_id
    left outer join m_attributesetinstance ia
    on ol.m_attributesetinstance_id = ia.m_attributesetinstance_id;