select case when pord_pondcode = 'Local' then 'Local' else 'Non-Local' end,sum(poit_valord),poit_supplier
from poitem,porder,plsupp
where poit_order = pord_order
AND poit_qtydel < poit_qtyord
AND pord_supplier = poit_supplier
AND plsup_ndcode = pord_supndcode
GROUP BY poit_supplier,plsup_minord,case when pord_pondcode = 'Local' then 'Local' else 'Non-Local' end

SELECT  supplier = ITM.poit_supplier,
        local_orders = SUM(CASE WHEN ORD.pord_pondcode = 'Local' THEN ITM.poit_valord ELSE 0 END),
        global_orders = SUM(CASE WHEN ORD.pord_pondcode <> 'Local' THEN ITM.poit_valord ELSE 0 END)
FROM    poitem ITM
JOIN    porder ORD
        ON  ORD.pord_order = ITM.poit_order
        AND ORD.pord_supplier = ITM.poit_supplier
JOIN    plsupp SUP
        ON  SUP.plsup_ndcode = ORD.pord_supndcode
WHERE   ITM.poit_qtydel < ITM.poit_qtyord
GROUP   BY 
        ITM.poit_supplier,
        SUP.plsup_minord;