TYPE=VIEW
query=select `dc`.`id` AS `id`,`a`.`code` AS `code`,`dc`.`acc_no` AS `acc_no`,`dc`.`member_id` AS `member_id`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`,\' \',`dc`.`name_p`) AS `name`,`dc`.`name_p` AS `Name_Of_Person`,`a`.`father_name` AS `father_name`,`a`.`gender` AS `gender`,`a`.`dob` AS `dob`,`a`.`address` AS `address`,`a`.`city` AS `city`,`a`.`cust` AS `cust`,`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`,`dc`.`acc_type` AS `acc_type`,`dc`.`date_open` AS `date_open`,`dc`.`head` AS `head`,`dc`.`sub_head` AS `sub_head`,`dc`.`scheme` AS `scheme`,`dc`.`duration` AS `duration`,`dc`.`duration_time` AS `duration_time`,`dc`.`fianl_date` AS `fianl_date`,`dc`.`amt` AS `amt`,`dc`.`interest` AS `interest`,`dc`.`inst_amt` AS `inst_amt`,`dc`.`status` AS `status`,`dc`.`c_status` AS `Complete_status`,`dc`.`no_inst` AS `Number_Instalment`,`dc`.`loan_against` AS `loan_against`,`dc`.`loan_agianst_acc_no` AS `loan_agianst_acc_no`,`dc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`a`.`verify` AS `verify`,`dc`.`ins_type` AS `ins_type`,`dc`.`no_inst` AS `no_inst`,`dc`.`od_int` AS `od_int`,`dc`.`lf_no` AS `lf_no`,`dc`.`s_amt` AS `s_amt`,`dc`.`last_day` AS `last_day`,`dc`.`oth_amt` AS `oth_amt`,`dc`.`deperment` AS `deperment`,`dc`.`c_status` AS `c_status`,`dcc`.`bankacc` AS `BANKACC` from ((`co-operativebank-henria`.`applicant` `a` join `co-operativebank-henria`.`loan_acc` `dc`) join `co-operativebank-henria`.`deposit_acc` `dcc`) where ((`dcc`.`acc_no` = `a`.`Acc_No`) and (`dcc`.`acc_no` = `dc`.`loan_against_sv_acc`) and (`a`.`Acc_No` = `dc`.`loan_against_sv_acc`) and (`a`.`code` = `dc`.`app_code`))
md5=8fc8b241756d38d95a976a1bda3caa3f
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-06-05 08:06:36
create-version=1
source=select `dc`.`id` AS `id`,`a`.`code` AS `code`,`dc`.`acc_no` AS `acc_no`,`dc`.`member_id` AS `member_id`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`,\' \',`dc`.`name_p`) AS `name`,`dc`.`name_p` AS `Name_Of_Person`,`a`.`father_name` AS `father_name`,`a`.`gender` AS `gender`,`a`.`dob` AS `dob`,`a`.`address` AS `address`,`a`.`city` AS `city`,a.cust,`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`,`dc`.`acc_type` AS `acc_type`,`dc`.`date_open` AS `date_open`,`dc`.`head` AS `head`,`dc`.`sub_head` AS `sub_head`,`dc`.`scheme` AS `scheme`,`dc`.`duration` AS `duration`,`dc`.`duration_time` AS `duration_time`,`dc`.`fianl_date` AS `fianl_date`,`dc`.`amt` AS `amt`,`dc`.`interest` AS `interest`,`dc`.`inst_amt` AS `inst_amt`,`dc`.`status` AS `status`,`dc`.`c_status` AS `Complete_status`,`dc`.`no_inst` AS `Number_Instalment`,`dc`.`loan_against` AS `loan_against`,`dc`.`loan_agianst_acc_no` AS `loan_agianst_acc_no`,`dc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`a`.`verify` AS `verify`,`dc`.`ins_type` AS `ins_type`,`dc`.`no_inst` AS `no_inst`,`dc`.`od_int` AS `od_int`,`dc`.`lf_no` AS `lf_no`,`dc`.`s_amt` AS `s_amt`,`dc`.`last_day` AS `last_day`,`dc`.`oth_amt` AS `oth_amt`,`dc`.`deperment` AS `deperment`,`dc`.`c_status` AS `c_status`,`dcc`.`bankacc` AS `BANKACC` from ((`applicant` `a` join `loan_acc` `dc`) join `deposit_acc` `dcc`) where ((`dcc`.`acc_no` = `a`.`Acc_No`) and (`dcc`.`acc_no` = `dc`.`loan_against_sv_acc`) and (`a`.`Acc_No` = `dc`.`loan_against_sv_acc`) and (`a`.`code` = `dc`.`app_code`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `dc`.`id` AS `id`,`a`.`code` AS `code`,`dc`.`acc_no` AS `acc_no`,`dc`.`member_id` AS `member_id`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`,\' \',`dc`.`name_p`) AS `name`,`dc`.`name_p` AS `Name_Of_Person`,`a`.`father_name` AS `father_name`,`a`.`gender` AS `gender`,`a`.`dob` AS `dob`,`a`.`address` AS `address`,`a`.`city` AS `city`,`a`.`cust` AS `cust`,`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`,`dc`.`acc_type` AS `acc_type`,`dc`.`date_open` AS `date_open`,`dc`.`head` AS `head`,`dc`.`sub_head` AS `sub_head`,`dc`.`scheme` AS `scheme`,`dc`.`duration` AS `duration`,`dc`.`duration_time` AS `duration_time`,`dc`.`fianl_date` AS `fianl_date`,`dc`.`amt` AS `amt`,`dc`.`interest` AS `interest`,`dc`.`inst_amt` AS `inst_amt`,`dc`.`status` AS `status`,`dc`.`c_status` AS `Complete_status`,`dc`.`no_inst` AS `Number_Instalment`,`dc`.`loan_against` AS `loan_against`,`dc`.`loan_agianst_acc_no` AS `loan_agianst_acc_no`,`dc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`a`.`verify` AS `verify`,`dc`.`ins_type` AS `ins_type`,`dc`.`no_inst` AS `no_inst`,`dc`.`od_int` AS `od_int`,`dc`.`lf_no` AS `lf_no`,`dc`.`s_amt` AS `s_amt`,`dc`.`last_day` AS `last_day`,`dc`.`oth_amt` AS `oth_amt`,`dc`.`deperment` AS `deperment`,`dc`.`c_status` AS `c_status`,`dcc`.`bankacc` AS `BANKACC` from ((`co-operativebank-henria`.`applicant` `a` join `co-operativebank-henria`.`loan_acc` `dc`) join `co-operativebank-henria`.`deposit_acc` `dcc`) where ((`dcc`.`acc_no` = `a`.`Acc_No`) and (`dcc`.`acc_no` = `dc`.`loan_against_sv_acc`) and (`a`.`Acc_No` = `dc`.`loan_against_sv_acc`) and (`a`.`code` = `dc`.`app_code`))
