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).
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
pb.ID = xxxx AND
pb.IS_CURRENT = 1