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-246`.`applicant` `a` USE INDEX (`by_acc_no`) join `co-operativebank-246`.`deposit_acc` `dc` USE INDEX (`by_acc_no`)) join `co-operativebank-246`.`sub_head` `sh`) join `co-operativebank-246`.`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=6647515d6084ec2d0c5e36628fdd71fd
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-12-29 05:45:38
create-version=1
source=select  `dc`.`acc_no`  AS  `Acc_no` ,\n `dc`.`member_id`  AS  `Member_id` ,\n `dc`.`fd_sv_acc_no`  AS  `Sv_Acc_no` ,\n `a`.`initial`  AS  `initial` ,\n `a`.`fname`  AS  `fname` ,\n `a`.`mname`  AS  `mname` ,\n `a`.`lname`  AS  `lname` ,\nconcat(  `a`.`initial` ,  \' \',  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `Name` ,\n `a`.`father_name`  AS  `Father_Name` ,\n `a`.`gender`  AS  `Gender` ,\n `a`.`dob`  AS  `Dob` ,\n `a`.`address`  AS  `Address` ,\n `a`.`city`  AS  `City` ,\n `a`.`state`  AS  `State` ,\n `a`.`pin`  AS  `Pin` ,\n `a`.`mobile`  AS  `Mobile` ,\n `a`.`pan`  AS  `Pan` ,\n `a`.`adhar`  AS  `Adhar` ,\n `a`.`voter`  AS  `Voter` ,\n `a`.`occupation`  AS  `Occupation` ,\n `a`.`income`  AS  `Income` ,\n `a`.`verify`  AS  `verify` ,\n `a`.`photo`  AS  `photo` ,\n `a`.`sign`  AS  `sign` ,\n `dc`.`acc_type`  AS  `Acc_Type` ,\n `dc`.`operation_type`  AS  `Operation_Type` ,\n `dc`.`date_open`  AS  `Date_open` ,\n `sh`.`head`  AS  `Head` ,\n `dc`.`sub_head`  AS  `Sub_Head` ,\n `dc`.`amt`  AS  `Principle_Amount` ,\n `dc`.`Deposit_Type`  AS  `Deposit_Type` ,\n `dc`.`Chk_Acc_No`  AS  `Chk_Acc_No` ,\n `dc`.`Chk_No`  AS  `Chk_No` ,\n `dc`.`Draw_Bank`  AS  `Draw_Bank` ,\n `dc`.`Duration`  AS  `Duration` ,\n `dc`.`Duration_Type`  AS  `Duration_Type` ,\n `dc`.`Instalment_Type`  AS  `Instalment_Type` ,\n `dc`.`Age_Type`  AS  `Age_Type` ,\n `dc`.`interest`  AS  `interest` ,\n `dc`.`maturity_amt`  AS  `Maturity_Amount` ,\n `dc`.`maturity_date`  AS  `Maturity_Date` ,\n `dc`.`status`  AS  `Status` ,\n `dc`.`intro_acc_no`  AS  `Introducer_Account` ,\n `n`.`name`  AS  `Nominee_Name` ,\n `n`.`address`  AS  `Nominee_Address` ,\n `n`.`city`  AS  `Nominee_City` ,\n `n`.`state`  AS  `Nominee_State` ,\n `n`.`pin`  AS  `Nominee_Pin` ,\n `n`.`relation`  AS  `Nominee_Relation` ,\n `n`.`dob`  AS  `Nominee_Dob` ,\n `dc`.`amt`  AS  `amt` ,\n `dc`.`loan_acc_no`  AS  `loan_acc_no` ,\n `dc`.`lf_no`  AS  `lf_no` ,\n `dc`.`smsfacility`  AS  `smsfacility` ,\n `dc`.`maturity_amt`  AS  `maturity_amt` ,\n `dc`.`block`  AS  `block` ,\n `dc`.`bankacc`  AS  `bankacc` ,\n `a`.`email`  AS  `email` ,\n `a`.`cust`  AS  `cust` ,\n `dc`.`fd_sv_acc_no`  AS  `fd_sv_acc_no` ,\n `dc`.`deperment`  AS  `deperment` ,\n `dc`.`close_dt`  AS  `close_dt`  from ( ( (  `co-operativebank-246`.`applicant`  `a`  USE  INDEX (  `by_acc_no`  )  join  `co-operativebank-246`.`deposit_acc`  `dc`  USE  INDEX (  `by_acc_no`  )  ) join  `co-operativebank-246`.`sub_head`  `sh`  ) join  `co-operativebank-246`.`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-246`.`applicant` `a` USE INDEX (`by_acc_no`) join `co-operativebank-246`.`deposit_acc` `dc` USE INDEX (`by_acc_no`)) join `co-operativebank-246`.`sub_head` `sh`) join `co-operativebank-246`.`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`))
