TYPE=VIEW
query=select `co-operativebank-246`.`loan_acc`.`acc_no` AS `acc_no`,`co-operativebank-246`.`loan_acc`.`sub_head` AS `sub_head`,max(`co-operativebank-246`.`loan_acc`.`fianl_date`) AS `fianl_date`,`co-operativebank-246`.`loan_acc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,max(`co-operativebank-246`.`loan_acc`.`date_open`) AS `date_open`,max(`co-operativebank-246`.`loan_acc`.`id`) AS `id` from `co-operativebank-246`.`loan_acc` group by `co-operativebank-246`.`loan_acc`.`acc_no`,`co-operativebank-246`.`loan_acc`.`sub_head`
md5=0ca125b0a14fff26f40343e5caf8594f
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-12-29 05:45:54
create-version=1
source=select  `co-operativebank-246`.`loan_acc`.`acc_no`  AS  `acc_no` ,\n `co-operativebank-246`.`loan_acc`.`sub_head`  AS  `sub_head` ,\nmax(  `co-operativebank-246`.`loan_acc`.`fianl_date`  )  AS  `fianl_date` ,\n `co-operativebank-246`.`loan_acc`.`loan_against_sv_acc`  AS  `loan_against_sv_acc` ,\nmax(  `co-operativebank-246`.`loan_acc`.`date_open`  )  AS  `date_open` ,\nmax(  `co-operativebank-246`.`loan_acc`.`id`  )  AS  `id`  from  `co-operativebank-246`.`loan_acc`  group  by  `co-operativebank-246`.`loan_acc`.`acc_no` ,\n `co-operativebank-246`.`loan_acc`.`sub_head`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-246`.`loan_acc`.`acc_no` AS `acc_no`,`co-operativebank-246`.`loan_acc`.`sub_head` AS `sub_head`,max(`co-operativebank-246`.`loan_acc`.`fianl_date`) AS `fianl_date`,`co-operativebank-246`.`loan_acc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,max(`co-operativebank-246`.`loan_acc`.`date_open`) AS `date_open`,max(`co-operativebank-246`.`loan_acc`.`id`) AS `id` from `co-operativebank-246`.`loan_acc` group by `co-operativebank-246`.`loan_acc`.`acc_no`,`co-operativebank-246`.`loan_acc`.`sub_head`
