eo

select
    A.product_id,
    f_get_product_code(A.product_id) code,f_get_product_name(A.product_id) nama ,
f_get_warehouse_name(A.warehouse_id) warehouse,
    A.warehouse_id,
    SUM(A.qty) qty
from in_log_product_balance_stock A
inner join m_product B On A.product_id = B.product_id
WHERE  A.warehouse_id = 22 AND A.ou_id = 17
AND b.product_code IN (
'BST 251',
'DLP 002',
'DLP 081',
'DLP 169',
'DLP 172',
'DLP 173',
'DLP 174',
'EFO 003',
'FAL 011',
'FIL 042',
'GTL 002',
'GTL 003',
'GTL 005',
'GTR 164',
'HKK 061',
'OLI 070'
)
group by A.product_id,A.warehouse_id
order by code asc