AnsweredAssumed Answered

Query to return timeslice info, but also bill_rate, timesheet status and t

Question asked by matpj on Oct 16, 2008
Latest reply on Sep 1, 2010 by carrie.cottew
Hi all, does anyone have some SQL that will return the time booked to tasks from the time-slice tables, as well as the bill-rate, and the timesheet status etc? I can get time entered once posted and the bil-rate from PPA_WIP and PPA_TRANSCONTROL (plus VALUES) but I need to see time prior to timesheet approval/posting with the billrate.The only way I can get the time on a daily level seems to be from the time_slices - but then I don't know how to get the bill_rate... Any help will be appreciated. Regards,Matt