CREATE ALGORITHM = UNDEFINED DEFINER = `priyas`@`%` SQL SECURITY DEFINER VIEW `aerion`.`vw_dev_est_access_my_reqs` AS SELECT `aerion`.`dev_est_access`.`dev_est_emp_id` AS `dev_est_emp_id`, `aerion`.`dev_est_access`.`dev_est_req_access` AS `dev_est_req_access`, `aerion`.`dev_est_access`.`dev_est_access` AS `dev_est_access`, `vw_dev_est_reqs`.`iddev_est_reqs` AS `iddev_est_reqs`, `vw_dev_est_reqs`.`iddev_est` AS `iddev_est`, `vw_dev_est_reqs`.`open_dt_time` AS `open_dt_time`, `vw_dev_est_reqs`.`open_dt_time_unformatted` AS `open_dt_time_unformatted`, `vw_dev_est_reqs`.`close_dt_time` AS `close_dt_time`, `vw_dev_est_reqs`.`close_dt_time_unformatted` AS `close_dt_time_unformatted`, `vw_dev_est_reqs`.`req_time` AS `req_time`, `vw_dev_est_reqs`.`pseudo_req_time` AS `pseudo_req_time`, `vw_dev_est_reqs`.`pseudo_req_days` AS `pseudo_req_days`, `vw_dev_est_reqs`.`disp_order` AS `disp_order`, `vw_dev_est_reqs`.`req_desc` AS `req_desc`, `vw_dev_est_reqs`.`estimater_id` AS `estimater_id`, `vw_dev_est_reqs`.`owner_id` AS `owner_id`, `vw_dev_est_reqs`.`est_type` AS `est_type`, `vw_dev_est_reqs`.`req_status_id` AS `req_status_id`, `vw_dev_est_reqs`.`req_status` AS `req_status`, `vw_dev_est_reqs`.`req_type` AS `req_type`, `vw_dev_est_reqs`.`category` AS `category`, `vw_dev_est_reqs`.`skill_lvl` AS `skill_lvl`, `vw_dev_est_reqs`.`skill_lvl_val` AS `skill_lvl_val`, `vw_dev_est_reqs`.`gap_lvl` AS `gap_lvl`, `vw_dev_est_reqs`.`gap_lvl_val` AS `gap_lvl_val`, `vw_dev_est_reqs`.`st_dt_time` AS `st_dt_time`, `vw_dev_est_reqs`.`st_dt_time_unformatted` AS `st_dt_time_unformatted`, `vw_dev_est_reqs`.`e_dt_time` AS `e_dt_time`, `vw_dev_est_reqs`.`e_dt_time_unformatted` AS `e_dt_time_unformatted`, `vw_dev_est_reqs`.`stat_time` AS `stat_time`, `vw_dev_est_reqs`.`pseudo_stat_time` AS `pseudo_stat_time`, `vw_dev_est_reqs`.`idlook_stat_order` AS `idlook_stat_order`, `vw_dev_est_reqs`.`assigned_to_id` AS `assigned_to_id`, `vw_dev_est_reqs`.`assigned_to` AS `assigned_to`, `vw_dev_est_reqs`.`updater_id` AS `updater_id`, `vw_dev_est_reqs`.`updater` AS `updater`, `vw_dev_est_reqs`.`last_updated` AS `last_updated`, `vw_dev_est_reqs`.`last_updated_unformatted` AS `last_updated_unformatted`, `vw_dev_est_reqs`.`expire_diff` AS `expire_diff` FROM (`aerion`.`dev_est_access` LEFT JOIN `aerion`.`vw_dev_est_reqs` ON ((`aerion`.`dev_est_access`.`iddev_est` = `vw_dev_est_reqs`.`iddev_est`)))