TYPE=VIEW
query=select `a`.`code` AS `code`,`dc`.`acc_no` AS `Acc_no`,`dc`.`member_id` AS `Member_id`,`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`.`photo` AS `photo`,`a`.`sign` AS `sign`,`a`.`voter` AS `Voter`,`a`.`occupation` AS `Occupation`,`a`.`income` AS `Income`,`a`.`cust` AS `cust`,`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`,`a`.`verify` AS `verify`,`a`.`relation` AS `relation`,`dc`.`lf_no` AS `lf_no` from (((`co-operativebank-115`.`applicant` `a` join `co-operativebank-115`.`deposit_acc` `dc`) join `co-operativebank-115`.`nominee` `n`) join `co-operativebank-115`.`sub_head` `sh`) where ((`a`.`Acc_No` = `dc`.`acc_no`) and (`n`.`acc_no` = `dc`.`acc_no`) and (`sh`.`code` = `dc`.`sub_head`))
md5=c7b134f3f4d7a7a6e4bd905eef86f8a3
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2024-04-23 06:49:53
create-version=1
source=select  `a`.`code`  AS  `code` ,\n `dc`.`acc_no`  AS  `Acc_no` ,\n `dc`.`member_id`  AS  `Member_id` ,\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`.`photo`  AS  `photo` ,\n `a`.`sign`  AS  `sign` ,\n `a`.`voter`  AS  `Voter` ,\n `a`.`occupation`  AS  `Occupation` ,\n `a`.`income`  AS  `Income` ,\n `a`.`cust`  AS  `cust` ,\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 `a`.`verify`  AS  `verify` ,\n `a`.`relation`  AS  `relation` ,\n `dc`.`lf_no`  AS  `lf_no`  from ( ( (  `co-operativebank-115`.`applicant`  `a`  join  `co-operativebank-115`.`deposit_acc`  `dc`  ) join  `co-operativebank-115`.`nominee`  `n`  ) join  `co-operativebank-115`.`sub_head`  `sh`  ) where ( (  `a`.`Acc_No`  =  `dc`.`acc_no`  ) and (  `n`.`acc_no`  =  `dc`.`acc_no`  ) and (  `sh`.`code`  =  `dc`.`sub_head`  ) )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `a`.`code` AS `code`,`dc`.`acc_no` AS `Acc_no`,`dc`.`member_id` AS `Member_id`,`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`.`photo` AS `photo`,`a`.`sign` AS `sign`,`a`.`voter` AS `Voter`,`a`.`occupation` AS `Occupation`,`a`.`income` AS `Income`,`a`.`cust` AS `cust`,`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`,`a`.`verify` AS `verify`,`a`.`relation` AS `relation`,`dc`.`lf_no` AS `lf_no` from (((`co-operativebank-115`.`applicant` `a` join `co-operativebank-115`.`deposit_acc` `dc`) join `co-operativebank-115`.`nominee` `n`) join `co-operativebank-115`.`sub_head` `sh`) where ((`a`.`Acc_No` = `dc`.`acc_no`) and (`n`.`acc_no` = `dc`.`acc_no`) and (`sh`.`code` = `dc`.`sub_head`))
