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`,
        `b`.`iddev_est` AS `iddev_est`,
        `b`.`app_name` AS `app_name`,
        `b`.`dev_est_smry` AS `dev_est_smry`,
        `b`.`owner_file_name` AS `owner_file_name`,
        `b`.`estimater_file_name` AS `estimater_file_name`,
        `b`.`est_cnt_pcnt` AS `est_cnt_pcnt`,
        `b`.`est_cnt_actual_est` AS `est_cnt_actual_est`,
        `b`.`iddev_est_reqs` AS `iddev_est_reqs`,
        `b`.`req_desc` AS `req_desc`,
        `b`.`req_time` AS `req_time`,
        `b`.`req_open_dt_time` AS `req_open_dt_time`,
        `b`.`req_open_dt_time_unformatted` AS `req_open_dt_time_unformatted`,
        `b`.`req_close_dt_time` AS `req_close_dt_time`,
        `b`.`req_close_dt_time_unformatted` AS `req_close_dt_time_unformatted`,
        `b`.`status` AS `status`,
        `b`.`reqs_cnt_pcnt` AS `reqs_cnt_pcnt`,
        `b`.`reqs_cnt_actual_est` AS `reqs_cnt_actual_est`,
        `b`.`stat_time` AS `stat_time`,
        `b`.`stat_st_dt` AS `stat_st_dt`,
        `b`.`stat_st_dt_unformatted` AS `stat_st_dt_unformatted`,
        `b`.`stat_e_dt` AS `stat_e_dt`,
        `b`.`stat_e_dt_unformatted` AS `stat_e_dt_unformatted`,
        `b`.`assigned_to` AS `assigned_to`,
        `b`.`assigned_to_file_name` AS `assigned_to_file_name`,
        `a`.`hist_cnt` AS `hist_cnt`,
        `a`.`reqs_status_by` AS `reqs_status_by`,
        IFNULL(CONCAT(`k`.`firstname`, ' ', `k`.`lastname`),
                'None') AS `reqs_status_by_nm`,
        `a`.`req_amt` AS `req_amt`,
        `a`.`req_action_by` AS `req_action_by`,
        IFNULL(CONCAT(`i`.`firstname`, ' ', `i`.`lastname`),
                'Pending') AS `req_action_by_nm`,
        `a`.`req_action` AS `req_action`,
        IFNULL(`p`.`look_value`, 'No-Action') AS `req_action_nm`,
        `a`.`req_paid` AS `req_paid`,
        `a`.`req_bal` AS `req_bal`,
        `a`.`updater` AS `updater_id`,
        IFNULL(CONCAT(`j`.`firstname`, ' ', `j`.`lastname`),
                'Admin') AS `updater`,
        DATE_FORMAT(`a`.`last_updated`, '%m-%d-%y %h:%i %p') AS `last_updated_formatted`,
        `a`.`last_updated` AS `last_updated`,
        DATE_FORMAT(`a`.`del_dt`, '%m-%d-%y %h:%i %p') AS `del_dt_formatted`,
        `a`.`del_dt` AS `del_dt`,
        IFNULL(CONCAT(`e_del_by`.`firstname`,
                        ' ',
                        `e_del_by`.`lastname`),
                'Admin') AS `del_by`,
        `a`.`del_by` AS `del_by_id`,
        `o_del_by`.`file_name` AS `del_by_file_name`,
        `a`.`del_day` AS `del_day`,
        (TO_DAYS((DATE_FORMAT(`a`.`del_dt`, '%y-%m-%d') + INTERVAL `a`.`del_day` DAY)) - TO_DAYS(DATE_FORMAT(NOW(), '%y-%m-%d'))) AS `virtual_del_day`,
        IFNULL(CONCAT(`e_arch_by`.`firstname`,
                        ' ',
                        `e_arch_by`.`lastname`),
                'Admin') AS `arch_by`,
        `a`.`archv_by` AS `arch_by_id`,
        `o_arch_by`.`file_name` AS `arch_by_file_name`,
        DATE_FORMAT(`a`.`archv_dt`, '%m-%d-%y %h:%i %p') AS `arch_dt_formatted`,
        `a`.`archv_dt` AS `arch_dt`
    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 `emp` `j` ON ((`a`.`updater` = `j`.`emp_id`)))
        LEFT JOIN `dev_look_value` `p` ON ((`a`.`req_action` = `p`.`iddev_look_value`)))
        LEFT JOIN `storages` `s` ON ((`j`.`idstorage` = `s`.`idstorage`)))
        LEFT JOIN `emp` `k` ON ((`a`.`reqs_status_by` = `k`.`emp_id`)))
        LEFT JOIN `emp` `i` ON ((`a`.`req_action_by` = `i`.`emp_id`)))
        LEFT JOIN `emp` `e_del_by` ON ((`a`.`del_dt` = `e_del_by`.`emp_id`)))
        LEFT JOIN `emp` `e_arch_by` ON ((`a`.`archv_by` = `e_arch_by`.`emp_id`)))
        LEFT JOIN `storages` `o_del_by` ON ((`e_del_by`.`idstorage` = `o_del_by`.`idstorage`)))
        LEFT JOIN `storages` `o_arch_by` ON ((`e_arch_by`.`idstorage` = `o_arch_by`.`idstorage`)))