TYPE=VIEW
query=select `npa1`.`acc_no` AS `acc_no`,`npa1`.`name` AS `name`,`npa1`.`father_name` AS `father_name`,`npa1`.`address` AS `address`,`npa1`.`mobile` AS `mobile`,`npa1`.`issue_date` AS `issue_date`,`npa1`.`loan_amt` AS `loan_amt`,`npa1`.`ist_type` AS `ist_type`,`npa1`.`inst_ant` AS `inst_ant`,`npa1`.`due_date` AS `due_date`,`npa1`.`C_INST` AS `C_INST`,`npa1`.`od_amt` AS `od_amt`,`npa1`.`clear_amt` AS `clear_amt`,`npa1`.`od_int_a` AS `od_int_a`,`npa1`.`cc_int_a` AS `cc_int_a`,`npa1`.`loss` AS `loss`,`npa1`.`days` AS `days`,`npa1`.`oddays` AS `oddays`,`npa1`.`s_amt` AS `s_amt`,if((`npa1`.`oddays` < 90),`npa1`.`clear_amt`,0) AS `standard`,if(((`npa1`.`oddays` >= 90) and (`npa1`.`oddays` < 1095)),`npa1`.`clear_amt`,0) AS `sub_standard`,`npa1`.`s_amt` AS `r_value`,if(((`npa1`.`oddays` >= 1095) and (`npa1`.`oddays` < 1460)),if((`npa1`.`s_amt` > `npa1`.`clear_amt`),`npa1`.`clear_amt`,`npa1`.`s_amt`),0) AS `d1`,if(((`npa1`.`oddays` >= 1460) and (`npa1`.`oddays` < 2190)),if((`npa1`.`s_amt` > `npa1`.`clear_amt`),`npa1`.`clear_amt`,`npa1`.`s_amt`),0) AS `d2`,if((`npa1`.`oddays` >= 2190),if((`npa1`.`s_amt` > `npa1`.`clear_amt`),`npa1`.`clear_amt`,`npa1`.`s_amt`),0) AS `d3`,if((`npa1`.`oddays` >= 1095),if((`npa1`.`s_amt` > `npa1`.`clear_amt`),0,(`npa1`.`clear_amt` - `npa1`.`s_amt`)),0) AS `unsecure` from `co-operativebank-210`.`npa1`
md5=e674d4ca856fe17d4bb9ec1fba8f1ded
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-12-31 03:11:07
create-version=1
source=SELECT *,if(oddays<90,clear_amt,0) as standard,if(oddays>=90 and oddays<1095,clear_amt,0) as sub_standard, s_amt as r_value,if(oddays>=1095 and oddays<1460,if(s_amt>clear_amt,clear_amt,s_amt),0) as d1,if(oddays>=1460 and oddays<2190,if(s_amt>clear_amt,clear_amt,s_amt),0) as d2,if(oddays>=2190,if(s_amt>clear_amt,clear_amt,s_amt),0) as d3,if(oddays>=1095,if(s_amt>clear_amt,0,(clear_amt- s_amt)),0) as unsecure from npa1
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `npa1`.`acc_no` AS `acc_no`,`npa1`.`name` AS `name`,`npa1`.`father_name` AS `father_name`,`npa1`.`address` AS `address`,`npa1`.`mobile` AS `mobile`,`npa1`.`issue_date` AS `issue_date`,`npa1`.`loan_amt` AS `loan_amt`,`npa1`.`ist_type` AS `ist_type`,`npa1`.`inst_ant` AS `inst_ant`,`npa1`.`due_date` AS `due_date`,`npa1`.`C_INST` AS `C_INST`,`npa1`.`od_amt` AS `od_amt`,`npa1`.`clear_amt` AS `clear_amt`,`npa1`.`od_int_a` AS `od_int_a`,`npa1`.`cc_int_a` AS `cc_int_a`,`npa1`.`loss` AS `loss`,`npa1`.`days` AS `days`,`npa1`.`oddays` AS `oddays`,`npa1`.`s_amt` AS `s_amt`,if((`npa1`.`oddays` < 90),`npa1`.`clear_amt`,0) AS `standard`,if(((`npa1`.`oddays` >= 90) and (`npa1`.`oddays` < 1095)),`npa1`.`clear_amt`,0) AS `sub_standard`,`npa1`.`s_amt` AS `r_value`,if(((`npa1`.`oddays` >= 1095) and (`npa1`.`oddays` < 1460)),if((`npa1`.`s_amt` > `npa1`.`clear_amt`),`npa1`.`clear_amt`,`npa1`.`s_amt`),0) AS `d1`,if(((`npa1`.`oddays` >= 1460) and (`npa1`.`oddays` < 2190)),if((`npa1`.`s_amt` > `npa1`.`clear_amt`),`npa1`.`clear_amt`,`npa1`.`s_amt`),0) AS `d2`,if((`npa1`.`oddays` >= 2190),if((`npa1`.`s_amt` > `npa1`.`clear_amt`),`npa1`.`clear_amt`,`npa1`.`s_amt`),0) AS `d3`,if((`npa1`.`oddays` >= 1095),if((`npa1`.`s_amt` > `npa1`.`clear_amt`),0,(`npa1`.`clear_amt` - `npa1`.`s_amt`)),0) AS `unsecure` from `co-operativebank-210`.`npa1`
