Orphon serial numbers

SELECT count(*) FROM mtl_serial_numbers_temp msnt

where msnt.fm_serial_number =  'C-13-007106'  and

   NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp mmtt

    WHERE  mmtt.transaction_temp_id = msnt.transaction_temp_id)

AND     NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt

    WHERE  mtlt.SERIAL_TRANSACTION_TEMP_ID = msnt.transaction_temp_id)

  AND     NOT EXISTS (SELECT 1 FROM wsh_delivery_details wdd

    WHERE  wdd.transaction_temp_id IS NOT NULL

    AND    wdd.transaction_temp_id = msnt.transaction_temp_id

    AND    wdd.released_status in ('Y','C')

    AND    wdd.inv_interfaced_flag <> 'Y')

    AND     NOT EXISTS (SELECT 1 FROM rcv_transactions_interface rti

    WHERE  interface_transaction_id = msnt.transaction_temp_id);