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