CREATE ALGORITHM = UNDEFINED DEFINER = `aerion`@`localhost` SQL SECURITY DEFINER VIEW `vw_taxamt` AS SELECT `a`.`idtax_amt` AS `idtax_amt`, `a`.`idtax_period` AS `idtax_period`, `a`.`idtax_lk_qtr` AS `idtax_lk_qtr`, `a`.`gender` AS `gender`, `a`.`tax_amt` AS `tax_amt`, `a`.`idtax_amt_sub` AS `idtax_amt_sub`, `a`.`tax_type` AS `tax_type`, `b`.`tax_detail_id` AS `tax_detail_id`, `b`.`idtax_lk_yr_qtr` AS `idtax_lk_yr_qtr`, `b`.`tax_range` AS `tax_range`, `aa`.`look_values` AS `tax_for`, `c`.`tax_id` AS `tax_id`, `d`.`dept_id` AS `dept_id`, `d`.`state_id` AS `state_id`, `e`.`idtax_qtr` AS `idtax_qtr`, `e`.`idtax_yr` AS `idtax_yr`, `t`.`look_values` AS `credit`, `f`.`tax_yr` AS `tax_yr`, `h`.`tax_from` AS `tax_from`, `h`.`tax_to` AS `tax_to`, CONCAT(LEFT(MONTHNAME(STR_TO_DATE(`g`.`idtax_lk_mon_from`, _UTF8'%m')), 3), _UTF8' - ', LEFT(MONTHNAME(STR_TO_DATE(`g`.`idtax_lk_mon_to`, _UTF8'%m')), 3)) AS `Year_cycle`, CONCAT(LEFT(MONTHNAME(STR_TO_DATE(`s`.`idtax_lk_mon_from`, _UTF8'%m')), 3), _UTF8' - ', LEFT(MONTHNAME(STR_TO_DATE(`s`.`idtax_lk_mon_to`, _UTF8'%m')), 3)) AS `qtr_mon_frm_to`, CONCAT(ROUND(`h`.`tax_from`, 2), _UTF8' - ', ROUND(`h`.`tax_to`, 2)) AS `tax_from_to`, `i`.`state_name` AS `state_name`, `i`.`country_id` AS `country_id`, `j`.`look_values` AS `dept`, `k`.`look_values` AS `amt_subdept` FROM (((((((((((((`tax_amt` `a` LEFT JOIN `tax_period` `b` ON ((`a`.`idtax_period` = `b`.`idtax_period`))) LEFT JOIN `tax_detail` `c` ON ((`b`.`tax_detail_id` = `c`.`tax_detail_id`))) LEFT JOIN `taxes` `d` ON ((`c`.`tax_id` = `d`.`tax_id`))) LEFT JOIN `look_values` `j` ON ((`j`.`look_values_id` = `d`.`dept_id`))) LEFT JOIN `look_values` `k` ON ((`k`.`look_values_id` = `a`.`idtax_amt_sub`))) LEFT JOIN `tax_lk_yr_qtr` `e` ON ((`b`.`idtax_lk_yr_qtr` = `e`.`idtax_lk_yr_qtr`))) LEFT JOIN `tax_lk_yr` `f` ON ((`f`.`idtax_lk_yr` = `e`.`idtax_yr`))) LEFT JOIN `tax_lk_qtr` `g` ON ((`g`.`idtax_lk_qtr` = `e`.`idtax_qtr`))) LEFT JOIN `tax_range` `h` ON ((`h`.`tax_range_id` = `b`.`tax_range`))) LEFT JOIN `look_state` `i` ON ((`i`.`state_id` = `d`.`state_id`))) LEFT JOIN `tax_lk_qtr` `s` ON ((`s`.`idtax_lk_qtr` = `a`.`idtax_lk_qtr`))) LEFT JOIN `look_values` `t` ON ((`t`.`look_values_id` = `c`.`creditable`))) LEFT JOIN `look_values` `aa` ON ((`aa`.`look_values_id` = `c`.`tax_for`)))