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`)))