TYPE=VIEW
query=select `co-operativebank`.`loan_acc`.`sub_head` AS `sub_head`,max(`co-operativebank`.`loan_acc`.`id`) AS `id`,`co-operativebank`.`loan_acc`.`acc_no` AS `acc_no`,max(`co-operativebank`.`loan_acc`.`date_open`) AS `issue_date`,max(`co-operativebank`.`loan_acc`.`fianl_date`) AS `due_data`,max(`co-operativebank`.`loan_acc`.`amt`) AS `Loan_amount`,0 AS `gap_amt`,0 AS `crop_amt`,0 AS `from_chr`,0 AS `share_amt`,`co-operativebank`.`loan_acc`.`c_status` AS `c_status` from `co-operativebank`.`loan_acc` where (`co-operativebank`.`loan_acc`.`sub_head` = \'23101A\') group by `co-operativebank`.`loan_acc`.`acc_no`
md5=37d34f9bcc073d9380c0b4062fb56bcd
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2022-05-30 06:49:15
create-version=1
source=select 	sub_head,max(id) as id,acc_no,max(date_open) as issue_date ,max(fianl_date) as due_data,max(amt) as Loan_amount,0 as gap_amt,0 as crop_amt,0 as from_chr,0 as share_amt,c_status from loan_acc where sub_head=\'23101A\' group by acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank`.`loan_acc`.`sub_head` AS `sub_head`,max(`co-operativebank`.`loan_acc`.`id`) AS `id`,`co-operativebank`.`loan_acc`.`acc_no` AS `acc_no`,max(`co-operativebank`.`loan_acc`.`date_open`) AS `issue_date`,max(`co-operativebank`.`loan_acc`.`fianl_date`) AS `due_data`,max(`co-operativebank`.`loan_acc`.`amt`) AS `Loan_amount`,0 AS `gap_amt`,0 AS `crop_amt`,0 AS `from_chr`,0 AS `share_amt`,`co-operativebank`.`loan_acc`.`c_status` AS `c_status` from `co-operativebank`.`loan_acc` where (`co-operativebank`.`loan_acc`.`sub_head` = \'23101A\') group by `co-operativebank`.`loan_acc`.`acc_no`
