I can select the work plans,schuld_effort,act_effort, PERC_COMPLETE etc. from WP_WORK_UNITS table .But I want to see the changes on the work plan.For example if a work unit changes 3 times. I want to get 3 rows about this unit.Thanks.
Go to Solution.
You can get thes details form Audit logs...
Just put your Project Request id in the SQL
SELECT * FROM ITG_AUDIT_EVENTS WHERE ENTITY_TYPE = 59
AND ENTITY_ID IN (SELECT TASK_INFO_ID FROM WP_TASKS WHERE WORK_PLAN_ID IN
(SELECT WORK_PLAN_ID FROM PM_WORK_PLANS WHERE PROJECT_ID = (SELECT PROJECT_ID FROM PM_PROJECTS WHERE PFM_REQUEST_ID = <YOUR_REQUEST_ID>)))
Thanks for your reply. It was very usefull.