AnsweredAssumed Answered

How do I locate all Master Projects for a Sub-project via SQL?

Question asked by marlon on Aug 25, 2009
Latest reply on Aug 25, 2009 by Paul_Maxwell
Hi.We're trying to locate (via SQL) all Master / Parent projects for a particular sub-project, (so that we can remove the child/parent link via an automated process) and have found references on INV_HIERARCHIES and INV_FLAT_HIERARCHIES, but when we Delete the relevant row in these tables, the sub-project still is visible when opening up the parent (but is not visible when you open the sub-project and go to Hierarchy/Parents).  There's obviously another table somewhere where this parent/child project-to-sub/project link is stored.  Any info greatly appreciated.  Thanks.

Outcomes