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-bajbajia`.`deposit_acc` `d` join `co-operativebank-bajbajia`.`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-bajbajia`.`loan_acc` `a` join `co-operativebank-bajbajia`.`quick_name` `q`) where ((`a`.`status` = \'InActive\') and (`q`.`acc_no` = `a`.`acc_no`))
md5=38567e4f41fa9a83151e0907ce231232
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:52:12
create-version=1
source=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 (`deposit_acc` `d` join `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 (`loan_acc` `a` join `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-bajbajia`.`deposit_acc` `d` join `co-operativebank-bajbajia`.`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-bajbajia`.`loan_acc` `a` join `co-operativebank-bajbajia`.`quick_name` `q`) where ((`a`.`status` = \'InActive\') and (`q`.`acc_no` = `a`.`acc_no`))
