AnsweredAssumed Answered

R12 - Query to Show Template Projects & Resource Roles Assigned

Question asked by DanielSGHE on Jun 21, 2010
Latest reply on Dec 15, 2010 by DanielSGHE

I have been asked to build a query to identify all active template projects and the (resource) roles that are assigned to those templates. The report output should look something like this:

Project Name Project ID Role Name
Project A 10001 Project Manager
Project A 10001 Technical Consultant
Project B 10002 Project Manager
Project B 10002 Student Consultant

Hopefully you get the idea. Can anyone assist in helping me to build this query? I'm having a difficult time figuring out the joins to get from INV_INVESTMENTS to Resources (assigned to the project) to Roles (assigned to the resource).

Clarity R12
Oracle 11g

Any help is greatly appreciated!

Daniel with SunGard