Query to find Picked but not Dropped line(In material tranasation temp WMS)

SELECT   (SELECT   organization_code
            FROM   org_organization_definitions
           WHERE   organization_id = mmt.organization_id)
            org_name,
         msi.segment1 part_num,
         mmt.transaction_quantity,
         transaction_date,
         license_plate_number,
         TRANSFER_SUBINVENTORY,
         (SELECT   concatenated_segments
            FROM   mtl_item_locations_kfv
           WHERE   inventory_location_id = mmt.TRANSFER_TO_LOCATION)
            loc_name,lpn_context
  FROM   mtl_material_transactions_temp mmt,
         mtl_system_items_b msi,
         wms_license_plate_numbers wlp
 WHERE       mmt.inventory_item_id = msi.inventory_item_id
         AND mmt.organization_id = msi.organization_id
         AND mmt.transfer_lpn_id = wlp.lpn_id
         AND mmt.organization_id = :P_ORG_ID