TYPE=VIEW
query=select `ld`.`loan_id` AS `loan_id`,`ld`.`Acc_No` AS `acc_no`,sum(`ld`.`intrst_Amt`) AS `int_amt`,sum(`ld`.`Total_amt`) AS `prince`,max(`ld`.`Date`) AS `max_dt`,round(((sum(`ld`.`intrst_Amt`) / `l`.`interest`) * 3),0) AS `subsidy`,(`l`.`amt` - sum(`ld`.`Total_amt`)) AS `Due_Amt` from `co-operativebank-244`.`loan_acc` `l` join `co-operativebank-244`.`loan_deposit` `ld` where ((`ld`.`loan_id` = `l`.`id`) and (`ld`.`Date` >= \'2025-04-01\') and (`ld`.`Date` <= \'2026-02-10\') and (`l`.`sub_head` = \'23101B\')) group by `ld`.`loan_id`
md5=ad828745fd39f48a6c79f79044b76533
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2026-02-10 10:34:02
create-version=1
source=SELECT loan_id,ld.acc_no,sum(intrst_Amt) as int_amt,sum(Total_amt) as prince,max(date) as max_dt,round((sum(intrst_amt)/interest*3),0) subsidy,(l.amt-sum(`ld`.`Total_amt`)) as Due_Amt FROM `loan_acc` l,loan_deposit ld  WHERE ld.loan_id=l.id and date>=\'2025-04-01\' and date<=\'2026-02-10\' and sub_head=\'23101B\' group by ld.loan_id
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `ld`.`loan_id` AS `loan_id`,`ld`.`Acc_No` AS `acc_no`,sum(`ld`.`intrst_Amt`) AS `int_amt`,sum(`ld`.`Total_amt`) AS `prince`,max(`ld`.`Date`) AS `max_dt`,round(((sum(`ld`.`intrst_Amt`) / `l`.`interest`) * 3),0) AS `subsidy`,(`l`.`amt` - sum(`ld`.`Total_amt`)) AS `Due_Amt` from `co-operativebank-244`.`loan_acc` `l` join `co-operativebank-244`.`loan_deposit` `ld` where ((`ld`.`loan_id` = `l`.`id`) and (`ld`.`Date` >= \'2025-04-01\') and (`ld`.`Date` <= \'2026-02-10\') and (`l`.`sub_head` = \'23101B\')) group by `ld`.`loan_id`
