Query GetSummaryForDeliveryOrderMlm

SELECT z.so_mlm_id, SUM(qty_so_int) AS totalQtySo, SUM(a.nett_sell_price * a.qty_dlv_int) AS totalNettItemAmount,
        SUM(qty_so * price_after_disc) AS totalPriceAfterDisc, SUM(qty_so * gross_sell_price) AS totalGrossSellPrice,
        f_get_so_commission_amount(z.so_mlm_id) AS nilai_komisi,
        TRUNC(sl_get_total_harga_netto(z.so_mlm_id),0) - f_get_so_commission_amount(z.so_mlm_id) + f_get_so_mlm_additional_cost(z.so_mlm_id) AS total_pembelian,
        f_get_so_mlm_additional_cost(z.so_mlm_id) AS additional_cost,
        SUM(a.qty_dlv_int) AS totalQtyDlv
    FROM sl_so_mlm_balance_product a
    INNER JOIN sl_so_mlm z ON a.tenant_id = z.tenant_id AND a.so_mlm_id = z.so_mlm_id
    INNER JOIN m_product_catalog b ON a.tenant_id = b.tenant_id AND a.product_catalog_id = b.product_catalog_id
    INNER JOIN m_uom c ON a.tenant_id = c.tenant_id AND a.so_uom_id = c.uom_id
    INNER JOIN m_uom d ON a.tenant_id = d.tenant_id AND a.base_uom_id = d.uom_id
    INNER JOIN t_combo_value e ON e.code = z.curr_code AND e.combo_id = 'CURRENCY'
    LEFT OUTER JOIN m_tax f ON a.tenant_id = f.tenant_id AND a.tax_id = f.tax_id
    INNER JOIN t_combo_value g ON g.code = a.flg_tax_amount AND g.combo_id = 'YESNO'
    WHERE a.tenant_id = :tenantId
        AND a.so_mlm_id = :soMlmId
    GROUP BY z.so_mlm_id