Query to find the 'Qty On Hand' details. Nettable

Hello !

Query to find the On hand Quantity details.

Can some one please advise how to control the Nettable / Non Nettable. used the below query to find the On hand Qty , it return as - 4 but actually it should return 0 , where as it is Non Nettable.

SELECT SUM (OHQD.PRIMARY_TRANSACTION_QUANTITY) QTY_ON_HAND
FROM MTL_ONHAND_QUANTITIES_DETAIL OHQD
JOIN MTL_SYSTEM_ITEMS_B MSI
ON MSI.INVENTORY_ITEM_ID = OHQD.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = OHQD.ORGANIZATION_ID
JOIN MTL_PARAMETERS MP ON MP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
JOIN CST_ITEM_COSTS CIC
ON CIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID