Project Management - Where to pull the percent complete for a project?
I am new to this Project Management, I want to pull the percent complete for project. What table can i get this information from? any documents that will help me to understand the project management data is greatly appreciated.
Re: Project Management - Where to pull the percent complete for a project?
SELECT WTA.PERC_COMPLETE, PP.PROJECT_ID, WT.TASK_ID FROM PM_PROJECTS PP, WP_TASK_ACTUALS WTA, WP_TASKS WT, PM_WORK_PLANS PWP WHERE PWP.PROJECT_ID = PP.PROJECT_ID AND WT.WORK_PLAN_ID = PWP.WORK_PLAN_ID AND WTA.ACTUALS_ID = WT.TASK_ACTUALS_ID ORDER BY PP.PROJECT_ID, WT.TASK_ID;