SELECT l.Application_Id,CW_Transaction_Id as TRANSACTION_ID,Mobile_Phone, 
l.External_Source_System,l.WorkFlow_Stage,
l.Request_PayLoad,l.Response_PayLoad  FROM 
loandb.loan_application_external_response l,loandb.loan_application_details a
where l.Application_Id=a.Application_Id and Mobile_Phone='639100888888';