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-243`.`deposit_acc` `d` join `co-operativebank-243`.`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-243`.`loan_acc` `a` join `co-operativebank-243`.`quick_name` `q`) where ((`a`.`status` = \'InActive\') and (`q`.`acc_no` = `a`.`acc_no`))
md5=7d14d934557a134610ee07c74c60dd55
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-09-15 05:28:13
create-version=1
source=select  `d`.`acc_no`  AS  `acc_no` ,\n `d`.`date_open`  AS  `date_open` ,\n `d`.`amt`  AS  `amt` ,\n `d`.`acc_type`  AS  `acc_type` ,\n `d`.`sub_head`  AS  `sub_head` ,\n `d`.`status`  AS  `status` ,\n \'Details\' AS  `details` ,\n `q`.`name`  AS  `name`  from (  `co-operativebank-243`.`deposit_acc`  `d`  join  `co-operativebank-243`.`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` ,\n `a`.`date_open`  AS  `date_open` ,\n `a`.`amt`  AS  `amt` ,\n \'LOAN\' AS  `LOAN` ,\n `a`.`sub_head`  AS  `sub_head` ,\n `a`.`status`  AS  `status` ,\n \'Details\' AS  `details` ,\n `q`.`name`  AS  `name`  from (  `co-operativebank-243`.`loan_acc`  `a`  join  `co-operativebank-243`.`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-243`.`deposit_acc` `d` join `co-operativebank-243`.`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-243`.`loan_acc` `a` join `co-operativebank-243`.`quick_name` `q`) where ((`a`.`status` = \'InActive\') and (`q`.`acc_no` = `a`.`acc_no`))
