Onhand quantity LPN wise

Need sql query to pull onhand qty information LPN wise along with item details.Below columns has to be in the query

LPN and LPN creationdate,product, onhadn_qty.Below query is wrong results.

SELECT wln.LICENSE_PLATE_NUMBER InventoryId,

       wln.CREATION_DATE DeliveryDate,

       /*wln.subinventory_code subinventory_code,*/     

       msiv.concatenated_segments ProductId,

             sum(wlc.quantity) Quantity

       ,MMS.STATUS_CODE Status

       ,decode(MMS.STATUS_CODE,'Active','F','T') OnHold

  FROM mtl_parameters mp,

       mtl_lot_numbers mln,

       mtl_item_locations_kfv mil,

       mtl_secondary_inventories msi,

       wms_lpn_contents wlc,

       wms_license_plate_numbers wln,

       mtl_system_items_vl msiv,