-- http://www.phpmyadmin.net
--




--
-- Database: `vafa_5`
--

-- --------------------------------------------------------

--
-- Structure for view `project_process_budget_details`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `project_process_budget_details`  AS  select `PMPM`.`project_master_name` AS `project_master_name`,`PMPM`.`project_management_master_id` AS `project_id`,`PPM`.`project_process_master_name` AS `project_process_master_name`,`PPP`.`project_plan_process_id` AS `project_plan_process_id`,`PPP`.`project_plan_process_active` AS `project_plan_process_active`,`U`.`user_name` AS `added_by`,`U`.`user_id` AS `user_id`,`AU`.`user_name` AS `assigned_user`,`AP`.`user_name` AS `approved_by`,`PPM`.`project_process_master_id` AS `project_process_master_id` from ((((((`project_plan_process` `PPP` join `users` `U` on((`U`.`user_id` = `PPP`.`project_plan_process_assigned_user`))) join `users` `AU` on((`AU`.`user_id` = `PPP`.`project_plan_process_assigned_user`))) join `project_process_master` `PPM` on((`PPM`.`project_process_master_id` = `PPP`.`project_plan_process_name`))) left join `users` `AP` on((`AP`.`user_id` = `PPP`.`project_plan_process_approved_by`))) join `project_plan` `PP` on((`PP`.`project_plan_id` = `PPP`.`project_plan_process_plan_id`))) join `project_management_project_master` `PMPM` on((`PMPM`.`project_management_master_id` = `PP`.`project_plan_project_id`))) ;

--
-- VIEW  `project_process_budget_details`
-- Data: None
--


