SELECT trnx.id,trnx.bll_request_id,ch_process_id,trnx.msisdn,trnx.request_date,trnx.customer_type,trnx.id_type,trnx.id_type_value AS docid,trnx.dob,trnx.nll_transaction_id,
trnx.pos_code,trnx.process_id,proc.process_name,trnx.imei,trnx.sim_category,trnx.sim_serial_or_iccid AS sims_iccid,trnx.STATUS,error_details,new_id_type,new_id_type_value,new_dob,is_foreign,visa_expiry_date
FROM REDSHIFT_BLL_TXN.SUMMARY_TXN_LOG trnx LEFT JOIN REDSHIFT_BLL_TXN.process proc ON trnx.process_id=proc.process_id
WHERE
trnx.msisdn IN('8801626401229') AND STATUS ='SUCCESSFUL' --8801866951987
--trnx.bll_request_id='51918632'
--trnx.sim_serial_or_iccid='721251462747' and status ='SUCCESSFUL' --SUCCESSFUL FAILED
--and trnx.error_details='NID does not match with NID stored in'
ORDER BY trnx.request_date