TYPE=VIEW
query=select `co-operativebank-244`.`loan_acc`.`acc_no` AS `acc_no`,`co-operativebank-244`.`loan_acc`.`sub_head` AS `sub_head`,max(`co-operativebank-244`.`loan_acc`.`fianl_date`) AS `fianl_date`,`co-operativebank-244`.`loan_acc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,max(`co-operativebank-244`.`loan_acc`.`date_open`) AS `date_open`,max(`co-operativebank-244`.`loan_acc`.`id`) AS `id` from `co-operativebank-244`.`loan_acc` group by `co-operativebank-244`.`loan_acc`.`acc_no`,`co-operativebank-244`.`loan_acc`.`sub_head`
md5=89c8cc1df372a35d585d64eee02fac20
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-11-19 04:30:16
create-version=1
source=select  `co-operativebank-244`.`loan_acc`.`acc_no`  AS  `acc_no` ,\n `co-operativebank-244`.`loan_acc`.`sub_head`  AS  `sub_head` ,\nmax(  `co-operativebank-244`.`loan_acc`.`fianl_date`  )  AS  `fianl_date` ,\n `co-operativebank-244`.`loan_acc`.`loan_against_sv_acc`  AS  `loan_against_sv_acc` ,\nmax(  `co-operativebank-244`.`loan_acc`.`date_open`  )  AS  `date_open` ,\nmax(  `co-operativebank-244`.`loan_acc`.`id`  )  AS  `id`  from  `co-operativebank-244`.`loan_acc`  group  by  `co-operativebank-244`.`loan_acc`.`acc_no` ,\n `co-operativebank-244`.`loan_acc`.`sub_head`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-244`.`loan_acc`.`acc_no` AS `acc_no`,`co-operativebank-244`.`loan_acc`.`sub_head` AS `sub_head`,max(`co-operativebank-244`.`loan_acc`.`fianl_date`) AS `fianl_date`,`co-operativebank-244`.`loan_acc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,max(`co-operativebank-244`.`loan_acc`.`date_open`) AS `date_open`,max(`co-operativebank-244`.`loan_acc`.`id`) AS `id` from `co-operativebank-244`.`loan_acc` group by `co-operativebank-244`.`loan_acc`.`acc_no`,`co-operativebank-244`.`loan_acc`.`sub_head`
