TYPE=VIEW
query=select `co-operativebank-mitrachak`.`loan_acc`.`id` AS `id`,`co-operativebank-mitrachak`.`loan_acc`.`no` AS `no`,`co-operativebank-mitrachak`.`loan_acc`.`member_id` AS `member_id`,`co-operativebank-mitrachak`.`loan_acc`.`app_code` AS `app_code`,`co-operativebank-mitrachak`.`loan_acc`.`acc_no` AS `acc_no`,`co-operativebank-mitrachak`.`loan_acc`.`loan_against` AS `loan_against`,`co-operativebank-mitrachak`.`loan_acc`.`acc_type` AS `acc_type`,`co-operativebank-mitrachak`.`loan_acc`.`date_open` AS `date_open`,`co-operativebank-mitrachak`.`loan_acc`.`sub_head` AS `sub_head`,`co-operativebank-mitrachak`.`loan_acc`.`duration` AS `duration`,`co-operativebank-mitrachak`.`loan_acc`.`duration_time` AS `duration_time`,`co-operativebank-mitrachak`.`loan_acc`.`fianl_date` AS `fianl_date`,`co-operativebank-mitrachak`.`loan_acc`.`amt` AS `amt`,`co-operativebank-mitrachak`.`loan_acc`.`interest` AS `interest`,`co-operativebank-mitrachak`.`loan_acc`.`inst_amt` AS `inst_amt`,`co-operativebank-mitrachak`.`loan_acc`.`status` AS `status`,`co-operativebank-mitrachak`.`loan_acc`.`vch_no` AS `vch_no`,`co-operativebank-mitrachak`.`loan_acc`.`s_acc_no` AS `s_acc_no`,`co-operativebank-mitrachak`.`loan_acc`.`s_dtl` AS `s_dtl`,`co-operativebank-mitrachak`.`loan_acc`.`s_amt` AS `s_amt`,`co-operativebank-mitrachak`.`loan_acc`.`no_inst` AS `no_inst`,`co-operativebank-mitrachak`.`loan_acc`.`loan_agianst_acc_no` AS `loan_agianst_acc_no`,`co-operativebank-mitrachak`.`loan_acc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`co-operativebank-mitrachak`.`loan_acc`.`head` AS `head`,`co-operativebank-mitrachak`.`loan_acc`.`scheme` AS `scheme`,`co-operativebank-mitrachak`.`loan_acc`.`c_status` AS `c_status`,`co-operativebank-mitrachak`.`loan_acc`.`oth_amt` AS `oth_amt`,`co-operativebank-mitrachak`.`loan_acc`.`name_p` AS `name_p`,`co-operativebank-mitrachak`.`loan_acc`.`ins_type` AS `ins_type`,`co-operativebank-mitrachak`.`loan_acc`.`poloan` AS `poloan`,`co-operativebank-mitrachak`.`loan_acc`.`mdate` AS `mdate`,`co-operativebank-mitrachak`.`loan_acc`.`od_int` AS `od_int`,`co-operativebank-mitrachak`.`loan_acc`.`last_day` AS `last_day`,`co-operativebank-mitrachak`.`loan_acc`.`nsc` AS `nsc`,`co-operativebank-mitrachak`.`loan_acc`.`lf_no` AS `lf_no`,`co-operativebank-mitrachak`.`loan_acc`.`bankacc` AS `bankacc`,`co-operativebank-mitrachak`.`loan_acc`.`accper` AS `accper`,`co-operativebank-mitrachak`.`loan_acc`.`deperment` AS `deperment`,`co-operativebank-mitrachak`.`loan_acc`.`TRAN_TYPE` AS `TRAN_TYPE`,`co-operativebank-mitrachak`.`loan_acc`.`loanappno` AS `loanappno`,`co-operativebank-mitrachak`.`loan_acc`.`memberno` AS `memberno` from `co-operativebank-mitrachak`.`loan_acc` where ((`co-operativebank-mitrachak`.`loan_acc`.`fianl_date` = \'2019-06-11\') and (`co-operativebank-mitrachak`.`loan_acc`.`sub_head` = \'23101A\'))
md5=8a99733863e35d0d27ef2e7a2e095497
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2019-08-27 05:36:28
create-version=1
source=SELECT *  FROM `loan_acc` WHERE `fianl_date` = \'2019-06-11\' and sub_head=\'23101A\'
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-mitrachak`.`loan_acc`.`id` AS `id`,`co-operativebank-mitrachak`.`loan_acc`.`no` AS `no`,`co-operativebank-mitrachak`.`loan_acc`.`member_id` AS `member_id`,`co-operativebank-mitrachak`.`loan_acc`.`app_code` AS `app_code`,`co-operativebank-mitrachak`.`loan_acc`.`acc_no` AS `acc_no`,`co-operativebank-mitrachak`.`loan_acc`.`loan_against` AS `loan_against`,`co-operativebank-mitrachak`.`loan_acc`.`acc_type` AS `acc_type`,`co-operativebank-mitrachak`.`loan_acc`.`date_open` AS `date_open`,`co-operativebank-mitrachak`.`loan_acc`.`sub_head` AS `sub_head`,`co-operativebank-mitrachak`.`loan_acc`.`duration` AS `duration`,`co-operativebank-mitrachak`.`loan_acc`.`duration_time` AS `duration_time`,`co-operativebank-mitrachak`.`loan_acc`.`fianl_date` AS `fianl_date`,`co-operativebank-mitrachak`.`loan_acc`.`amt` AS `amt`,`co-operativebank-mitrachak`.`loan_acc`.`interest` AS `interest`,`co-operativebank-mitrachak`.`loan_acc`.`inst_amt` AS `inst_amt`,`co-operativebank-mitrachak`.`loan_acc`.`status` AS `status`,`co-operativebank-mitrachak`.`loan_acc`.`vch_no` AS `vch_no`,`co-operativebank-mitrachak`.`loan_acc`.`s_acc_no` AS `s_acc_no`,`co-operativebank-mitrachak`.`loan_acc`.`s_dtl` AS `s_dtl`,`co-operativebank-mitrachak`.`loan_acc`.`s_amt` AS `s_amt`,`co-operativebank-mitrachak`.`loan_acc`.`no_inst` AS `no_inst`,`co-operativebank-mitrachak`.`loan_acc`.`loan_agianst_acc_no` AS `loan_agianst_acc_no`,`co-operativebank-mitrachak`.`loan_acc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`co-operativebank-mitrachak`.`loan_acc`.`head` AS `head`,`co-operativebank-mitrachak`.`loan_acc`.`scheme` AS `scheme`,`co-operativebank-mitrachak`.`loan_acc`.`c_status` AS `c_status`,`co-operativebank-mitrachak`.`loan_acc`.`oth_amt` AS `oth_amt`,`co-operativebank-mitrachak`.`loan_acc`.`name_p` AS `name_p`,`co-operativebank-mitrachak`.`loan_acc`.`ins_type` AS `ins_type`,`co-operativebank-mitrachak`.`loan_acc`.`poloan` AS `poloan`,`co-operativebank-mitrachak`.`loan_acc`.`mdate` AS `mdate`,`co-operativebank-mitrachak`.`loan_acc`.`od_int` AS `od_int`,`co-operativebank-mitrachak`.`loan_acc`.`last_day` AS `last_day`,`co-operativebank-mitrachak`.`loan_acc`.`nsc` AS `nsc`,`co-operativebank-mitrachak`.`loan_acc`.`lf_no` AS `lf_no`,`co-operativebank-mitrachak`.`loan_acc`.`bankacc` AS `bankacc`,`co-operativebank-mitrachak`.`loan_acc`.`accper` AS `accper`,`co-operativebank-mitrachak`.`loan_acc`.`deperment` AS `deperment`,`co-operativebank-mitrachak`.`loan_acc`.`TRAN_TYPE` AS `TRAN_TYPE`,`co-operativebank-mitrachak`.`loan_acc`.`loanappno` AS `loanappno`,`co-operativebank-mitrachak`.`loan_acc`.`memberno` AS `memberno` from `co-operativebank-mitrachak`.`loan_acc` where ((`co-operativebank-mitrachak`.`loan_acc`.`fianl_date` = \'2019-06-11\') and (`co-operativebank-mitrachak`.`loan_acc`.`sub_head` = \'23101A\'))
