TYPE=VIEW
query=select `d`.`acc_no` AS `acc_no`,`d`.`date_open` AS `date_open`,`d`.`amt` AS `amt`,`d`.`acc_type` AS `acc_type`,`d`.`sub_head` AS `sub_head`,`d`.`status` AS `status`,\'Details\' AS `details`,`q`.`name` AS `name` from `co-operativebank`.`deposit_acc` `d` join `co-operativebank`.`quick_name` `q` where ((`d`.`status` = \'InActive\') and (`d`.`acc_no` = `q`.`acc_no`)) group by `d`.`acc_no` union all select `a`.`acc_no` AS `acc_no`,`a`.`date_open` AS `date_open`,`a`.`amt` AS `amt`,\'LOAN\' AS `LOAN`,`a`.`sub_head` AS `sub_head`,`a`.`status` AS `status`,\'Details\' AS `details`,`q`.`name` AS `name` from (`co-operativebank`.`loan_acc` `a` join `co-operativebank`.`quick_name` `q`) where ((`a`.`status` = \'InActive\') and (`q`.`acc_no` = `a`.`acc_no`))
md5=317c906283a74898929a4fe272d6bc3e
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2018-06-11 05:09:25
create-version=1
source=select d.Acc_no AS acc_no,Date_open AS date_open,amt AS amt,Acc_Type AS acc_type,Sub_Head AS sub_head,Status AS status,\'Details\' AS details,Name AS name from deposit_acc d,quick_name q where (Status = \'InActive\') and d.acc_no=q.acc_no group by d.Acc_no 
\n union all select a.acc_no AS acc_no,a.date_open AS date_open,a.amt AS amt,\'LOAN\' AS LOAN,a.sub_head AS sub_head,a.status AS status,\'Details\' AS details, name from (loan_acc a,quick_name q) where ((a.status = \'InActive\') and q.acc_no=a.acc_no)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `d`.`acc_no` AS `acc_no`,`d`.`date_open` AS `date_open`,`d`.`amt` AS `amt`,`d`.`acc_type` AS `acc_type`,`d`.`sub_head` AS `sub_head`,`d`.`status` AS `status`,\'Details\' AS `details`,`q`.`name` AS `name` from `co-operativebank`.`deposit_acc` `d` join `co-operativebank`.`quick_name` `q` where ((`d`.`status` = \'InActive\') and (`d`.`acc_no` = `q`.`acc_no`)) group by `d`.`acc_no` union all select `a`.`acc_no` AS `acc_no`,`a`.`date_open` AS `date_open`,`a`.`amt` AS `amt`,\'LOAN\' AS `LOAN`,`a`.`sub_head` AS `sub_head`,`a`.`status` AS `status`,\'Details\' AS `details`,`q`.`name` AS `name` from (`co-operativebank`.`loan_acc` `a` join `co-operativebank`.`quick_name` `q`) where ((`a`.`status` = \'InActive\') and (`q`.`acc_no` = `a`.`acc_no`))
