Oracle Ebs-sql (INV-3): Check Warehouse inventory value details. SQL

SELECT
A.subinventory_code Sub-Library code
, d.description subpackage Description
, B.segment1 material code
, B.description material description
, b.primary_unit_of_measure units
, SUM (a.primary_transaction_quantity) number
, C.material_cost cost
, To_char (SUM (a.primary_transaction_quantity) *c.material_cost, ' 99999999999999.9999 ') amount
, To_char (sysdate, ' yyyy-mm-dd HH:MM:SS ') Reporting date
From
INV. Mtl_onhand_quantities_detail A,
INV. Mtl_system_items_b B,
Bom. Cst_item_costs C,
INV. Mtl_secondary_inventories D
WHERE
a.organization_id = X
and a.organization_id=b.organization_id
and c.inventory_item_id (+) =b.inventory_item_id
and a.inventory_item_id=b.inventory_item_id
--and a.subinventory_code like ' t% '
and c.cost_type_id (+) =1000
and D.secondary_inventory_name=a.subinventory_code
and d.organization_id=b.organization_id
GROUP by
B.segment1
, b.description
, A.subinventory_code
, B.primary_unit_of_measure
, C.material_cost
, d.description
ORDER BY
A.subinventory_code