CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_dev_est_reqs_stat_amt_pay` AS
    SELECT 
        `e`.`iddev_est` AS `iddev_est`,
        `b`.`iddev_est_reqs_stat_amt` AS `iddev_est_reqs_stat_amt`,
        `b`.`iddev_est_reqs_status` AS `iddev_est_reqs_status`,
        `d`.`status` AS `reqs_status`,
        `d`.`iddev_est_reqs` AS `iddev_est_reqs`,
        `d`.`req_desc` AS `req_desc`,
        `d`.`dev_est_smry` AS `dev_est_smry`,
        `d`.`stat_st_dt` AS `stat_st_dt`,
        `d`.`stat_e_dt` AS `stat_e_dt`,
        `d`.`cur_stat_id` AS `cur_stat_id`,
        `d`.`cur_stat` AS `cur_stat`,
        `d`.`cur_assignee_id` AS `cur_assignee_id`,
        `d`.`cur_assignee_nm` AS `cur_assignee_nm`,
        `a`.`idinv_pay_apply` AS `idinv_pay_apply`,
        `b`.`req_amt` AS `req_amt`,
        IFNULL(`a`.`req_paid_amt`, 0) AS `req_paid_amt`,
        IF(ISNULL(`a`.`req_paid_amt`),
            0,
            (`b`.`req_amt` - `a`.`req_paid_amt`)) AS `req_bal`,
        `a`.`req_pay_dt` AS `req_pay_dt`,
        `a`.`updater` AS `updater_id`,
        IFNULL(CONCAT(`c`.`firstname`, ' ', `c`.`lastname`),
                'Admin') AS `updater`,
        DATE_FORMAT(`a`.`last_updated`,
                _UTF8'%m-%d-%y %H:%i:%s') AS `last_updated`
    FROM
        ((((`dev_est_reqs_stat_amt` `b`
        LEFT JOIN `dev_est_reqs_stat_amt_pay` `a` ON ((`a`.`iddev_est_reqs_status` = `b`.`iddev_est_reqs_status`)))
        LEFT JOIN `emp` `c` ON ((`a`.`updater` = `c`.`emp_id`)))
        LEFT JOIN `vw_dev_est_reqs_status` `d` ON ((`b`.`iddev_est_reqs_status` = `d`.`iddev_est_reqs_status`)))
        LEFT JOIN `vw_dev_est_reqs` `e` ON ((`d`.`iddev_est_reqs` = `e`.`iddev_est_reqs`)))