AnsweredAssumed Answered

PRJ_BLB_SLICES_M_BASE question

Question asked by janurva on May 28, 2014
Latest reply on Jun 16, 2014 by Kathryn_Ellis

Hi!

Could someone share some light about the table: PRJ_BLB_SLICES_M_BASE. As I understood, this is resources monthly baseline allocations (time slices) and that what i want (i want to get some specific project baselined team & monthly allocation). Looking clarity UI - i know the data is somewhere stored but i could not build a query by myself. Could you suggest, what table/field should be joined with PRJ_BLB_SLICES_M_BASE.PRJ_OBJECT_ID (whatever I'll try - don't get no slices).

SELECT
pb.NAME,
r.FULL_NAME,
s.SLICE,
s.SLICE_DATE
FROM
PRJ_BASELINES pb
INNER JOIN PRJ_BASELINE_DETAILS pd ON pd.BASELINE_ID = pb.ID AND pd.OBJECT_TYPE = 'TEAM'
    INNER JOIN niku.PRTEAM tm ON pd.OBJECT_ID = tm.PRID
    INNER JOIN niku.SRM_RESOURCES r ON tm.PRROLEID = r.ID
LEFT JOIN PRJ_BLB_SLICES_M_BASE s ON tm.PRID = s.PRJ_OBJECT_ID
WHERE
pb.ID = xxxx AND
pb.IS_CURRENT = 1

Outcomes