TYPE=VIEW
query=select `dc`.`acc_no` AS `Acc_no`,`dc`.`member_id` AS `Member_id`,`dc`.`fd_sv_acc_no` AS `Sv_Acc_no`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `Name`,`a`.`father_name` AS `Father_Name`,`a`.`gender` AS `Gender`,`a`.`dob` AS `Dob`,`a`.`address` AS `Address`,`a`.`city` AS `City`,`a`.`state` AS `State`,`a`.`pin` AS `Pin`,`a`.`mobile` AS `Mobile`,`a`.`pan` AS `Pan`,`a`.`adhar` AS `Adhar`,`a`.`voter` AS `Voter`,`a`.`occupation` AS `Occupation`,`a`.`income` AS `Income`,`a`.`verify` AS `verify`,`a`.`photo` AS `photo`,`a`.`sign` AS `sign`,`dc`.`acc_type` AS `Acc_Type`,`dc`.`operation_type` AS `Operation_Type`,`dc`.`date_open` AS `Date_open`,`sh`.`head` AS `Head`,`dc`.`sub_head` AS `Sub_Head`,`dc`.`amt` AS `Principle_Amount`,`dc`.`Deposit_Type` AS `Deposit_Type`,`dc`.`Chk_Acc_No` AS `Chk_Acc_No`,`dc`.`Chk_No` AS `Chk_No`,`dc`.`Draw_Bank` AS `Draw_Bank`,`dc`.`Duration` AS `Duration`,`dc`.`Duration_Type` AS `Duration_Type`,`dc`.`Instalment_Type` AS `Instalment_Type`,`dc`.`Age_Type` AS `Age_Type`,`dc`.`interest` AS `interest`,`dc`.`maturity_amt` AS `Maturity_Amount`,`dc`.`maturity_date` AS `Maturity_Date`,`dc`.`status` AS `Status`,`dc`.`intro_acc_no` AS `Introducer_Account`,`n`.`name` AS `Nominee_Name`,`n`.`address` AS `Nominee_Address`,`n`.`city` AS `Nominee_City`,`n`.`state` AS `Nominee_State`,`n`.`pin` AS `Nominee_Pin`,`n`.`relation` AS `Nominee_Relation`,`n`.`dob` AS `Nominee_Dob`,`dc`.`amt` AS `amt`,`dc`.`loan_acc_no` AS `loan_acc_no`,`dc`.`lf_no` AS `lf_no`,`dc`.`smsfacility` AS `smsfacility`,`dc`.`maturity_amt` AS `maturity_amt`,`dc`.`block` AS `block`,`dc`.`bankacc` AS `bankacc`,`a`.`email` AS `email`,`a`.`cust` AS `cust`,`dc`.`fd_sv_acc_no` AS `fd_sv_acc_no`,`dc`.`deperment` AS `deperment`,`dc`.`close_dt` AS `close_dt` from (((`co-operativebank-dekhaliannapurna`.`applicant` `a` USE INDEX (`by_acc_no`) join `co-operativebank-dekhaliannapurna`.`deposit_acc` `dc` USE INDEX (`by_acc_no`)) join `co-operativebank-dekhaliannapurna`.`sub_head` `sh`) join `co-operativebank-dekhaliannapurna`.`nominee` `n` USE INDEX (`by_acc_no`)) where ((`a`.`Acc_No` = `dc`.`acc_no`) and (`n`.`acc_no` = `dc`.`acc_no`) and (`dc`.`sub_head` = `sh`.`code`) and (`dc`.`app_code` = `a`.`code`))
md5=1d175f992072cf08438482847e2d324d
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2024-11-26 07:09:10
create-version=1
source=select `dc`.`acc_no` AS `Acc_no`,`dc`.`member_id` AS `Member_id`,`dc`.`fd_sv_acc_no` AS `Sv_Acc_no`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `Name`,`a`.`father_name` AS `Father_Name`,`a`.`gender` AS `Gender`,`a`.`dob` AS `Dob`,`a`.`address` AS `Address`,`a`.`city` AS `City`,`a`.`state` AS `State`,`a`.`pin` AS `Pin`,`a`.`mobile` AS `Mobile`,`a`.`pan` AS `Pan`,`a`.`adhar` AS `Adhar`,`a`.`voter` AS `Voter`,`a`.`occupation` AS `Occupation`,`a`.`income` AS `Income`,`a`.`verify` AS `verify`,`a`.`photo` AS `photo`,`a`.`sign` AS `sign`,`dc`.`acc_type` AS `Acc_Type`,`dc`.`operation_type` AS `Operation_Type`,`dc`.`date_open` AS `Date_open`,`sh`.`head` AS `Head`,`dc`.`sub_head` AS `Sub_Head`,`dc`.`amt` AS `Principle_Amount`,`dc`.`Deposit_Type` AS `Deposit_Type`,`dc`.`Chk_Acc_No` AS `Chk_Acc_No`,`dc`.`Chk_No` AS `Chk_No`,`dc`.`Draw_Bank` AS `Draw_Bank`,`dc`.`Duration` AS `Duration`,`dc`.`Duration_Type` AS `Duration_Type`,`dc`.`Instalment_Type` AS `Instalment_Type`,`dc`.`Age_Type` AS `Age_Type`,`dc`.`interest` AS `interest`,`dc`.`maturity_amt` AS `Maturity_Amount`,`dc`.`maturity_date` AS `Maturity_Date`,`dc`.`status` AS `Status`,`dc`.`intro_acc_no` AS `Introducer_Account`,`n`.`name` AS `Nominee_Name`,`n`.`address` AS `Nominee_Address`,`n`.`city` AS `Nominee_City`,`n`.`state` AS `Nominee_State`,`n`.`pin` AS `Nominee_Pin`,`n`.`relation` AS `Nominee_Relation`,`n`.`dob` AS `Nominee_Dob`,`dc`.`amt` AS `amt`,`dc`.`loan_acc_no` AS `loan_acc_no`,`dc`.`lf_no` AS `lf_no`,`dc`.`smsfacility` AS `smsfacility`,`dc`.`maturity_amt` AS `maturity_amt`,`dc`.`block` AS `block`,`dc`.`bankacc` AS `bankacc`,`a`.`email` AS `email`,`a`.`cust` AS `cust`,`dc`.`fd_sv_acc_no` AS `fd_sv_acc_no`,dc.deperment,dc.close_dt from (((`applicant` `a` USE INDEX (`by_acc_no`) join `deposit_acc` `dc` USE INDEX (`by_acc_no`)) join `sub_head` `sh`) join `nominee` `n` USE INDEX (`by_acc_no`)) where ((`a`.`Acc_No` = `dc`.`acc_no`) and (`n`.`acc_no` = `dc`.`acc_no`) and (`dc`.`sub_head` = `sh`.`code`) and (`dc`.`app_code` = `a`.`code`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `dc`.`acc_no` AS `Acc_no`,`dc`.`member_id` AS `Member_id`,`dc`.`fd_sv_acc_no` AS `Sv_Acc_no`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `Name`,`a`.`father_name` AS `Father_Name`,`a`.`gender` AS `Gender`,`a`.`dob` AS `Dob`,`a`.`address` AS `Address`,`a`.`city` AS `City`,`a`.`state` AS `State`,`a`.`pin` AS `Pin`,`a`.`mobile` AS `Mobile`,`a`.`pan` AS `Pan`,`a`.`adhar` AS `Adhar`,`a`.`voter` AS `Voter`,`a`.`occupation` AS `Occupation`,`a`.`income` AS `Income`,`a`.`verify` AS `verify`,`a`.`photo` AS `photo`,`a`.`sign` AS `sign`,`dc`.`acc_type` AS `Acc_Type`,`dc`.`operation_type` AS `Operation_Type`,`dc`.`date_open` AS `Date_open`,`sh`.`head` AS `Head`,`dc`.`sub_head` AS `Sub_Head`,`dc`.`amt` AS `Principle_Amount`,`dc`.`Deposit_Type` AS `Deposit_Type`,`dc`.`Chk_Acc_No` AS `Chk_Acc_No`,`dc`.`Chk_No` AS `Chk_No`,`dc`.`Draw_Bank` AS `Draw_Bank`,`dc`.`Duration` AS `Duration`,`dc`.`Duration_Type` AS `Duration_Type`,`dc`.`Instalment_Type` AS `Instalment_Type`,`dc`.`Age_Type` AS `Age_Type`,`dc`.`interest` AS `interest`,`dc`.`maturity_amt` AS `Maturity_Amount`,`dc`.`maturity_date` AS `Maturity_Date`,`dc`.`status` AS `Status`,`dc`.`intro_acc_no` AS `Introducer_Account`,`n`.`name` AS `Nominee_Name`,`n`.`address` AS `Nominee_Address`,`n`.`city` AS `Nominee_City`,`n`.`state` AS `Nominee_State`,`n`.`pin` AS `Nominee_Pin`,`n`.`relation` AS `Nominee_Relation`,`n`.`dob` AS `Nominee_Dob`,`dc`.`amt` AS `amt`,`dc`.`loan_acc_no` AS `loan_acc_no`,`dc`.`lf_no` AS `lf_no`,`dc`.`smsfacility` AS `smsfacility`,`dc`.`maturity_amt` AS `maturity_amt`,`dc`.`block` AS `block`,`dc`.`bankacc` AS `bankacc`,`a`.`email` AS `email`,`a`.`cust` AS `cust`,`dc`.`fd_sv_acc_no` AS `fd_sv_acc_no`,`dc`.`deperment` AS `deperment`,`dc`.`close_dt` AS `close_dt` from (((`co-operativebank-dekhaliannapurna`.`applicant` `a` USE INDEX (`by_acc_no`) join `co-operativebank-dekhaliannapurna`.`deposit_acc` `dc` USE INDEX (`by_acc_no`)) join `co-operativebank-dekhaliannapurna`.`sub_head` `sh`) join `co-operativebank-dekhaliannapurna`.`nominee` `n` USE INDEX (`by_acc_no`)) where ((`a`.`Acc_No` = `dc`.`acc_no`) and (`n`.`acc_no` = `dc`.`acc_no`) and (`dc`.`sub_head` = `sh`.`code`) and (`dc`.`app_code` = `a`.`code`))
