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-211`.`loan_acc` `l` join `co-operativebank-211`.`loan_deposit` `ld` where ((`ld`.`loan_id` = `l`.`id`) and (`ld`.`Date` >= \'2022-10-11\') and (`ld`.`Date` <= \'2023-09-30\') and (`l`.`sub_head` = \'23101A\')) group by `ld`.`loan_id`
md5=ae4c2ed102628a029c3168792eea7b68
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2024-04-09 12:50:00
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>=\'2022-10-11\' and date<=\'2023-09-30\' and sub_head=\'23101A\' group by ld.loan_id
client_cs_name=utf8
connection_cl_name=utf8_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-211`.`loan_acc` `l` join `co-operativebank-211`.`loan_deposit` `ld` where ((`ld`.`loan_id` = `l`.`id`) and (`ld`.`Date` >= \'2022-10-11\') and (`ld`.`Date` <= \'2023-09-30\') and (`l`.`sub_head` = \'23101A\')) group by `ld`.`loan_id`
