TYPE=VIEW
query=select `lc`.`acc_no` AS `Acc_No`,`lc`.`loan_against_sv_acc` AS `Savings_Acc_No`,`lc`.`date_open` AS `Open_Date`,`lc`.`fianl_date` AS `Final_Date`,`lc`.`name` AS `Name`,`lc`.`amt` AS `Ammount`,(`ld`.`Amt` - `lc`.`amt`) AS `Interest_Ammount`,`lc`.`interest` AS `loan_subsidy`,`lc`.`loan_against` AS `Loan_Against`,`lc`.`pan` AS `Pan_Number`,`h`.`code` AS `head_code`,`h`.`head` AS `Loan_Type`,`sh`.`code` AS `sub_code`,`sh`.`sub_head` AS `sub_head`,`ld`.`Date` AS `with_date` from (((`co-operativebank`.`loan_account` `lc` join `co-operativebank`.`sub_head` `sh`) join `co-operativebank`.`head` `h`) join `co-operativebank`.`loan_deposit` `ld`) where ((not(exists(select 1 from `co-operativebank`.`loan_subsidy` `ls` where (`ls`.`l_acc_no` = `lc`.`acc_no`)))) and (`sh`.`code` = `lc`.`sub_head`) and (`h`.`code` = `lc`.`head`) and (`ld`.`Acc_No` = `lc`.`acc_no`) and (`lc`.`fianl_date` >= `ld`.`Date`) and (`ld`.`com_sts` = 1))
md5=0f0929a4a9b3ddff39a57037fc4a5bd6
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-10-12 17:31:56
create-version=1
source=select  `lc`.`acc_no`  AS  `Acc_No` ,\n `lc`.`loan_against_sv_acc`  AS  `Savings_Acc_No` ,\n `lc`.`date_open`  AS  `Open_Date` ,\n `lc`.`fianl_date`  AS  `Final_Date` ,\n `lc`.`name`  AS  `Name` ,\n `lc`.`amt`  AS  `Ammount` ,\n(  `ld`.`Amt`  -  `lc`.`amt`  ) AS  `Interest_Ammount` ,\n `lc`.`interest`  AS  `loan_subsidy` ,\n `lc`.`loan_against`  AS  `Loan_Against` ,\n `lc`.`pan`  AS  `Pan_Number` ,\n `h`.`code`  AS  `head_code` ,\n `h`.`head`  AS  `Loan_Type` ,\n `sh`.`code`  AS  `sub_code` ,\n `sh`.`sub_head`  AS  `sub_head` ,\n `ld`.`Date`  AS  `with_date`  from ( ( (  `co-operativebank`.`loan_account`  `lc`  join  `co-operativebank`.`sub_head`  `sh`  ) join  `co-operativebank`.`head`  `h`  ) join  `co-operativebank`.`loan_deposit`  `ld`  ) where ( (  not (  exists (  select 1  from  `co-operativebank`.`loan_subsidy`  `ls`  where (  `ls`.`l_acc_no`  =  `lc`.`acc_no`  ) ) ) ) and (  `sh`.`code`  =  `lc`.`sub_head`  ) and (  `h`.`code`  =  `lc`.`head`  ) and (  `ld`.`Acc_No`  =  `lc`.`acc_no`  ) and (  `lc`.`fianl_date`  >=  `ld`.`Date`  ) and (  `ld`.`com_sts`  =1 ) )
client_cs_name=utf8
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `lc`.`acc_no` AS `Acc_No`,`lc`.`loan_against_sv_acc` AS `Savings_Acc_No`,`lc`.`date_open` AS `Open_Date`,`lc`.`fianl_date` AS `Final_Date`,`lc`.`name` AS `Name`,`lc`.`amt` AS `Ammount`,(`ld`.`Amt` - `lc`.`amt`) AS `Interest_Ammount`,`lc`.`interest` AS `loan_subsidy`,`lc`.`loan_against` AS `Loan_Against`,`lc`.`pan` AS `Pan_Number`,`h`.`code` AS `head_code`,`h`.`head` AS `Loan_Type`,`sh`.`code` AS `sub_code`,`sh`.`sub_head` AS `sub_head`,`ld`.`Date` AS `with_date` from (((`co-operativebank`.`loan_account` `lc` join `co-operativebank`.`sub_head` `sh`) join `co-operativebank`.`head` `h`) join `co-operativebank`.`loan_deposit` `ld`) where ((not(exists(select 1 from `co-operativebank`.`loan_subsidy` `ls` where (`ls`.`l_acc_no` = `lc`.`acc_no`)))) and (`sh`.`code` = `lc`.`sub_head`) and (`h`.`code` = `lc`.`head`) and (`ld`.`Acc_No` = `lc`.`acc_no`) and (`lc`.`fianl_date` >= `ld`.`Date`) and (`ld`.`com_sts` = 1))
