TYPE=VIEW
query=select `co-operativebank`.`od`.`No` AS `No`,`co-operativebank`.`od`.`Code` AS `Code`,`co-operativebank`.`od`.`P_Amt` AS `P_Amt`,`co-operativebank`.`od`.`Duration` AS `Duration`,`co-operativebank`.`od`.`Durattion_D` AS `Durattion_D`,`co-operativebank`.`od`.`Interest` AS `Interest`,`co-operativebank`.`od`.`loan_against` AS `loan_against`,`co-operativebank`.`od`.`ins_type` AS `ins_type`,`co-operativebank`.`od`.`ins_v` AS `ins_v`,`co-operativebank`.`od`.`Int_V` AS `Int_V`,`co-operativebank`.`od`.`M_V` AS `M_V`,`co-operativebank`.`od`.`sub_head` AS `sub_head`,`co-operativebank`.`od`.`scheme` AS `scheme`,`co-operativebank`.`od`.`cc_loan_code` AS `cc_loan_code`,`co-operativebank`.`od`.`cc_scheme` AS `cc_scheme`,`co-operativebank`.`od`.`interest_payable` AS `interest_payable` from `co-operativebank`.`od` group by `co-operativebank`.`od`.`cc_loan_code`
md5=f6c2d8b9f8d30b19f8e67f34ce958253
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2018-11-14 05:19:01
create-version=1
source=SELECT * FROM `od` GROUP by cc_loan_code
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank`.`od`.`No` AS `No`,`co-operativebank`.`od`.`Code` AS `Code`,`co-operativebank`.`od`.`P_Amt` AS `P_Amt`,`co-operativebank`.`od`.`Duration` AS `Duration`,`co-operativebank`.`od`.`Durattion_D` AS `Durattion_D`,`co-operativebank`.`od`.`Interest` AS `Interest`,`co-operativebank`.`od`.`loan_against` AS `loan_against`,`co-operativebank`.`od`.`ins_type` AS `ins_type`,`co-operativebank`.`od`.`ins_v` AS `ins_v`,`co-operativebank`.`od`.`Int_V` AS `Int_V`,`co-operativebank`.`od`.`M_V` AS `M_V`,`co-operativebank`.`od`.`sub_head` AS `sub_head`,`co-operativebank`.`od`.`scheme` AS `scheme`,`co-operativebank`.`od`.`cc_loan_code` AS `cc_loan_code`,`co-operativebank`.`od`.`cc_scheme` AS `cc_scheme`,`co-operativebank`.`od`.`interest_payable` AS `interest_payable` from `co-operativebank`.`od` group by `co-operativebank`.`od`.`cc_loan_code`
