TYPE=VIEW
query=select `dc`.`No` AS `no`,`da`.`acc_no` AS `acc_no`,`da`.`date_open` AS `date_open`,`da`.`amt` AS `amt`,`da`.`acc_type` AS `acc_type`,`da`.`fd_sv_acc_no` AS `fd_sv_acc_no`,`da`.`rd_dep_per` AS `rd_dep_per`,`dc`.`Amt` AS `instal_amountnt`,`dc`.`inst_dt` AS `inst_dt` from (`co-operativebank-mohati`.`deposit` `dc` join `co-operativebank-mohati`.`deposit_acc` `da`) where ((`da`.`acc_type` = \'rd\') and (`da`.`acc_no` = `dc`.`Acc_No`) and (`da`.`status` = \'Active\') and (`da`.`rd_dep_per` = 1))
md5=e38bff54eaac97facb3c43e71871430f
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2020-10-16 13:11:28
create-version=1
source=select  `dc`.`No`  AS  `no` ,\n `da`.`acc_no`  AS  `acc_no` ,\n `da`.`date_open`  AS  `date_open` ,\n `da`.`amt`  AS  `amt` ,\n `da`.`acc_type`  AS  `acc_type` ,\n `da`.`fd_sv_acc_no`  AS  `fd_sv_acc_no` ,\n `da`.`rd_dep_per`  AS  `rd_dep_per` ,\n `dc`.`Amt`  AS  `instal_amountnt` ,\n `dc`.`inst_dt`  AS  `inst_dt`  from (  `co-operativebank-mohati`.`deposit`  `dc`  join  `co-operativebank-mohati`.`deposit_acc`  `da`  ) where ( (  `da`.`acc_type`  =  \'rd\' ) and (  `da`.`acc_no`  =  `dc`.`Acc_No`  ) and (  `da`.`status`  =  \'Active\' ) and (  `da`.`rd_dep_per`  =1 ) )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `dc`.`No` AS `no`,`da`.`acc_no` AS `acc_no`,`da`.`date_open` AS `date_open`,`da`.`amt` AS `amt`,`da`.`acc_type` AS `acc_type`,`da`.`fd_sv_acc_no` AS `fd_sv_acc_no`,`da`.`rd_dep_per` AS `rd_dep_per`,`dc`.`Amt` AS `instal_amountnt`,`dc`.`inst_dt` AS `inst_dt` from (`co-operativebank-mohati`.`deposit` `dc` join `co-operativebank-mohati`.`deposit_acc` `da`) where ((`da`.`acc_type` = \'rd\') and (`da`.`acc_no` = `dc`.`Acc_No`) and (`da`.`status` = \'Active\') and (`da`.`rd_dep_per` = 1))
