I am working on a report where we have to show sum of Role Rate x Hours for the whole team at project level. Before attempting to write a function, I would like to know if this info is already available.
I dont think we have a column in DB which has the details of Rate X hours - usually we do the math in the query. You can use NBI_PROJ_RES_RATES_AND_COSTS or ppa_matrix for the rate and the hours from ppa_wip or from the slice tables.
Let me know how it goes.
Retrieving data ...