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

Item Against Sub inventory and locatory

/* Get Item Against Primary Subinv and locator */
  SELECT   SEGMENT1 PART_NUM,
           (SELECT   SECONDARY_INVENTORY
              FROM   MTL_ITEM_SUB_INVENTORIES_ALL_V
             WHERE       INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
                     AND ORGANIZATION_ID = MSI.ORGANIZATION_ID
                     AND ROWNUM = 1)
              PRIMARY_SUB_INV,
           (SELECT   CONCATENATED_SEGMENTS
              FROM   MTL_ITEM_LOCATIONS_KFV
             WHERE   INVENTORY_LOCATION_ID IN
                           (SELECT   MIN (SECONDARY_LOCATOR)
                              FROM   MTL_SECONDARY_LOCATORS_ALL_V
                             WHERE   INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
                                     AND ORGANIZATION_ID = MSI.ORGANIZATION_ID))
              LOCATOR
    FROM   MTL_SYSTEM_ITEMS_B MSI
   WHERE   ORGANIZATION_ID = :P_ORG_ID
ORDER BY   1