Hi Dave, Thanks for your reply, here is my query ---
select
inv.code,inv.name ,
prj.slice_date,TRUNC(prj.slice_date, 'IW') WeekStartDay, -- Week Start Date
nvl(round(prj.slice,2),0) sday,
prj.slice_request_id ,
pt.prname,
prt.prresourceid,
srm1.last_name ||','|| srm1.first_name,
srm2.last_name
from
prassignment pra,
prtask pt, inv_investments inv,
prj_blb_slices prj,
prteam prt, srm_resources srm1,
srm_resources srm2
where
pra.prtaskid = pt.prid
and pt.prprojectid = inv.id
and prj.prj_object_id = pra.prid
and prt.prprojectid = inv.id
and prt.prresourceid = pra.prresourceid
and srm1.id = prt.prresourceid
and srm2.id = prt.prroleid(+)
and pt.prprojectid in (5148508,5419158)
and prj.slice_date <=to_date('12/31/2013','MM/DD/YYYY')
and prj.slice_request_id = 3 -- DAILYRESOURCEESTCURVE
--group by inv.code,inv.name,srm.full_name,prj.slice_date,prj.slice_request_id ,pt.prname
order by prj.slice_date