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