select order_number
from oks_reprocessing a
where a.success_flag = ‘E’ and order_number not in (Select nvl(source_header_ref,’11111′) from csi_txn_errors)
List the orders that have failed in transaction and have an entry in the CSI_TXN_ERRORS table.