Project and Portfolio Management Practitioners Forum
cancel

Geeting Workplan Cost Information

Highlighted
Om Prakash Acha
Trusted Contributor.

Geeting Workplan Cost Information

Hi
Can anyone let me know how I can get the Actual Cost,Actual Non-Labor, Actual Labor,
Planned Labor, Planned Total information of a particular Workplan (Cost View) from backend query. If any body have any sql query that can fetch these information.

Thanks
1 REPLY
Erik Cole
Acclaimed Contributor.

Re: Geeting Workplan Cost Information

Sure...try something like:

SELECT p.PROJECT_NAME PROJECT_NAME,
t.TASK_ID,
t.SEQUENCE_NUMBER "SEQ_NUM",
PM_UTILS.Get_Task_Path(t.TASK_ID) "PATH",
i.NAME TASK_NAME,
DECODE(i.task_type_code,'S', 'SUMMARY', 'LEAF') "TYPE",
i.STATUS "STATUS_CODE",
round(tc.PLAN_CAP_LABOR_BSE/10000,2),
round(tc.PLAN_OP_LABOR_BSE/10000,2),
round(tc.ACT_CAP_LABOR_BSE/10000,2),
round(tc.ACT_OP_LABOR_BSE/10000,2)
FROM PM_PROJECTS p
JOIN PM_WORK_PLANS wp
ON wp.PROJECT_ID = p.PROJECT_ID
JOIN WP_TASKS t
ON t.WORK_PLAN_ID = wp.WORK_PLAN_ID
JOIN WP_TASK_INFO i
ON i.TASK_INFO_ID = t.TASK_INFO_ID
JOIN WP_TASK_ACTUALS a
ON a.ACTUALS_ID = t.TASK_ACTUALS_ID
join WP_TASK_COSTS tc on tc.TASK_COST_ID = t.TASK_COST_ID
WHERE 1=1
AND p.PROJECT_NAME = 'MY PROJECT'
ORDER BY 1,2,3