CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `priyas`@`%` 
    SQL SECURITY DEFINER
VIEW `aerion`.`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`
    FROM
        (`aerion`.`dev_est_reqs_stat_amt` `a`
        LEFT JOIN `aerion`.`vw_dev_est_reqs_status` `b` ON ((`a`.`iddev_est_reqs_status` = `b`.`iddev_est_reqs_status`)))