TYPE=VIEW
query=select max(`co-operativebank-244`.`loan_deposit`.`loan_id`) AS `loan_id`,`co-operativebank-244`.`loan_deposit`.`Acc_No` AS `acc_no`,sum(`co-operativebank-244`.`loan_deposit`.`prin_amt`) AS `prin_amt`,max(`co-operativebank-244`.`loan_deposit`.`Date`) AS `Date` from `co-operativebank-244`.`loan_deposit` group by `co-operativebank-244`.`loan_deposit`.`Acc_No`
md5=8e14f2bf84f3f3d44152f3061d2cc4b5
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-11-19 04:30:15
create-version=1
source=select max(  `co-operativebank-244`.`loan_deposit`.`loan_id`  )  AS  `loan_id` ,\n `co-operativebank-244`.`loan_deposit`.`Acc_No`  AS  `acc_no` ,\nsum(  `co-operativebank-244`.`loan_deposit`.`prin_amt`  )  AS  `prin_amt` ,\nmax(  `co-operativebank-244`.`loan_deposit`.`Date`  )  AS  `Date`  from  `co-operativebank-244`.`loan_deposit`  group  by  `co-operativebank-244`.`loan_deposit`.`Acc_No`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select max(`co-operativebank-244`.`loan_deposit`.`loan_id`) AS `loan_id`,`co-operativebank-244`.`loan_deposit`.`Acc_No` AS `acc_no`,sum(`co-operativebank-244`.`loan_deposit`.`prin_amt`) AS `prin_amt`,max(`co-operativebank-244`.`loan_deposit`.`Date`) AS `Date` from `co-operativebank-244`.`loan_deposit` group by `co-operativebank-244`.`loan_deposit`.`Acc_No`
