select usr1.USER_NAME, usr2.USER_NAME delegate, project.PROJ_SHORT_NAME from tsdelegate, users usr1, project, users usr2 where project.proj_id(+)=tsdelegate.proj_id and usr1.user_id=tsdelegate.user_id and usr2.user_id=tsdelegate.TS_DELEGATE_USER_ID;
How to report on Primavera Timesheet approval delegates
There is no single screen to display all the delegations done by Primavera timesheet users but a database query will show delegates.
Timesheet approval delegates could be listed with below query. The query should run as a privileged database user or on Oracle databases as Primavera database admin user;