SQL Querry to Find The On Hand Quantity with cost wise

SELECT B.SEGMENT1 ITEM,
B.DESCRIPTION,
E.ORGANIZATION_CODE ,
A.SUBINVENTORY_CODE,
C.SEGMENT1 LOCATOR,
D.ITEM_COST,
SUM(A.PRIMARY_TRANSACTION_QUANTITY) QUANTITY,
SUM(A.PRIMARY_TRANSACTION_QUANTITY)*D.ITEM_COST TOTAL_VALUE
FROM MTL_ONHAND_QUANTITIES_DETAIL A
,MTL_SYSTEM_ITEMS_B B,
MTL_ITEM_LOCATIONS C,
CST_ITEM_COSTS D,
ORG_ORGANIZATION_DEFINITIONS E
WHERE A.INVENTORY_ITEM_ID =  B.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID=B.ORGANIZATION_ID
AND C.ORGANIZATION_ID=B.ORGANIZATION_ID
AND C.INVENTORY_LOCATION_ID=A.LOCATOR_ID
AND  A.INVENTORY_ITEM_ID =  D.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID=D.ORGANIZATION_ID
AND E.ORGANIZATION_ID=A.ORGANIZATION_ID
AND A.ORGANIZATION_ID IN (84,86,90,91,92,93)
--AND B.SEGMENT1='M-0106011'
GROUP BY B.SEGMENT1,B.DESCRIPTION,E.ORGANIZATION_CODE,
A.SUBINVENTORY_CODE,C.SEGMENT1,D.ITEM_COST;