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`.`sub_head`
md5=e594f74a1c04548db977dfcbcb0d2988
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2016-07-30 18:19:30
create-version=1
source=select `od`.`No` AS `No`,`od`.`Code` AS `Code`,`od`.`P_Amt` AS `P_Amt`,`od`.`Duration` AS `Duration`,`od`.`Durattion_D` AS `Durattion_D`,`od`.`Interest` AS `Interest`,`od`.`loan_against` AS `loan_against`,`od`.`ins_type` AS `ins_type`,`od`.`ins_v` AS `ins_v`,`od`.`Int_V` AS `Int_V`,`od`.`M_V` AS `M_V`,`od`.`sub_head` AS `sub_head`,`od`.`scheme` AS `scheme`,`od`.`cc_loan_code` AS `cc_loan_code`,`od`.`cc_scheme` AS `cc_scheme`,`od`.`interest_payable` AS `interest_payable` from `od` group by `od`.`sub_head`
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_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`.`sub_head`
