CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_dev_est_reqs_stat_amt` AS
    SELECT 
        `a`.` iddev_est_reqs_stat_amt` AS `iddev_est_reqs_stat_amt`,
        `a`.`iddev_est_reqs_status` AS `iddev_est_reqs_status`,
        `a`.`req_amt` AS `req_amt`,
        `a`.`req_paid` AS `req_paid`,
        `a`.`req_bal` AS `req_bal`,
        `a`.`updater` AS `updater`,
        `a`.`last_updated` AS `last_updated`,
        `b`.`status_id` AS `status_id`,
        `b`.`status` AS `status`,
        `b`.`stat_st_dt` AS `stat_st_dt`,
        `b`.`stat_e_dt` AS `stat_e_dt`,
        `b`.`stat_time` AS `stat_time`,
        `b`.`pseudo_stat_time` AS `pseudo_stat_time`,
        `b`.`lag_time` AS `lag_time`,
        `b`.`assigned_to_id` AS `assigned_to_id`,
        `b`.`assigned_to` AS `assigned_to`,
        `b`.`nickname` AS `nickname`,
        `c`.`req_status_id` AS `cur_stat_id`,
        `c`.`req_status` AS `cur_stat`,
        `c`.`st_dt_time` AS `cur_st_dt_tm`,
        `c`.`st_dt_time_unformatted` AS `cur_st_dt_tm_fmt`,
        `c`.`e_dt_time` AS `cur_e_dt_tm`,
        `c`.`e_dt_time_unformatted` AS `cur_e_dt_tm_fmt`,
        `c`.`stat_time` AS `cur_stat_tm`,
        `c`.`pseudo_stat_time` AS `cur_stat_tm_pseudo`,
        `c`.`assigned_to_id` AS `cur_assignee_id`,
        `c`.`assigned_to` AS `cur_assignee_nm`,
        `c`.`iddev_est_reqs` AS `iddev_est_reqs`,
        `c`.`iddev_est` AS `iddev_est`,
        `c`.`dev_est_smry` AS `dev_est_smry`,
        `c`.`open_dt_time` AS `open_dt_time`,
        `c`.`open_dt_time_unformatted` AS `open_dt_time_unformatted`,
        `c`.`close_dt_time` AS `close_dt_time`,
        `c`.`close_dt_time_unformatted` AS `close_dt_time_unformatted`,
        `c`.`req_time` AS `req_time`,
        `c`.`pseudo_req_time` AS `pseudo_req_time`,
        `c`.`pseudo_req_days` AS `pseudo_req_days`,
        `c`.`disp_order` AS `disp_order`,
        `c`.`req_desc` AS `req_desc`,
        `c`.`estimater_id` AS `estimater_id`,
        `c`.`owner_id` AS `owner_id`,
        `c`.`req_type` AS `req_type`,
        `c`.`category` AS `category`,
        `c`.`skill_lvl` AS `skill_lvl`,
        `c`.`skill_lvl_val` AS `skill_lvl_val`,
        `c`.`gap_lvl` AS `gap_lvl`,
        `c`.`gap_lvl_val` AS `gap_lvl_val`
    FROM
        ((`dev_est_reqs_stat_amt` `a`
        LEFT JOIN `vw_dev_est_reqs_status` `b` ON ((`a`.`iddev_est_reqs_status` = `b`.`iddev_est_reqs_status`)))
        LEFT JOIN `vw_dev_est_reqs` `c` ON ((`b`.`iddev_est_reqs` = `c`.`iddev_est_reqs`)))