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