vw_current_stock_indocom

CREATE OR REPLACE VIEW vw_current_stock_indocom
AS
SELECT F.ou_code, F.ou_name, C.product_code AS product_code, C.product_name AS product_name,
       D.warehouse_code AS warehouse_code, D.warehouse_name AS warehouse_name,
       SUM(A.qty) AS qty_current_stock, E.uom_code AS uom_code, E.uom_name AS uom_name,
       A.product_status AS product_status
FROM in_product_balance_stock A
INNER JOIN m_warehouse_ou B ON A.warehouse_id = B.warehouse_id
INNER JOIN m_product C ON A.product_id = C.product_id
INNER JOIN m_warehouse D ON A.warehouse_id = D.warehouse_id
INNER JOIN m_uom E ON A.base_uom_id = E.uom_id
INNER JOIN t_ou F ON F.ou_id = B.ou_id
WHERE A.tenant_id = 10
GROUP BY F.ou_code, F.ou_name, C.product_code, C.product_name, D.warehouse_code, D.warehouse_name, E.uom_code, E.uom_name, A.product_status;