AnsweredAssumed Answered

Query that inculdes name of the subprojects

Question asked by Calemirou on Feb 8, 2016
Latest reply on Feb 9, 2016 by Dave_3.0

Hi all,

  • I'm new here. i'd make a query that let me have the following informations:
    > direct Children from parent source (project manager)
    > Allocation rate
    > Names of subprojects

Here is the SQL I'm using:

 

select inv.parent_id parent,

inv.child_id child,

DEFAULT_ALLOC_PCT alloc

from INV_HIERARCHIES

 

The problem is, how can i associate the name of subprojects with INV_HIERARCHIES?

Any helps?

thanks

 

Outcomes