TYPE=VIEW
query=select `l`.`acc_no` AS `acc_no`,`l`.`loan_against_sv_acc` AS `SB_ACC`,`l`.`date_open` AS `DATE_OPEN`,`l`.`amt` AS `AMT`,`l`.`sub_head` AS `sub_head`,if((`sh`.`code` = \'23101A\'),\'ST-RABI\',if((`sh`.`code` = \'23101B\'),\'ST-KHARIP\',if((`sh`.`code` = \'23115\'),\'ST-LAD\',if((`sh`.`code` = \'23103\'),\'ST-KCC\',if((`sh`.`code` = \'23105\'),\'AGCL\',if((`sh`.`code` = \'23107\'),\'ST-PAWNING\',if((`sh`.`code` = \'23109\'),\'ST-KVP\',if((`sh`.`code` = \'23111\'),\'ST-FISHERY\',if((`sh`.`code` = \'23113\'),\'ST-SHG\',if((`sh`.`code` = \'23213\'),\'MT-SHG\',if((`sh`.`code` = \'23215\'),\'MT-NF\',\'LOAN\'))))))))))) AS `TITLE` from (`co-operativebank-simuldari`.`sub_head` `sh` join `co-operativebank-simuldari`.`loan_acc` `l`) where (`l`.`sub_head` = `sh`.`code`)
md5=a16ce0a8bf5aa4690bf201c2cb999778
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-07-22 15:13:49
create-version=1
source=select  `l`.`acc_no`  AS  `acc_no` ,\n `l`.`loan_against_sv_acc`  AS  `SB_ACC` ,\n `l`.`date_open`  AS  `DATE_OPEN` ,\n `l`.`amt`  AS  `AMT` ,\n `l`.`sub_head`  AS  `sub_head` ,\nif( (  `sh`.`code`  =  \'23101A\' ),  \'ST-RABI\', if( (  `sh`.`code`  =  \'23101B\' ),  \'ST-KHARIP\', if( (  `sh`.`code`  =  \'23115\' ),  \'ST-LAD\', if( (  `sh`.`code`  =  \'23103\' ),  \'ST-KCC\', if( (  `sh`.`code`  =  \'23105\' ),  \'AGCL\', if( (  `sh`.`code`  =  \'23107\' ),  \'ST-PAWNING\', if( (  `sh`.`code`  =  \'23109\' ),  \'ST-KVP\', if( (  `sh`.`code`  =  \'23111\' ),  \'ST-FISHERY\', if( (  `sh`.`code`  =  \'23113\' ),  \'ST-SHG\', if( (  `sh`.`code`  =  \'23213\' ),  \'MT-SHG\', if( (  `sh`.`code`  =  \'23215\' ),  \'MT-NF\',  \'LOAN\'  )  )  )  )  )  )  )  )  )  )  )  AS  `TITLE`  from (  `co-operativebank-simuldari`.`sub_head`  `sh`  join  `co-operativebank-simuldari`.`loan_acc`  `l`  ) where (  `l`.`sub_head`  =  `sh`.`code`  )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `l`.`acc_no` AS `acc_no`,`l`.`loan_against_sv_acc` AS `SB_ACC`,`l`.`date_open` AS `DATE_OPEN`,`l`.`amt` AS `AMT`,`l`.`sub_head` AS `sub_head`,if((`sh`.`code` = \'23101A\'),\'ST-RABI\',if((`sh`.`code` = \'23101B\'),\'ST-KHARIP\',if((`sh`.`code` = \'23115\'),\'ST-LAD\',if((`sh`.`code` = \'23103\'),\'ST-KCC\',if((`sh`.`code` = \'23105\'),\'AGCL\',if((`sh`.`code` = \'23107\'),\'ST-PAWNING\',if((`sh`.`code` = \'23109\'),\'ST-KVP\',if((`sh`.`code` = \'23111\'),\'ST-FISHERY\',if((`sh`.`code` = \'23113\'),\'ST-SHG\',if((`sh`.`code` = \'23213\'),\'MT-SHG\',if((`sh`.`code` = \'23215\'),\'MT-NF\',\'LOAN\'))))))))))) AS `TITLE` from (`co-operativebank-simuldari`.`sub_head` `sh` join `co-operativebank-simuldari`.`loan_acc` `l`) where (`l`.`sub_head` = `sh`.`code`)
